squirrels

Custom SQL query returning 19 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 "Foraging" = :p0 and "Highlight Fur Color" = :p1 and "Tail twitches" = :p2 order by Moans 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	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
67	-73.968381325559	40.7780143443779	16E-PM-1018-06	16E	PM	10182018	6	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	On a rock	0	0	0	1		0	1	0	1	0		POINT (-73.968381325559 40.7780143443779)
423	-73.97567542977471	40.7738518843446	9B-PM-1013-02	09B	PM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.9756754297747 40.7738518843446)
432	-73.9757787135906	40.7737231427345	9B-PM-1013-03	09B	PM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.9757787135906 40.7737231427345)
748	-73.9756603846107	40.7672531319384	3F-PM-1013-03	03F	PM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.9756603846107 40.7672531319384)
905	-73.9757216124349	40.7754310239649	11A-PM-1013-05	11A	PM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	0	1	digging	0	1	0	0	0		POINT (-73.9757216124349 40.7754310239649)
1473	-73.9584064190878	40.7912992852442	33F-PM-1012-03	33F	PM	10122018	3	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE		0	0	1	1		0	1	0	1	0		POINT (-73.9584064190878 40.7912992852442)
1492	-73.9807078515193	40.768333529264204	2A-AM-1010-04	02A	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1		0	1	0	1	0		POINT (-73.9807078515193 40.7683335292642)
1725	-73.96574800660741	40.7753465489231	14I-PM-1018-04	14I	PM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1		0	1	1	0	0		POINT (-73.9657480066074 40.7753465489231)
1808	-73.9698870647042	40.7826510985538	20B-AM-1007-02	20B	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		1	1	1	0	0		POINT (-73.9698870647042 40.7826510985538)
1816	-73.9710187505339	40.7797265666746	17B-AM-1010-02	17B	AM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.9710187505339 40.7797265666746)
2156	-73.96503878480009	40.7814134438394	21F-AM-1018-04	21F	AM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	0	0		POINT (-73.9650387848001 40.7814134438394)
2218	-73.9694382427984	40.7846350692923	22A-AM-1008-04	22A	AM	10082018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	0	1		POINT (-73.9694382427984 40.7846350692923)
2255	-73.96429678758571	40.78156523539371	21F-AM-1018-08	21F	AM	10182018	8	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1		0	1	0	1	0		POINT (-73.9642967875857 40.7815652353937)
2467	-73.9755923256429	40.7672967972471	3F-PM-1013-02	03F	PM	10132018	2	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	0	1		POINT (-73.97559232564292 40.7672967972471)
2488	-73.97269208477921	40.779411746388895	16A-PM-1019-02	16A	PM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	0	1	scared by dog	POINT (-73.9726920847792 40.7794117463889)
2727	-73.974596903918	40.7765498215674	12A-PM-1013-02	12A	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	1	0	1		0	1	0	0	1		POINT (-73.974596903918 40.7765498215674)
2746	-73.95614328368629	40.798266534723396	41C-AM-1017-07	41C	AM	10172018	7	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.9561432836863 40.7982665347234)
2938	-73.97033289561999	40.7701079697795	7H-AM-1006-14	07H	AM	10062018	14	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0	1	0		POINT (-73.97033289562 40.7701079697795)
2999	-73.972415182837	40.773080463452004	10E-AM-1010-02	10E	AM	10102018	2	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE		1	0	0	1		0	1	0	1	0		POINT (-73.972415182837 40.773080463452)