2018_Central_Park_Squirrel_Census_-_Squirrel_Data

25 rows where Foraging = 1, Hectare Squirrel Number = 2, 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, Tail flags, 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
127	127	-73.96641005044359	40.7828778892276	21D-AM-1008-02	21D	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9664100504436 40.7828778892276)
184	184	-73.9553811810434	40.7970895007931	40E-AM-1014-02	40E	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9553811810434 40.7970895007931)
304	304	-73.9523001834395	40.7949231000186	39H-AM-1007-02	39H	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9523001834395 40.7949231000186)
485	485	-73.9677423154682	40.7728813350245	11I-AM-1012-02	11I	AM	10122018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9677423154682 40.77288133502451)
508	508	-73.97469187620759	40.765523188367794	1G-AM-1006-02	01G	AM	10062018	2	Juvenile	Gray	White	Gray+White		Above Ground	30		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9746918762076 40.7655231883678)
513	513	-73.96310068980699	40.7920255189467	32B-AM-1017-02	32B	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon on its head	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.963100689807 40.79202551894671)
756	756	-73.9773079154219	40.7696506688861	4C-AM-1006-02	04C	AM	10062018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9773079154219 40.7696506688861)
862	862	-73.9626120417397	40.790512635862605	30C-AM-1014-02	30C	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	on a rock	1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9626120417397 40.7905126358626)
1035	1035	-73.97725699096729	40.7664804797448	1E-AM-1006-02	01E	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9772569909673 40.7664804797448)
1057	1057	-73.9594406225891	40.7918533707789	33D-AM-1017-02	33D	AM	10172018	2	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9594406225891 40.7918533707789)
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)
1387	1387	-73.9697160572446	40.7711445570446	9H-AM-1006-02	09H	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.96971605724461 40.7711445570446)
1488	1488	-73.9690072647093	40.7737712267463	12G-AM-1012-02	12G	AM	10122018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9690072647093 40.7737712267463)
1578	1578	-73.97352989433209	40.771493999358896	8E-AM-1013-02	08E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9735298943321 40.7714939993589)
1593	1593	-73.9676539688726	40.7777229934129	16F-AM-1008-02	16F	AM	10082018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near fence	0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9676539688726 40.7777229934129)
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)
1808	1808	-73.9698870647042	40.7826510985538	20B-AM-1007-02	20B	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	1	1	0	0		POINT (-73.9698870647042 40.7826510985538)
1816	1816	-73.9710187505339	40.7797265666746	17B-AM-1010-02	17B	AM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9710187505339 40.7797265666746)
1885	1885	-73.9594174605642	40.7973128653773	38B-AM-1019-02	38B	AM	10192018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9594174605642 40.7973128653773)
2037	2037	-73.96833704175509	40.781359835050004	19D-AM-1007-02	19D	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	0	1		0	0	0	0	1	0	0	0	fenced area	POINT (-73.9683370417551 40.78135983505)
2216	2216	-73.97351950184459	40.778714727971504	14A-AM-1014-02	14A	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	1	0	0	0		POINT (-73.9735195018446 40.7787147279715)
2273	2273	-73.9671534029191	40.7810849804467	20D-AM-1007-02	20D	AM	10072018	2	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		0	0	0	0	1	quieter	0	0	0	0	1	0	0	0		POINT (-73.9671534029191 40.7810849804467)
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)
2576	2576	-73.9751625910271	40.7671023412885	3F-AM-1006-02	03F	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9751625910271 40.7671023412885)
2999	2999	-73.972415182837	40.773080463452004	10E-AM-1010-02	10E	AM	10102018	2	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.972415182837 40.773080463452)

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