2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Date = 10122018, Foraging = 0, Running = 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, Color notes, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, 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
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)
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	0	0	0	1	0		0	0	0	1	1	1	0	0		POINT (-73.9594357049738 40.7840678890949)
1349	1349	-73.9806805581636	40.7681537966505	1B-AM-1012-16	01B	AM	10122018	16	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9806805581636 40.7681537966505)
2199	2199	-73.9677500862135	40.7726060987821	11I-AM-1012-01	11I	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9677500862135 40.7726060987821)
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)
2390	2390	-73.9680741975294	40.7847036778165	23B-PM-1012-04	23B	PM	10122018	4	Adult	Gray	White	Gray+White		Above Ground	20		0	0	0	0	0	watching me - didn't move	0	0	0	0	1	0	0	1		POINT (-73.9680741975294 40.7847036778165)
2598	2598	-73.976658503418	40.768686845691704	4D-AM-1012-03	04D	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.976658503418 40.7686868456917)
2745	2745	-73.97296259363002	40.7652601851275	1I-PM-1012-04	01I	PM	10122018	4	Juvenile	Cinnamon	White	Cinnamon+White	Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	2	on ledge	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.97296259363 40.7652601851275)
2898	2898	-73.97941182346509	40.767449554056896	1C-AM-1012-02	01C	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9794118234651 40.7674495540569)
2988	2988	-73.9766342759486	40.7687518380873	4D-AM-1012-04	04D	AM	10122018	4	Adult	Gray		Gray+		Above Ground	3	on tree trunk	0	1	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9766342759486 40.7687518380873)

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