2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Date = 10062018, Eating = 1, Foraging = 0 and Tail twitches = 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: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, 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
314	314	-73.960601067176	40.7917243850136	32D-PM-1006-09	32D	PM	10062018	9	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	1	0	0		POINT (-73.960601067176 40.7917243850136)
335	335	-73.97823514358521	40.7715896672335	6A-AM-1006-03	06A	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	30	tree	0	1	0	1	0		0	0	0	1	1	0	0	0		POINT (-73.9782351435852 40.7715896672335)
381	381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black		Black+		Above Ground	15		1	0	0	1	0		0	0	0	0	1	0	0	1	ran up tree	POINT (-73.959709414696 40.7919745085986)
668	668	-73.9706903740547	40.7726873760687	10G-AM-1006-07	10G	AM	10062018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9706903740547 40.77268737606871)
670	670	-73.9602398690946	40.7910157676119	32D-PM-1006-04	32D	PM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9602398690946 40.7910157676119)
728	728	-73.96029131055779	40.7910635810038	32D-PM-1006-03	32D	PM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9602913105578 40.7910635810038)
1091	1091	-73.97055600790999	40.7698499183436	7H-AM-1006-07	07H	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon					0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.97055600791 40.7698499183436)
1303	1303	-73.9603302382958	40.7910100435196	32D-PM-1006-01	32D	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9603302382958 40.7910100435196)
1345	1345	-73.95813265542058	40.7918074743129	34E-PM-1006-02	34E	PM	10062018	2	Juvenile	Black	Gray, White	Black+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9581326554206 40.7918074743129)
1586	1586	-73.9714150090362	40.7774976423922	14C-PM-1006-03	14C	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9714150090362 40.7774976423922)
2344	2344	-73.9786310308892	40.766934936818295	1D-AM-1006-05	01D	AM	10062018	5	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	0		POINT (-73.9786310308892 40.7669349368183)
2433	2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	3		0	0	0	1	0		0	0	0	1	1	0	1	0		POINT (-73.9706949930717 40.772362045852)
2604	2604	-73.9605163698302	40.7914179994956	32D-PM-1006-05	32D	PM	10062018	5	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	1	1	0		0	0	0	0	1	0	0	1		POINT (-73.9605163698302 40.7914179994956)
2723	2723	-73.96064260275601	40.791726541984204	32D-PM-1006-08	32D	PM	10062018	8	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	0	stand on two feet and watching me	POINT (-73.960642602756 40.7917265419842)
2766	2766	-73.95516398474659	40.790858199891	34H-PM-1006-03	34H	PM	10062018	3		Gray	White	Gray+White	white belly	Ground Plane	FALSE	Under Tupelo Tree	0	0	0	1	0		0	0	0	0	1	0	0	0		POINT (-73.9551639847466 40.790858199891)
2947	2947	-73.96012151981141	40.7909769801241	32D-PM-1006-02	32D	PM	10062018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9601215198114 40.7909769801241)

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