2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Hectare Squirrel Number = 1, Highlight Fur Color = "Cinnamon", Indifferent = 0 and Running = 1

- 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: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, Approaches, 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
118	118	-73.9566346046453	40.7973923396512	40D-PM-1013-01	40D	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9566346046453 40.7973923396512)
193	193	-73.9537691298752	40.7941272599797	38G-PM-1020-01	38G	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9537691298752 40.7941272599797)
403	403	-73.9597470659927	40.797321593541604	38A-PM-1013-01	38A	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9597470659927 40.7973215935416)
479	479	-73.95694033658471	40.795659960879796	38D-PM-1006-01	38D	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	didn't see me or others	POINT (-73.9569403365847 40.7956599608798)
528	528	-73.9647284206644	40.7839611840884	23E-PM-1006-01	23E	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on a tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9647284206644 40.7839611840884)
641	641	-73.97190362174459	40.7803588122409	17A-AM-1017-01	17A	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3	ground & tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.9719036217446 40.7803588122409)
720	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	0	0	0	1	0	0	1		POINT (-73.9669814346326 40.780390919948)
837	837	-73.9557172336815	40.79211256577221	35G-PM-1006-01	35G	PM	10062018	1	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9557172336815 40.7921125657722)
930	930	-73.96220300857941	40.7917723228749	32B-AM-1017-01	32B	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	ran up a tree	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9622030085794 40.7917723228749)
1408	1408	-73.973230162241	40.768982453144396	5F-AM-1007-01	05F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	fence	1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.973230162241 40.7689824531444)
1429	1429	-73.9706533131129	40.768902033818996	6I-AM-1006-01	06I	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground			1	0	1	1	1		0	0	0	0	0	0	0	1	runs from (someone sneezed)	POINT (-73.9706533131129 40.768902033819)
1440	1440	-73.9748669205206	40.7743879232016	10B-AM-1006-01	10B	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9748669205206 40.7743879232016)
1945	1945	-73.9530257401736	40.795139740737	39G-PM-1013-01	39G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9530257401736 40.79513974073701)
2147	2147	-73.9651217998407	40.7761115392738	15I-PM-1012-01	15I	PM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9651217998407 40.7761115392738)
2275	2275	-73.96142184133559	40.793894505879294	34B-AM-1013-01	34B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	hopping	0	0	0	0	1	1	0	0		POINT (-73.9614218413356 40.7938945058793)
2313	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	0	0		POINT (-73.9646174034945 40.7781287528262)
2316	2316	-73.957697363244	40.7997576909042	42A-PM-1014-01	42A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	up on hind legs looking around	0	0	0	0	0	0	0	0	came to about 10' away then ran off	POINT (-73.957697363244 40.7997576909042)
2371	2371	-73.9769520212123	40.774006725862996	9A-AM-1013-01	09A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9769520212123 40.774006725863)
2423	2423	-73.973552877209	40.7715638228207	7E-PM-1013-01	07E	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Ground & Tree Base	1	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.973552877209 40.7715638228207)
2522	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	0	0	0	1	0	0	1		POINT (-73.9658747245917 40.7754033737532)
2585	2585	-73.9771726831497	40.7732320781799	8A-AM-1013-01	08A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	trail	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9771726831497 40.7732320781799)
2682	2682	-73.97110012783891	40.778746609584104	15C-PM-1017-01	15C	PM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9711001278389 40.7787466095841)
2758	2758	-73.95420748142959	40.79543222400039	39F-AM-1014-01	39F	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9542074814296 40.7954322240004)

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