squirrels

Custom SQL query returning 7 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 "Highlight Fur Color" = :p1 and "Tail twitches" = :p2 order by [Unique Squirrel ID] 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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Indifferent	Runs from	Other Interactions	Lat/Long
1863	-73.96828305109541	40.7810151087286	19D-PM-1008-03	19D	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	may be same squirrel as #1 - male	Above Ground	5	on branch of dead tree	0	0	0	1	0	1	0		POINT (-73.9682830510954 40.7810151087286)
2862	-73.967466716152	40.782434654827796	21D-PM-1008-04	21D	PM	10082018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	0	1	0	0	1	i scared it	POINT (-73.967466716152 40.7824346548278)
1247	-73.96709048698709	40.7832091658006	21D-PM-1008-06	21D	PM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0	0	1		POINT (-73.9670904869871 40.7832091658006)
1592	-73.9575517912392	40.788915826819206	31H-PM-1008-05	31H	PM	10082018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground			0	0	1	0	0	0	1		POINT (-73.9575517912392 40.7889158268192)
2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1	1	1	0		POINT (-73.9584950620879 40.7902770710643)
1432	-73.9632577850183	40.793112839016	33A-AM-1008-01	33A	AM	10082018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	0	0	acknowledged	POINT (-73.9632577850183 40.793112839016)
2177	-73.9758211560957	40.7693422860766	5E-AM-1008-10	05E	AM	10082018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up a tree	1	0	0	0	1	1	0		POINT (-73.9758211560957 40.7693422860766)