2018_Central_Park_Squirrel_Census_-_Squirrel_Data

59 rows where Date = 10132018, Indifferent = 0, Moans = 0 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Runs from, 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
27	27	-73.9670628558161	40.7734991420941	12I-AM-1013-01	12I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on tree roots	0	0	0	0	0	sitting	0	0	0	0	1	0	0	1		POINT (-73.9670628558161 40.77349914209411)
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)
30	30	-73.96929432916109	40.776953610248796	15E-AM-1013-01	15E	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9692943291611 40.7769536102488)
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)
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)
145	145	-73.971970670614	40.7720868124544	9F-AM-1013-04	09F	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.971970670614 40.7720868124544)
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)
222	222	-73.97702735535249	40.7732399463626	8A-AM-1013-03	08A	AM	10132018	3	Juvenile			+		Above Ground	3	fence	1	1	1	1	0	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770273553525 40.7732399463626)
271	271	-73.9661262885099	40.7844085550945	23D-AM-1013-01	23D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		0	0	1	0	0		0	0	0	0	0	1	0	0	approaches (he saw me,came towards,then darted up)	POINT (-73.9661262885099 40.7844085550945)
291	291	-73.9679661308374	40.7837388390673	22C-AM-1013-01	22C	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	0	0	sitting still,tail over back	0	0	0	0	0	0	0	0		POINT (-73.9679661308374 40.7837388390673)
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)
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)
497	497	-73.96021668769791	40.7953811003986	36B-AM-1013-04	36B	AM	10132018	4		Black		Black+		Above Ground	20	Moved 20+ feet high above top of tree limb	0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9602166876979 40.7953811003986)
630	630	-73.9580109357087	40.78556544054471	28I-AM-1013-01	28I	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Jumped onto path & then back into brush	0	0	0	0	0	stood on fence	0	0	0	0	0	0	0	1		POINT (-73.9580109357087 40.7855654405447)
654	654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.976769659152 40.7741908010484)
797	797	-73.969345754447	40.7770429650288	15E-AM-1013-02	15E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		1	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.969345754447 40.7770429650288)
819	819	-73.9603620122205	40.7955965755851	36B-AM-1013-02	36B	AM	10132018	2		Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	didn't see me	POINT (-73.9603620122205 40.7955965755851)
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)
867	867	-73.9762257701293	40.7744032758323	9A-AM-1013-08	09A	AM	10132018	8	Adult			+					0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9762257701293 40.7744032758323)
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)
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)
1011	1011	-73.97191114701641	40.7758789855474	12D-AM-1013-02	12D	AM	10132018	2	Adult	Gray		Gray+		Above Ground	7	Was on top of the edge of Bow Bridge	0	0	0	0	0	jumped off	0	0	0	1	0	0	0	1		POINT (-73.9719111470164 40.7758789855474)
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)
1261	1261	-73.9719109949232	40.772313852132704	9F-AM-1013-01	09F	AM	10132018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9719109949232 40.7723138521327)
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)
1354	1354	-73.97652692820591	40.774687663524794	9A-AM-1013-10	09A	AM	10132018	10	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9765269282059 40.7746876635248)
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)
1449	1449	-73.95611248920629	40.7949440648632	37E-AM-1013-04	37E	AM	10132018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	8		0	0	1	1	0		1	0	0	0	0	0	0	1		POINT (-73.9561124892063 40.7949440648632)
1459	1459	-73.95638478673159	40.790601226116294	33G-AM-1013-03	33G	AM	10132018	3	?			+	Only peeked head out	Above Ground	13		0	0	0	0	0	peeking out of tree,did *not* come out	0	0	0	0	0	0	0	0		POINT (-73.9563847867316 40.7906012261163)
1467	1467	-73.9684657285532	40.7840113573723	22B-AM-1013-05	22B	AM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		tree	0	0	1	0	0		0	0	0	0	0	0	0	0	looked down on me like her imperial subject	POINT (-73.9684657285532 40.7840113573723)
1493	1493	-73.96847906578509	40.7838818717863	22B-AM-1013-01	22B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	looked at me,standing on back feet	POINT (-73.9684790657851 40.7838818717863)
1507	1507	-73.9699799501516	40.7736576286234	11F-AM-1013-02	11F	AM	10132018	2	Adult	Gray		Gray+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699799501516 40.7736576286234)
1553	1553	-73.9690645326017	40.7773822116124	15E-AM-1013-03	15E	AM	10132018	3	Adult	Gray		Gray+		Above Ground	2	on fallen log	0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9690645326017 40.7773822116124)
1621	1621	-73.97349693209429	40.7722754599865	8E-AM-1013-01	08E	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9734969320943 40.7722754599865)
1623	1623	-73.97701191330229	40.773294909000505	8A-AM-1013-04	08A	AM	10132018	4	Juvenile			+		Above Ground	4	fence	1	1	0	1	1	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770119133023 40.7732949090005)
1707	1707	-73.96045242711669	40.7956624328733	36B-AM-1013-01	36B	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9604524271167 40.7956624328733)
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)
1938	1938	-73.9719879697272	40.7725625124591	9F-AM-1013-02	09F	AM	10132018	2	Adult	Black		Black+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9719879697272 40.7725625124591)
1939	1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9540151828782 40.7920066170587)
2161	2161	-73.9715375915057	40.7751212088827	12D-AM-1013-01	12D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9715375915057 40.7751212088827)
2179	2179	-73.95596639495109	40.7974497269789	40D-AM-1013-07	40D	AM	10132018	7	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	1		0	0	0	0	0	0	0	1	curious	POINT (-73.9559663949511 40.7974497269789)
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)
2262	2262	-73.9556177490335	40.788856916153705	32I-AM-1013-03	32I	AM	10132018	3	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.9556177490335 40.7888569161537)
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)
2275	2275	-73.96142184133559	40.793894505879294	34B-AM-1013-01	34B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	hopping	0	0	0	0	1	1	0	0		POINT (-73.9614218413356 40.7938945058793)
2284	2284	-73.9730181306326	40.779460132242704	16A-AM-1013-02	16A	AM	10132018	2	Adult	Black		Black+		Above Ground			0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9730181306326 40.7794601322427)
2338	2338	-73.9716621112698	40.774286221946895	11E-AM-1013-01	11E	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9716621112698 40.7742862219469)
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)
2377	2377	-73.9704328573603	40.7739347247552	11F-AM-1013-03	11F	AM	10132018	3	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9704328573603 40.7739347247552)
2446	2446	-73.95227045119691	40.796566887896105	41G-AM-1013-01	41G	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9522704511969 40.7965668878961)
2479	2479	-73.9657958433575	40.7763496875058	15H-AM-1013-01	15H	AM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9657958433575 40.7763496875058)
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)
2609	2609	-73.95968653180941	40.7893787188526	31F-AM-1013-01	31F	AM	10132018	1	Adult	Gray	Black	Gray+Black		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9596865318094 40.7893787188526)
2646	2646	-73.9772239251936	40.7731716665766	8A-AM-1013-05	08A	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		1	0	1	1	0		0	0	0	0	0	1	0	0		POINT (-73.9772239251936 40.7731716665766)
2693	2693	-73.95614986460359	40.7949288561893	37E-AM-1013-05	37E	AM	10132018	5	?			+		Above Ground	10	unsure, just heard kuks	0	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9561498646036 40.79492885618931)
2784	2784	-73.9763722433833	40.7744121430891	9A-AM-1013-07	09A	AM	10132018	7	Adult			+					0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9763722433833 40.7744121430891)
2926	2926	-73.9714653576023	40.77174001395021	9F-AM-1013-03	09F	AM	10132018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9714653576023 40.7717400139502)
2969	2969	-73.9654409838612	40.7901338748522	29A-AM-1013-01	29A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	climbed tree (oak)	0	0	0	0	1	0	0	1		POINT (-73.9654409838612 40.7901338748522)

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