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 and (Eating > :p3 or (Eating = :p3 and rowid > :p2)) order by Eating, rowid 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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Climbing	Eating	Other Activities	Tail twitches	Indifferent	Other Interactions	Lat/Long
1500	-73.9769969548024	40.7710711265211	6C-AM-1007-01	06C	AM	10072018	1	Adult	Gray	White	Gray+White	vid!	Above Ground	15		1	0		1	0	curious,but wary	POINT (-73.97699695480242 40.7710711265211)
1607	-73.9770508584979	40.7710769301257	6C-AM-1007-02	06C	AM	10072018	2	Adult			+		Above Ground	15		1	0	pulling things off branches	0	0		POINT (-73.9770508584979 40.7710769301257)
1727	-73.96924722995651	40.7722592187215	10H-PM-1007-01	10H	PM	10072018	1	Adult	Gray	White	Gray+White	dark gray	Above Ground	15	in tree	1	0		0	1		POINT (-73.9692472299565 40.7722592187215)
1796	-73.9765355395622	40.7735653237366	8B-AM-1007-03	08B	AM	10072018	3	Adult	Gray		Gray+		Above Ground	15		1	0		0	1		POINT (-73.97653553956222 40.7735653237366)
1887	-73.95861842328891	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black		Black+		Above Ground	15		1	0	jumping	0	0	stared at me	POINT (-73.9586184232889 40.7993153832942)
2561	-73.9591513028486	40.7835978067328	25I-PM-1007-01	25I	PM	10072018	1	Adult	Gray		Gray+		Above Ground	15		1	0		0	0		POINT (-73.9591513028486 40.7835978067328)
591	-73.95433237868879	40.7943086530436	37G-PM-1007-03	37G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	1	lying on belly on branch,eating big nut	0	0		POINT (-73.9543323786888 40.7943086530436)
1624	-73.97370600439879	40.772566022498296	8D-AM-1007-05	08D	AM	10072018	5	Adult	Gray		Gray+		Above Ground	15		0	1		0	0		POINT (-73.9737060043988 40.7725660224983)