squirrels

Custom SQL query returning 12 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 [Highlight Fur 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	Chasing	Climbing	Eating	Foraging	Other Activities	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
12	-73.96836135162249	40.772590884749896	11H-AM-1010-03	11H	AM	10102018	3	Adult	Cinnamon	White	Cinnamon+White				0	0	0	1		1	0	1	0		POINT (-73.9683613516225 40.7725908847499)
157	-73.9637946878735	40.791570044687795	31A-AM-1010-04	31A	AM	10102018	4	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		1	0	0	0		POINT (-73.9637946878735 40.7915700446878)
278	-73.9787796921165	40.7707526535381	5A-PM-1010-01	05A	PM	10102018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		1	0	0	0		POINT (-73.9787796921165 40.7707526535381)
537	-73.9682803241007	40.772451055832704	11H-AM-1010-04	11H	AM	10102018	4		Gray	White	Gray+White				0	0	0	1		1	0	0	0		POINT (-73.9682803241007 40.7724510558327)
1256	-73.9679457364586	40.7717350221981	10I-AM-1010-02	10I	AM	10102018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		1	0	0	1		POINT (-73.9679457364586 40.7717350221981)
1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	3		0	1	0	0		1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
2007	-73.9684834138222	40.772428912021105	11H-AM-1010-06	11H	AM	10102018	6	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		1	0	0	0		1	0	1	0		POINT (-73.9684834138222 40.7724289120211)
2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	3		0	1	0	0		1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
2587	-73.97899712868441	40.7707024146365	5A-PM-1010-04	05A	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		0	0	1	1		1	0	0	0		POINT (-73.9789971286844 40.7707024146365)
2692	-73.98016364007441	40.769019205592606	2A-AM-1010-09	02A	AM	10102018	9	Adult	Gray	White	Gray+White	Above Ground		climbing in bush	0	1	0	0	hopping & flipping around. this one was very energetic & jumping aorund	1	0	0	0	climbed a foot up a tree and watched me	POINT (-73.9801636400744 40.7690192055926)
2816	-73.9809342290598	40.7687265606227	2A-AM-1010-05	02A	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE	base of tree with ~ 30 small birds all eating	0	0	1	1		1	1	1	0		POINT (-73.9809342290598 40.7687265606227)
2824	-73.97506180080991	40.773752116709396	9B-AM-1010-05	09B	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		1	0	1	0		POINT (-73.9750618008099 40.7737521167094)