2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Eating = 1, Hectare Squirrel Number = 2, Indifferent = 0 and Runs from = 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: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, 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
33	33	-73.9738033257473	40.7711846894166	7E-AM-1006-02	07E	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE	under a tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9738033257473 40.7711846894166)
246	246	-73.9779805668091	40.768093156679704	2D-PM-1012-02	02D	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9779805668091 40.7680931566797)
289	289	-73.9684254196866	40.77809016436	16E-AM-1014-02	16E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9684254196866 40.77809016436)
519	519	-73.96590102384171	40.7791683666215	18G-PM-1013-02	18G	PM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9659010238417 40.779168366621505)
882	882	-73.9786805884996	40.769755923192704	4B-PM-1018-02	04B	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9786805884996 40.7697559231927)
1258	1258	-73.9789385196073	40.7675202157155	2C-AM-1010-02	02C	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9789385196073 40.7675202157155)
1330	1330	-73.9643032554205	40.7794514526463	19H-AM-1010-02	19H	AM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near base of small tree	1	0	0	1	1		0	0	0	1	0	1	0	0	ran from human with dog	POINT (-73.9643032554205 40.7794514526463)
1480	1480	-73.96285255338309	40.793844934501706	34A-PM-1013-02	34A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	1	eating upside down on tree trunk	0	0	0	0	0	0	0	0		POINT (-73.9628525533831 40.7938449345017)
1561	1561	-73.9642397829547	40.7918992406575	31A-PM-1017-02	31A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.96423978295472 40.7918992406575)
1720	1720	-73.9725844658514	40.7701092834201	7F-PM-1012-02	07F	PM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	observes	POINT (-73.9725844658514 40.7701092834201)
2231	2231	-73.95454276114769	40.793035381744104	36G-PM-1012-02	36G	PM	10122018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545427611477 40.7930353817441)
2370	2370	-73.9573119777312	40.7875347862766	30H-AM-1007-02	30H	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0	following #1	0	0	0	0	1	0	0	0		POINT (-73.9573119777312 40.7875347862766)
2380	2380	-73.97613757295049	40.766223189212496	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	1	0		0	0	0	0	0	1	0	0		POINT (-73.9761375729505 40.7662231892125)
2398	2398	-73.95871384837301	40.7963918051751	38C-PM-1014-02	38C	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.958713848373 40.7963918051751)
2511	2511	-73.95845615374209	40.791121116475395	33F-PM-1012-02	33F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	1	0	0	0		POINT (-73.9584561537421 40.7911211164754)
2551	2551	-73.970138810251	40.770579297644	8H-PM-1014-02	08H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	froze & watched me,then went back to eating	POINT (-73.970138810251 40.770579297644)

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