2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Age = "Juvenile", Hectare Squirrel Number = 2, Highlight Fur Color = "Cinnamon" and Primary Fur Color = "Gray"

- 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: Shift, Date, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, 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
6	6	-73.9565700386162	40.7902561000937	33H-AM-1019-02	33H	AM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	wrestling with mother	0	0	0	0	0	0	0	0		POINT (-73.9565700386162 40.7902561000937)
43	43	-73.9574648097543	40.7892508428622	31H-PM-1008-02	31H	PM	10082018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9574648097543 40.78925084286221)
169	169	-73.97487064155841	40.7744174965072	10B-AM-1006-02	10B	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		High in a tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9748706415584 40.7744174965072)
209	209	-73.97107601968679	40.7725506006789	10F-PM-1019-02	10F	PM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head & stripe	Ground Plane	FALSE	Behind fence, grass	1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9710760196868 40.7725506006789)
374	374	-73.9556817958407	40.788852000621	32I-AM-1013-02	32I	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	0	0	watching me from tree - curious	POINT (-73.9556817958407 40.788852000621)
419	419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9777328709928 40.7669087724668)
484	484	-73.9666526554772	40.7756111718355	14H-AM-1007-02	14H	AM	10072018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9666526554772 40.77561117183551)
871	871	-73.9583738783348	40.7979302775527	39B-PM-1014-02	39B	PM	10142018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9583738783348 40.7979302775527)
880	880	-73.95656845779891	40.79360039404129	36F-PM-1012-02	36F	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9565684577989 40.7936003940413)
993	993	-73.97724226646571	40.773436329163	8A-AM-1013-02	08A	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	playground	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9772422664657 40.773436329163)
995	995	-73.9698843507358	40.780375418758105	18C-PM-1018-02	18C	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9698843507358 40.7803754187581)
1064	1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon					1	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9540257319561 40.798408619116)
1531	1531	-73.9630381400083	40.7807571827321	21H-PM-1018-02	21H	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9630381400083 40.7807571827321)
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)
1782	1782	-73.9549133872427	40.7946871036949	38F-PM-1013-02	38F	PM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9549133872427 40.7946871036949)
2029	2029	-73.9687213827744	40.7843586374648	22B-PM-1014-02	22B	PM	10142018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9687213827744 40.7843586374648)
2368	2368	-73.9731925179247	40.7748962746181	11D-PM-1006-02	11D	PM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9731925179247 40.7748962746181)
2426	2426	-73.9790203973636	40.768883711483205	3B-AM-1010-02	03B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	together w/ #3	0	0	0	0	0	0	0	1		POINT (-73.9790203973636 40.7688837114832)
2432	2432	-73.9657203199746	40.775173008911	14I-PM-1018-02	14I	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9657203199746 40.775173008911)
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)

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