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 "Combination of Primary and Highlight Color" = :p0 and "Date" = :p1 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
392	-73.9802376131034	40.7680707516627	1B-AM-1012-12	01B	AM	10122018	12	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9802376131034 40.7680707516627)	19	4	19	13
788	-73.9687476703117	40.7742856696093	12G-AM-1012-01	12G	AM	10122018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9687476703117 40.7742856696093)	19	4	19	13
1098	-73.9604954276129	40.7965682182001	37A-AM-1012-01	37A	AM	10122018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Drawing included on tally sheet	Ground Plane	FALSE		false	false	false	false	true	scanning (drawing included)	false	false	false	false	false	false	false	true	POINT (-73.9604954276129 40.7965682182001)	19	4	19	13
1716	-73.9797425262459	40.7679120246352	1B-AM-1012-02	01B	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9797425262459 40.7679120246352)	19	4	19	13
2309	-73.966824257293	40.7753405377869	14H-PM-1012-04	14H	PM	10122018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.966824257293 40.7753405377869)	19	4	19	13
2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	31	on tree	true	true	false	false	false		false	false	false	true	true	false	true	false	POINT (-73.9595222999173 40.7833202577782)	19	4	19	13