2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Hectare Squirrel Number = 1, Location = "Above Ground", Runs from = 0 and Tail twitches = 1

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, 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
137	137	-73.97824171151392	40.77246650364471	7A-AM-1006-01	07A	AM	10062018	1	Adult	Gray	White	Gray+White		Above Ground	10	in tree	0	0	0	0	1		0	1	0	0	1	0	0	0	looked at us	POINT (-73.9782417115139 40.7724665036447)
326	326	-73.9699843570636	40.7729480440312	10G-AM-1006-01	10G	AM	10062018	1	Adult	Gray		Gray+		Above Ground	80		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.96998435706361 40.7729480440312)
380	380	-73.9649590119935	40.782210792076896	21F-AM-1018-01	21F	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9649590119935 40.7822107920769)
387	387	-73.9578316525492	40.789010295962896	31G-PM-1007-01	31G	PM	10072018	1	Adult	Gray		Gray+		Above Ground	15		0	0	0	0	0	hiding	0	0	0	0	1	0	0	0	froze,sight of dogs	POINT (-73.9578316525492 40.7890102959629)
733	733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	0	0	0	1	0		0	0	0	1	1	1	0	0		POINT (-73.9594357049738 40.7840678890949)
1164	1164	-73.97902264006291	40.76989976537921	4B-AM-1010-01	04B	AM	10102018	1	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Above Ground	2		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9790226400629 40.7698997653792)
1235	1235	-73.9679686793869	40.7825993867876	21C-AM-1014-01	21C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		1	0	0	0	0	jumping back & forth on tree	0	0	0	1	1	0	1	0		POINT (-73.9679686793869 40.7825993867876)
1241	1241	-73.9651817987035	40.781908283833396	21E-AM-1017-01	21E	AM	10172018	1	Adult	Gray	White	Gray+White		Above Ground	3	Climbs small tree	0	0	0	1	1		0	0	0	0	1	0	0	0	walks from	POINT (-73.9651817987035 40.7819082838334)
1413	1413	-73.98100322064279	40.768162563497896	1A-AM-1007-01	01A	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	7		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9810032206428 40.7681625634979)
1500	1500	-73.9769969548024	40.7710711265211	6C-AM-1007-01	06C	AM	10072018	1	Adult	Gray	White	Gray+White	vid!	Above Ground	15		0	0	1	0	0		0	0	0	0	1	0	0	0	curious,but wary	POINT (-73.97699695480242 40.7710711265211)
1867	1867	-73.9745204169071	40.7736282868469	9C-AM-1006-01	09C	AM	10062018	1	Adult	Gray		Gray+		Above Ground	40	Tree	1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9745204169071 40.7736282868469)
2009	2009	-73.9639505810228	40.789573183584	29B-PM-1010-01	29B	PM	10102018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	4	climbing trees	0	0	1	1	1	scratching self	0	0	0	0	1	0	1	0		POINT (-73.9639505810228 40.789573183584)
2016	2016	-73.9589492240754	40.798901118974	40A-PM-1014-01	40A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0		0	0	0	0	1	0	1	0	stared & then went back up tree—then ran to different tree	POINT (-73.9589492240754 40.798901118974)
2387	2387	-73.98085173247209	40.7683154647217	1A-PM-1014-01	01A	PM	10142018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9808517324721 40.7683154647217)
2559	2559	-73.95723834787741	40.787685738072206	30H-PM-1006-01	30H	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9572383478774 40.7876857380722)
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)
2896	2896	-73.970595860252	40.7832060751268	20A-AM-1010-01	20A	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.970595860252 40.7832060751268)

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