squirrels

Custom SQL query returning 24 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 "Indifferent" = :p2 order by Location desc 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	Tail flags	Tail twitches	Approaches	Runs from	Other Interactions	Lat/Long
107	-73.9521110154872	40.7978449143313	42G-AM-1018-03	42G	AM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0	stop to look at me—then ran	0	0	0	1		POINT (-73.9521110154872 40.7978449143313)
148	-73.9532620128307	40.795247554804796	39G-AM-1018-01	39G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	dead (something ran over it)	0	0	0	0		POINT (-73.9532620128307 40.7952475548048)
180	-73.96908283251791	40.781803817227505	19C-PM-1018-04	19C	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0		POINT (-73.9690828325179 40.7818038172275)
551	-73.9643825381614	40.7815445841195	21F-PM-1018-03	21F	PM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0		POINT (-73.9643825381614 40.7815445841195)
631	-73.95488778301359	40.795015748910295	38F-AM-1018-04	38F	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	0	0		0	0	0	0		POINT (-73.95488778301362 40.7950157489103)
720	-73.9669814346326	40.780390919948	19E-PM-1018-01	19E	PM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	1	0	1		POINT (-73.9669814346326 40.780390919948)
913	-73.9514111329059	40.797508587289705	42G-AM-1018-01	42G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	1		POINT (-73.9514111329059 40.797508587289705)
995	-73.9698843507358	40.780375418758105	18C-PM-1018-02	18C	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0		POINT (-73.9698843507358 40.7803754187581)
1111	-73.96327993398721	40.7808316436308	21H-PM-1018-01	21H	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	staring	0	1	1	0		POINT (-73.9632799339872 40.7808316436308)
1174	-73.9682067129876	40.7779911208015	16E-PM-1018-05	16E	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	staring	1	0	1	0	approaches (very close)	POINT (-73.9682067129876 40.7779911208015)
1620	-73.96356061997841	40.782206970617	22G-AM-1018-03	22G	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	0		0	0	0	1		POINT (-73.9635606199784 40.782206970617)
1704	-73.9624052832372	40.7809656348254	21H-PM-1018-04	21H	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	1	1	0		POINT (-73.9624052832372 40.7809656348254)
2164	-73.955013129397	40.7954024311542	38F-AM-1018-05	38F	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0	ran up tree	0	0	0	1		POINT (-73.955013129397 40.7954024311542)
2313	-73.9646174034945	40.778128752826206	18H-AM-1018-01	18H	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Running from one tree to the other	1	1	0	0	0	playing?	0	0	0	0		POINT (-73.9646174034945 40.7781287528262)
2374	-73.9551370586201	40.7946465469021	38F-AM-1018-06	38F	AM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	hopped away	0	0	0	1		POINT (-73.95513705862011 40.7946465469021)
2432	-73.9657203199746	40.775173008911	14I-PM-1018-02	14I	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0	1		POINT (-73.9657203199746 40.775173008911)
2681	-73.968807163616	40.7812018159499	19C-PM-1018-02	19C	PM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0		POINT (-73.968807163616 40.7812018159499)
2703	-73.9690174442945	40.7817617696508	19C-PM-1018-05	19C	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	1	0		POINT (-73.9690174442945 40.7817617696508)
2765	-73.971525123573	40.770368535984204	7G-PM-1018-06	07G	PM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1	grooming	0	0	0	0		POINT (-73.971525123573 40.7703685359842)
2888	-73.955258162768	40.7958147673603	39E-AM-1018-01	39E	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	standing still	0	0	0	1		POINT (-73.955258162768 40.7958147673603)
1451	-73.9645365195454	40.778153102126296	18H-AM-1018-02	18H	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		Tree	1	1	0	0	0	playing?	0	0	0	0		POINT (-73.9645365195454 40.7781531021263)
1518	-73.9632265832593	40.7816914475461	22G-AM-1018-04	22G	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3		0	0	1	0	0		0	0	0	0		POINT (-73.9632265832593 40.78169144754611)
1970	-73.96314646937691	40.793415656751	33A-PM-1018-02	33A	PM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10	Tree cavity [of] London Plane tree	0	0	0	0	0	hanging out,watching world	0	0	0	0	watching	POINT (-73.9631464693769 40.793415656751)
2522	-73.9658747245917	40.77540337375321	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground		Fallen branch	1	0	0	0	1		0	1	0	1		POINT (-73.9658747245917 40.7754033737532)