squirrels

Custom SQL query returning 11 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 "Runs from" = :p1 and ([Highlight Fur Color] > :p3 or ([Highlight Fur Color] = :p3 and rowid > :p2)) order by [Highlight Fur Color], 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Kuks	Tail flags	Tail twitches	Indifferent	Lat/Long
1956	-73.98089749771201	40.7690578709841	2A-PM-1019-02	02A	PM	10192018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	0	0	1	0	0	POINT (-73.980897497712 40.7690578709841)
2153	-73.9797122322834	40.767834758743504	1B-PM-1019-10	01B	PM	10192018	10	Adult	Cinnamon	White	Cinnamon+White	Above Ground		Dog chased up tree	0	0	1	0	0	0	0	1	0	POINT (-73.97971223228342 40.7678347587435)
2283	-73.9628982772673	40.788430480338604	28D-PM-1019-01	28D	PM	10192018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	1	0	0	0	1	POINT (-73.9628982772673 40.7884304803386)
2412	-73.98094464895641	40.768503216587895	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White	Above Ground	15	in tree!	1	0	0	0	0	0	0	0	1	POINT (-73.9809446489564 40.7685032165879)
2482	-73.9805927710872	40.76799891166421	1B-PM-1019-07	01B	PM	10192018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1	0	0	0	0	1	POINT (-73.9805927710872 40.7679989116642)
2657	-73.9582150734453	40.7962862794303	38C-AM-1019-08	38C	AM	10192018	8	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	1	1	0	0	1	POINT (-73.9582150734453 40.7962862794303)
2684	-73.9809688694074	40.7688535974878	2A-PM-1019-06	02A	PM	10192018	6	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	1	0	0	0	1	POINT (-73.9809688694074 40.7688535974878)
2688	-73.9799302952205	40.767720720979796	1B-PM-1019-02	01B	PM	10192018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	0	0	0	0	1	POINT (-73.9799302952205 40.7677207209798)
2800	-73.9802983138318	40.7676540772339	1B-PM-1019-05	01B	PM	10192018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1	0	0	0	0	1	POINT (-73.9802983138318 40.7676540772339)
2865	-73.98028424040159	40.767825738497706	1B-PM-1019-03	01B	PM	10192018	3	Juvenile	Gray	White	Gray+White	Above Ground	25	in tree	0	1	0	0	0	0	0	0	0	POINT (-73.98028424040162 40.7678257384977)
2885	-73.9530811255728	40.7983069118579	42F-AM-1019-02	42F	AM	10192018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1	1	0	0	0	1	POINT (-73.9530811255728 40.79830691185791)