2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Date = 10072018, Hectare Squirrel Number = 2, Indifferent = 1 and Running = 0

- 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, Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches

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
68	68	-73.96942403275091	40.7755898126674	13F-AM-1007-02	13F	AM	10072018	2	Adult	Cinnamon	White	Cinnamon+White					0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96942403275091 40.7755898126674)
192	192	-73.9651654887991	40.7777806006951	17H-PM-1007-02	17H	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9651654887991 40.7777806006951)
234	234	-73.9741401377844	40.7758134257881	12B-AM-1007-02	12B	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9741401377844 40.7758134257881)
304	304	-73.9523001834395	40.7949231000186	39H-AM-1007-02	39H	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9523001834395 40.7949231000186)
319	319	-73.96590343597059	40.779751668884394	19F-AM-1007-02	19F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9659034359706 40.77975166888441)
484	484	-73.9666526554772	40.7756111718355	14H-AM-1007-02	14H	AM	10072018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9666526554772 40.77561117183551)
505	505	-73.9677387336667	40.774269591199996	12H-PM-1007-02	12H	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677387336667 40.7742695912)
553	553	-73.9638526062093	40.782693848993	22F-AM-1007-02	22F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	standing	0	0	0	0	0	0	1	0		POINT (-73.9638526062093 40.782693848993)
694	694	-73.9698032734704	40.7782343912417	16D-AM-1007-02	16D	AM	10072018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9698032734704 40.7782343912417)
831	831	-73.9587712679442	40.7944502501428	36D-PM-1007-02	36D	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	1	0		POINT (-73.9587712679442 40.7944502501428)
848	848	-73.9692190295442	40.776336630915395	14F-AM-1007-02	14F	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9692190295442 40.7763366309154)
894	894	-73.96751982309179	40.778631094685004	17F-AM-1007-02	17F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9675198230918 40.778631094685)
1067	1067	-73.9695305996721	40.774538689695895	12F-PM-1007-02	12F	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305996721 40.7745386896959)
1095	1095	-73.9735547926323	40.772342007610796	8D-AM-1007-02	08D	AM	10072018	2	Adult	Gray		Gray+		Above Ground	12		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9735547926323 40.7723420076108)
1228	1228	-73.9729090336637	40.779434005250295	15A-AM-1007-02	15A	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	in fenced in lawn (chill)	POINT (-73.9729090336637 40.7794340052503)
1668	1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nut	0	0	0	0	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
1724	1724	-73.9795492724533	40.770949747173795	4A-AM-1007-02	04A	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9795492724533 40.7709497471738)
1804	1804	-73.98077710643099	40.7681635726316	1A-AM-1007-02	01A	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	11		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.980777106431 40.7681635726316)
1847	1847	-73.9782283921819	40.766793260207706	1D-PM-1007-02	01D	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9782283921819 40.7667932602077)
1899	1899	-73.9764314091366	40.773645805795205	8B-AM-1007-02	08B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9764314091366 40.773645805795205)
1972	1972	-73.9558370309765	40.7921977208472	35G-AM-1007-02	35G	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9558370309765 40.7921977208472)
2026	2026	-73.9622752768962	40.7814921913101	22H-PM-1007-02	22H	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	low branch	0	0	0	0	0	watching me scratching	1	0	0	1	0	0	1	0		POINT (-73.9622752768962 40.7814921913101)
2208	2208	-73.96149727573321	40.7921404951324	33C-PM-1007-02	33C	PM	10072018	2	Adult	Gray	Black, White	Gray+Black, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9614972757332 40.7921404951324)
2222	2222	-73.9639048209454	40.777737334555795	18I-PM-1007-02	18I	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12		0	0	1	1	1	hanging upside down	0	0	0	0	0	0	1	0		POINT (-73.9639048209454 40.7777373345558)
2230	2230	-73.9730813162152	40.7779315720879	14B-AM-1007-02	14B	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9730813162152 40.7779315720879)
2321	2321	-73.9743060404813	40.7687901781431	5F-PM-1007-02	05F	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9743060404813 40.7687901781431)
2356	2356	-73.9611355303487	40.793069353224	34C-AM-1007-02	34C	AM	10072018	2	Adult	Gray		Gray+		Above Ground	40		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611355303487 40.793069353224)
2448	2448	-73.9668230576555	40.78706372333271	25B-PM-1007-02	25B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9668230576555 40.7870637233327)
2626	2626	-73.9737329655838	40.7726424441344	8D-PM-1007-02	08D	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9737329655838 40.7726424441344)
2791	2791	-73.9593624259363	40.7905522356793	32E-AM-1007-02	32E	AM	10072018	2	Adult	Gray		Gray+		Above Ground	40		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9593624259363 40.7905522356793)
2851	2851	-73.955208233231	40.7890574331084	32I-PM-1007-02	32I	PM	10072018	2	Adult			+		Above Ground	30		0	0	1	0	0	different sound - happy,playful chirps	0	0	0	0	1	0	1	0		POINT (-73.955208233231 40.7890574331084)

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
);