squirrels

Custom SQL query returning 8 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 [Primary Fur Color] 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	Climbing	Foraging	Other Activities	Quaas	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
1617	-73.97520295136441	40.767173466736104	3F-AM-1006-04	03F	AM	10062018	4	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	on a rock	0	0	1		0	0	0	0	0	1		POINT (-73.9752029513644 40.7671734667361)
2503	-73.974382557804	40.7674812627373	3F-AM-1006-10	03F	AM	10062018	10	Adult	Cinnamon	White	Cinnamon+White	Above Ground	6	on fence	0	1	0		0	0	0	0	0	0	clueless	POINT (-73.974382557804 40.7674812627373)
2547	-73.9743393747021	40.767634679832504	3F-AM-1006-12	03F	AM	10062018	12	Juvenile	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		0	0	1		0	1	0	0	1	0		POINT (-73.9743393747021 40.7676346798325)
1756	-73.9755041276839	40.7678213857557	3F-AM-1006-13	03F	AM	10062018	13	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1		0	0	0	1	0	0		POINT (-73.9755041276839 40.7678213857557)
2576	-73.9751625910271	40.7671023412885	3F-AM-1006-02	03F	AM	10062018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1		0	0	1	0	1	0		POINT (-73.9751625910271 40.7671023412885)
2767	-73.9751806727197	40.7671940332258	3F-PM-1013-05	03F	PM	10132018	5	Adult	Gray	White	Gray+White	Above Ground	13		1	0	0		0	0	0	0	0	1		POINT (-73.97518067271972 40.7671940332258)
2811	-73.97568897660891	40.7676078308589	3F-AM-1006-14	03F	AM	10062018	14	Adult	Gray	White	Gray+White	Above Ground	12		1	1	0	running from dog	0	0	0	0	0	1		POINT (-73.9756889766089 40.7676078308589)
2815	-73.97473113123941	40.76773197250439	3F-PM-1013-06	03F	PM	10132018	6	Adult	Gray	White	Gray+White	Above Ground	19		0	1	0		1	0	0	0	0	1		POINT (-73.97473113123941 40.7677319725044)