2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Eating = 1, Hectare Squirrel Number = 1, Indifferent = 1 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

- 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: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, 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
112	112	-73.96517544644391	40.7755181941559	15I-AM-1008-01	15I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7	tree	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9651754464439 40.7755181941559)
488	488	-73.9615751148595	40.795455123814605	36A-AM-1018-01	36A	AM	10182018	1	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9615751148595 40.7954551238146)
498	498	-73.9669432929573	40.779136518298	18F-AM-1014-01	18F	AM	10142018	1	Adult	Gray	White	Gray+White		Above Ground		Low tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9669432929573 40.779136518298)
587	587	-73.9771843912229	40.772366638212496	7B-AM-1008-01	07B	AM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9771843912229 40.77236663821251)
632	632	-73.9767314435027	40.7661199889431	1F-AM-1010-01	01F	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9767314435027 40.7661199889431)
719	719	-73.96268812347421	40.7905208345549	30C-AM-1014-01	30C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9626881234742 40.7905208345549)
736	736	-73.9660110060416	40.780999009859705	20F-AM-1014-01	20F	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9660110060416 40.7809990098597)
804	804	-73.9697196619878	40.7814068507607	19B-AM-1019-01	19B	AM	10192018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Side stripes	Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	1	indifferent then runs from	POINT (-73.9697196619878 40.7814068507607)
860	860	-73.97135191580271	40.7798470142991	17B-AM-1010-01	17B	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9713519158027 40.7798470142991)
911	911	-73.9697277998257	40.7705198722028	8H-AM-1017-01	08H	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9697277998257 40.7705198722028)
942	942	-73.9533923917973	40.796170187476896	40G-AM-1007-01	40G	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25	large tree	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9533923917973 40.7961701874769)
1094	1094	-73.9773898301093	40.770858156205705	5B-AM-1008-01	05B	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1	running across ball field 5,near home plate	0	0	0	0	0	0	1	0		POINT (-73.9773898301093 40.7708581562057)
1169	1169	-73.9570391901515	40.7930697207834	35F-AM-1007-01	35F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9570391901515 40.7930697207834)
1353	1353	-73.9636476467218	40.7775556986702	18I-AM-1017-01	18I	AM	10172018	1	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9636476467218 40.7775556986702)
1380	1380	-73.98069592481521	40.7684820679479	2A-AM-1010-01	02A	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9806959248152 40.7684820679479)
1478	1478	-73.9676370985166	40.7869888639434	25A-AM-1013-01	25A	AM	10132018	1		Gray	White	Gray+White	White Belly	Ground Plane	FALSE		0	0	0	1	0	staring at me	0	0	0	0	0	0	1	0		POINT (-73.96763709851662 40.7869888639434)
1739	1739	-73.96397004344492	40.777500305002796	17I-AM-1014-01	17I	AM	10142018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	Running across fence between statue & swings	1	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9639700434449 40.7775003050028)
1766	1766	-73.972757765574	40.76542855100671	2I-AM-1006-01	02I	AM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.972757765574 40.7654285510067)
2116	2116	-73.9801562527339	40.76872673271129	2B-AM-1010-01	02B	AM	10102018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9801562527339 40.7687267327113)
2163	2163	-73.9643664403785	40.77936707037271	19H-AM-1010-01	19H	AM	10102018	1		Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near base of small tree	1	0	0	1	1		0	0	0	0	0	0	1	0	run from human w/ dog	POINT (-73.9643664403785 40.7793670703727)
2195	2195	-73.955352152771	40.7988549523022	42D-AM-1014-01	42D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		0	0	1	1	0		1	0	0	0	0	0	1	0		POINT (-73.955352152771 40.7988549523022)
2221	2221	-73.9771847728747	40.769597116498105	4C-AM-1006-01	04C	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771847728747 40.7695971164981)
2424	2424	-73.9684752839242	40.776581626151795	15F-AM-1007-01	15F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	1		POINT (-73.9684752839242 40.7765816261518)
2440	2440	-73.96738035086291	40.778524502550795	17F-AM-1007-01	17F	AM	10072018	1	Adult	Gray		Gray+		Above Ground	18		0	0	1	1	0		0	0	0	1	0	0	1	0		POINT (-73.9673803508629 40.7785245025508)
2489	2489	-73.9663168490265	40.7825083721362	21D-AM-1008-01	21D	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	1	0	1	0		POINT (-73.9663168490265 40.7825083721362)
2545	2545	-73.9617594316752	40.7946803725236	35A-AM-1014-01	35A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9617594316752 40.7946803725236)
2706	2706	-73.9745141185576	40.76914797812071	5E-AM-1008-01	05E	AM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on a checker table	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9745141185576 40.7691479781207)
2802	2802	-73.9533101544112	40.7938634280159	38H-AM-1019-01	38H	AM	10192018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9533101544112 40.7938634280159)
2941	2941	-73.96902666603171	40.7853134751509	23A-AM-1018-01	23A	AM	10182018	1	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690266660317 40.7853134751509)
3007	3007	-73.9635140434993	40.7912807969365	31B-AM-1017-01	31B	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9635140434993 40.7912807969365)
3017	3017	-73.9662895079734	40.7843300758044	23C-AM-1019-01	23C	AM	10192018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	7		0	0	1	1	0	eating (on branch)	1	0	0	0	0	0	1	0		POINT (-73.9662895079734 40.7843300758044)

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