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 "Tail twitches" = :p2 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	Color notes	Location	Above Ground Sighter Measurement	Climbing	Eating	Foraging	Other Activities	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
65	-73.9741824992294	40.7689486657963	5F-PM-1007-03	05F	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	0	hiding nut	1	0	1	0		POINT (-73.9741824992294 40.7689486657963)
136	-73.9528682507794	40.792580780830704	36I-PM-1007-13	36I	PM	10072018	13	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	1	0		1	1	0	0		POINT (-73.9528682507794 40.7925807808307)
161	-73.9649632550828	40.7809187761995	20F-PM-1007-01	20F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	cinnamon tail	Ground Plane	FALSE	0	1	1		1	0	1	0		POINT (-73.9649632550828 40.7809187761995)
304	-73.9523001834395	40.7949231000186	39H-AM-1007-02	39H	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	1	1		1	0	1	0		POINT (-73.9523001834395 40.7949231000186)
733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	1	0	0		1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
1169	-73.9570391901515	40.7930697207834	35F-AM-1007-01	35F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	1	1		1	0	1	0		POINT (-73.9570391901515 40.7930697207834)
1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	0	burying nut	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
1948	-73.9738410069766	40.7691686156505	5F-PM-1007-06	05F	PM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	0	jumping on fence	1	0	1	0		POINT (-73.9738410069766 40.7691686156505)
2037	-73.96833704175509	40.781359835050004	19D-AM-1007-02	19D	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	1	0	1		1	0	0	0	fenced area	POINT (-73.9683370417551 40.78135983505)
2133	-73.9736164871197	40.7725695048569	8D-PM-1007-04	08D	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		1	0	0	0		POINT (-73.9736164871197 40.7725695048569)
2321	-73.9743060404813	40.7687901781431	5F-PM-1007-02	05F	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		1	0	1	0		POINT (-73.9743060404813 40.7687901781431)
2382	-73.97439704555329	40.7687880243986	5F-PM-1007-01	05F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	1	0		1	0	1	0		POINT (-73.9743970455533 40.7687880243986)
2472	-73.9596820155238	40.7932886803231	34D-PM-1007-03	34D	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	1	0		1	0	0	1		POINT (-73.9596820155238 40.7932886803231)
2833	-73.9552595564798	40.7889533029466	32I-PM-1007-01	32I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	1	1	1	chirps	1	0	1	0		POINT (-73.9552595564798 40.7889533029466)
2961	-73.9736238258579	40.7688712771191	5F-PM-1007-04	05F	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		1	0	1	0		POINT (-73.9736238258579 40.7688712771191)