2018_Central_Park_Squirrel_Census_-_Squirrel_Data

38 rows where Date = 10102018, Moans = 0, Runs from = 1 and Shift = "AM"

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by longitude Sort by latitude Sort by Unique Squirrel ID Sort by Hectare Sort by Shift Sort by Date Sort by Hectare Squirrel Number Sort by Age Sort by Primary Fur Color Sort by Highlight Fur Color Sort by Combination of Primary and Highlight Color Sort by Color notes Sort by Location Sort by Above Ground Sighter Measurement Sort by Specific Location Sort by Running Sort by Chasing Sort by Climbing Sort by Eating Sort by Foraging Sort by Other Activities Sort by Kuks Sort by Quaas Sort by Moans Sort by Tail flags Sort by Tail twitches Sort by Approaches Sort by Indifferent Sort by Runs from Sort by Other Interactions Sort by Lat/Long

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Indifferent, Other Interactions

Link	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
110	110	-73.97113187902791	40.7701941550273	7G-AM-1010-02	07G	AM	10102018	2	Adult	Gray		Gray+		Above Ground	3		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9711318790279 40.7701941550273)
123	123	-73.9671147090087	40.7772624641112	16G-AM-1010-03	16G	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	was hanging out w/ #2 until i showed up	1	0	0	0	0	0	0	1		POINT (-73.9671147090087 40.7772624641112)
124	124	-73.9588660250232	40.7982597947515	40A-AM-1010-03	40A	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom of great hill	0	0	0	1	1		0	0	0	1	0	0	1	1	dog chased	POINT (-73.9588660250232 40.7982597947515)
186	186	-73.9788138172962	40.7693001754769	3B-AM-1010-09	03B	AM	10102018	9	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9788138172962 40.7693001754769)
242	242	-73.9590236602085	40.798263245686606	40A-AM-1010-04	40A	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom great hill	0	0	0	0	1		0	0	0	1	0	0	1	1	dog chased	POINT (-73.9590236602085 40.7982632456866)
283	283	-73.9529060669193	40.79279097353879	37I-AM-1010-01	37I	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9529060669193 40.7927909735388)
313	313	-73.9646610347972	40.7790583544252	19H-AM-1010-05	19H	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	near a brush	0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9646610347972 40.7790583544252)
417	417	-73.9639888092327	40.791449395909	31A-AM-1010-01	31A	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9639888092327 40.791449395909005)
534	534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9650499507011 40.7908191782173)
547	547	-73.9559677963727	40.7951124076946	38E-AM-1010-07	38E	AM	10102018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #6	0	0	0	0	1	0	0	1		POINT (-73.9559677963727 40.7951124076946)
623	623	-73.9662939630722	40.7878502338031	26B-AM-1010-01	26B	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE	running across bridle path	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9662939630722 40.7878502338031)
650	650	-73.98096101171708	40.7683896665502	2A-AM-1010-02	02A	AM	10102018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground		perched on small fence	0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9809610117171 40.7683896665502)
671	671	-73.9709244006956	40.7676942639697	5I-AM-1010-02	05I	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9709244006956 40.7676942639697)
768	768	-73.9729394928432	40.774325671649606	11D-AM-1010-01	11D	AM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9729394928432 40.7743256716496)
769	769	-73.976521916284	40.773784724458	9B-AM-1010-01	09B	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		1	0	0	0	0	0	0	1		POINT (-73.976521916284 40.773784724458)
916	916	-73.95618876244708	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	0	0	1	me	POINT (-73.95618876244711 40.7958187455815)
923	923	-73.9578924882613	40.789806297824	32G-AM-1010-02	32G	AM	10102018	2	Adult	Gray		Gray+		Above Ground	13		0	0	1	1	0		0	0	0	0	1	0	0	1		POINT (-73.9578924882613 40.789806297824)
988	988	-73.97870401924729	40.767901024728104	2C-AM-1010-06	02C	AM	10102018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	stood still & watched me then jumped on a fence and ran away	0	0	0	0	0	0	1	1		POINT (-73.9787040192473 40.7679010247281)
1080	1080	-73.96902119353459	40.773038298158	11H-AM-1010-07	11H	AM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9690211935346 40.773038298158)
1236	1236	-73.97920390711141	40.76787494712671	2C-AM-1010-07	02C	AM	10102018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	0	0	0	#7 & #8 chased each other up diff tree	0	0	0	0	0	0	0	1		POINT (-73.9792039071114 40.76787494712671)
1256	1256	-73.9679457364586	40.7717350221981	10I-AM-1010-02	10I	AM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9679457364586 40.7717350221981)
1347	1347	-73.9616693665254	40.792971019627	33B-AM-1010-05	33B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616693665254 40.792971019627)
1548	1548	-73.9790044506465	40.7689469479245	3B-AM-1010-03	03B	AM	10102018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0	chasing #2	0	0	0	0	0	0	0	1		POINT (-73.9790044506465 40.7689469479245)
1643	1643	-73.95305356247809	40.7929809144271	37I-AM-1010-02	37I	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9530535624781 40.7929809144271)
1662	1662	-73.95616002372842	40.7953143196705	38E-AM-1010-10	38E	AM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	over a log across stream	0	0	0	0	0	chillin'	0	0	0	0	0	0	0	1	runs from leaf blower	POINT (-73.9561600237284 40.7953143196705)
1714	1714	-73.9763542780331	40.773653130362206	9B-AM-1010-02	09B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	in bush	0	0	1	0	1		0	0	0	0	1	0	0	1	froze	POINT (-73.9763542780331 40.773653130362206)
1734	1734	-73.9524132295658	40.7933777553406	37I-AM-1010-05	37I	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.95241322956582 40.7933777553406)
1814	1814	-73.97223594012421	40.7702891474555	7G-AM-1010-07	07G	AM	10102018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9722359401242 40.7702891474555)
2038	2038	-73.98035621370491	40.7685780990634	2B-AM-1010-02	02B	AM	10102018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9803562137049 40.7685780990634)
2330	2330	-73.9724618533895	40.7745021602455	11D-AM-1010-02	11D	AM	10102018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	0	1	walking	0	0	0	0	1	0	0	1		POINT (-73.9724618533895 40.7745021602455)
2406	2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
2426	2426	-73.9790203973636	40.768883711483205	3B-AM-1010-02	03B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	together w/ #3	0	0	0	0	0	0	0	1		POINT (-73.9790203973636 40.7688837114832)
2435	2435	-73.972087127535	40.776237268628	13C-AM-1010-01	13C	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.972087127535 40.776237268628)
2565	2565	-73.97086402918009	40.7781721063527	15C-AM-1010-01	15C	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9708640291801 40.7781721063527)
2607	2607	-73.9642988690682	40.779559128197896	19H-AM-1010-04	19H	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	1	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)
2807	2807	-73.9618213644671	40.792764881973795	33B-AM-1010-02	33B	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.96182136446711 40.7927648819738)
2963	2963	-73.9687020800791	40.7735903424522	11H-AM-1010-08	11H	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9687020800791 40.7735903424522)
2968	2968	-73.9587236619579	40.799185018043396	40A-AM-1010-02	40A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park at 108th West	1	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9587236619579 40.7991850180434)

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);