squirrels

Custom SQL query returning 12 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 "Foraging" = :p1 and "Highlight Fur Color" = :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	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
155	-73.9522142360388	40.7949598486683	39H-PM-1013-02	39H	PM	10132018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	1	0	1	0		POINT (-73.9522142360388 40.7949598486683)
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)
1885	-73.9594174605642	40.7973128653773	38B-AM-1019-02	38B	AM	10192018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	1	1	1	0	1	0		POINT (-73.9594174605642 40.7973128653773)
1024	-73.9521514669041	40.7949515182825	39H-PM-1013-03	39H	PM	10132018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	0	1	1	1		POINT (-73.9521514669041 40.7949515182825)
2471	-73.964274290774	40.779531955602295	19H-AM-1010-03	19H	AM	10102018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	1	1	0	0	1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
1591	-73.95762233900821	40.79797466396471	40B-AM-1019-04	40B	AM	10192018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	1	0	1	0	1	1	0		POINT (-73.9576223390082 40.79797466396471)
1161	-73.9694066600156	40.7805662180672	18C-PM-1018-06	18C	PM	10182018	6	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	1		0	1	1	1	0	0	1	0		POINT (-73.9694066600156 40.7805662180672)
482	-73.97217978245759	40.7801213843628	16A-PM-1019-07	16A	PM	10192018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	1	1	0	0	approaches (very friendly)	POINT (-73.9721797824576 40.7801213843628)
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	0	1	0	0	1	0		POINT (-73.9745556229855 40.7672921040998)
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	0	1	0	0	1	0		POINT (-73.9745800592393 40.767356541975)
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	0	1	0	0	1	0		POINT (-73.9745227769788 40.76736182847821)
669	-73.98020792598659	40.7678723471007	1B-AM-1012-10	01B	AM	10122018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	1	1	0	1	0	0		POINT (-73.9802079259866 40.7678723471007)