2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Date = 10132018, Hectare Squirrel Number = 2 and Primary Fur Color = "Cinnamon"

- 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, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, 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
384	384	-73.968045072743	40.783662671722496	22C-AM-1013-02	22C	AM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		0	0	1	0	1		1	0	0	1	0	0	0	1		POINT (-73.968045072743 40.7836626717225)
423	423	-73.97567542977471	40.7738518843446	9B-PM-1013-02	09B	PM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9756754297747 40.7738518843446)
1103	1103	-73.9541500874008	40.7920329989756	35H-AM-1013-02	35H	AM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Sitting on tree limb	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0	watching me from tree,but calm	POINT (-73.9541500874008 40.7920329989756)
1187	1187	-73.97933344163779	40.7674142089209	1C-PM-1013-02	01C	PM	10132018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	0	0		POINT (-73.9793334416378 40.7674142089209)
1437	1437	-73.97212798086831	40.7661158663901	3I-PM-1013-02	03I	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9721279808683 40.7661158663901)
1558	1558	-73.968200390984	40.783709576948205	22B-AM-1013-02	22B	AM	10132018	2	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1	climbed tree	0	0	0	0	0	0	1	0		POINT (-73.968200390984 40.7837095769482)
1601	1601	-73.9544278270221	40.7987827316512	42D-PM-1013-02	42D	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Gray tail, Cinnamon feet	Ground Plane	FALSE		0	1	0	0	1	chasing (chased by #1),found a nut,buried it	0	0	0	0	0	0	1	0		POINT (-73.9544278270221 40.7987827316512)
1749	1749	-73.97568253382991	40.7755542506699	11A-PM-1013-02	11A	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9756825338299 40.7755542506699)
2194	2194	-73.960898739757	40.7961393097144	37A-PM-1013-02	37A	PM	10132018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.960898739757 40.7961393097144)
2504	2504	-73.9550131837533	40.7958617258176	39E-PM-1013-02	39E	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Gray tail & butt	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	1	0		POINT (-73.9550131837533 40.7958617258176)
2727	2727	-73.974596903918	40.7765498215674	12A-PM-1013-02	12A	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.974596903918 40.7765498215674)
2915	2915	-73.9734630412566	40.7653097139415	1H-PM-1013-02	01H	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9734630412566 40.7653097139415)

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