2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Date = 10102018, Eating = 0, Running = 0 and Runs from = 1

- remove filter - rowid longitude latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid longitude latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid longitude latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid longitude latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid longitude latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by longitude Sort by latitude Sort by Unique Squirrel ID Sort by Hectare Sort by Shift Sort by Date Sort by Hectare Squirrel Number Sort by Age Sort by Primary Fur Color Sort by Highlight Fur Color Sort by Combination of Primary and Highlight Color Sort by Color notes Sort by Location Sort by Above Ground Sighter Measurement Sort by Specific Location Sort by Running Sort by Chasing Sort by Climbing Sort by Eating Sort by Foraging Sort by Other Activities Sort by Kuks Sort by Quaas Sort by Moans Sort by Tail flags Sort by Tail twitches Sort by Approaches Sort by Indifferent Sort by Runs from Sort by Other Interactions Sort by Lat/Long

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Indifferent

Link	rowid ▼	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
123	123	-73.9671147090087	40.7772624641112	16G-AM-1010-03	16G	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	was hanging out w/ #2 until i showed up	1	0	0	0	0	0	0	1		POINT (-73.9671147090087 40.7772624641112)
186	186	-73.9788138172962	40.7693001754769	3B-AM-1010-09	03B	AM	10102018	9	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9788138172962 40.7693001754769)
242	242	-73.9590236602085	40.798263245686606	40A-AM-1010-04	40A	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom great hill	0	0	0	0	1		0	0	0	1	0	0	1	1	dog chased	POINT (-73.9590236602085 40.7982632456866)
283	283	-73.9529060669193	40.79279097353879	37I-AM-1010-01	37I	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9529060669193 40.7927909735388)
554	554	-73.97335194581801	40.768814796037	5G-PM-1010-03	05G	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.973351945818 40.768814796037)
769	769	-73.976521916284	40.773784724458	9B-AM-1010-01	09B	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		1	0	0	0	0	0	0	1		POINT (-73.976521916284 40.773784724458)
785	785	-73.9619417432685	40.7930365939865	33B-PM-1010-12	33B	PM	10102018	12	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9619417432685 40.7930365939865)
807	807	-73.97772590224409	40.76820599079029	3D-PM-1010-10	03D	PM	10102018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9777259022441 40.7682059907903)
968	968	-73.9689781843873	40.7709333833783	9I-PM-1010-04	09I	PM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9689781843873 40.7709333833783)
988	988	-73.97870401924729	40.767901024728104	2C-AM-1010-06	02C	AM	10102018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	stood still & watched me then jumped on a fence and ran away	0	0	0	0	0	0	1	1		POINT (-73.9787040192473 40.7679010247281)
1256	1256	-73.9679457364586	40.7717350221981	10I-AM-1010-02	10I	AM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9679457364586 40.7717350221981)
1268	1268	-73.96239842629359	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623984262936 40.7913900453449)
1347	1347	-73.9616693665254	40.792971019627	33B-AM-1010-05	33B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616693665254 40.792971019627)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1548	1548	-73.9790044506465	40.7689469479245	3B-AM-1010-03	03B	AM	10102018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0	chasing #2	0	0	0	0	0	0	0	1		POINT (-73.9790044506465 40.7689469479245)
1645	1645	-73.9619673317128	40.7924176673037	33B-PM-1010-08	33B	PM	10102018	8	Juvenile	Gray		Gray+		Above Ground		running up tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619673317128 40.7924176673037)
1662	1662	-73.95616002372842	40.7953143196705	38E-AM-1010-10	38E	AM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	over a log across stream	0	0	0	0	0	chillin'	0	0	0	0	0	0	0	1	runs from leaf blower	POINT (-73.9561600237284 40.7953143196705)
1714	1714	-73.9763542780331	40.773653130362206	9B-AM-1010-02	09B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	in bush	0	0	1	0	1		0	0	0	0	1	0	0	1	froze	POINT (-73.9763542780331 40.773653130362206)
1824	1824	-73.9617250054003	40.7925390432044	33B-PM-1010-03	33B	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9617250054003 40.7925390432044)
1825	1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
2097	2097	-73.9773486521595	40.77084549021129	5C-PM-1010-02	05C	PM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9773486521595 40.7708454902113)
2330	2330	-73.9724618533895	40.7745021602455	11D-AM-1010-02	11D	AM	10102018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	0	1	walking	0	0	0	0	1	0	0	1		POINT (-73.9724618533895 40.7745021602455)
2406	2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
2435	2435	-73.972087127535	40.776237268628	13C-AM-1010-01	13C	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.972087127535 40.776237268628)
2501	2501	-73.96169441957758	40.7927250423024	33B-PM-1010-02	33B	PM	10102018	2	Adult			+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616944195776 40.7927250423024)
2565	2565	-73.97086402918009	40.7781721063527	15C-AM-1010-01	15C	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9708640291801 40.7781721063527)
2631	2631	-73.9690080105286	40.7710230515054	9I-PM-1010-03	09I	PM	10102018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White					0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9690080105286 40.7710230515054)
2963	2963	-73.9687020800791	40.7735903424522	11H-AM-1010-08	11H	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9687020800791 40.7735903424522)

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);