2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Age = "Juvenile", Foraging = 0, Shift = "AM" 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, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Approaches, 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
53	53	-73.95849706432129	40.7982886348696	40B-AM-1019-03	40B	AM	10192018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	1	0	0		POINT (-73.9584970643213 40.7982886348696)
100	100	-73.9761592532482	40.774721358538706	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	0	0	0	0	0	walking on branch	0	0	0	0	1	0	0	0		POINT (-73.9761592532482 40.7747213585387)
172	172	-73.958535640774	40.7982737896998	40B-AM-1019-02	40B	AM	10192018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.958535640774 40.7982737896998)
419	419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9777328709928 40.7669087724668)
588	588	-73.9646597452128	40.7827698220703	22F-AM-1007-07	22F	AM	10072018	7	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	0	alert & aware	POINT (-73.9646597452128 40.7827698220703)
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)
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9722737593623 40.768963018754)
2033	2033	-73.9500167570283	40.7966185836685	41I-AM-1018-01	41I	AM	10182018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0	cautious,observant,runs off	POINT (-73.9500167570283 40.7966185836685)
2098	2098	-73.9700779726297	40.7722086251085	10G-AM-1006-11	10G	AM	10062018	11	Juvenile	Gray		Gray+		Above Ground	2		0	0	1	0	0		0	0	0	0	1	0	0	0		POINT (-73.9700779726297 40.7722086251085)
2389	2389	-73.9801343393329	40.769151245340204	3A-AM-1012-01	03A	AM	10122018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9801343393329 40.7691512453402)

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