2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Hectare Squirrel Number = 3, Highlight Fur Color = "Cinnamon", Running = 1 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: Unique Squirrel ID, Hectare, Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Tail flags, Indifferent, Runs from, Other Interactions

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
2	2	-73.9570437717691	40.7948509408039	37E-PM-1006-03	37E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	me	POINT (-73.9570437717691 40.794850940803904)
107	107	-73.9521110154872	40.7978449143313	42G-AM-1018-03	42G	AM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	stop to look at me—then ran	0	0	0	0	0	0	0	1		POINT (-73.9521110154872 40.7978449143313)
408	408	-73.9633760173635	40.7818422357619	22G-PM-1018-03	22G	PM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	chilling	0	0	0	0	0	0	1	0	observed	POINT (-73.96337601736352 40.7818422357619)
413	413	-73.96989341826121	40.7708211633861	8H-PM-1014-03	08H	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9698934182612 40.7708211633861)
612	612	-73.9629420113622	40.789133072717	29C-AM-1007-03	29C	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9629420113622 40.789133072717)
716	716	-73.9745427984089	40.7691848214817	5E-AM-1008-03	05E	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9745427984089 40.7691848214817)
786	786	-73.953296595236	40.7927644594513	36I-AM-1017-03	36I	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon stripe on back	Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.953296595236 40.7927644594513)
1021	1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1	running (from a dog)	0	0	0	0	0	0	1	0		POINT (-73.97186968288 40.778926988884)
1150	1150	-73.97447264347429	40.776729630785	12A-PM-1013-03	12A	PM	10132018	3		Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		1	0	0	0	0	chased up a tree by #4	0	0	0	0	0	0	1	0		POINT (-73.9744726434743 40.776729630785)
1447	1447	-73.9601968065017	40.7935831836482	34C-PM-1012-03	34C	PM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9601968065017 40.79358318364821)
1481	1481	-73.95388671863759	40.794140943400706	38G-PM-1020-03	38G	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9538867186376 40.7941409434007)
1748	1748	-73.955710327539	40.797451079756705	40D-AM-1013-03	40D	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955710327539 40.7974510797567)
1773	1773	-73.9611126813593	40.7943113021522	35B-AM-1010-03	35B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611126813593 40.7943113021522)
1968	1968	-73.9699088881236	40.775277835162605	13F-AM-1007-03	13F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699088881236 40.7752778351626)
2256	2256	-73.9720050204318	40.769941909416794	7G-AM-1010-03	07G	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9720050204318 40.7699419094168)
2259	2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.975565603566 40.7738462518304)
2272	2272	-73.9569670900695	40.7948792856813	37E-PM-1006-03	37E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	me	POINT (-73.9569670900695 40.794879285681304)
2407	2407	-73.95557243517759	40.7967602498249	39E-AM-1018-03	39E	AM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9555724351776 40.7967602498249)
2465	2465	-73.9686999860219	40.784401473513604	22B-PM-1014-03	22B	PM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9686999860219 40.7844014735136)
2694	2694	-73.969628583287	40.770406779793205	8H-AM-1017-03	08H	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	fence	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.969628583287 40.7704067797932)
2836	2836	-73.953092053256	40.7982256930243	42F-PM-1017-03	42F	PM	10172018	3		Gray	Cinnamon	Gray+Cinnamon					1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.953092053256 40.7982256930243)
2871	2871	-73.9777124331985	40.7704051056666	5B-AM-1008-03	05B	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9777124331985 40.7704051056666)
2948	2948	-73.9545225586988	40.7956074663106	39F-AM-1014-03	39F	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545225586988 40.7956074663106)
2985	2985	-73.9721159387757	40.766050318863705	3I-PM-1013-03	03I	PM	10132018	3	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9721159387757 40.7660503188637)

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