2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Climbing = 1, Foraging = 1, Highlight Fur Color = "Cinnamon" and Runs from = 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, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Indifferent

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
97	97	-73.9639744005647	40.782511195076395	22F-AM-1007-01	22F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9639744005647 40.7825111950764)
241	241	-73.97602564775579	40.7703573131398	5D-AM-1020-02	05D	AM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1	small jumps	0	0	0	0	0	0	0	0		POINT (-73.9760256477558 40.7703573131398)
1035	1035	-73.97725699096729	40.7664804797448	1E-AM-1006-02	01E	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9772569909673 40.7664804797448)
1045	1045	-73.9730420696993	40.778615101972605	15B-AM-1014-01	15B	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40		0	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.9730420696993 40.7786151019726)
1163	1163	-73.9677096985223	40.7825358361204	21C-AM-1014-02	21C	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	50		1	1	1	0	1		0	1	0	0	0	0	0	0	looked at us from tree	POINT (-73.9677096985223 40.7825358361204)
1425	1425	-73.95862528758559	40.7852027586217	27I-AM-1007-03	27I	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	had .5 of a tail	Above Ground	20		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9586252875856 40.7852027586217)
1480	1480	-73.96285255338309	40.793844934501706	34A-PM-1013-02	34A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	1	eating upside down on tree trunk	0	0	0	0	0	0	0	0		POINT (-73.9628525533831 40.7938449345017)
1564	1564	-73.9703816112358	40.777384606591895	15D-PM-1017-02	15D	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9703816112358 40.7773846065919)
1609	1609	-73.96390249881229	40.777695306584896	18I-PM-1007-01	18I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25		0	0	1	1	1	hanging upside down	0	0	0	0	0	0	1	0		POINT (-73.9639024988123 40.7776953065849)
1918	1918	-73.9632866142841	40.7890043294436	29C-PM-1006-01	29C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	0	not too shy	POINT (-73.96328661428412 40.78900432944361)
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)
2259	2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.975565603566 40.7738462518304)
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)
2639	2639	-73.9543832609857	40.795355063970106	39F-AM-1014-02	39F	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	rocks	1	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.9543832609857 40.7953550639701)
2700	2700	-73.9601988871514	40.7943473161329	35C-PM-1013-01	35C	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	1		1	1	0	1	1	0	1	0		POINT (-73.9601988871514 40.7943473161329)
2702	2702	-73.9588339897601	40.7848084865431	26I-PM-1010-06	26I	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35	tree	0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9588339897601 40.7848084865431)
2747	2747	-73.971314838366	40.774951285041	12E-AM-1017-03	12E	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.971314838366 40.774951285041)
2833	2833	-73.9552595564798	40.7889533029466	32I-PM-1007-01	32I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	1	chirps	0	0	0	0	1	0	1	0		POINT (-73.9552595564798 40.7889533029466)

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