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 "Hectare" = :p0 and "Tail twitches" = :p1 order by rowid 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	Chasing	Climbing	Eating	Foraging	Other Activities	Indifferent	Runs from	Other Interactions	Lat/Long
256	-73.976798124308	40.774131657411296	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon		Cinnamon+	Above Ground	20		1	0	1	0	0		1	0		POINT (-73.97679812430802 40.7741316574113)
596	-73.9769319450348	40.7743883576247	9A-AM-1013-11	09A	AM	10132018	11	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	foot of tree	1	1	0	0	0		1	0		POINT (-73.9769319450348 40.7743883576247)
654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	0		0	0		POINT (-73.976769659152 40.7741908010484)
690	-73.9767949141123	40.774454583585	9A-PM-1010-01	09A	PM	10102018	1	Adult			+	Ground Plane	FALSE	by large tree in sectioned off area	0	0	1	0	0	i think it climbed the tree when i first saw it.	1	0		POINT (-73.9767949141123 40.774454583585)
711	-73.97679809251241	40.774362775678	9A-PM-1010-02	09A	PM	10102018	2	Adult			+	Ground Plane	FALSE		1	0	0	0	0		1	0		POINT (-73.9767980925124 40.774362775678)
752	-73.9768617690725	40.7741877060705	9A-PM-1010-03	09A	PM	10102018	3		Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	0	0		0	0	froze - standing on hind legs for ~10 seconds then scampered off	POINT (-73.97686176907251 40.7741877060705)
867	-73.9762257701293	40.7744032758323	9A-AM-1013-08	09A	AM	10132018	8	Adult			+				0	0	0	0	0		0	1		POINT (-73.9762257701293 40.7744032758323)
915	-73.9770235090023	40.774135208066	9A-AM-1013-02	09A	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		1	0		POINT (-73.9770235090023 40.774135208066)
1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon		Cinnamon+	Ground Plane	FALSE		1	0	0	0	0		1	0		POINT (-73.9761792189352 40.7745745517215)
1354	-73.97652692820591	40.774687663524794	9A-AM-1013-10	09A	AM	10132018	10	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1	0		0	1		POINT (-73.9765269282059 40.7746876635248)
1705	-73.97654172820009	40.7740994735325	9A-AM-1013-05	09A	AM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	1	0		1	0		POINT (-73.9765417282001 40.7740994735325)
2065	-73.9768411547701	40.7741377018895	9A-AM-1013-03	09A	AM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		1	0		POINT (-73.9768411547701 40.7741377018895)
2371	-73.9769520212123	40.774006725862996	9A-AM-1013-01	09A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	1		POINT (-73.9769520212123 40.774006725863)
2784	-73.9763722433833	40.7744121430891	9A-AM-1013-07	09A	AM	10132018	7	Adult			+				0	0	0	0	0		0	1		POINT (-73.9763722433833 40.7744121430891)
2845	-73.9765016413674	40.77406728629529	9A-AM-1013-06	09A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	1	0		1	0		POINT (-73.9765016413674 40.7740672862953)
2919	-73.9768563402344	40.7744487310786	9A-AM-1013-12	09A	AM	10132018	12	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	foot of tree	1	1	0	0	0		1	0		POINT (-73.9768563402344 40.7744487310786)