squirrels

Custom SQL query returning 46 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 "Date" = :p0 and "Eating" = :p1 and "Indifferent" = :p2 order by rowid 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	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
158	-73.9710991123992	40.7723889726647	9F-PM-1014-02	09F	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9710991123992 40.7723889726647)		19	4	19	13
330	-73.9708969246276	40.7767695507462	14D-AM-1014-03	14D	AM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9708969246276 40.7767695507462)		19	4	19	13
393	-73.9577212629651	40.7965525296722	38C-PM-1014-06	38C	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9577212629651 40.7965525296722)		19	4	19	13
498	-73.9669432929573	40.779136518298	18F-AM-1014-01	18F	AM	10142018	1	Adult	Gray	White	Gray+White		Above Ground		Low tree	false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9669432929573 40.779136518298)		19	4	19	13
548	-73.9584696083284	40.7980121226635	39B-PM-1014-03	39B	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9584696083284 40.7980121226635)		19	4	19	13
577	-73.9497217674555	40.796517007214	42I-PM-1014-03	42I	PM	10142018	3		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9497217674555 40.796517007214)		19	4	19	13
719	-73.9626881234742	40.7905208345549	30C-AM-1014-01	30C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9626881234742 40.7905208345549)		19	4	19	13
736	-73.9660110060416	40.7809990098597	20F-AM-1014-01	20F	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9660110060416 40.7809990098597)		19	4	19	13
818	-73.9608757424052	40.7906686504657	31D-AM-1014-06	31D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9608757424052 40.7906686504657)		19	4	19	13
826	-73.9557263533489	40.7939505791448	37F-PM-1014-02	37F	PM	10142018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	LAWN	false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.95572635334891 40.7939505791448)		19	4	19	13
842	-73.9645147011741	40.7772566833799	17I-AM-1014-04	17I	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	true	false		POINT (-73.9645147011741 40.7772566833799)		19	4	19	13
845	-73.9582850206205	40.7978975855555	39B-PM-1014-01	39B	PM	10142018	1	Adult	Gray	White	Gray+White	White belly	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9582850206205 40.7978975855555)		19	4	19	13
878	-73.9757215415855	40.7668205976986	2F-PM-1014-03	02F	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9757215415855 40.7668205976986)		19	4	19	13
1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	true	true	running (from a dog)	false	false	false	false	false	false	true	false		POINT (-73.97186968288 40.778926988884)		19	4	19	13
1097	-73.9761579527932	40.7755877312075	10A-PM-1014-02	10A	PM	10142018	2	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Ground Plane	FALSE	in the bushes beneath a tree	false	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9761579527932 40.7755877312075)		19	4	19	13
1122	-73.9728700359494	40.7659842666881	3H-PM-1014-05	03H	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9728700359494 40.7659842666881)		19	4	19	13
1223	-73.9591298551111	40.7919612446005	33E-AM-1014-04	33E	AM	10142018	4	Adult	Black	Cinnamon, White	Black+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9591298551111 40.7919612446005)		19	4	19	13
1255	-73.9717469822209	40.7753731930704	12D-PM-1014-03	12D	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		true	false	false	true	false		false	false	false	false	true	false	true	false		POINT (-73.9717469822209 40.7753731930704)		19	4	19	13
1382	-73.9611274898661	40.7915250069086	32C-AM-1014-05	32C	AM	10142018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9611274898661 40.7915250069086)		19	4	19	13
1482	-73.9588610195699	40.7945269936639	36C-AM-1014-02	36C	AM	10142018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	Crossing path	false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9588610195699 40.7945269936639)		19	4	19	13
1537	-73.9767220179725	40.7753262103123	10A-PM-1014-03	10A	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground		above my head in tree	false	false	false	true	false	eating (in a tree)	false	false	false	false	false	false	true	false	indifferent (lots of people taking its picture,didn't bother it)	POINT (-73.9767220179725 40.7753262103123)	12420	20	4	19	12
1603	-73.9545929242174	40.7986940168685	42D-AM-1014-02	42D	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9545929242174 40.7986940168685)		19	4	19	13
1667	-73.9645989003589	40.7782157459155	18H-PM-1014-01	18H	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9645989003589 40.7782157459155)		19	4	19	13
1708	-73.9618486459307	40.7946365810826	35A-AM-1014-02	35A	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9618486459307 40.7946365810826)		19	4	19	13
1739	-73.9639700434449	40.7775003050028	17I-AM-1014-01	17I	AM	10142018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	Running across fence between statue & swings	true	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9639700434449 40.7775003050028)		19	4	19	13
1771	-73.9750688083336	40.7665584681025	2F-PM-1014-07	02F	PM	10142018	7	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9750688083336 40.7665584681025)		19	4	19	13
1775	-73.951965247933	40.7938167628067	38I-PM-1014-03	38I	PM	10142018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	true		POINT (-73.951965247933 40.7938167628067)		19	4	19	13
1936	-73.9667911565238	40.779321901098	18F-AM-1014-02	18F	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE	In small tree by water	false	false	false	true	true		false	true	false	false	false	false	true	false		POINT (-73.9667911565238 40.77932190109801)		19	4	19	13
2128	-73.9757673193743	40.7669614322613	2F-PM-1014-04	02F	PM	10142018	4	Adult	Gray		Gray+		Above Ground	20		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9757673193743 40.766961432261304)		19	4	19	13
2174	-73.9684092812839	40.7711445841928	9I-AM-1014-07	09I	AM	10142018	7	Adult	Cinnamon		Cinnamon+	No real highlight, White tail?	Ground Plane	FALSE		false	false	true	true	true		false	false	false	false	false	false	true	false		POINT (-73.9684092812839 40.7711445841928)		19	4	19	13
2195	-73.955352152771	40.7988549523022	42D-AM-1014-01	42D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		false	false	true	true	false		true	false	false	false	false	false	true	false		POINT (-73.955352152771 40.7988549523022)		19	4	19	13
2270	-73.9703732649257	40.7701979377103	8H-PM-1014-04	08H	PM	10142018	4	Adult	Black		Black+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.97037326492571 40.7701979377103)		19	4	19	13
2325	-73.9728360875598	40.7660637295671	3H-PM-1014-04	03H	PM	10142018	4	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9728360875598 40.7660637295671)		19	4	19	13
2507	-73.964868521585	40.7821064183815	22F-PM-1014-01	22F	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.964868521585 40.7821064183815)		19	4	19	13
2545	-73.9617594316752	40.7946803725236	35A-AM-1014-01	35A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9617594316752 40.7946803725236)		19	4	19	13
2580	-73.970795746101	40.7704727212299	8H-PM-1014-01	08H	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.970795746101 40.7704727212299)		19	4	19	13
2613	-73.96393252683	40.7808289765857	21G-AM-1014-04	21G	AM	10142018	4	Adult	Gray	White	Gray+White		Above Ground	6		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.96393252683 40.7808289765857)		19	4	19	13
2641	-73.9615516703494	40.7905219388359	31D-AM-1014-04	31D	AM	10142018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE	Open ground	true	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9615516703494 40.7905219388359)		19	4	19	13
2645	-73.9584967368893	40.7977320341094	39B-PM-1014-05	39B	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true	pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous.	false	false	false	false	false	false	true	false		POINT (-73.9584967368893 40.7977320341094)		19	4	19	13
2804	-73.9576094432477	40.7965342664074	38C-PM-1014-07	38C	PM	10142018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9576094432477 40.7965342664074)		19	4	19	13
2805	-73.9711634340673	40.7760553338671	13D-AM-1014-05	13D	AM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	true	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9711634340673 40.7760553338671)		19	4	19	13
2846	-73.9661570478029	40.7807271518813	20E-AM-1014-02	20E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9661570478029 40.7807271518813)		19	4	19	13
2916	-73.9517525111679	40.7974407641075	42G-PM-1014-02	42G	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	14		false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9517525111679 40.7974407641075)		19	4	19	13
2953	-73.9585862117341	40.7986549251083	40A-PM-1014-05	40A	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true	eating (in a tree cage thing)	false	false	false	false	false	false	true	false		POINT (-73.9585862117341 40.7986549251083)		19	4	19	13
2967	-73.9713257586372	40.7762719619467	13D-AM-1014-09	13D	AM	10142018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9713257586372 40.7762719619467)		19	4	19	13
2980	-73.9716414586381	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	true	false	running (from birds)	false	false	false	true	false	false	true	false		POINT (-73.9716414586381 40.771760114722)		19	4	19	13