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 "Highlight Fur Color" = :p1 order by Chasing 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 flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
146	-73.95621174550999	40.795104437820704	38E-AM-1010-09	38E	AM	10102018	9	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0		POINT (-73.95621174551 40.7951044378207)
680	-73.95640114211221	40.7958097849369	38E-AM-1010-02	38E	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	climbs	POINT (-73.95640114211221 40.7958097849369)
916	-73.95618876244708	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	1	0	0		1	0	0	1	me	POINT (-73.95618876244711 40.7958187455815)
1320	-73.9554327683595	40.7953846381499	38E-AM-1010-05	38E	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	interested in my presence	POINT (-73.9554327683595 40.7953846381499)
1615	-73.9564215689843	40.7957539444068	38E-AM-1010-01	38E	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0		POINT (-73.9564215689843 40.7957539444068)
1662	-73.95616002372842	40.7953143196705	38E-AM-1010-10	38E	AM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	over a log across stream	0	0	0	0	0	chillin'	0	0	0	1	runs from leaf blower	POINT (-73.9561600237284 40.7953143196705)
1735	-73.9563652303243	40.795512787396795	38E-PM-1014-05	38E	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	on log	0	0	0	0	0	statue	0	0	1	0		POINT (-73.9563652303243 40.7955127873968)
1880	-73.9562362816756	40.7950457218996	38E-AM-1010-08	38E	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0		POINT (-73.9562362816756 40.7950457218996)
2127	-73.9562442622553	40.7957285542564	38E-AM-1010-03	38E	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0		POINT (-73.9562442622553 40.7957285542564)
2751	-73.956289117157	40.795339399380296	38E-AM-1010-11	38E	AM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	edge of the stream	0	0	0	0	1		1	0	1	0		POINT (-73.956289117157 40.7953393993803)
547	-73.9559677963727	40.7951124076946	38E-AM-1010-07	38E	AM	10102018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #6	0	1	0	1		POINT (-73.9559677963727 40.7951124076946)
2247	-73.95595201371721	40.7950536287174	38E-AM-1010-06	38E	AM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #7	0	1	1	0		POINT (-73.95595201371721 40.7950536287174)