2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Hectare Squirrel Number = 1, Shift = "AM" and Tail flags = 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

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail twitches, Approaches, Indifferent, Runs from

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
38	38	-73.9742073452913	40.7757957380463	12B-AM-1007-01	12B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9742073452913 40.7757957380463)
308	308	-73.9554095823557	40.788730580204394	32I-AM-1013-01	32I	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9554095823557 40.7887305802044)
373	373	-73.96721272832829	40.7810666805133	20D-AM-1007-01	20D	AM	10072018	1	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		1	0	1	1	0	a lot of activity	0	0	0	1	0	0	0	0		POINT (-73.9672127283283 40.7810666805133)
507	507	-73.9744835563086	40.7729521433235	9D-AM-1008-01	09D	AM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9744835563086 40.7729521433235)
566	566	-73.9708364583591	40.772369158743295	10F-AM-1007-01	10F	AM	10072018	1	Adult	Gray		Gray+		Above Ground	60		0	0	1	0	0		0	0	0	1	0	0	0	0		POINT (-73.9708364583591 40.7723691587433)
568	568	-73.97994414934041	40.767149999752704	1C-AM-1012-01	01C	AM	10122018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9799441493404 40.7671499997527)
1007	1007	-73.96353178229771	40.7821352080233	22G-AM-1018-01	22G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		1	0	0	1	0	0	1	0		POINT (-73.9635317822977 40.7821352080233)
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	0	0	0	1	0		0	0	0	1	1	1	0	0		POINT (-73.9594357049738 40.7840678890949)
1235	1235	-73.9679686793869	40.7825993867876	21C-AM-1014-01	21C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		1	0	0	0	0	jumping back & forth on tree	0	0	0	1	1	0	1	0		POINT (-73.9679686793869 40.7825993867876)
1818	1818	-73.956863563379	40.798641885114705	41C-AM-1017-01	41C	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.95686356337902 40.7986418851147)
2044	2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	1	0	0		POINT (-73.9771552326199 40.7706917595308)
2429	2429	-73.97266996869429	40.770112379122295	7F-AM-1008-01	07F	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bench	0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9726699686943 40.7701123791223)
2440	2440	-73.96738035086291	40.778524502550795	17F-AM-1007-01	17F	AM	10072018	1	Adult	Gray		Gray+		Above Ground	18		0	0	1	1	0		0	0	0	1	0	0	1	0		POINT (-73.9673803508629 40.7785245025508)
2469	2469	-73.9600963639087	40.7934962325313	34C-AM-1007-01	34C	AM	10072018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1	dog	POINT (-73.9600963639087 40.7934962325313)
2489	2489	-73.9663168490265	40.7825083721362	21D-AM-1008-01	21D	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	1	0	1	0		POINT (-73.9663168490265 40.7825083721362)
2569	2569	-73.9559663734409	40.794582826137706	37F-AM-1010-01	37F	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	0	0		0	0	0	1	0	0	1	0		POINT (-73.9559663734409 40.7945828261377)
2583	2583	-73.97696931406509	40.7684390015166	3D-AM-1006-01	03D	AM	10062018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	9	up a tree	1	0	1	1	1	digging (?)	0	0	0	1	0	0	0	1	runs from (man led his dog into the area to chase squirrel)	POINT (-73.9769693140651 40.7684390015166)

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