squirrels

Custom SQL query returning 18 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 "Combination of Primary and Highlight Color" = :p0 and "Foraging" = :p1 and "Indifferent" = :p2 and "Runs from" = :p3 order by rowid 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	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
348	-73.9542990150586	40.7940915300678	37G-PM-1007-09	37G	PM	10072018	9	Adult	Cinnamon	White	Cinnamon+White				false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9542990150586 40.7940915300678)	19	4	19	13
349	-73.9689657039917	40.7767834276767	15F-AM-1007-04	15F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	false	false	POINT (-73.9689657039917 40.7767834276767)	19	4	19	13
490	-73.978426472499	40.771904101844	6A-PM-1012-04	06A	PM	10122018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	true	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.978426472499 40.771904101844)	19	4	19	13
514	-73.9768357173861	40.7683813358343	3D-PM-1010-12	03D	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	true	true	false	false	true		false	true	false	false	false	false	false	false	POINT (-73.9768357173861 40.7683813358343)	19	4	19	13
590	-73.9785133301426	40.7718260288338	6A-PM-1012-05	06A	PM	10122018	5	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9785133301426 40.7718260288338)	19	4	19	13
699	-73.9504693544225	40.797225436004	42H-AM-1019-01	42H	AM	10192018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	false	false	POINT (-73.9504693544225 40.797225436004)	19	4	19	13
897	-73.9734687538064	40.7694308959222	6F-PM-1008-04	06F	PM	10082018	4	Adult	Cinnamon	White	Cinnamon+White	patches of white on haunches	Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9734687538064 40.7694308959222)	19	4	19	13
931	-73.9785948413883	40.7718908026758	6A-PM-1012-01	06A	PM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	true	false	true		false	false	false	false	false	false	false	false	POINT (-73.9785948413883 40.7718908026758)	19	4	19	13
1127	-73.9776445567926	40.768119107973	3D-PM-1010-07	03D	PM	10102018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9776445567926 40.768119107973)	19	4	19	13
1132	-73.9798390387307	40.7700761090896	3A-PM-1017-07	03A	PM	10172018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	true	false	false	POINT (-73.9798390387307 40.7700761090896)	19	4	19	13
1146	-73.9794367096274	40.7672720598482	1C-PM-1013-04	01C	PM	10132018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9794367096274 40.7672720598482)	19	4	19	13
1158	-73.9763894759543	40.7705523372364	5C-PM-1010-12	05C	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	false	false	POINT (-73.9763894759543 40.7705523372364)	19	4	19	13
1187	-73.9793334416378	40.7674142089209	1C-PM-1013-02	01C	PM	10132018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true	digging	false	false	false	false	false	false	false	false	POINT (-73.9793334416378 40.7674142089209)	19	4	19	13
1712	-73.9801899519657	40.7695777009264	3A-PM-1017-02	03A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9801899519657 40.7695777009264)	19	4	19	13
2138	-73.9791536183194	40.7672705931866	1C-PM-1013-03	01C	PM	10132018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9791536183194 40.7672705931866)	19	4	19	13
2587	-73.9789971286844	40.7707024146365	5A-PM-1010-04	05A	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	true	false	false	false	POINT (-73.9789971286844 40.7707024146365)	19	4	19	13
2674	-73.9771009024581	40.7688793288864	3D-PM-1010-06	03D	PM	10102018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9771009024581 40.7688793288864)	19	4	19	13
2900	-73.9631005470369	40.7885494057193	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	true	false	false	false	true		false	false	false	false	true	false	false	false	POINT (-73.9631005470369 40.7885494057193)	19	4	19	13