2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Date = 10132018, Running = 1 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

- 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions

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
83	83	-73.9617088749928	40.7944585082367	35A-PM-1013-06	35A	PM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9617088749928 40.7944585082367)
109	109	-73.967097592707	40.785411934253794	24B-AM-1013-01	24B	AM	10132018	1		Gray		Gray+		Above Ground	50		1	0	0	1	0	took nut to bury	0	0	0	0	1	0	0	1		POINT (-73.967097592707 40.7854119342538)
403	403	-73.9597470659927	40.797321593541604	38A-PM-1013-01	38A	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9597470659927 40.7973215935416)
409	409	-73.9530809650496	40.7959176317705	40G-PM-1013-02	40G	PM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0	hiding from dog	0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9530809650496 40.79591763177051)
536	536	-73.9561141662309	40.7976258458604	40D-PM-1013-05	40D	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9561141662309 40.7976258458604)
583	583	-73.9612398509782	40.7950033150385	35A-PM-1013-12	35A	PM	10132018	12	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9612398509782 40.7950033150385)
628	628	-73.96001657854859	40.795246676183204	36B-PM-1013-03	36B	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9600165785486 40.7952466761832)
824	824	-73.9606344681252	40.7958337780644	37B-PM-1013-04	37B	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9606344681252 40.795833778064406)
852	852	-73.9609704650925	40.7938786854735	34B-AM-1013-03	34B	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		1	0	1	0	0	hopping	0	0	0	0	0	1	0	1		POINT (-73.9609704650925 40.7938786854735)
859	859	-73.9600964585868	40.7952339524416	36B-PM-1013-02	36B	PM	10132018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	1	1	0	1		POINT (-73.9600964585868 40.7952339524416)
902	902	-73.969105907	40.782047490919204	20B-PM-1013-08	20B	PM	10132018	8	Adult	Gray	White	Gray+White	(very brown)	Ground Plane	FALSE		1	0	0	0	0	being chased by dog	0	0	0	0	0	0	0	1		POINT (-73.969105907 40.7820474909192)
943	943	-73.9773096718574	40.773805386248895	8A-AM-1013-06	08A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9773096718574 40.7738053862489)
955	955	-73.96065706156101	40.79561507441021	36A-PM-1013-08	36A	PM	10132018	8		Gray		Gray+		Ground Plane	FALSE	"FIELD"	1	0	0	0	0	running from #7	0	0	0	0	0	0	0	1		POINT (-73.960657061561 40.7956150744102)
979	979	-73.9612349421547	40.795958647574395	36A-PM-1013-09	36A	PM	10132018	9		Gray		Gray+		Ground Plane	FALSE	THICK UNDERGROWTH	1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9612349421547 40.7959586475744)
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)
1029	1029	-73.9601259189134	40.795535060905706	36B-PM-1013-04	36B	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9601259189134 40.7955350609057)
1059	1059	-73.97494575169209	40.7676712372245	3F-PM-1013-07	03F	PM	10132018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9749457516921 40.7676712372245)
1096	1096	-73.95683008997729	40.793585574335395	36E-AM-1013-01	36E	AM	10132018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran into treebrush)	POINT (-73.9568300899773 40.7935855743354)
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)
1176	1176	-73.9553263156025	40.79755920605721	40D-PM-1013-04	40D	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9553263156025 40.7975592060572)
1180	1180	-73.9639726817977	40.7829083461049	23F-PM-1013-01	23F	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.)	POINT (-73.9639726817977 40.7829083461049)
1200	1200	-73.9657721715305	40.778534830257	18G-PM-1013-03	18G	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9657721715305 40.778534830257)
1294	1294	-73.9604089940153	40.7910028063138	32D-AM-1013-04	32D	AM	10132018	4	Adult	Cinnamon		Cinnamon+	Brown legs	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	1	0	1		POINT (-73.9604089940153 40.7910028063138)
1346	1346	-73.9735655529245	40.7716072681474	7E-PM-1013-02	07E	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Ground & Tree Base	1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9735655529245 40.7716072681474)
1348	1348	-73.95991976123891	40.7954836456006	36B-PM-1013-05	36B	PM	10132018	5	Adult	Gray		Gray+		Above Ground	4		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9599197612389 40.7954836456006)
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)
1442	1442	-73.961241953418	40.7941677113011	35B-PM-1013-07	35B	PM	10132018	7	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	1	0	got fed twice by grandpa,grabbed from grass and ate in tree	0	0	0	0	0	1	1	1	approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up.	POINT (-73.961241953418 40.7941677113011)
1594	1594	-73.9778730762957	40.770827251547	5B-PM-1013-05	05B	PM	10132018	5	Adult	Gray		Gray+		Above Ground	3		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9778730762957 40.770827251547)
1656	1656	-73.9557399927792	40.7971563708988	40D-PM-1013-07	40D	PM	10132018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9557399927792 40.7971563708988)
1900	1900	-73.9529224802393	40.796189576364895	40G-PM-1013-05	40G	PM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (to the tree)	POINT (-73.9529224802393 40.7961895763649)
1932	1932	-73.96169725573041	40.7953872829374	36A-PM-1013-03	36A	PM	10132018	3	Juvenile	Cinnamon		Cinnamon+	COULD HAVE BEEN CHIPPY, DEEP BROWN	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9616972557304 40.7953872829374)
1952	1952	-73.96818104666929	40.7720638449419	10I-PM-1013-01	10I	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9681810466693 40.7720638449419)
2143	2143	-73.9596232170232	40.7959550843229	37B-PM-1013-01	37B	PM	10132018	1	Adult	Gray		Gray+	Sighting was far away	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9596232170232 40.795955084322905)
2242	2242	-73.9565824187667	40.797312050952	40D-AM-1013-06	40D	AM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		1	0	1	0	1		1	0	0	0	1	0	0	1		POINT (-73.9565824187667 40.797312050952)
2263	2263	-73.95693753558841	40.793539800861204	36E-AM-1013-02	36E	AM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9569375355884 40.7935398008612)
2278	2278	-73.96453903109901	40.78099163100121	20G-PM-1013-01	20G	PM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.964539031099 40.7809916310012)
2357	2357	-73.96323010348829	40.7925707244111	32A-PM-1013-06	32A	PM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9632301034883 40.7925707244111)
2371	2371	-73.9769520212123	40.774006725862996	9A-AM-1013-01	09A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9769520212123 40.774006725863)
2373	2373	-73.9613276802049	40.7943813964442	35B-PM-1013-03	35B	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1	threatened by approaching dog (dog #1)	0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.96132768020492 40.7943813964442)
2423	2423	-73.973552877209	40.7715638228207	7E-PM-1013-01	07E	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Ground & Tree Base	1	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.973552877209 40.7715638228207)
2483	2483	-73.9596083366477	40.7949526729608	36C-PM-1013-05	36C	PM	10132018	5	Adult	Cinnamon		Cinnamon+	"Warm brown" written in for Primary.	Ground Plane	FALSE	Ran across path in front of people	1	0	0	1	1		0	0	0	0	1	0	1	1		POINT (-73.9596083366477 40.7949526729608)
2562	2562	-73.9615643742864	40.7944678447843	35B-PM-1013-06	35B	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	1	0	0	chased by dog #2	1	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9615643742864 40.7944678447843)
2585	2585	-73.9771726831497	40.7732320781799	8A-AM-1013-01	08A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	trail	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9771726831497 40.7732320781799)
2672	2672	-73.9614599022015	40.7945181285991	35A-PM-1013-11	35A	PM	10132018	11	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9614599022015 40.7945181285991)
2716	2716	-73.9618094076328	40.7944097368153	35A-PM-1013-03	35A	PM	10132018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9618094076328 40.7944097368153)
2727	2727	-73.974596903918	40.7765498215674	12A-PM-1013-02	12A	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.974596903918 40.7765498215674)
2767	2767	-73.9751806727197	40.7671940332258	3F-PM-1013-05	03F	PM	10132018	5	Adult	Gray	White	Gray+White		Above Ground	13		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97518067271972 40.7671940332258)
2810	2810	-73.9614659899028	40.7945562907624	35A-PM-1013-10	35A	PM	10132018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9614659899028 40.7945562907624)
2820	2820	-73.9615926031253	40.7944223235385	35B-PM-1013-05	35B	PM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	0	chased by dog #2	1	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.96159260312531 40.7944223235385)
2985	2985	-73.9721159387757	40.766050318863705	3I-PM-1013-03	03I	PM	10132018	3	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9721159387757 40.7660503188637)
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
);