squirrels

Custom SQL query returning 15 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 "Combination of Primary and Highlight Color" = :p0 and "Date" = :p1 order by Approaches limit 101

Query parameters

This data as json, CSV

rowid	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
92	-73.9565759733611	40.7992461674802	42C-AM-1007-02	42C	AM	10072018	2		+					false	false	false	false	false		false	true	false	false	false	false	false	false	POINT (-73.9565759733611 40.7992461674802)	19	4	19	13
526	-73.9680833729772	40.7741871025115	12H-PM-1007-08	12H	PM	10072018	8		+		Above Ground	7	in tree	false	false	false	false	false		false	false	false	false	false	false	false	true	POINT (-73.9680833729772 40.7741871025115)	19	4	19	13
708	-73.9592819491968	40.7941062008626	35C-AM-1007-06	35C	AM	10072018	6	Adult	+		Above Ground	30		false	false	true	false	false		false	false	false	false	false	false	false	false	POINT (-73.9592819491968 40.7941062008626)	19	4	19	13
1112	-73.9583934264026	40.7854742185504	27I-AM-1007-02	27I	AM	10072018	2		+					false	false	false	false	false		true	false	false	false	false	false	false	false	POINT (-73.9583934264026 40.785474218550405)	19	4	19	13
1244	-73.9565260889843	40.7991807924337	42C-AM-1007-03	42C	AM	10072018	3		+					false	false	false	false	false		false	true	false	false	false	false	false	false	POINT (-73.9565260889843 40.79918079243371)	19	4	19	13
1388	-73.9685709455958	40.7744877026506	12G-PM-1007-07	12G	PM	10072018	7	Juvenile	+		Above Ground	45		false	false	false	true	false	acorns	false	false	false	false	false	false	false	false	POINT (-73.9685709455958 40.7744877026506)	19	4	19	13
1407	-73.9704778551644	40.7783119113627	15D-AM-1007-05	15D	AM	10072018	5	Adult	+					false	false	false	false	false		false	false	false	false	false	false	false	false	POINT (-73.9704778551644 40.7783119113627)	19	4	19	13
1554	-73.9597462612063	40.7832801145306	25I-PM-1007-06	25I	PM	10072018	6		+	Didn't see squirrel size, or colors	Above Ground	20	up in tree	false	false	false	false	false		false	true	false	false	false	false	false	false	POINT (-73.9597462612063 40.7832801145306)	19	4	19	13
1607	-73.9770508584979	40.7710769301257	6C-AM-1007-02	06C	AM	10072018	2	Adult	+		Above Ground	15		false	false	true	false	false	pulling things off branches	false	false	false	false	false	false	false	false	POINT (-73.9770508584979 40.7710769301257)	19	4	19	13
1654	-73.9766342125035	40.7715437147052	6C-AM-1007-08	06C	AM	10072018	8	Adult	+		Above Ground	35		false	false	true	false	false	dropping acorns	false	false	false	false	false	false	false	false	POINT (-73.9766342125035 40.7715437147052)	19	4	19	13
2031	-73.9795454787631	40.7688026892741	3B-PM-1007-09	03B	PM	10072018	9	Adult	+					false	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9795454787631 40.7688026892741)	19	4	19	13
2034	-73.9699135187297	40.7782354186163	16D-AM-1007-03	16D	AM	10072018	3	Adult	+	ran away before I could take a good look	Above Ground	2		false	false	true	false	false		false	false	false	false	false	false	false	true	POINT (-73.9699135187297 40.7782354186163)	19	4	19	13
2141	-73.9787015184662	40.7690114585688	3B-PM-1007-06	03B	PM	10072018	6	Juvenile	+					false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9787015184662 40.7690114585688)	19	4	19	13
2388	-73.9604476047877	40.7938014328732	35C-AM-1007-03	35C	AM	10072018	3	Adult	+		Above Ground	40		false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9604476047877 40.7938014328732)	19	4	19	13
2851	-73.955208233231	40.7890574331084	32I-PM-1007-02	32I	PM	10072018	2	Adult	+		Above Ground	30		false	false	true	false	false	different sound - happy,playful chirps	false	false	false	false	true	false	true	false	POINT (-73.955208233231 40.7890574331084)	19	4	19	13