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 "Hectare Squirrel Number" = :p1 and "Runs from" = :p2 order by Indifferent 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	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
292	-73.9674069524601	40.7772529662424	16F-PM-1013-02	16F	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Woods	0	0	0	1		0	0	0	0	0	1		POINT (-73.9674069524601 40.7772529662424)
384	-73.968045072743	40.783662671722496	22C-AM-1013-02	22C	AM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4		0	1	0	1		1	1	0	0	0	1		POINT (-73.968045072743 40.7836626717225)
409	-73.9530809650496	40.7959176317705	40G-PM-1013-02	40G	PM	10132018	2	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	1	0	hiding from dog	0	0	0	0	0	1	runs from (dog)	POINT (-73.9530809650496 40.79591763177051)
859	-73.9600964585868	40.7952339524416	36B-PM-1013-02	36B	PM	10132018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	1	0	0		0	0	1	1	0	1		POINT (-73.9600964585868 40.7952339524416)
993	-73.97724226646571	40.773436329163	8A-AM-1013-02	08A	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	playground	1	0	0	0		0	0	0	0	0	1		POINT (-73.9772422664657 40.773436329163)
1011	-73.97191114701641	40.7758789855474	12D-AM-1013-02	12D	AM	10132018	2	Adult	Gray		Gray+	Above Ground	7	Was on top of the edge of Bow Bridge	0	0	0	0	jumped off	0	1	0	0	0	1		POINT (-73.9719111470164 40.7758789855474)
1346	-73.9735655529245	40.7716072681474	7E-PM-1013-02	07E	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Ground & Tree Base	1	0	1	1		0	0	0	0	0	1		POINT (-73.9735655529245 40.7716072681474)
1507	-73.9699799501516	40.7736576286234	11F-AM-1013-02	11F	AM	10132018	2	Adult	Gray		Gray+	Above Ground	5		0	1	0	0		0	0	0	0	0	1		POINT (-73.9699799501516 40.7736576286234)
1953	-73.9644974196807	40.7810020292593	20G-PM-1013-02	20G	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1		0	0	0	0	0	1		POINT (-73.96449741968071 40.7810020292593)
2072	-73.9618709589382	40.7944969066792	35A-PM-1013-02	35A	PM	10132018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	0	0	0	1		POINT (-73.9618709589382 40.7944969066792)
2263	-73.95693753558841	40.793539800861204	36E-AM-1013-02	36E	AM	10132018	2	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	1	0		0	0	0	0	0	1		POINT (-73.9569375355884 40.7935398008612)
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	0	1	0	0	1		POINT (-73.97559232564292 40.7672967972471)
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	0	1	0	0	1		POINT (-73.974596903918 40.7765498215674)
147	-73.9564023626619	40.7905423546155	33G-AM-1013-02	33G	AM	10132018	2	Adult	Gray		Gray+	Above Ground	13	shelter in hole in tree	0	1	0	0		0	0	0	0	1	1		POINT (-73.9564023626619 40.7905423546155)
779	-73.9745305540008	40.7742043234014	10C-PM-1013-02	10C	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1		0	0	1	0	1	1		POINT (-73.9745305540008 40.7742043234014)