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 "Date" = :p0 and "Hectare Squirrel Number" = :p1 and "Highlight Fur Color" = :p2 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	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
77	-73.9615696577673	40.7951278622399	35A-AM-1014-03	35A	AM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	1	0	0	1	0		POINT (-73.9615696577673 40.7951278622399)
517	-73.954959868822	40.7985404965582	41D-PM-1014-03	41D	PM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	0	0	0	0	0		POINT (-73.954959868822 40.7985404965582)
580	-73.97509925643621	40.7743391883762	10B-PM-1014-03	10B	PM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1	1	0	0	0	0	avoided people	POINT (-73.9750992564362 40.7743391883762)
649	-73.9554891003543	40.7968774599654	40E-AM-1014-03	40E	AM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	0	1	0	0	1	0		POINT (-73.9554891003543 40.79687745996541)
702	-73.963858549251	40.7808999610914	21G-AM-1014-03	21G	AM	10142018	3	Adult	Gray	White	Gray+White	Above Ground	7		0	0	0	0	1	1	0	1	0		POINT (-73.963858549251 40.7808999610914)
891	-73.9613351649026	40.79098668513571	31D-AM-1014-03	31D	AM	10142018	3		Gray	White	Gray+White	Ground Plane	FALSE	Undergrowth	0	0	0	0	1	0	0	0	1		POINT (-73.9613351649026 40.7909866851357)
1310	-73.9546201403481	40.798942376865604	42D-AM-1014-03	42D	AM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	1	1	0	1	0		POINT (-73.9546201403481 40.7989423768656)
1510	-73.9655670884957	40.7763728890554	16H-PM-1014-03	16H	PM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	0	0	1	0	0	followed man across bridge	POINT (-73.9655670884957 40.7763728890554)
1860	-73.9767100101318	40.7675779951996	2E-PM-1014-03	02E	PM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	0	0	0	1	0		POINT (-73.9767100101318 40.7675779951996)
1987	-73.9573692542155	40.7989252908321	41B-PM-1014-03	41B	PM	10142018	3	Adult	Gray	White	Gray+White	Above Ground	28		0	0	1	0	0	0	0	0	0		POINT (-73.9573692542155 40.7989252908321)
2041	-73.9651796685091	40.7785578267586	18G-AM-1014-03	18G	AM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	0	0	0	1	0		POINT (-73.9651796685091 40.7785578267586)
1395	-73.9710801547498	40.7760872452093	13D-AM-1014-03	13D	AM	10142018	3	Juvenile	Gray	White	Gray+White	Above Ground	2		0	1	1	1	0	0	0	0	1		POINT (-73.9710801547498 40.7760872452093)