squirrels

Custom SQL query returning 9 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 Approaches 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	Combination of Primary and Highlight Color	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
3	-73.9768311751004	40.7667178072558	2E-AM-1010-03	02E	AM	10102018	3	Adult	Cinnamon	Cinnamon+	Above Ground	4		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9768311751004 40.76671780725581)	19	4	19	13
256	-73.976798124308	40.7741316574113	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon	Cinnamon+	Above Ground	20		true	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.97679812430802 40.7741316574113)	19	4	19	13
893	-73.9799311173259	40.7685576997559	2B-AM-1010-03	02B	AM	10102018	3	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9799311173259 40.7685576997559)	19	4	19	13
1038	-73.9563311167069	40.7950901563337	38E-AM-1010-12	38E	AM	10102018	12	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE	running on rocks	false	true	false	false	false		false	false	false	true	false	false	false	false	runs toward something	POINT (-73.9563311167069 40.7950901563337)	19	4	19	13
1260	-73.9811585807616	40.768706748732	2A-AM-1010-06	02A	AM	10102018	6	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		true	true	false	false	false	chasing #5	false	false	false	false	false	false	false	false		POINT (-73.9811585807616 40.768706748732)	19	4	19	13
1363	-73.972112497276	40.7702759037428	7G-AM-1010-08	07G	AM	10102018	8	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.972112497276 40.7702759037428)	19	4	19	13
1763	-73.9768286349595	40.7687012827059	3D-PM-1010-05	03D	PM	10102018	5	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9768286349595 40.7687012827059)	19	4	19	13
2025	-73.9766541879006	40.7674077265375	2E-AM-1010-06	02E	AM	10102018	6	Adult	Cinnamon	Cinnamon+	Above Ground	35		false	false	false	false	false	leaping branch to branch	false	false	false	false	false	false	true	false		POINT (-73.9766541879006 40.7674077265375)	19	4	19	13
2401	-73.972010921173	40.7701626919216	7G-AM-1010-09	07G	AM	10102018	9	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.972010921173 40.7701626919216)	19	4	19	13