2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Date = 10122018, Hectare Squirrel Number = 3 and Shift = "AM"

- 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: Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, 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
698	698	-73.95855376683821	40.7903905787005	32F-AM-1012-03	32F	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0	bringing green leaves to nest	0	0	0	0	0	0	0	0		POINT (-73.9585537668382 40.7903905787005)
820	820	-73.9801902133148	40.769557595068	3A-AM-1012-03	03A	AM	10122018	3	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9801902133148 40.769557595068)
963	963	-73.9621066718851	40.7942427079733	34A-AM-1012-03	34A	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9621066718851 40.7942427079733)
1159	1159	-73.9682129261841	40.77542323581179	14G-AM-1012-03	14G	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9682129261841 40.7754232358118)
1249	1249	-73.9590132705889	40.7952248279764	37C-AM-1012-03	37C	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon flanks	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9590132705889 40.7952248279764)
1327	1327	-73.9689939368647	40.7740824773353	12G-AM-1012-03	12G	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.96899393686472 40.7740824773353)
1516	1516	-73.9625383795297	40.7883862331728	28D-AM-1012-03	28D	AM	10122018	3	Adult	Black		Black+		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9625383795297 40.7883862331728)
2205	2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon		Cinnamon+		Above Ground	8	on turn, see map	1	1	0	1	0		0	0	0	0	1	1	0	0		POINT (-73.9594986107981 40.7840083040604)
2211	2211	-73.9799250782277	40.767610659888895	1B-AM-1012-03	01B	AM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.97992507822771 40.7676106598889)
2480	2480	-73.9546780963388	40.790321652211105	34I-AM-1012-03	34I	AM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	0	nut in mouth	0	0	0	0	0	0	1	0		POINT (-73.9546780963388 40.7903216522111)
2598	2598	-73.976658503418	40.768686845691704	4D-AM-1012-03	04D	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.976658503418 40.7686868456917)
2666	2666	-73.9763593390732	40.771729705854895	7C-AM-1012-03	07C	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	foraging (loving the acorns!)	0	0	0	0	0	0	1	0		POINT (-73.97635933907321 40.7717297058549)

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