2018_Central_Park_Squirrel_Census_-_Squirrel_Data

15 rows where Date = 10082018, Foraging = 0, Hectare Squirrel Number = 1 and Indifferent = 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: Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Approaches, 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
144	144	-73.9730750601212	40.7701304211944	6F-PM-1008-01	06F	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9730750601212 40.7701304211944)
151	151	-73.9714789136757	40.7694886645194	6H-AM-1008-01	06H	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9714789136757 40.7694886645194)
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)
265	265	-73.9691094942294	40.776760392858	14E-AM-1008-01	14E	AM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0	walking	0	0	0	0	0	0	0	1		POINT (-73.9691094942294 40.776760392858)
382	382	-73.9735946835545	40.7724155751282	8E-PM-1008-01	08E	PM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by tree trunk base	0	0	0	1	0		0	0	0	0	0	1	0	0	eating food being thrown at it by a mom & baby	POINT (-73.9735946835545 40.7724155751282)
813	813	-73.9758959798289	40.7694125671679	4D-PM-1008-01	04D	PM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9758959798289 40.7694125671679)
906	906	-73.9664120826015	40.7888022709721	27A-AM-1008-01	27A	AM	10082018	1	Adult	Gray		Gray+		Above Ground	3		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.96641208260151 40.7888022709721)
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)
1144	1144	-73.9743184653765	40.7667932997	3G-AM-1008-01	03G	AM	10082018	1	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.9743184653765 40.7667932997)
1534	1534	-73.9695226023739	40.7797527775804	17D-AM-1008-01	17D	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695226023739 40.7797527775804)
1835	1835	-73.9562068537632	40.796733285323796	39D-AM-1008-01	39D	AM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562068537632 40.7967332853238)
2005	2005	-73.9755259087781	40.770725612418104	6D-AM-1008-01	06D	AM	10082018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		0	0	1	1	0		1	0	0	0	0	1	0	0		POINT (-73.9755259087781 40.7707256124181)
2456	2456	-73.9698446365683	40.784260716857794	22A-AM-1008-01	22A	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4	on fence	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9698446365683 40.7842607168578)
2724	2724	-73.96114340826671	40.7893671772846	30E-PM-1008-01	30E	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40		0	0	1	0	0		0	1	0	0	0	0	0	0		POINT (-73.9611434082667 40.7893671772846)
2942	2942	-73.9672063784809	40.7826070395665	21D-PM-1008-01	21D	PM	10082018	1		Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.9672063784809 40.7826070395665)

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