squirrels

Custom SQL query returning 13 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], [Zip Codes], [Community Districts], [Borough Boundaries], [City Council Districts], [Police Precincts] from squirrels where "Kuks" = :p0 and "Tail flags" = :p1 order by [Zip Codes] 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	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
150	-73.9763430829342	40.7686351097159	4D-PM-1008-11	04D	PM	10082018	11	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	3	on tree facing downward	false	true	false	false	false	chased #12	true	false	false	true	false	false	false	true		POINT (-73.9763430829342 40.7686351097159)	19	4	19	13
188	-73.9570528770427	40.7990973804149	41B-AM-1010-07	41B	AM	10102018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	10		false	false	false	false	false		true	false	false	true	false	true	false	false	mad!	POINT (-73.9570528770427 40.7990973804149)	19	4	19	13
384	-73.968045072743	40.7836626717225	22C-AM-1013-02	22C	AM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4		false	false	true	false	true		true	false	false	true	false	false	false	true		POINT (-73.968045072743 40.7836626717225)	19	4	19	13
1007	-73.9635317822977	40.7821352080233	22G-AM-1018-01	22G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	false		true	false	false	true	false	false	true	false		POINT (-73.9635317822977 40.7821352080233)	19	4	19	13
1514	-73.9548006161673	40.7945503341011	38G-PM-1020-08	38G	PM	10202018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		false	false	false	true	true		true	false	false	true	false	false	true	false		POINT (-73.9548006161673 40.7945503341011)	19	4	19	13
1959	-73.9707737073771	40.7800373465838	17B-PM-1012-02	17B	PM	10122018	2	Adult	Black		Black+	Ground Plane	FALSE		true	true	false	false	true	2/3 chasing each other	true	true	false	true	true	false	true	false		POINT (-73.9707737073771 40.7800373465838)	19	4	19	13
2026	-73.9622752768962	40.7814921913101	22H-PM-1007-02	22H	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4	low branch	false	false	false	false	false	watching me scratching	true	false	false	true	false	false	true	false		POINT (-73.9622752768962 40.7814921913101)	19	4	19	13
2142	-73.9598535425706	40.7915589343685	33D-PM-1006-01	33D	PM	10062018	1		Gray	Cinnamon	Gray+Cinnamon	Above Ground	15		false	true	false	false	false	hanging on fence	true	false	false	true	false	false	false	true		POINT (-73.9598535425706 40.7915589343685)	19	4	19	13
2176	-73.9583201789615	40.7913938722521	33F-PM-1012-05	33F	PM	10122018	5	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Ground Plane	FALSE		true	false	false	false	true		true	false	false	true	true	false	false	true		POINT (-73.95832017896151 40.7913938722521)	19	4	19	13
2295	-73.9590632051055	40.7963146584827	38B-AM-1019-04	38B	AM	10192018	4	Adult	Gray		Gray+	Above Ground	20		false	false	false	false	false	sitting in tree	true	true	false	true	false	false	true	false	observant	POINT (-73.9590632051055 40.7963146584827)	19	4	19	13
2588	-73.9581007437094	40.7959403112722	38C-AM-1019-06	38C	AM	10192018	6	Adult	Gray		Gray+	Above Ground	23		false	false	true	false	false		true	false	false	true	false	false	true	false		POINT (-73.9581007437094 40.7959403112722)	19	4	19	13
2700	-73.9601988871514	40.7943473161329	35C-PM-1013-01	35C	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		false	false	true	false	true		true	true	false	true	true	false	true	false		POINT (-73.9601988871514 40.7943473161329)	19	4	19	13
2794	-73.9712187890707	40.7750640173134	12E-PM-1018-01	12E	PM	10182018	1	Juvenile	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		true	false	true	false	false		true	false	false	true	false	false	false	true		POINT (-73.9712187890707 40.7750640173134)	19	4	19	13