squirrels

Custom SQL query returning 14 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 "Approaches" = :p0 and "Date" = :p1 order by Running 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	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Other Interactions	Lat/Long
188	-73.9570528770427	40.7990973804149	41B-AM-1010-07	41B	AM	10102018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	10		0	0	0	0		1	1	0	1	0	mad!	POINT (-73.9570528770427 40.7990973804149)
572	-73.97636222692721	40.7704671295941	5C-PM-1010-10	05C	PM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	0		0	0	0	1	0	fed by woman	POINT (-73.9763622269272 40.7704671295941)
692	-73.9594529310985	40.7840492606552	26I-PM-1010-04	26I	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1		0	0	0	1	0		POINT (-73.95945293109851 40.7840492606552)
917	-73.9676514056678	40.7730853732876	11H-AM-1010-01	11H	AM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	20		0	1	0	0		0	0	0	1	0	started climbing down to me	POINT (-73.9676514056678 40.7730853732876)
1336	-73.97338200536791	40.76873304735621	5G-PM-1010-05	05G	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1		0	0	0	1	0		POINT (-73.9733820053679 40.7687330473562)
1597	-73.9789401448556	40.76973731414979	4B-AM-1010-04	04B	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1		0	0	0	1	0		POINT (-73.9789401448556 40.7697373141498)
1672	-73.9640989602986	40.789929543926505	29B-PM-1010-03	29B	PM	10102018	3	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1		0	0	0	1	0		POINT (-73.9640989602986 40.7899295439265)
2455	-73.9577297187155	40.799225295679	41B-AM-1010-08	41B	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	20		0	1	1	0		0	0	0	1	0		POINT (-73.9577297187155 40.799225295679)
2523	-73.9619016393127	40.792516012692104	33B-PM-1010-06	33B	PM	10102018	6	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	0	0	1	0		POINT (-73.9619016393127 40.7925160126921)
2575	-73.97357533521291	40.7687061447032	5G-PM-1010-04	05G	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	0		0	0	0	1	0		POINT (-73.9735753352129 40.7687061447032)
2816	-73.9809342290598	40.7687265606227	2A-AM-1010-05	02A	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE	base of tree with ~ 30 small birds all eating	0	0	1	1		0	0	1	1	1		POINT (-73.9809342290598 40.7687265606227)
2957	-73.97473131521521	40.7653888351839	1G-PM-1010-03	01G	PM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1		0	0	0	1	0		POINT (-73.9747313152152 40.7653888351839)
2976	-73.97240833205379	40.7744163768061	11D-AM-1010-08	11D	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		0	0	1	1	drinking	0	0	0	1	0		POINT (-73.9724083320538 40.7744163768061)
1330	-73.9643032554205	40.7794514526463	19H-AM-1010-02	19H	AM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE	near base of small tree	1	0	1	1		0	1	0	1	0	ran from human with dog	POINT (-73.9643032554205 40.7794514526463)