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 "Date" = :p0 and "Eating" = :p1 and "Hectare Squirrel Number" = :p2 order by [Combination of Primary and Highlight Color] 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	Kuks	Quaas	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
2606	-73.96143417385001	40.794546426211205	35B-PM-1013-02	35B	PM	10132018	2	Juvenile			+	Ground Plane	FALSE		0	0	0	1	0	did not notice dog sitting a few yards away (10-20 ft)	0	0	1	1	0		POINT (-73.96143417385 40.7945464262112)
2915	-73.9734630412566	40.7653097139415	1H-PM-1013-02	01H	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9734630412566 40.7653097139415)
409	-73.9530809650496	40.7959176317705	40G-PM-1013-02	40G	PM	10132018	2	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	0	1	0	hiding from dog	0	0	0	0	1	runs from (dog)	POINT (-73.9530809650496 40.79591763177051)
519	-73.96590102384171	40.7791683666215	18G-PM-1013-02	18G	PM	10132018	2	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0		POINT (-73.9659010238417 40.779168366621505)
1504	-73.97065861080058	40.779635744447106	17C-PM-1013-02	17C	PM	10132018	2	Adult	Gray		Gray+	Above Ground	20	in a tree	0	0	0	1	0		0	0	0	1	0		POINT (-73.9706586108006 40.7796357444471)
1971	-73.9591880400132	40.795007125283604	36C-PM-1013-02	36C	PM	10132018	2	Adult	Gray		Gray+	Ground Plane	FALSE	Clearing near bike path (bikes active)	0	1	0	1	1		1	1	1	1	0		POINT (-73.95918804001322 40.7950071252836)
2263	-73.95693753558841	40.793539800861204	36E-AM-1013-02	36E	AM	10132018	2	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1		POINT (-73.9569375355884 40.7935398008612)
346	-73.9712971568288	40.7745520717065	11E-AM-1013-02	11E	AM	10132018	2	Adult	Gray	Black	Gray+Black	Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9712971568288 40.7745520717065)
779	-73.9745305540008	40.7742043234014	10C-PM-1013-02	10C	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	1		0	0	1	1	1		POINT (-73.9745305540008 40.7742043234014)
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	0	1	1		0	0	0	0	1		POINT (-73.9735655529245 40.7716072681474)
1480	-73.96285255338309	40.793844934501706	34A-PM-1013-02	34A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1	1	eating upside down on tree trunk	0	0	0	0	0		POINT (-73.9628525533831 40.7938449345017)
1677	-73.9594332600733	40.7960622445291	37B-PM-1013-02	37B	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9594332600733 40.7960622445291)
2093	-73.9597994674082	40.797298837759	38A-PM-1013-02	38A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9597994674082 40.797298837759)
2683	-73.972179947936	40.7810042827198	17A-PM-1013-02	17A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	20	on a little pedestal-shaped part of a tree	0	0	0	1	0		0	0	1	1	0		POINT (-73.972179947936 40.7810042827198)
1108	-73.96383977903841	40.782895027290394	23F-PM-1013-02	23F	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	0	0	1	1		0	1	1	1	0	indifferent (mostly,did notice me,busy eating,foraging)	POINT (-73.9638397790384 40.7828950272904)
1552	-73.9695655231393	40.769832465951296	8I-PM-1013-02	08I	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9695655231393 40.7698324659513)