2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Eating = 1, Hectare Squirrel Number = 2, Indifferent = 1 and Shift = "AM"

- 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, Foraging, Kuks, Quaas, Tail twitches, 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
68	68	-73.96942403275091	40.7755898126674	13F-AM-1007-02	13F	AM	10072018	2	Adult	Cinnamon	White	Cinnamon+White					0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96942403275091 40.7755898126674)
187	187	-73.9700162034073	40.7815277479588	19B-AM-1019-02	19B	AM	10192018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0	posing	0	0	0	0	0	0	1	1	indifferent then runs from	POINT (-73.9700162034073 40.7815277479588)
199	199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		1	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9771614686616 40.7709677983247)
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)
319	319	-73.96590343597059	40.779751668884394	19F-AM-1007-02	19F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9659034359706 40.77975166888441)
346	346	-73.9712971568288	40.7745520717065	11E-AM-1013-02	11E	AM	10132018	2	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712971568288 40.7745520717065)
450	450	-73.96442931957729	40.7813829172072	21F-AM-1018-02	21F	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9644293195773 40.7813829172072)
535	535	-73.9772396728545	40.7668696411765	2E-AM-1010-02	02E	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0	totally indifferent	POINT (-73.9772396728545 40.7668696411765)
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)
1062	1062	-73.957259673402	40.7974442913898	39C-AM-1017-02	39C	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.957259673402 40.7974442913898)
1120	1120	-73.9564079273261	40.7939340053805	36F-AM-1017-02	36F	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon on shoulders	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9564079273261 40.7939340053805)
1203	1203	-73.9616999731028	40.7954126939561	36A-AM-1018-02	36A	AM	10182018	2	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9616999731028 40.7954126939561)
1439	1439	-73.9729645190377	40.7723310150843	9E-AM-1008-02	09E	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9729645190377 40.7723310150843)
1444	1444	-73.9763852372393	40.768876248561	4D-AM-1012-02	04D	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9763852372393 40.768876248561)
1482	1482	-73.95886101956991	40.7945269936639	36C-AM-1014-02	36C	AM	10142018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	Crossing path	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9588610195699 40.7945269936639)
1528	1528	-73.9690104245067	40.7853358193723	23A-AM-1018-02	23A	AM	10182018	2	Juvenile	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690104245067 40.7853358193723)
1603	1603	-73.95459292421741	40.7986940168685	42D-AM-1014-02	42D	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9545929242174 40.7986940168685)
1708	1708	-73.9618486459307	40.7946365810826	35A-AM-1014-02	35A	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9618486459307 40.7946365810826)
1853	1853	-73.9721210372896	40.7667971476099	4I-AM-1006-02	04I	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9721210372896 40.7667971476099)
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)
1936	1936	-73.9667911565238	40.779321901098	18F-AM-1014-02	18F	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE	In small tree by water	0	0	0	1	1		0	1	0	0	0	0	1	0		POINT (-73.9667911565238 40.77932190109801)
1990	1990	-73.9774584305147	40.770813398619204	5B-AM-1008-02	05B	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9774584305147 40.7708133986192)
2300	2300	-73.9789251806378	40.7699558513225	4B-AM-1010-02	04B	AM	10102018	2	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	30		0	0	1	1	1		1	0	0	0	0	0	1	0		POINT (-73.9789251806378 40.7699558513225)
2470	2470	-73.96388775886999	40.79154773042521	31A-AM-1010-02	31A	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1	scratching	0	0	0	0	0	0	1	0		POINT (-73.96388775887 40.7915477304252)
2510	2510	-73.9748635473782	40.7742591029151	10C-AM-1018-02	10C	AM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0	sitting in the sun	0	0	0	0	0	0	1	0		POINT (-73.9748635473782 40.7742591029151)
2578	2578	-73.97653869653709	40.766371971272996	1F-AM-1010-02	01F	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765386965371 40.766371971273)
2739	2739	-73.9681960138614	40.7726867422002	11H-AM-1010-02	11H	AM	10102018	2		Cinnamon	Gray	Cinnamon+Gray					0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9681960138614 40.7726867422002)
2783	2783	-73.97917671562679	40.7714445258765	5A-AM-1006-02	05A	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12	in tall shrubs near wall next to CPW	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9791767156268 40.7714445258765)
2846	2846	-73.96615704780291	40.7807271518813	20E-AM-1014-02	20E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9661570478029 40.7807271518813)
2885	2885	-73.9530811255728	40.7983069118579	42F-AM-1019-02	42F	AM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9530811255728 40.79830691185791)
3006	3006	-73.97443902173859	40.7663168362582	2G-AM-1010-02	02G	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9744390217386 40.7663168362582)

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