squirrels

Custom SQL query returning 6 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 order by [Specific Location] 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	Chasing	Climbing	Eating	Foraging	Indifferent	Runs from	Other Interactions	Lat/Long
1631	-73.9527196716568	40.792363826828	36I-PM-1007-11	36I	PM	10072018	11	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Above Ground	3		0	1	0	0	0	1	me!	POINT (-73.9527196716568 40.792363826828)
1743	-73.9635412640983	40.7902529354639	30B-AM-1007-11	30B	AM	10072018	11	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	1	0	1	0		POINT (-73.9635412640983 40.7902529354639)
2236	-73.9597845469964	40.790617930344794	32E-AM-1007-11	32E	AM	10072018	11	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	0	0	0	0		POINT (-73.9597845469964 40.7906179303448)
2760	-73.9701808122548	40.7744632730919	12F-PM-1007-11	12F	PM	10072018	11	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	1	0		POINT (-73.9701808122548 40.7744632730919)
126	-73.97921554736891	40.7693711799946	3B-PM-1007-11	03B	PM	10072018	11	Adult	Gray		Gray+	Above Ground	5	in tree	0	1	0	0	0	0		POINT (-73.9792155473689 40.7693711799946)
2868	-73.9653873284496	40.7804699882574	20F-PM-1007-11	20F	PM	10072018	11	Adult	Gray	White	Gray+White	Above Ground	10	in tree	0	1	0	0	0	0		POINT (-73.9653873284496 40.7804699882574)