2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Foraging = 1, Indifferent = 0, Primary Fur Color = "Cinnamon" 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: Hectare, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, 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
79	79	-73.9610705592868	40.7914829661051	32D-AM-1013-06	32D	AM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	1	1	eating (a mushroom),circles around us,really fat,scratching himself,grooming activity	0	0	0	0	1	1	0	0		POINT (-73.9610705592868 40.7914829661051)
88	88	-73.9683608295976	40.784292740532706	22B-AM-1013-04	22B	AM	10132018	4	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	Under bench	0	0	0	0	1		0	0	0	0	0	0	0	1	ran from dog-walker	POINT (-73.9683608295976 40.7842927405327)
120	120	-73.9511118711108	40.7950813345902	40I-AM-1018-01	40I	AM	10182018	1	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	1	begging	0	0	0	0	0	0	0	0		POINT (-73.9511118711108 40.7950813345902)
204	204	-73.96795381633409	40.7837103696906	22C-AM-1013-03	22C	AM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1	eating (mushroom)	0	0	0	0	0	0	0	1		POINT (-73.9679538163341 40.7837103696906)
214	214	-73.97725765612441	40.767989509396294	3D-AM-1006-08	03D	AM	10062018	8	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0	approaches (food stand)	POINT (-73.9772576561244 40.7679895093963)
268	268	-73.968107276769	40.7768612676036	15F-AM-1007-09	15F	AM	10072018	9	Adult	Cinnamon	White	Cinnamon+White		Above Ground	20		0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.968107276769 40.7768612676036)
349	349	-73.9689657039917	40.776783427676705	15F-AM-1007-04	15F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9689657039917 40.7767834276767)
384	384	-73.968045072743	40.783662671722496	22C-AM-1013-02	22C	AM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		0	0	1	0	1		1	0	0	1	0	0	0	1		POINT (-73.968045072743 40.7836626717225)
397	397	-73.9690416961886	40.7716618670996	10H-AM-1014-05	10H	AM	10142018	5		Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9690416961886 40.7716618670996)
470	470	-73.95812430217221	40.794431473386	36D-AM-1007-01	36D	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	1	avoiding a dog	POINT (-73.95812430217221 40.794431473386)
699	699	-73.95046935442251	40.797225436004	42H-AM-1019-01	42H	AM	10192018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9504693544225 40.797225436004)
954	954	-73.96584435488221	40.7796704898979	19F-AM-1007-03	19F	AM	10072018	3	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	scared	POINT (-73.9658443548822 40.7796704898979)
982	982	-73.9676424599715	40.777776610680704	16F-AM-1008-01	16F	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	near fence	0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9676424599715 40.7777766106807)
1050	1050	-73.9562642076935	40.798333876307396	41C-AM-1017-02	41C	AM	10172018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9562642076935 40.7983338763074)
1088	1088	-73.9770985425092	40.7665926744505	1E-AM-1006-04	01E	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9770985425092 40.7665926744505)
1098	1098	-73.96049542761291	40.7965682182001	37A-AM-1012-01	37A	AM	10122018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Drawing included on tally sheet	Ground Plane	FALSE		0	0	0	0	1	scanning (drawing included)	0	0	0	0	0	0	0	1		POINT (-73.9604954276129 40.7965682182001)
1412	1412	-73.9594676326588	40.7984457363388	39A-AM-1013-01	39A	AM	10132018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9594676326588 40.7984457363388)
1617	1617	-73.97520295136441	40.767173466736104	3F-AM-1006-04	03F	AM	10062018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on a rock	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9752029513644 40.7671734667361)
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)
2001	2001	-73.9521655419974	40.7948785497717	39H-AM-1007-04	39H	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9521655419974 40.7948785497717)
2156	2156	-73.96503878480009	40.7814134438394	21F-AM-1018-04	21F	AM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9650387848001 40.7814134438394)
2218	2218	-73.9694382427984	40.7846350692923	22A-AM-1008-04	22A	AM	10082018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9694382427984 40.7846350692923)
2281	2281	-73.96915208260279	40.77171040377829	10H-AM-1014-06	10H	AM	10142018	6		Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9691520826028 40.7717104037783)
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)
2453	2453	-73.9756105226696	40.7696531972655	5D-AM-1020-03	05D	AM	10202018	3	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9756105226696 40.7696531972655)
2464	2464	-73.96913180449691	40.770980197469605	9I-AM-1014-05	09I	AM	10142018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9691318044969 40.7709801974696)
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)
2608	2608	-73.95226776576591	40.7934034811368	38I-AM-1019-02	38I	AM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9522677657659 40.7934034811368)
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)
2900	2900	-73.9631005470369	40.788549405719294	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9631005470369 40.7885494057193)
2976	2976	-73.97240833205379	40.7744163768061	11D-AM-1010-08	11D	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	1	drinking	0	0	0	0	0	1	0	0		POINT (-73.9724083320538 40.7744163768061)

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