squirrels

Custom SQL query returning 9 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 "Highlight Fur Color" = :p1 and (longitude > :p3 or (longitude = :p3 and rowid > :p2)) order by longitude, 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	Running	Chasing	Climbing	Eating	Foraging	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
1769	-73.9721086069437	40.7698172190404	6G-AM-1008-06	06G	AM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	white at end of tail	Ground Plane	FALSE	grass	0	0	0	0	1	1	1	0		POINT (-73.9721086069437 40.7698172190404)
1863	-73.96828305109541	40.7810151087286	19D-PM-1008-03	19D	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	may be same squirrel as #1 - male	Above Ground	5	on branch of dead tree	0	0	0	1	0	0	1	0		POINT (-73.9682830510954 40.7810151087286)
1593	-73.9676539688726	40.7777229934129	16F-AM-1008-02	16F	AM	10082018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near fence	0	0	0	0	1	1	0	0		POINT (-73.9676539688726 40.7777229934129)
2091	-73.96761128642859	40.7772792086081	16F-AM-1008-03	16F	AM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	road	1	0	0	0	0	1	1	0		POINT (-73.9676112864286 40.7772792086081)
2862	-73.967466716152	40.782434654827796	21D-PM-1008-04	21D	PM	10082018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	0	1	0	0	0	1	i scared it	POINT (-73.967466716152 40.7824346548278)
1247	-73.96709048698709	40.7832091658006	21D-PM-1008-06	21D	PM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0	0	0	1		POINT (-73.9670904869871 40.7832091658006)
1432	-73.9632577850183	40.793112839016	33A-AM-1008-01	33A	AM	10082018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	0	0	0	acknowledged	POINT (-73.9632577850183 40.793112839016)
2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1	1	0	1	0		POINT (-73.9584950620879 40.7902770710643)
1592	-73.9575517912392	40.788915826819206	31H-PM-1008-05	31H	PM	10082018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground			0	0	1	0	0	0	0	1		POINT (-73.9575517912392 40.7889158268192)