2018_Central_Park_Squirrel_Census_-_Squirrel_Data

27 rows where Climbing = 1, Foraging = 0, Hectare Squirrel Number = 1 and Runs from = 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, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Kuks, Quaas, Moans, Tail flags, Tail twitches, Indifferent

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
45	45	-73.9579645940414	40.7918613498407	34F-AM-1007-01	34F	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9579645940414 40.7918613498407)
102	102	-73.95759861613641	40.799368134968	41B-PM-1014-01	41B	PM	10142018	1	Adult	Gray	White	Gray+White		Above Ground	25	Climbing tree	0	0	1	0	0	climbing (tree)	0	0	0	0	0	0	0	1		POINT (-73.9575986161364 40.799368134968)
236	236	-73.9737266070919	40.7786338379896	14A-PM-1014-01	14A	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9737266070919 40.7786338379896)
534	534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9650499507011 40.7908191782173)
643	643	-73.976730206737	40.773709213913996	8A-PM-1014-01	08A	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	0		1	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.976730206737 40.773709213914)
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)
865	865	-73.9741621946917	40.775248147202504	11C-PM-1018-01	11C	PM	10182018	1	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9741621946917 40.7752481472025)
984	984	-73.9672950266018	40.7782477517567	17F-PM-1020-01	17F	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9672950266018 40.7782477517567)
996	996	-73.9703149829421	40.778558363032296	16D-AM-1007-01	16D	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9703149829421 40.7785583630323)
1051	1051	-73.96137470327021	40.7920483852431	33C-PM-1007-01	33C	PM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9613747032702 40.792048385243106)
1055	1055	-73.9632337134707	40.791468237073396	31B-PM-1007-01	31B	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #2 and climbing tree w/ #2	0	0	0	0	0	0	0	1		POINT (-73.9632337134707 40.7914682370734)
1206	1206	-73.97487092063541	40.77608025411	11B-PM-1014-01	11B	PM	10142018	1	Adult	Gray		Gray+	Fat!	Above Ground	10		0	0	1	0	0		1	0	0	0	0	0	0	1		POINT (-73.9748709206354 40.77608025411)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1534	1534	-73.9695226023739	40.7797527775804	17D-AM-1008-01	17D	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695226023739 40.7797527775804)
1560	1560	-73.9587072763996	40.7850256219415	27I-AM-1007-01	27I	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9587072763996 40.7850256219415)
1581	1581	-73.97157754108001	40.7776249963967	14C-PM-1006-01	14C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.97157754108 40.7776249963967)
1640	1640	-73.9564632239432	40.7904807427954	33G-AM-1013-01	33G	AM	10132018	1	Adult	Cinnamon		Cinnamon+		Above Ground	13	shelter in hole in tree	0	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9564632239432 40.7904807427954)
1825	1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
1939	1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9540151828782 40.7920066170587)
2338	2338	-73.9716621112698	40.774286221946895	11E-AM-1013-01	11E	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9716621112698 40.7742862219469)
2406	2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
2435	2435	-73.972087127535	40.776237268628	13C-AM-1010-01	13C	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.972087127535 40.776237268628)
2463	2463	-73.9653343572865	40.77752869246171	17H-PM-1007-01	17H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9653343572865 40.7775286924617)
2495	2495	-73.9621253644004	40.7912082086879	31C-AM-1017-01	31C	AM	10172018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	8		1	0	1	1	0		0	0	0	0	1	0	0	1		POINT (-73.9621253644004 40.7912082086879)
2729	2729	-73.9615429203441	40.7907417648701	31D-AM-1014-01	31D	AM	10142018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	Ground then up tree	0	0	1	0	0	chased by a doggo	0	0	1	0	0	0	0	1	runs from (dogs!)	POINT (-73.9615429203441 40.7907417648701)
2794	2794	-73.9712187890707	40.7750640173134	12E-PM-1018-01	12E	PM	10182018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		1	0	0	1	0	0	0	1		POINT (-73.9712187890707 40.7750640173134)
2874	2874	-73.9597453664295	40.7891382153733	30F-PM-1007-01	30F	PM	10072018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground	1	tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9597453664295 40.7891382153733)

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