2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Eating = 0, Foraging = 1, Hectare Squirrel Number = 4 and Runs from = 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: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Tail flags, Tail twitches, Indifferent

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
29	29	-73.96717867152559	40.7867352791232	25A-AM-1013-04	25A	AM	10132018	4		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9671786715256 40.7867352791232)
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)
108	108	-73.9574809028248	40.7950013620207	37D-PM-1014-04	37D	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	1	chasing (a chipmunk)	0	0	0	0	0	0	0	1		POINT (-73.9574809028248 40.7950013620207)
205	205	-73.9564724104048	40.7936055508162	36F-PM-1012-04	36F	PM	10122018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9564724104048 40.7936055508162)
242	242	-73.9590236602085	40.798263245686606	40A-AM-1010-04	40A	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom great hill	0	0	0	0	1		0	0	0	1	0	0	1	1	dog chased	POINT (-73.9590236602085 40.7982632456866)
302	302	-73.9695176417703	40.7741725190048	12G-PM-1007-04	12G	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9695176417703 40.7741725190048)
427	427	-73.9589367709165	40.78964653034829	31F-PM-1007-04	31F	PM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9589367709165 40.7896465303483)
914	914	-73.9760801742337	40.7674218954729	3E-AM-1006-04	03E	AM	10062018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9760801742337 40.7674218954729)
968	968	-73.9689781843873	40.7709333833783	9I-PM-1010-04	09I	PM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9689781843873 40.7709333833783)
1005	1005	-73.95582687317709	40.7952074193788	38E-PM-1014-04	38E	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE	THICK UNDERGROWTH	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9558268731771 40.7952074193788)
1124	1124	-73.959516757215	40.7952545908471	36C-PM-1013-04	36C	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE	On rock	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.959516757215 40.7952545908471)
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)
1626	1626	-73.9617519095277	40.794717907138796	35A-PM-1013-04	35A	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE	In the weeds by the pool	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9617519095277 40.7947179071388)
1809	1809	-73.96901686738441	40.777761204391396	15E-AM-1013-04	15E	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9690168673844 40.7777612043914)
2011	2011	-73.9603245806655	40.79427124776971	35C-PM-1013-04	35C	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9603245806655 40.7942712477697)
2158	2158	-73.9597593485091	40.7937528403249	35C-AM-1007-04	35C	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9597593485091 40.7937528403249)
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)
2329	2329	-73.9717515173863	40.7747999274418	11D-PM-1006-04	11D	PM	10062018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9717515173863 40.7747999274418)
2828	2828	-73.9587439756541	40.7849006107353	27I-AM-1007-04	27I	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9587439756541 40.7849006107353)
2934	2934	-73.9561669236168	40.799473743127706	42C-PM-1013-04	42C	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9561669236168 40.7994737431277)
3005	3005	-73.96161411525391	40.7921803313341	33C-PM-1007-04	33C	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616141152539 40.7921803313341)
3012	3012	-73.96137019608979	40.7943363227822	35B-PM-1013-04	35B	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	1	got threatened by dog (same dog,dog #1)	0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9613701960898 40.7943363227822)

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