squirrels

247 rows where Combination of Primary and Highlight Color = "Gray+", Location = "Above Ground" and Running = "false"

- 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts

= != contains ends with starts with > ≥ < ≤ 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 Sort by Zip Codes Sort by Community Districts Sort by Borough Boundaries Sort by City Council Districts Sort by Police Precincts

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, 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	Zip Codes	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
4	4	-73.9757249834141	40.7697032606755	5D-PM-1018-05	05D	PM	10182018	5	Juvenile	Gray		Gray+		Above Ground	3		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9757249834141 40.7697032606755)		19	4	19	13
39	39	-73.9716147061553	40.7813911036179	18A-PM-1018-01	18A	PM	10182018	1	Adult	Gray		Gray+		Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9716147061553 40.7813911036179)		19	4	19	13
46	46	-73.9673253417305	40.7749505252981	13H-PM-1010-02	13H	PM	10102018	2	Adult	Gray		Gray+		Above Ground	5	tree	false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9673253417305 40.7749505252981)		19	4	19	13
48	48	-73.9595933195409	40.7905847332369	32E-AM-1007-13	32E	AM	10072018	13	Adult	Gray		Gray+		Above Ground	50		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9595933195409 40.7905847332369)		19	4	19	13
49	49	-73.9602222116708	40.793779699421	35C-AM-1007-05	35C	AM	10072018	5	Adult	Gray		Gray+		Above Ground	4		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9602222116708 40.793779699421)		19	4	19	13
71	71	-73.9576245992455	40.7873862510001	29H-PM-1006-01	29H	PM	10062018	1	Adult	Gray		Gray+		Above Ground	50		false	false	true	false	false	sitting	false	false	false	false	false	false	true	false		POINT (-73.9576245992455 40.7873862510001)		19	4	19	13
72	72	-73.9666007935638	40.7845098131567	23C-PM-1014-03	23C	PM	10142018	3	Adult	Gray		Gray+		Above Ground	8		false	true	false	false	false	chasing (#4 across trees)	false	false	false	false	false	false	false	false		POINT (-73.9666007935638 40.7845098131567)		19	4	19	13
86	86	-73.9708726050721	40.7723572030236	10F-AM-1007-02	10F	AM	10072018	2	Adult	Gray		Gray+		Above Ground	70		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9708726050721 40.7723572030236)		19	4	19	13
91	91	-73.9565905868276	40.7895654068546	32H-PM-1006-01	32H	PM	10062018	1		Gray		Gray+		Above Ground		in the European Beech	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9565905868276 40.7895654068546)		19	4	19	13
96	96	-73.9708549670788	40.7699587019058	7H-PM-1006-04	07H	PM	10062018	4	Adult	Gray		Gray+		Above Ground	12	on tree knob	false	false	false	false	false	sitting	false	false	false	false	false	false	true	false		POINT (-73.9708549670788 40.7699587019058)		19	4	19	13
98	98	-73.9730277911422	40.7712145488828	7F-AM-1008-16	07F	AM	10082018	16	Juvenile	Gray		Gray+		Above Ground	2	tree	false	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9730277911422 40.7712145488828)		19	4	19	13
100	100	-73.9761592532482	40.7747213585387	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	false	false	false	false	false	walking on branch	false	false	false	false	true	false	false	false		POINT (-73.9761592532482 40.7747213585387)		19	4	19	13
105	105	-73.9589249555235	40.7908193284981	32E-PM-1017-03	32E	PM	10172018	3	Adult	Gray		Gray+		Above Ground	2	bottom of tree	false	false	false	true	false	still	false	false	false	false	false	false	true	false		POINT (-73.9589249555235 40.7908193284981)		19	4	19	13
126	126	-73.9792155473689	40.7693711799946	3B-PM-1007-11	03B	PM	10072018	11	Adult	Gray		Gray+		Above Ground	5	in tree	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9792155473689 40.7693711799946)		19	4	19	13
139	139	-73.969847380865	40.7769884612305	14E-AM-1008-05	14E	AM	10082018	5	Adult	Gray		Gray+		Above Ground	25		false	false	true	false	false	nest building	false	false	false	false	false	false	true	false		POINT (-73.969847380865 40.7769884612305)		19	4	19	13
147	147	-73.9564023626619	40.7905423546155	33G-AM-1013-02	33G	AM	10132018	2	Adult	Gray		Gray+		Above Ground	13	shelter in hole in tree	false	false	true	false	false		false	false	false	false	false	false	true	true		POINT (-73.9564023626619 40.7905423546155)		19	4	19	13
156	156	-73.9576589997493	40.7972751877447	39C-PM-1006-02	39C	PM	10062018	2	Adult	Gray		Gray+		Above Ground	50		false	false	true	false	false		false	false	false	false	false	false	false	false	unaware of	POINT (-73.95765899974931 40.7972751877447)		19	4	19	13
178	178	-73.9613780522542	40.790786197111	31D-PM-1006-04	31D	PM	10062018	4	Adult	Gray		Gray+		Above Ground	30		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9613780522542 40.790786197111)		19	4	19	13
185	185	-73.9588468413094	40.7963852299012	38B-AM-1019-05	38B	AM	10192018	5	Adult	Gray		Gray+		Above Ground	28		false	false	true	false	false	sitting still	false	true	false	false	false	false	false	false		POINT (-73.9588468413094 40.7963852299012)		19	4	19	13
226	226	-73.9775681731459	40.7676421190309	2D-AM-1007-03	02D	AM	10072018	3	Adult	Gray		Gray+		Above Ground	100		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9775681731459 40.7676421190309)		19	4	19	13
229	229	-73.972416242971	40.7714260236636	8F-PM-1012-04	08F	PM	10122018	4	Adult	Gray		Gray+		Above Ground	6		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.972416242971 40.7714260236636)		19	4	19	13
259	259	-73.9726958070536	40.7706096126328	7F-AM-1008-09	07F	AM	10082018	9	Adult	Gray		Gray+		Above Ground	20		false	false	true	false	false	playing w/ #8	false	false	false	false	false	false	true	false		POINT (-73.9726958070536 40.7706096126328)		19	4	19	13
279	279	-73.9550082056509	40.7894521543449	33I-AM-1008-03	33I	AM	10082018	3	Adult	Gray		Gray+		Above Ground	2	98th @ edge of park	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9550082056509 40.7894521543449)		19	4	19	13
281	281	-73.9619411917909	40.7923536640283	33B-PM-1010-11	33B	PM	10102018	11	Adult	Gray		Gray+		Above Ground	10		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9619411917909 40.7923536640283)		19	4	19	13
286	286	-73.9720907384613	40.7762987836055	13C-PM-1019-01	13C	PM	10192018	1	Adult	Gray		Gray+		Above Ground	7		false	false	true	false	false		true	false	false	false	false	false	true	false		POINT (-73.9720907384613 40.7762987836055)		19	4	19	13
306	306	-73.9689700100267	40.7775169562765	15E-PM-1008-05	15E	PM	10082018	5	Adult	Gray		Gray+		Above Ground	20		false	false	false	false	false	sitting	false	true	false	false	false	false	false	false		POINT (-73.9689700100267 40.7775169562765)		19	4	19	13
311	311	-73.9578779556574	40.7934116539732	35E-PM-1006-06	35E	PM	10062018	6	Adult	Gray		Gray+		Above Ground			false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9578779556574 40.7934116539732)		19	4	19	13
317	317	-73.9545799024508	40.7908084039886	34I-PM-1010-01	34I	PM	10102018	1	Adult	Gray		Gray+		Above Ground	15		false	false	false	true	false		false	false	false	false	false	false	false	false		POINT (-73.9545799024508 40.7908084039886)		19	4	19	13
326	326	-73.9699843570636	40.7729480440312	10G-AM-1006-01	10G	AM	10062018	1	Adult	Gray		Gray+		Above Ground	80		false	false	true	false	false		false	false	false	false	true	false	true	false		POINT (-73.96998435706361 40.7729480440312)		19	4	19	13
341	341	-73.9703161745884	40.7702610461336	8H-PM-1014-05	08H	PM	10142018	5	Juvenile	Gray		Gray+		Above Ground	2		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9703161745884 40.7702610461336)		19	4	19	13
347	347	-73.9611696144784	40.7816692895155	22I-AM-1007-03	22I	AM	10072018	3	Adult	Gray		Gray+		Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9611696144784 40.7816692895155)		19	4	19	13
360	360	-73.9672054610151	40.7876519923501	26A-PM-1006-05	26A	PM	10062018	5	Adult	Gray		Gray+		Above Ground	40		false	true	false	false	false		false	false	false	false	true	false	false	false		POINT (-73.9672054610151 40.7876519923501)		19	4	19	13
366	366	-73.9673548527075	40.7765669058396	15G-PM-1019-11	15G	PM	10192018	11	Adult	Gray		Gray+		Above Ground	4		false	false	true	false	false		false	false	false	false	false	false	false	false	stared	POINT (-73.9673548527075 40.7765669058396)		19	4	19	13
380	380	-73.9649590119935	40.7822107920769	21F-AM-1018-01	21F	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		false	false	true	false	false		false	false	false	false	true	false	true	false		POINT (-73.9649590119935 40.7822107920769)		19	4	19	13
387	387	-73.9578316525492	40.7890102959629	31G-PM-1007-01	31G	PM	10072018	1	Adult	Gray		Gray+		Above Ground	15		false	false	false	false	false	hiding	false	false	false	false	true	false	false	false	froze,sight of dogs	POINT (-73.9578316525492 40.7890102959629)		19	4	19	13
414	414	-73.9721899838568	40.7761519045651	13C-AM-1010-03	13C	AM	10102018	3	Adult	Gray		Gray+		Above Ground	20		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9721899838568 40.7761519045651)		19	4	19	13
415	415	-73.9570131890379	40.7991786736124	41B-PM-1014-05	41B	PM	10142018	5	Adult	Gray		Gray+		Above Ground	25		false	false	true	false	false		true	false	false	false	false	false	true	true		POINT (-73.9570131890379 40.7991786736124)		19	4	19	13
425	425	-73.9704485231855	40.7717290560806	9G-AM-1007-02	09G	AM	10072018	2	Adult	Gray		Gray+		Above Ground	25		false	false	true	false	false		false	false	false	false	false	false	false	true	kids were trying to poke it with a stick	POINT (-73.9704485231855 40.7717290560806)		19	4	19	13
496	496	-73.9548430741605	40.798207350942	41E-AM-1007-06	41E	AM	10072018	6	Adult	Gray		Gray+		Above Ground	30	tree	false	false	true	false	true		false	false	false	false	false	false	false	false		POINT (-73.9548430741605 40.798207350942)		19	4	19	13
518	518	-73.9687847410656	40.778185700305	16E-AM-1014-09	16E	AM	10142018	9	Adult	Gray		Gray+		Above Ground	25	In tree	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9687847410656 40.778185700305)		19	4	19	13
530	530	-73.9696360756453	40.7786545659072	16D-PM-1010-03	16D	PM	10102018	3	Adult	Gray		Gray+		Above Ground	18		false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9696360756453 40.7786545659072)		19	4	19	13
539	539	-73.9761440627966	40.7706035301542	6D-PM-1020-04	06D	PM	10202018	4		Gray		Gray+		Above Ground	15		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9761440627966 40.7706035301542)		19	4	19	13
566	566	-73.9708364583591	40.7723691587433	10F-AM-1007-01	10F	AM	10072018	1	Adult	Gray		Gray+		Above Ground	60		false	false	true	false	false		false	false	false	true	false	false	false	false		POINT (-73.9708364583591 40.7723691587433)		19	4	19	13
582	582	-73.9677779408464	40.7867482211349	25A-AM-1013-02	25A	AM	10132018	2		Gray		Gray+		Above Ground	15	BIG TREE	false	true	false	false	false	chasing #3	false	false	false	true	false	false	true	false		POINT (-73.9677779408464 40.7867482211349)		19	4	19	13
639	639	-73.9558589529608	40.7892400394941	32H-PM-1006-02	32H	PM	10062018	2		Gray		Gray+		Above Ground	8		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9558589529608 40.7892400394941)		19	4	19	13
656	656	-73.9553726714504	40.7987578541123	41D-AM-1014-02	41D	AM	10142018	2	Adult	Gray		Gray+		Above Ground	20		false	false	false	false	false	jumping	false	false	false	false	false	false	true	false		POINT (-73.9553726714504 40.7987578541123)		19	4	19	13
665	665	-73.9563661256875	40.7966823114508	39D-AM-1008-03	39D	AM	10082018	3	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9563661256875 40.7966823114508)		19	4	19	13
666	666	-73.9687027782726	40.7705162616199	9I-AM-1014-09	09I	AM	10142018	9	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	true		false	false	false	false	false	false	false	false		POINT (-73.96870277827261 40.7705162616199)		19	4	19	13
696	696	-73.9656098194149	40.7757643078973	15I-AM-1008-05	15I	AM	10082018	5	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9656098194149 40.7757643078973)		19	4	19	13
700	700	-73.9691261755936	40.7702929428604	8I-AM-1006-12	08I	AM	10062018	12	Adult	Gray		Gray+		Above Ground	50	tree	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9691261755936 40.7702929428604)		19	4	19	13
744	744	-73.9745687653791	40.7776396926997	13A-PM-1014-02	13A	PM	10142018	2	Adult	Gray		Gray+		Above Ground	45		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9745687653791 40.7776396926997)		19	4	19	13
747	747	-73.9771422625274	40.772361415776	7B-AM-1008-02	07B	AM	10082018	2	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9771422625274 40.772361415776)		19	4	19	13
754	754	-73.9563203089105	40.7906275357726	33G-PM-1006-01	33G	PM	10062018	1	Juvenile	Gray		Gray+		Above Ground	2		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9563203089105 40.7906275357726)		19	4	19	13
764	764	-73.9746608786299	40.7776092078254	13A-AM-1017-01	13A	AM	10172018	1	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9746608786299 40.7776092078254)		19	4	19	13
778	778	-73.9677054870327	40.778992870166	17E-AM-1017-03	17E	AM	10172018	3	Adult	Gray		Gray+		Above Ground	9	Tree trunk	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9677054870327 40.778992870166)		19	4	19	13
783	783	-73.9677654289757	40.786785529449	25A-AM-1013-03	25A	AM	10132018	3		Gray		Gray+		Above Ground	15	BIG TREE	false	false	false	false	false	being chased by #2	false	false	false	false	false	false	true	false		POINT (-73.9677654289757 40.786785529449)		19	4	19	13
801	801	-73.9743342303548	40.7727742948332	8D-AM-1007-08	08D	AM	10072018	8	Adult	Gray		Gray+		Above Ground	15		false	false	false	false	false	communicating from tree	false	false	false	false	false	false	false	false		POINT (-73.97433423035481 40.7727742948332)		19	4	19	13
811	811	-73.9771695272048	40.7724277276263	7B-AM-1008-03	07B	AM	10082018	3	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9771695272048 40.7724277276263)		19	4	19	13
822	822	-73.9576559099012	40.7992598626483	41B-AM-1010-09	41B	AM	10102018	9	Adult	Gray		Gray+		Above Ground	3		false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9576559099012 40.7992598626483)		19	4	19	13
838	838	-73.9691031094688	40.7706693835189	9I-AM-1014-02	09I	AM	10142018	2	Adult	Gray		Gray+	Very far, so appx	Above Ground	35		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9691031094688 40.7706693835189)		19	4	19	13
849	849	-73.9736165917399	40.7724543901497	8D-AM-1007-04	08D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	3		false	true	false	false	false	chasing squirrel #3	false	false	false	false	false	false	false	false		POINT (-73.9736165917399 40.7724543901497)		19	4	19	13
890	890	-73.9667755678511	40.7760256836088	15H-PM-1008-02	15H	PM	10082018	2	Adult	Gray		Gray+		Above Ground	10	oak tree	false	true	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9667755678511 40.7760256836088)		19	4	19	13
896	896	-73.9755055978764	40.7707438681742	6D-AM-1008-02	06D	AM	10082018	2	Juvenile	Gray		Gray+		Above Ground	10		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9755055978764 40.7707438681742)		19	4	19	13
906	906	-73.9664120826015	40.7888022709721	27A-AM-1008-01	27A	AM	10082018	1	Adult	Gray		Gray+		Above Ground	3		false	true	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.96641208260151 40.7888022709721)		19	4	19	13
919	919	-73.9637279711853	40.7905198502307	30B-AM-1007-09	30B	AM	10072018	9	Adult	Gray		Gray+		Above Ground	50		false	false	true	false	false	jumping b/w trees	false	false	false	false	false	false	false	false		POINT (-73.9637279711853 40.7905198502307)		19	4	19	13
923	923	-73.9578924882613	40.789806297824	32G-AM-1010-02	32G	AM	10102018	2	Adult	Gray		Gray+		Above Ground	13		false	false	true	true	false		false	false	false	false	true	false	false	true		POINT (-73.9578924882613 40.789806297824)		19	4	19	13
926	926	-73.9596006938677	40.7834706440535	25I-PM-1007-07	25I	PM	10072018	7	Adult	Gray		Gray+		Above Ground		playing very high in tree w/ #8	false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9596006938677 40.7834706440535)		19	4	19	13
935	935	-73.9666195118963	40.7839216739357	22C-PM-1006-10	22C	PM	10062018	10	Adult	Gray		Gray+		Above Ground	13		false	false	true	false	false		true	false	false	false	false	false	false	false		POINT (-73.9666195118963 40.78392167393571)		19	4	19	13
958	958	-73.9613862251332	40.791282169715	32C-AM-1014-03	32C	AM	10142018	3	Adult	Gray		Gray+		Above Ground	3		false	true	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9613862251332 40.791282169715)		19	4	19	13
981	981	-73.9673160165357	40.7766158001202	15G-PM-1019-12	15G	PM	10192018	12	Adult	Gray		Gray+		Above Ground	4		false	false	true	false	false		false	false	false	false	false	false	false	false	stared	POINT (-73.9673160165357 40.7766158001202)		19	4	19	13
1011	1011	-73.9719111470164	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	false	false	false	false	false	jumped off	false	false	false	true	false	false	false	true		POINT (-73.9719111470164 40.7758789855474)		19	4	19	13
1016	1016	-73.9691293546408	40.7703219076549	8I-AM-1006-11	08I	AM	10062018	11	Adult	Gray		Gray+		Above Ground	50	tree	false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9691293546408 40.77032190765491)		19	4	19	13
1018	1018	-73.9695305555392	40.7757541971012	13F-PM-1008-03	13F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	15	tree	false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9695305555392 40.7757541971012)		19	4	19	13
1032	1032	-73.9632868561794	40.7907806312915	30B-AM-1007-06	30B	AM	10072018	6	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9632868561794 40.7907806312915)		19	4	19	13
1041	1041	-73.9643236505425	40.7887854771596	28C-AM-1014-02	28C	AM	10142018	2	Adult	Gray		Gray+		Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9643236505425 40.7887854771596)		19	4	19	13
1053	1053	-73.9685859705486	40.7848805065322	23A-AM-1018-04	23A	AM	10182018	4	Adult	Gray		Gray+		Above Ground	3	Tree	false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9685859705486 40.7848805065322)		19	4	19	13
1061	1061	-73.9532657715601	40.7949046809422	39G-AM-1018-02	39G	AM	10182018	2	Juvenile	Gray		Gray+		Above Ground	25	Tree	false	false	false	false	false	sitting & watching	false	false	false	false	false	false	true	false		POINT (-73.9532657715601 40.7949046809422)		19	4	19	13
1069	1069	-73.9595485734618	40.7835326425693	25I-PM-1007-08	25I	PM	10072018	8	Adult	Gray		Gray+		Above Ground		playing very high in tree w/ #7	false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9595485734618 40.7835326425693)		19	4	19	13
1071	1071	-73.9703774000082	40.7717607551555	9G-AM-1007-01	09G	AM	10072018	1	Adult	Gray		Gray+		Above Ground	50		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9703774000082 40.7717607551555)		19	4	19	13
1087	1087	-73.9679955831115	40.7818431607916	20C-PM-1018-04	20C	PM	10182018	4	Adult	Gray		Gray+		Above Ground	8		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9679955831115 40.7818431607916)		19	4	19	13
1095	1095	-73.9735547926323	40.7723420076108	8D-AM-1007-02	08D	AM	10072018	2	Adult	Gray		Gray+		Above Ground	12		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9735547926323 40.7723420076108)		19	4	19	13
1110	1110	-73.9676434256976	40.7862336624448	24A-PM-1007-04	24A	PM	10072018	4	Adult	Gray		Gray+		Above Ground	50	in tree	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9676434256976 40.7862336624448)		19	4	19	13
1144	1144	-73.9743184653765	40.7667932997	3G-AM-1008-01	03G	AM	10082018	1	Adult	Gray		Gray+		Above Ground	30		false	false	true	false	false		true	false	false	false	false	false	false	false		POINT (-73.9743184653765 40.7667932997)		19	4	19	13
1148	1148	-73.9707339200738	40.7796333355689	17C-PM-1013-03	17C	PM	10132018	3	Adult	Gray		Gray+		Above Ground	20	in a tree	false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9707339200738 40.7796333355689)		19	4	19	13
1162	1162	-73.9568544270881	40.7972517274475	39D-AM-1008-06	39D	AM	10082018	6	Adult	Gray		Gray+		Above Ground	3	on rock	false	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9568544270881 40.7972517274475)		19	4	19	13
1206	1206	-73.9748709206354	40.77608025411	11B-PM-1014-01	11B	PM	10142018	1	Adult	Gray		Gray+	Fat!	Above Ground	10		false	false	true	false	false		true	false	false	false	false	false	false	true		POINT (-73.9748709206354 40.77608025411)		19	4	19	13
1207	1207	-73.9594708328732	40.791192982895	32E-AM-1007-07	32E	AM	10072018	7	Adult	Gray		Gray+		Above Ground		on tennis club house roof	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9594708328732 40.791192982895)		19	4	19	13
1227	1227	-73.9527924755398	40.7934366260533	37I-AM-1010-04	37I	AM	10102018	4	Adult	Gray		Gray+		Above Ground	50	in tree	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9527924755398 40.7934366260533)		19	4	19	13
1238	1238	-73.9773692131441	40.7679771150149	3D-PM-1010-02	03D	PM	10102018	2	Adult	Gray		Gray+		Above Ground	8		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9773692131441 40.7679771150149)		19	4	19	13
1240	1240	-73.9696119179789	40.7802926111865	18C-PM-1018-09	18C	PM	10182018	9	Juvenile	Gray		Gray+		Above Ground	5		false	false	true	true	true		false	false	false	false	false	false	false	false		POINT (-73.9696119179789 40.7802926111865)		19	4	19	13
1254	1254	-73.9764013589865	40.7663063499207	1F-PM-1019-03	01F	PM	10192018	3	Juvenile	Gray		Gray+		Above Ground	1		false	false	false	false	false	hiding	false	false	false	false	false	false	false	false		POINT (-73.9764013589865 40.7663063499207)		19	4	19	13
1263	1263	-73.9770873939997	40.7710379662106	6C-PM-1020-02	06C	PM	10202018	2	Adult	Gray		Gray+		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9770873939997 40.7710379662106)		19	4	19	13
1280	1280	-73.9562469727195	40.79685907654	39D-AM-1008-04	39D	AM	10082018	4	Adult	Gray		Gray+		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9562469727195 40.79685907654)		19	4	19	13
1301	1301	-73.9552146665714	40.7892909102377	32I-PM-1007-03	32I	PM	10072018	3	Adult	Gray		Gray+	small adult	Above Ground	20		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9552146665714 40.7892909102377)		19	4	19	13
1304	1304	-73.9533319519277	40.7933647909449	37H-AM-1018-02	37H	AM	10182018	2	Adult	Gray		Gray+		Above Ground		Large tree by (fence of the conservatory) about to climb up	false	false	true	false	false		false	false	false	false	false	false	false	false	busy,ready to climb	POINT (-73.9533319519277 40.7933647909449)		19	4	19	13
1313	1313	-73.9671813866177	40.7838640032038	22C-PM-1006-04	22C	PM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9671813866177 40.7838640032038)		19	4	19	13
1355	1355	-73.9655277320465	40.7806120529369	20F-AM-1014-03	20F	AM	10142018	3	Adult	Gray		Gray+		Above Ground	30		false	false	true	false	false		true	false	false	false	false	false	false	false		POINT (-73.9655277320465 40.7806120529369)		19	4	19	13
1357	1357	-73.9631350020634	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	false	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.9631350020634 40.791907210332)		19	4	19	13
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9791648157033 40.767625444347)		19	4	19	13
1371	1371	-73.9542733797804	40.795578653743	39F-PM-1006-02	39F	PM	10062018	2	Adult	Gray		Gray+		Above Ground	20	tree	false	false	false	false	false		false	false	false	false	false	false	false	true	ran up tree when approached	POINT (-73.9542733797804 40.795578653743)		19	4	19	13

Next page

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);