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 "Hectare Squirrel Number" = :p0 and "Indifferent" = :p1 and "Location" = :p2 order by [Primary 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	Running	Chasing	Climbing	Eating	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Lat/Long
2266	-73.9716402454355	40.7665133780672	3I-PM-1013-08	03I	PM	10132018	8	Adult	Black		Black+	Above Ground	2		0	0	1	0		0	0	0	1	POINT (-73.9716402454355 40.7665133780672)
2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	3		0	0	0	1		0	1	1	1	POINT (-73.9706949930717 40.772362045852)
191	-73.9787105069657	40.7693708133873	3B-AM-1010-08	03B	AM	10102018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		0	0	1	0	together w/ #7	0	0	0	1	POINT (-73.9787105069657 40.7693708133873)
758	-73.9703621616472	40.775032271482	12E-AM-1017-08	12E	AM	10172018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1		0	0	0	1	chilling	0	0	0	1	POINT (-73.9703621616472 40.775032271482)
1065	-73.9769700777377	40.772848957496706	7B-AM-1008-08	07B	AM	10082018	8	Adult	Gray		Gray+	Above Ground	5		1	0	0	0		0	0	0	1	POINT (-73.9769700777377 40.7728489574967)
1300	-73.964280573021	40.777830911491	18I-PM-1007-08	18I	PM	10072018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		0	1	1	0	canoodling w/ #9	0	0	0	1	POINT (-73.964280573021 40.777830911491)
1527	-73.970216605149	40.7702960667277	8H-PM-1014-08	08H	PM	10142018	8	Adult	Gray		Gray+	Above Ground	5		0	1	0	0	chasing (#7),playing?	0	0	0	1	POINT (-73.970216605149 40.7702960667277)
1546	-73.976422624924	40.7735818387346	8B-AM-1007-08	08B	AM	10072018	8	Adult	Gray		Gray+	Above Ground	6		0	0	0	1	holding nut	0	0	0	1	POINT (-73.976422624924 40.7735818387346)
1598	-73.9726828460055	40.770570769482205	7F-AM-1008-08	07F	AM	10082018	8	Adult	Gray		Gray+	Above Ground	20		0	0	1	0	playing w/ #9	0	0	0	1	POINT (-73.9726828460055 40.7705707694822)
1820	-73.9546337446865	40.7898772579576	33I-PM-1006-08	33I	PM	10062018	8	Adult	Gray		Gray+	Above Ground	6		0	0	1	0		0	0	1	1	POINT (-73.9546337446865 40.7898772579576)
2056	-73.9589600626433	40.7913690265064	33E-AM-1014-08	33E	AM	10142018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	5		0	0	1	0		1	0	0	1	POINT (-73.9589600626433 40.7913690265064)
2945	-73.9649103330443	40.7823913860445	22F-PM-1014-08	22F	PM	10142018	8	Adult	Gray		Gray+	Above Ground	10	CLIMBED THE TREE	0	0	1	0		0	0	0	1	POINT (-73.9649103330443 40.7823913860445)