squirrels

Custom SQL query returning 19 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 "Shift" = :p2 order by [Hectare Squirrel Number] 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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
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	0	0	POINT (-73.9532620128307 40.7952475548048)
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	0	1	0	1	POINT (-73.9514111329059 40.797508587289705)
1007	-73.96353178229771	40.7821352080233	22G-AM-1018-01	22G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	0	0		1	1	0	0	1	0	POINT (-73.9635317822977 40.7821352080233)
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	0	0	POINT (-73.9646174034945 40.7781287528262)
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	0	0	1	POINT (-73.955258162768 40.7958147673603)
450	-73.96442931957729	40.7813829172072	21F-AM-1018-02	21F	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	0		0	0	1	0	1	0	POINT (-73.9644293195773 40.7813829172072)
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	0	0	POINT (-73.9645365195454 40.7781531021263)
2543	-73.96914249979191	40.780542852496	18C-AM-1018-02	18C	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	POINT (-73.9691424997919 40.780542852496)
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	0	0	1	POINT (-73.9521110154872 40.7978449143313)
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	0	0	1	POINT (-73.9635606199784 40.782206970617)
2407	-73.95557243517759	40.7967602498249	39E-AM-1018-03	39E	AM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	POINT (-73.9555724351776 40.7967602498249)
2599	-73.96898934126929	40.785308737683	23A-AM-1018-03	23A	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	8	Tree	0	0	1	0	0		0	0	0	0	1	0	POINT (-73.9689893412693 40.785308737683)
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	0	0	POINT (-73.95488778301362 40.7950157489103)
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	0	0	POINT (-73.9632265832593 40.78169144754611)
527	-73.9632646049622	40.781740129208295	22G-AM-1018-05	22G	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	POINT (-73.9632646049622 40.7817401292083)
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	0	0	1	POINT (-73.955013129397 40.7954024311542)
2531	-73.9599424115626	40.79574725853271	37B-AM-1018-05	37B	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	POINT (-73.9599424115626 40.7957472585327)
2876	-73.95589957376541	40.7960097734603	39E-AM-1018-05	39E	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	1	0	0	1	0	POINT (-73.9558995737654 40.7960097734603)
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	0	0	1	POINT (-73.95513705862011 40.7946465469021)