squirrels

Custom SQL query returning 16 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 "Age" = :p0 and "Date" = :p1 and "Foraging" = :p2 order by [Hectare Squirrel Number] 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	Tail flags	Tail twitches	Indifferent	Runs from	Lat/Long
1980	-73.9686635017966	40.78431767328279	22B-PM-1014-01	22B	PM	10142018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	0	0	POINT (-73.96866350179661 40.7843176732828)
2207	-73.9748943397482	40.770399256427204	6E-AM-1014-01	06E	AM	10142018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	0	0	POINT (-73.9748943397482 40.7703992564272)
624	-73.96130519573059	40.7909351393505	31D-AM-1014-02	31D	AM	10142018	2	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	Undergrowth	0	0	0	1		0	0	0	1	POINT (-73.9613051957306 40.7909351393505)
655	-73.9728783802067	40.7731671049246	9E-PM-1014-02	09E	PM	10142018	2	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Ground Plane	FALSE		0	0	0	1		0	1	1	0	POINT (-73.9728783802067 40.7731671049246)
826	-73.95572635334891	40.7939505791448	37F-PM-1014-02	37F	PM	10142018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE	LAWN	0	0	1	1		0	0	1	0	POINT (-73.95572635334891 40.7939505791448)
871	-73.9583738783348	40.7979302775527	39B-PM-1014-02	39B	PM	10142018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	1	0	POINT (-73.9583738783348 40.7979302775527)
1482	-73.95886101956991	40.7945269936639	36C-AM-1014-02	36C	AM	10142018	2	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	Crossing path	0	0	1	1		0	0	1	0	POINT (-73.9588610195699 40.7945269936639)
784	-73.9649658099293	40.782326236907394	22F-PM-1014-03	22F	PM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		1	0	1	0	POINT (-73.9649658099293 40.7823262369074)
1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	1	1	running (from a dog)	0	0	1	0	POINT (-73.97186968288 40.778926988884)
2763	-73.96260656728941	40.788722645116	29D-AM-1014-03	29D	AM	10142018	3	Juvenile	Gray		Gray+	Above Ground	35	End of tree limb foraging	0	0	0	1		0	0	1	0	POINT (-73.9626065672894 40.788722645116)
459	-73.9624546917649	40.7888234959792	29D-AM-1014-04	29D	AM	10142018	4	Juvenile	Gray		Gray+	Ground Plane	FALSE	Rock a	0	0	0	1		0	0	1	0	POINT (-73.9624546917649 40.78882349597921)
823	-73.954595058342	40.7956567934304	39F-AM-1014-04	39F	AM	10142018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	1	0	POINT (-73.954595058342 40.7956567934304)
2641	-73.96155167034941	40.790521938835894	31D-AM-1014-04	31D	AM	10142018	4	Juvenile	Gray		Gray+	Ground Plane	FALSE	Open ground	1	0	1	1		0	1	1	0	POINT (-73.9615516703494 40.7905219388359)
1394	-73.95488263914001	40.7959474571251	39F-AM-1014-05	39F	AM	10142018	5	Juvenile	Cinnamon		Cinnamon+	Above Ground	2	up/down tree	1	1	0	1		0	1	1	0	POINT (-73.95488263914 40.7959474571251)
2061	-73.9608834102446	40.790624710005005	31D-AM-1014-05	31D	AM	10142018	5	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	0	1	POINT (-73.9608834102446 40.790624710005)
2288	-73.9577009571427	40.796126044520996	38C-PM-1014-10	38C	PM	10142018	10	Juvenile	Gray	White	Gray+White	Above Ground	10		0	1	1	1	climbing (down from ~10')	0	0	0	1	POINT (-73.9577009571427 40.796126044521)