squirrels

Custom SQL query returning 15 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 "Indifferent" = :p2 order by rowid desc 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	Eating	Foraging	Tail twitches	Indifferent	Lat/Long
2863	-73.9698246369929	40.7711472794488	9H-AM-1006-04	09H	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	1	POINT (-73.9698246369929 40.7711472794488)
2785	-73.9729105002306	40.7672758037086	4H-PM-1006-02	04H	PM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	0	1	POINT (-73.9729105002306 40.7672758037086)
2299	-73.9605554843228	40.7901473714024	31E-PM-1006-09	31E	PM	10062018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	1	POINT (-73.9605554843228 40.7901473714024)
2289	-73.97458005923929	40.767356541975005	3F-AM-1006-08	03F	AM	10062018	8	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	1	0	1	0	1	POINT (-73.9745800592393 40.767356541975)
1600	-73.9753093777	40.7666673897583	2F-AM-1006-04	02F	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Beautiful white puff at the end of its tail	Ground Plane	FALSE		1	0	0	1	1	POINT (-73.97530937770001 40.7666673897583)
1519	-73.97173027730099	40.7748805439381	11D-PM-1006-05	11D	PM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	1	1	POINT (-73.971730277301 40.7748805439381)
1243	-73.97455562298549	40.767292104099795	3F-AM-1006-07	03F	AM	10062018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	0	0	1	0	1	POINT (-73.9745556229855 40.7672921040998)
961	-73.9731457102903	40.7660255393205	2H-AM-1006-03	02H	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	1	POINT (-73.9731457102903 40.7660255393205)
816	-73.9785300509908	40.772112774842704	6A-AM-1006-07	06A	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	1	1	POINT (-73.9785300509908 40.7721127748427)
790	-73.9745040517502	40.77333038538	9C-PM-1006-06	09C	PM	10062018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	0	1	POINT (-73.97450405175022 40.77333038538)
787	-73.97251575343559	40.765837672923396	2I-PM-1006-02	02I	PM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	0	1	POINT (-73.9725157534356 40.7658376729234)
728	-73.96029131055779	40.7910635810038	32D-PM-1006-03	32D	PM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	1	0	1	1	POINT (-73.9602913105578 40.7910635810038)
670	-73.9602398690946	40.7910157676119	32D-PM-1006-04	32D	PM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	1	0	1	1	POINT (-73.9602398690946 40.7910157676119)
570	-73.9745227769788	40.7673618284782	3F-AM-1006-09	03F	AM	10062018	9	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	in grass by light post	0	0	1	0	1	POINT (-73.9745227769788 40.76736182847821)
104	-73.9764036522984	40.7705846185121	5C-AM-1006-05	05C	AM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	0	1	POINT (-73.9764036522984 40.7705846185121)