2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Date = 10072018, Eating = 0, Highlight Fur Color = "Cinnamon" and Runs from = 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, Hectare Squirrel Number, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, 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
41	41	-73.96391592984459	40.789177463798794	29C-AM-1007-06	29C	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9639159298446 40.7891774637988)
284	284	-73.9547336666137	40.7938937756332	37G-PM-1007-07	37G	PM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9547336666137 40.7938937756332)
302	302	-73.9695176417703	40.7741725190048	12G-PM-1007-04	12G	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9695176417703 40.7741725190048)
555	555	-73.9685227310735	40.776599466588	15F-AM-1007-02	15F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685227310735 40.776599466588)
612	612	-73.9629420113622	40.789133072717	29C-AM-1007-03	29C	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9629420113622 40.789133072717)
1055	1055	-73.9632337134707	40.791468237073396	31B-PM-1007-01	31B	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #2 and climbing tree w/ #2	0	0	0	0	0	0	0	1		POINT (-73.9632337134707 40.7914682370734)
1698	1698	-73.9631392113757	40.791463563578404	31B-PM-1007-02	31B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #1 and climbing tree w/ #1	0	0	0	0	0	0	0	1		POINT (-73.9631392113757 40.7914635635784)
1738	1738	-73.967975586222	40.77356830443129	12H-PM-1007-07	12H	PM	10072018	7		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	grass field	0	0	0	0	1		0	0	0	0	0	0	0	1	humans	POINT (-73.967975586222 40.7735683044313)
1862	1862	-73.97648512317541	40.771573686286104	6C-AM-1007-07	06C	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0	ambling	0	0	0	0	0	1	0	1	trucks	POINT (-73.9764851231754 40.7715736862861)
1949	1949	-73.9605362268777	40.7939470599346	35C-AM-1007-02	35C	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	13		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9605362268777 40.7939470599346)
1968	1968	-73.9699088881236	40.775277835162605	13F-AM-1007-03	13F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699088881236 40.7752778351626)
2158	2158	-73.9597593485091	40.7937528403249	35C-AM-1007-04	35C	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9597593485091 40.7937528403249)
2217	2217	-73.9652746477521	40.7809326848536	20F-PM-1007-07	20F	PM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	cinnamon tail	Ground Plane	FALSE		1	0	0	0	0	watching	0	0	0	1	0	0	0	1		POINT (-73.96527464775211 40.7809326848536)
2350	2350	-73.9564777440695	40.7993068355401	42C-AM-1007-01	42C	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	nut in mouth	0	0	0	0	0	0	0	1		POINT (-73.9564777440695 40.7993068355401)
2365	2365	-73.96887733063241	40.7766669852358	15F-AM-1007-05	15F	AM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9688773306324 40.7766669852358)
2596	2596	-73.9729786570879	40.7778238570396	14B-AM-1007-01	14B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	tail straight	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.97297865708792 40.7778238570396)
2637	2637	-73.968891673893	40.776700147172896	15F-AM-1007-06	15F	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	pair with #5	0	0	0	0	0	0	0	1		POINT (-73.968891673893 40.7767001471729)
2828	2828	-73.9587439756541	40.7849006107353	27I-AM-1007-04	27I	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9587439756541 40.7849006107353)

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