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 "Above Ground Sighter Measurement" = :p0 and "Date" = :p1 order by [Tail twitches] 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	Eating	Foraging	Other Activities	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
45	-73.9579645940414	40.7918613498407	34F-AM-1007-01	34F	AM	10072018	1	Adult	Gray	White	Gray+White	Above Ground	25		1	1	0	0		0	0	1		POINT (-73.9579645940414 40.7918613498407)
369	-73.9596398997228	40.793338695384705	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black		Black+	Above Ground	25		1	1	0	0		0	0	0	cautiously aware	POINT (-73.9596398997228 40.7933386953847)
425	-73.9704485231855	40.7717290560806	9G-AM-1007-02	09G	AM	10072018	2	Adult	Gray		Gray+	Above Ground	25		0	1	0	0		0	0	1	kids were trying to poke it with a stick	POINT (-73.9704485231855 40.7717290560806)
942	-73.9533923917973	40.796170187476896	40G-AM-1007-01	40G	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	25	large tree	0	1	1	0		0	1	0		POINT (-73.9533923917973 40.7961701874769)
1573	-73.9595613548804	40.7838057527338	25I-PM-1007-04	25I	PM	10072018	4	Adult	Gray		Gray+	Above Ground	25		0	1	0	0		0	0	0		POINT (-73.9595613548804 40.7838057527338)
1609	-73.96390249881229	40.777695306584896	18I-PM-1007-01	18I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	25		0	1	1	1	hanging upside down	0	1	0		POINT (-73.9639024988123 40.7776953065849)
1680	-73.9638167248251	40.7776485679354	18I-PM-1007-03	18I	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	25		0	1	0	0		0	0	0	stared at me	POINT (-73.9638167248251 40.77764856793541)
1315	-73.9595955824812	40.793304794353396	34D-PM-1007-01	34D	PM	10072018	1	Adult	Gray	White	Gray+White	Above Ground	25		0	1	0	1		1	0	1		POINT (-73.9595955824812 40.7933047943534)