squirrels

Custom SQL query returning 6 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 "Highlight Fur Color" = :p1 order by [Other Activities] 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	Other Interactions	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
782	-73.9710559113762	40.7794279914209	16C-PM-1018-01	16C	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		false	false	true	false	false		false	false	false	false	false	false	false	false	disappeared up other side of tree	POINT (-73.9710559113762 40.7794279914209)	19	4	19	13
1118	-73.9719460335398	40.7810508156287	18A-AM-1012-01	18A	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	3	tree	true	false	true	false	true		false	false	false	false	true	false	false	true		POINT (-73.9719460335398 40.7810508156287)	19	4	19	13
1788	-73.9685567075413	40.7703797723105	8I-AM-1006-10	08I	AM	10062018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	bush	false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.96855670754131 40.7703797723105)	19	4	19	13
394	-73.9719888241794	40.7667681685356	4I-PM-1007-03	04I	PM	10072018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	ran to tree	false	false	false	false	false	being chased	false	false	false	false	false	false	false	false		POINT (-73.9719888241794 40.7667681685356)	19	4	19	13
1086	-73.9713399316534	40.7750678026757	12E-PM-1018-02	12E	PM	10182018	2	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	3		false	false	true	false	false	lounging on tree upside down	false	false	false	false	true	false	true	false		POINT (-73.9713399316534 40.7750678026757)	19	4	19	13