2018_Central_Park_Squirrel_Census_-_Squirrel_Data

13 rows where Above Ground Sighter Measurement = "FALSE", Climbing = 1 and Date = 10102018

- 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, Running, Eating, Foraging, Tail flags, Tail twitches, 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
625	625	-73.9764235373322	40.770606513989	5C-PM-1010-11	05C	PM	10102018	11	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.97642353733221 40.770606513989)
680	680	-73.95640114211221	40.7958097849369	38E-AM-1010-02	38E	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0	climbs	POINT (-73.95640114211221 40.7958097849369)
690	690	-73.9767949141123	40.774454583585	9A-PM-1010-01	09A	PM	10102018	1	Adult			+		Ground Plane	FALSE	by large tree in sectioned off area	0	0	1	0	0	i think it climbed the tree when i first saw it.	0	0	0	0	0	0	1	0		POINT (-73.9767949141123 40.774454583585)
768	768	-73.9729394928432	40.774325671649606	11D-AM-1010-01	11D	AM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9729394928432 40.7743256716496)
916	916	-73.95618876244708	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	0	0	1	me	POINT (-73.95618876244711 40.7958187455815)
1259	1259	-73.976864402584	40.7705663751959	5C-PM-1010-05	05C	PM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.976864402584 40.7705663751959)
1882	1882	-73.9541601469123	40.7907832744689	34I-PM-1010-04	34I	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE	across the lawn and climb up a small tree	1	0	1	0	0	grooming	0	0	0	0	0	0	0	0		POINT (-73.9541601469123 40.79078327446891)
2404	2404	-73.96653096896159	40.7775271020244	16G-AM-1010-04	16G	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9665309689616 40.7775271020244)
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)
2471	2471	-73.964274290774	40.779531955602295	19H-AM-1010-03	19H	AM	10102018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
2574	2574	-73.978199543688	40.7695660563362	4C-PM-1010-17	04C	PM	10102018	17	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	climbed up tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.978199543688 40.7695660563362)
2607	2607	-73.9642988690682	40.779559128197896	19H-AM-1010-04	19H	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	1	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)
2968	2968	-73.9587236619579	40.799185018043396	40A-AM-1010-02	40A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park at 108th West	1	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9587236619579 40.7991850180434)

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