2018_Central_Park_Squirrel_Census_-_Squirrel_Data

26 rows where Climbing = 1, Date = 10072018 and Hectare Squirrel Number = 2

- 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Quaas, 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
86	86	-73.9708726050721	40.7723572030236	10F-AM-1007-02	10F	AM	10072018	2	Adult	Gray		Gray+		Above Ground	70		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9708726050721 40.7723572030236)
369	369	-73.9596398997228	40.793338695384705	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black		Black+		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	0	cautiously aware	POINT (-73.9596398997228 40.7933386953847)
425	425	-73.9704485231855	40.7717290560806	9G-AM-1007-02	09G	AM	10072018	2	Adult	Gray		Gray+		Above Ground	25		0	0	1	0	0		0	0	0	0	0	0	0	1	kids were trying to poke it with a stick	POINT (-73.9704485231855 40.7717290560806)
505	505	-73.9677387336667	40.774269591199996	12H-PM-1007-02	12H	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677387336667 40.7742695912)
525	525	-73.952526164386	40.796375924050395	40G-AM-1007-02	40G	AM	10072018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	18		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.952526164386 40.7963759240504)
555	555	-73.9685227310735	40.776599466588	15F-AM-1007-02	15F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685227310735 40.776599466588)
858	858	-73.96293834202741	40.7889383725489	29C-AM-1007-02	29C	AM	10072018	2	Adult	Black	Gray	Black+Gray		Above Ground	10		1	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.9629383420274 40.7889383725489)
894	894	-73.96751982309179	40.778631094685004	17F-AM-1007-02	17F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9675198230918 40.778631094685)
1067	1067	-73.9695305996721	40.774538689695895	12F-PM-1007-02	12F	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305996721 40.7745386896959)
1095	1095	-73.9735547926323	40.772342007610796	8D-AM-1007-02	08D	AM	10072018	2	Adult	Gray		Gray+		Above Ground	12		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9735547926323 40.7723420076108)
1168	1168	-73.9779874405715	40.7730765377366	7A-PM-1007-02	07A	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779874405715 40.7730765377366)
1220	1220	-73.97799837948492	40.767545209917294	2D-AM-1007-02	02D	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up tree	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779983794849 40.7675452099173)
1607	1607	-73.9770508584979	40.7710769301257	6C-AM-1007-02	06C	AM	10072018	2	Adult			+		Above Ground	15		0	0	1	0	0	pulling things off branches	0	0	0	0	0	0	0	0		POINT (-73.9770508584979 40.7710769301257)
1698	1698	-73.9631392113757	40.791463563578404	31B-PM-1007-02	31B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #1 and climbing tree w/ #1	0	0	0	0	0	0	0	1		POINT (-73.9631392113757 40.7914635635784)
1804	1804	-73.98077710643099	40.7681635726316	1A-AM-1007-02	01A	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	11		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.980777106431 40.7681635726316)
1887	1887	-73.95861842328891	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black		Black+		Above Ground	15		0	0	1	0	0	jumping	0	0	0	0	0	0	0	0	stared at me	POINT (-73.9586184232889 40.7993153832942)
1899	1899	-73.9764314091366	40.773645805795205	8B-AM-1007-02	08B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9764314091366 40.773645805795205)
1949	1949	-73.9605362268777	40.7939470599346	35C-AM-1007-02	35C	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	13		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9605362268777 40.7939470599346)
1972	1972	-73.9558370309765	40.7921977208472	35G-AM-1007-02	35G	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9558370309765 40.7921977208472)
2037	2037	-73.96833704175509	40.781359835050004	19D-AM-1007-02	19D	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	0	1		0	0	0	0	1	0	0	0	fenced area	POINT (-73.9683370417551 40.78135983505)
2222	2222	-73.9639048209454	40.777737334555795	18I-PM-1007-02	18I	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12		0	0	1	1	1	hanging upside down	0	0	0	0	0	0	1	0		POINT (-73.9639048209454 40.7777373345558)
2356	2356	-73.9611355303487	40.793069353224	34C-AM-1007-02	34C	AM	10072018	2	Adult	Gray		Gray+		Above Ground	40		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611355303487 40.793069353224)
2448	2448	-73.9668230576555	40.78706372333271	25B-PM-1007-02	25B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9668230576555 40.7870637233327)
2791	2791	-73.9593624259363	40.7905522356793	32E-AM-1007-02	32E	AM	10072018	2	Adult	Gray		Gray+		Above Ground	40		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9593624259363 40.7905522356793)
2829	2829	-73.95652309635541	40.798556387711	41C-PM-1007-02	41C	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565230963554 40.798556387711)
2851	2851	-73.955208233231	40.7890574331084	32I-PM-1007-02	32I	PM	10072018	2	Adult			+		Above Ground	30		0	0	1	0	0	different sound - happy,playful chirps	0	0	0	0	1	0	1	0		POINT (-73.955208233231 40.7890574331084)

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