2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Hectare Squirrel Number = 3, Location = "Above Ground" 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

- 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, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Quaas, 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
168	168	-73.9745691353018	40.777103558929795	13A-PM-1014-03	13A	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	1	0	0		0	0	0	0	0	0	0	1	child chasing	POINT (-73.9745691353018 40.7771035589298)
224	224	-73.9520592496349	40.797507629981105	42G-PM-1014-03	42G	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	on fence	1	0	0	0	0	prancing	0	0	0	0	0	0	0	1		POINT (-73.9520592496349 40.7975076299811)
258	258	-73.9534333425633	40.793256416332795	37H-AM-1018-03	37H	AM	10182018	3	Adult	Gray	White	Gray+White		Above Ground	10	in a tree with red berries	0	0	0	1	0		0	1	0	0	0	0	0	1		POINT (-73.9534333425633 40.7932564163328)
331	331	-73.95448101115	40.7954469678857	39F-PM-1006-03	39F	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15	lower branch of tree	0	0	0	1	0		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.95448101115 40.7954469678857)
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)
388	388	-73.9592537496995	40.7919271821316	33E-AM-1014-03	33E	AM	10142018	3	Adult	Black		Black+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9592537496995 40.7919271821316)
598	598	-73.9698196671161	40.7802972001469	18C-PM-1018-03	18C	PM	10182018	3	Juvenile	Gray		Gray+		Above Ground	1		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9698196671161 40.7802972001469)
820	820	-73.9801902133148	40.769557595068	3A-AM-1012-03	03A	AM	10122018	3	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9801902133148 40.769557595068)
852	852	-73.9609704650925	40.7938786854735	34B-AM-1013-03	34B	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		1	0	1	0	0	hopping	0	0	0	0	0	1	0	1		POINT (-73.9609704650925 40.7938786854735)
869	869	-73.96294833745279	40.7936809905265	33A-PM-1018-03	33A	PM	10182018	3	Adult	Gray		Gray+		Above Ground	6		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9629483374528 40.7936809905265)
1126	1126	-73.97001860010491	40.7826052184658	20B-AM-1007-03	20B	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground			0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9700186001049 40.7826052184658)
1230	1230	-73.9790822606486	40.7714466633386	5A-AM-1006-03	05A	AM	10062018	3	Juvenile	Cinnamon		Cinnamon+		Above Ground	8		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9790822606486 40.7714466633386)
1268	1268	-73.96239842629359	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623984262936 40.7913900453449)
1328	1328	-73.9765758043111	40.771380315403206	6C-AM-1007-03	06C	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	8	another tree	1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765758043111 40.7713803154032)
1395	1395	-73.9710801547498	40.7760872452093	13D-AM-1014-03	13D	AM	10142018	3	Juvenile	Gray	White	Gray+White		Above Ground	2		0	1	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9710801547498 40.7760872452093)
1553	1553	-73.9690645326017	40.7773822116124	15E-AM-1013-03	15E	AM	10132018	3	Adult	Gray		Gray+		Above Ground	2	on fallen log	0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9690645326017 40.7773822116124)
2034	2034	-73.96991351872971	40.7782354186163	16D-AM-1007-03	16D	AM	10072018	3	Adult			+	ran away before I could take a good look	Above Ground	2		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699135187297 40.7782354186163)
2090	2090	-73.9569759970802	40.7931497452294	35F-PM-1012-03	35F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9569759970802 40.79314974522941)
2132	2132	-73.967472660349	40.7772125619715	16F-PM-1013-03	16F	PM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4	Woods	0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.96747266034902 40.7772125619715)
2397	2397	-73.9704592500888	40.772962887933005	10G-AM-1006-03	10G	AM	10062018	3	Juvenile	Gray	White	Gray+White	tuft on butt	Above Ground	10		0	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9704592500888 40.772962887933)

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