2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Above Ground Sighter Measurement = "FALSE", Hectare Squirrel Number = 7, Shift = "AM" and Tail twitches = 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: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Quaas, Tail flags, Approaches, Indifferent, Runs from

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
559	559	-73.9704166194815	40.7766720346576	14E-AM-1008-07	14E	AM	10082018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	walking	0	0	0	0	0	0	1	0		POINT (-73.9704166194815 40.7766720346576)
642	642	-73.9568382279233	40.7975685470963	40C-AM-1017-07	40C	AM	10172018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9568382279233 40.7975685470963)
722	722	-73.9745953710328	40.7728284025195	8D-AM-1007-07	08D	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9745953710328 40.7728284025195)
750	750	-73.96996720741642	40.777438934574796	15D-AM-1007-07	15D	AM	10072018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1	chasing #8	0	0	0	0	0	0	1	0		POINT (-73.9699672074164 40.7774389345748)
770	770	-73.95977827620291	40.79207733767571	33D-AM-1017-07	33D	AM	10172018	7	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	1	0	1	0	0	1	0		POINT (-73.9597782762029 40.7920773376757)
910	910	-73.9796383715206	40.7682477738244	2B-AM-1010-07	02B	AM	10102018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9796383715206 40.7682477738244)
1066	1066	-73.9720174997123	40.774889426602705	11D-AM-1010-07	11D	AM	10102018	7	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9720174997123 40.7748894266027)
1073	1073	-73.9769742179824	40.772748452182896	7B-AM-1008-07	07B	AM	10082018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9769742179824 40.7727484521829)
1209	1209	-73.97631591531379	40.7705785330431	5C-AM-1006-07	05C	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9763159153138 40.7705785330431)
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)
1243	1243	-73.97455562298549	40.767292104099795	3F-AM-1006-07	03F	AM	10062018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745556229855 40.7672921040998)
1390	1390	-73.9677146741772	40.77882313323371	17E-AM-1017-07	17E	AM	10172018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9677146741772 40.7788231332337)
1791	1791	-73.97109071758341	40.776373910820006	13D-AM-1014-07	13D	AM	10142018	7	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.9710907175834 40.77637391082)
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)
1843	1843	-73.9685940262068	40.776932102013	15F-AM-1007-07	15F	AM	10072018	7	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9685940262068 40.776932102013)
1861	1861	-73.97555625268109	40.7678821029525	3E-AM-1006-07	03E	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nuts	0	0	0	0	0	0	0	0		POINT (-73.9755562526811 40.7678821029525)
1862	1862	-73.97648512317541	40.771573686286104	6C-AM-1007-07	06C	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0	ambling	0	0	0	0	0	1	0	1	trucks	POINT (-73.9764851231754 40.7715736862861)
1986	1986	-73.958247706428	40.7989079136796	40B-AM-1019-07	40B	AM	10192018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.958247706428 40.7989079136796)
2057	2057	-73.9579659543224	40.7905646887034	32F-AM-1012-07	32F	AM	10122018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9579659543224 40.7905646887034)
2100	2100	-73.9638312025305	40.7903826659569	30B-AM-1007-07	30B	AM	10072018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9638312025305 40.7903826659569)
2104	2104	-73.9622419917579	40.794579797904	35A-AM-1014-07	35A	AM	10142018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9622419917579 40.794579797904)
2174	2174	-73.9684092812839	40.7711445841928	9I-AM-1014-07	09I	AM	10142018	7	Adult	Cinnamon		Cinnamon+	No real highlight, White tail?	Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9684092812839 40.7711445841928)
2261	2261	-73.9609692861012	40.790502891247	31D-AM-1014-07	31D	AM	10142018	7		Gray		Gray+		Ground Plane	FALSE	Crossing path to tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9609692861012 40.790502891247)
2332	2332	-73.9709797467807	40.776909571067904	14D-AM-1014-07	14D	AM	10142018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9709797467807 40.7769095710679)
2462	2462	-73.9768544488742	40.76800695009771	3D-AM-1006-07	03D	AM	10062018	7	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0	running (with food in mouth)	0	0	0	0	0	0	1	0		POINT (-73.9768544488742 40.7680069500977)
2567	2567	-73.9690241805398	40.783796758077294	21B-AM-1019-07	21B	AM	10192018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9690241805398 40.7837967580773)
2649	2649	-73.9706428641753	40.7762933936464	13E-AM-1017-07	13E	AM	10172018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9706428641753 40.7762933936464)
2713	2713	-73.9687214684206	40.779284172016396	17D-AM-1008-07	17D	AM	10082018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9687214684206 40.7792841720164)
2778	2778	-73.9761799699276	40.774213409933	9B-AM-1010-07	09B	AM	10102018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9761799699276 40.774213409933)

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