squirrels

Custom SQL query returning 27 rows (hide)

select 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] from squirrels where "Above Ground Sighter Measurement" = :p0 and "Indifferent" = :p1 order by [Combination of Primary and Highlight Color] limit 101

Query parameters

This data as json, CSV

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
2135	-73.9596251284566	40.7916254797561	33D-AM-1017-05	33D	AM	10172018	5	Adult	Black		Black+		Above Ground	5		false	false	true	false	true		false	false	false	false	true	false	true	false	POINT (-73.9596251284566 40.7916254797561)	19	4	19	13
2008	-73.9524364087437	40.792846505434	37I-PM-1006-01	37I	PM	10062018	1	Adult	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Above Ground	5		false	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9524364087437 40.792846505434)	19	4	19	13
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
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
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
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
1065	-73.9769700777377	40.7728489574967	7B-AM-1008-08	07B	AM	10082018	8	Adult	Gray		Gray+		Above Ground	5		true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9769700777377 40.7728489574967)	19	4	19	13
1402	-73.9745009906157	40.7741574075364	10C-AM-1018-01	10C	AM	10182018	1	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9745009906157 40.7741574075364)	19	4	19	13
1527	-73.970216605149	40.7702960667277	8H-PM-1014-08	08H	PM	10142018	8	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false	chasing (#7),playing?	false	false	false	false	false	false	true	false	POINT (-73.970216605149 40.7702960667277)	19	4	19	13
1817	-73.9703076450783	40.770158422629	8H-PM-1014-07	08H	PM	10142018	7	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false	chasing (#8),playing?	false	false	false	false	false	false	true	false	POINT (-73.9703076450783 40.770158422629)	19	4	19	13
1841	-73.9806377967573	40.7681097168268	1B-AM-1012-15	01B	AM	10122018	15	Adult	Gray		Gray+		Above Ground	5		false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9806377967573 40.7681097168268)	19	4	19	13
1955	-73.9606559309874	40.7889527629826	30E-AM-1008-02	30E	AM	10082018	2	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false		true	false	false	false	false	false	true	false	POINT (-73.9606559309874 40.7889527629826)	19	4	19	13
2095	-73.9747762992858	40.7768579078578	12A-AM-1008-02	12A	AM	10082018	2	Adult	Gray		Gray+		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9747762992858 40.7768579078578)	19	4	19	13
2654	-73.9549261242548	40.7944701994615	37G-AM-1014-04	37G	AM	10142018	4	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false	playing	false	false	false	false	false	false	true	false	POINT (-73.9549261242548 40.7944701994615)	19	4	19	13
201	-73.9598015842806	40.7973522744237	38A-PM-1013-03	38A	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9598015842806 40.7973522744237)	19	4	19	13
462	-73.9661785940531	40.7742569936186	13I-PM-1008-01	13I	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	climbed tree	true	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9661785940531 40.7742569936186)	19	4	19	13
765	-73.96797780019	40.7847629473258	23B-PM-1012-05	23B	PM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	chain link fence	false	true	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.96797780019 40.7847629473258)	19	4	19	13
1921	-73.9756278240233	40.7669523701372	2F-AM-1006-02	02F	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	in tree	false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9756278240233 40.7669523701372)	19	4	19	13
2559	-73.9572383478774	40.7876857380722	30H-PM-1006-01	30H	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		false	false	true	false	false		false	false	false	false	true	false	true	false	POINT (-73.9572383478774 40.7876857380722)	19	4	19	13
2748	-73.960094705031	40.7916066137699	33D-AM-1017-01	33D	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.960094705031 40.7916066137699)	19	4	19	13
901	-73.9702228131711	40.7742131587983	12F-PM-1007-12	12F	PM	10072018	12	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	5		false	false	false	false	true	going down tree	false	false	false	false	false	false	true	false	POINT (-73.9702228131711 40.7742131587983)	19	4	19	13
1863	-73.9682830510954	40.7810151087286	19D-PM-1008-03	19D	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	may be same squirrel as #1 - male	Above Ground	5	on branch of dead tree	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9682830510954 40.7810151087286)	19	4	19	13
2056	-73.9589600626433	40.7913690265064	33E-AM-1014-08	33E	AM	10142018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	5		false	false	true	false	false		true	false	false	false	false	false	true	false	POINT (-73.9589600626433 40.7913690265064)	19	4	19	13
2323	-73.9715921982161	40.7746153066601	11E-PM-1012-06	11E	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	5		false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9715921982161 40.7746153066601)	19	4	19	13
1924	-73.9542332505231	40.7933475171434	37G-AM-1014-01	37G	AM	10142018	1	Adult	Gray	White	Gray+White	White tail	Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9542332505231 40.7933475171434)	19	4	19	13
1935	-73.9675268877392	40.7750409681718	13H-AM-1013-01	13H	AM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	5		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9675268877392 40.7750409681718)	19	4	19	13
2157	-73.9657171357842	40.7773277532224	16H-PM-1014-05	16H	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	5	tree	true	false	true	false	true		false	false	false	false	true	false	true	false	POINT (-73.9657171357842 40.7773277532224)	19	4	19	13