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] from [2018_Central_Park_Squirrel_Census_-_Squirrel_Data] where "Hectare" = :p0 and "Indifferent" = :p1 order by Running 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Tail twitches	Runs from	Lat/Long
522	-73.97738211356109	40.769045349438294	4C-PM-1010-06	04C	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	behind playground benches	0	0	0	1	0		1	1	POINT (-73.9773821135611 40.7690453494383)
2403	-73.97778796352159	40.769359455673	4C-AM-1006-03	04C	AM	10062018	3	Juvenile	Gray		Gray+	Above Ground	10		0	0	0	0	1		0	0	POINT (-73.9777879635216 40.769359455673)
2633	-73.9776151109912	40.7694681558386	4C-PM-1010-09	04C	PM	10102018	9	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	1	0	0	1		0	0	POINT (-73.9776151109912 40.7694681558386)
678	-73.977447585355	40.769716782800295	4C-PM-1010-11	04C	PM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	1	0		0	0	POINT (-73.977447585355 40.7697167828003)
1125	-73.9775735077285	40.7692872082165	4C-PM-1010-08	04C	PM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	on stone arch	1	0	1	0	0		0	1	POINT (-73.9775735077285 40.7692872082165)
1567	-73.97744073625871	40.7698056129554	4C-PM-1010-12	04C	PM	10102018	12	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	1		0	0	POINT (-73.9774407362587 40.7698056129554)
1822	-73.9775099290913	40.76976090631371	4C-PM-1010-14	04C	PM	10102018	14	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	1	0	0	0	chasing #15	0	0	POINT (-73.9775099290913 40.7697609063137)
1996	-73.977641787698	40.769583026578395	4C-PM-1010-10	04C	PM	10102018	10	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	1		0	0	POINT (-73.977641787698 40.7695830265784)
2107	-73.9772624834791	40.769282191854295	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	POINT (-73.9772624834791 40.7692821918543)
2574	-73.978199543688	40.7695660563362	4C-PM-1010-17	04C	PM	10102018	17	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE	climbed up tree	1	0	1	0	1		1	1	POINT (-73.978199543688 40.7695660563362)
2644	-73.97754454411941	40.7697096533728	4C-PM-1010-13	04C	PM	10102018	13	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	0	0	0	1		0	0	POINT (-73.9775445441194 40.7697096533728)
2889	-73.9771646835311	40.769304916508396	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	POINT (-73.9771646835311 40.7693049165084)