2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Hectare Squirrel Number = 1, Runs from = 1, Shift = "AM" and Tail twitches = 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: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Kuks

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
27	27	-73.9670628558161	40.7734991420941	12I-AM-1013-01	12I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on tree roots	0	0	0	0	0	sitting	0	0	0	0	1	0	0	1		POINT (-73.9670628558161 40.77349914209411)
109	109	-73.967097592707	40.785411934253794	24B-AM-1013-01	24B	AM	10132018	1		Gray		Gray+		Above Ground	50		1	0	0	1	0	took nut to bury	0	0	0	0	1	0	0	1		POINT (-73.967097592707 40.7854119342538)
342	342	-73.9605966636226	40.788984910863704	30E-AM-1008-01	30E	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1	scurried into bushes when jogger ran by	POINT (-73.9605966636226 40.7889849108637)
417	417	-73.9639888092327	40.791449395909	31A-AM-1010-01	31A	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9639888092327 40.791449395909005)
534	534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9650499507011 40.7908191782173)
641	641	-73.97190362174459	40.7803588122409	17A-AM-1017-01	17A	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3	ground & tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.9719036217446 40.7803588122409)
929	929	-73.97386112577159	40.773724677958704	10D-AM-1008-01	10D	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		1	0	0	0	1	0	0	1		POINT (-73.9738611257716 40.7737246779587)
1118	1118	-73.9719460335398	40.7810508156287	18A-AM-1012-01	18A	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	3	tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.9719460335398 40.7810508156287)
1911	1911	-73.9528937660465	40.7922919074537	36I-AM-1017-01	36I	AM	10172018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	1	runs from (me!)—from a pretty big distance	POINT (-73.9528937660465 40.7922919074537)
1939	1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9540151828782 40.7920066170587)
2199	2199	-73.9677500862135	40.7726060987821	11I-AM-1012-01	11I	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9677500862135 40.7726060987821)
2342	2342	-73.9533645762606	40.7983709215535	42F-AM-1019-01	42F	AM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	0	1	runs from (me)	POINT (-73.9533645762606 40.7983709215535)
2389	2389	-73.9801343393329	40.769151245340204	3A-AM-1012-01	03A	AM	10122018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9801343393329 40.7691512453402)
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)
2495	2495	-73.9621253644004	40.7912082086879	31C-AM-1017-01	31C	AM	10172018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	8		1	0	1	1	0		0	0	0	0	1	0	0	1		POINT (-73.9621253644004 40.7912082086879)
2757	2757	-73.96714191194559	40.77586024868621	14G-AM-1012-01	14G	AM	10122018	1	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9671419119456 40.7758602486862)
2849	2849	-73.9709912560997	40.77589655951979	13D-AM-1014-01	13D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9709912560997 40.7758965595198)
2969	2969	-73.9654409838612	40.7901338748522	29A-AM-1013-01	29A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	climbed tree (oak)	0	0	0	0	1	0	0	1		POINT (-73.9654409838612 40.7901338748522)

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
);