2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Indifferent = 0, Runs from = 0, Tail flags = 1 and Tail twitches = 0

- 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, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, 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
133	133	-73.9664711607022	40.787896428768	26A-PM-1006-06	26A	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Tree 90th left 90th & 89	0	0	1	0	0		0	0	0	1	0	0	0	0	studying us looking for food	POINT (-73.9664711607022 40.787896428768)
188	188	-73.9570528770427	40.7990973804149	41B-AM-1010-07	41B	AM	10102018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	10		0	0	0	0	0		1	0	0	1	0	1	0	0	mad!	POINT (-73.9570528770427 40.7990973804149)
210	210	-73.97112984911321	40.76769026035429	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	15	in tree by arsenal - climbing	0	0	1	1	0		0	0	0	1	0	0	0	0		POINT (-73.9711298491132 40.7676902603543)
373	373	-73.96721272832829	40.7810666805133	20D-AM-1007-01	20D	AM	10072018	1	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		1	0	1	1	0	a lot of activity	0	0	0	1	0	0	0	0		POINT (-73.9672127283283 40.7810666805133)
416	416	-73.9702788578386	40.7694484997295	7I-PM-1013-05	07I	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Rock	0	0	0	1	0		0	0	0	1	0	0	0	0		POINT (-73.9702788578386 40.7694484997295)
566	566	-73.9708364583591	40.772369158743295	10F-AM-1007-01	10F	AM	10072018	1	Adult	Gray		Gray+		Above Ground	60		0	0	1	0	0		0	0	0	1	0	0	0	0		POINT (-73.9708364583591 40.7723691587433)
1038	1038	-73.9563311167069	40.79509015633371	38E-AM-1010-12	38E	AM	10102018	12	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	running on rocks	0	1	0	0	0		0	0	0	1	0	0	0	0	runs toward something	POINT (-73.9563311167069 40.7950901563337)
1046	1046	-73.9647891228606	40.789853066039	29B-AM-1007-02	29B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	30		1	0	0	0	0		0	0	0	1	0	0	0	0		POINT (-73.9647891228606 40.789853066039)
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Oak tree	0	1	0	0	0	watching me	0	1	0	1	0	0	0	0	observant	POINT (-73.9667474482967 40.7760643720793)
1174	1174	-73.9682067129876	40.7779911208015	16E-PM-1018-05	16E	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	staring	0	0	0	1	0	1	0	0	approaches (very close)	POINT (-73.9682067129876 40.7779911208015)
1201	1201	-73.97828135384209	40.7715730368712	6A-AM-1006-02	06A	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	30	tree	0	1	1	0	0		0	0	0	1	0	0	0	0		POINT (-73.9782813538421 40.7715730368712)
1330	1330	-73.9643032554205	40.7794514526463	19H-AM-1010-02	19H	AM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near base of small tree	1	0	0	1	1		0	0	0	1	0	1	0	0	ran from human with dog	POINT (-73.9643032554205 40.7794514526463)
1415	1415	-73.9678561384348	40.77828773978221	16E-PM-1018-02	16E	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	0	0	gets distance from people but then continues to chase #1	POINT (-73.9678561384348 40.7782877397822)
1636	1636	-73.97014086231209	40.7695511718541	7I-PM-1013-04	07I	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Grass	1	0	0	1	0		0	0	0	1	0	0	0	0		POINT (-73.9701408623121 40.7695511718541)
1944	1944	-73.97432920664129	40.7756090404121	11B-AM-1007-05	11B	AM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0	1	0	0		POINT (-73.9743292066413 40.7756090404121)
1956	1956	-73.98089749771201	40.7690578709841	2A-PM-1019-02	02A	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	0		POINT (-73.980897497712 40.7690578709841)
2044	2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	1	0	0		POINT (-73.9771552326199 40.7706917595308)
2444	2444	-73.966590487009	40.780246905289104	19E-PM-1018-02	19E	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	0	0	0		POINT (-73.96659048700901 40.7802469052891)

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