squirrels

Custom SQL query returning 12 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 "Date" = :p1 and "Foraging" = :p2 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	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
776	-73.9686816795392	40.775770422667	14F-PM-1012-02	14F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9686816795392 40.775770422667)	19	4	19	13
947	-73.9736543790582	40.7651444188432	1H-AM-1012-02	01H	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	false	POINT (-73.9736543790582 40.7651444188432)	19	4	19	13
1576	-73.9619985187616	40.7943277743532	34A-AM-1012-02	34A	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	chasing from tree to ground	true	true	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9619985187616 40.7943277743532)	19	4	19	13
1721	-73.9587330707463	40.7907682009641	32F-AM-1012-02	32F	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray patches on back legs	Ground Plane	FALSE		false	false	false	false	false	curious about me	false	false	false	false	false	true	false	true	POINT (-73.9587330707463 40.7907682009641)	19	4	19	13
2199	-73.9677500862135	40.7726060987821	11I-AM-1012-01	11I	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	false	false	true	POINT (-73.9677500862135 40.7726060987821)	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
2389	-73.9801343393329	40.7691512453402	3A-AM-1012-01	03A	AM	10122018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	1		false	false	false	true	false		false	false	false	false	true	false	false	true	POINT (-73.9801343393329 40.7691512453402)	19	4	19	13
2480	-73.9546780963388	40.7903216522111	34I-AM-1012-03	34I	AM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	false	false	nut in mouth	false	false	false	false	false	false	true	false	POINT (-73.9546780963388 40.7903216522111)	19	4	19	13
2600	-73.9544553697736	40.7912866208106	34I-AM-1012-01	34I	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	false	false	POINT (-73.9544553697736 40.7912866208106)	19	4	19	13
2733	-73.9690082314914	40.7738993942891	12G-AM-1012-05	12G	AM	10122018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	true	false	false	false		true	false	false	false	false	false	false	true	POINT (-73.9690082314914 40.7738993942891)	19	4	19	13
2821	-73.9754536566013	40.7698604918771	5E-PM-1012-04	05E	PM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	false	false		false	false	false	true	false	false	false	true	POINT (-73.9754536566013 40.7698604918771)	19	4	19	13
2898	-73.9794118234651	40.7674495540569	1C-AM-1012-02	01C	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	false	true	false	false		false	false	false	false	true	false	false	true	POINT (-73.9794118234651 40.7674495540569)	19	4	19	13