2018_Central_Park_Squirrel_Census_-_Squirrel_Data

34 rows where Eating = 0, Hectare Squirrel Number = 4, Highlight Fur Color = "Cinnamon" 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, Date, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, 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
145	145	-73.971970670614	40.7720868124544	9F-AM-1013-04	09F	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.971970670614 40.7720868124544)
180	180	-73.96908283251791	40.781803817227505	19C-PM-1018-04	19C	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9690828325179 40.7818038172275)
240	240	-73.9767080512177	40.7717708794221	6B-PM-1017-04	06B	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9767080512177 40.7717708794221)
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)
338	338	-73.9765595553183	40.7748455340432	10A-PM-1014-04	10A	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765595553183 40.7748455340432)
364	364	-73.9623696148045	40.792184861375	32B-AM-1017-04	32B	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	13		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623696148045 40.792184861375)
533	533	-73.9652584749758	40.7803011124382	19F-PM-1017-04	19F	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9652584749758 40.7803011124382)
631	631	-73.95488778301359	40.795015748910295	38F-AM-1018-04	38F	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.95488778301362 40.7950157489103)
916	916	-73.95618876244708	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	0	0	1	me	POINT (-73.95618876244711 40.7958187455815)
920	920	-73.9571233640232	40.7992458980266	41B-PM-1014-04	41B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40		0	0	1	0	0		0	0	0	0	0	0	0	0	climbing	POINT (-73.9571233640232 40.7992458980266)
1008	1008	-73.9553038162633	40.7909367783223	34H-PM-1006-04	34H	PM	10062018	4		Gray	Cinnamon	Gray+Cinnamon		Above Ground		Elm tree	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9553038162633 40.790936778322305)
1022	1022	-73.95488534927121	40.7984783584388	41D-PM-1014-04	41D	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0	jumping tree to tree	0	0	0	0	0	0	0	0		POINT (-73.9548853492712 40.7984783584388)
1076	1076	-73.96279043284021	40.7939375305761	34A-PM-1013-04	34A	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	digging & burying	0	0	0	0	0	0	0	0		POINT (-73.9627904328402 40.7939375305761)
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9722737593623 40.768963018754)
1176	1176	-73.9553263156025	40.79755920605721	40D-PM-1013-04	40D	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9553263156025 40.7975592060572)
1237	1237	-73.9705370795538	40.7761725434851	13E-PM-1008-04	13E	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0	he took 2 steps then turned and stared at me	POINT (-73.9705370795538 40.7761725434851)
1474	1474	-73.9801971465604	40.7697081749827	3A-PM-1017-04	03A	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9801971465604 40.7697081749827)
1506	1506	-73.9728339757306	40.7782891207966	14B-PM-1014-04	14B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	running up and down	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9728339757306 40.7782891207966)
1508	1508	-73.96938943057859	40.775690674802604	13F-PM-1008-04	13F	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9693894305786 40.7756906748026)
1518	1518	-73.9632265832593	40.7816914475461	22G-AM-1018-04	22G	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9632265832593 40.78169144754611)
1608	1608	-73.9545425520879	40.7956853415959	39F-PM-1006-04	39F	PM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35	in tree	0	0	1	0	0	climbing down	0	0	0	0	0	0	0	1	ran when saw me	POINT (-73.9545425520879 40.7956853415959)
1704	1704	-73.9624052832372	40.7809656348254	21H-PM-1018-04	21H	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9624052832372 40.7809656348254)
1809	1809	-73.96901686738441	40.777761204391396	15E-AM-1013-04	15E	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9690168673844 40.7777612043914)
1919	1919	-73.9637440847107	40.789142741937205	29C-AM-1007-04	29C	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9637440847107 40.7891427419372)
2011	2011	-73.9603245806655	40.79427124776971	35C-PM-1013-04	35C	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9603245806655 40.7942712477697)
2133	2133	-73.9736164871197	40.7725695048569	8D-PM-1007-04	08D	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9736164871197 40.7725695048569)
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)
2271	2271	-73.96739494580959	40.7826218539496	21D-AM-1008-04	21D	AM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9673949458096 40.78262185394961)
2315	2315	-73.9767849679735	40.768566516928	3D-PM-1010-04	03D	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9767849679735 40.768566516928)
2520	2520	-73.95482071063391	40.7946991812402	38F-PM-1013-04	38F	PM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9548207106339 40.7946991812402)
2738	2738	-73.9691801791373	40.770927235357206	9I-AM-1014-04	09I	AM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9691801791373 40.7709272353572)
2809	2809	-73.9686756254868	40.777745910265104	16E-AM-1014-04	16E	AM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9686756254868 40.7777459102651)
2847	2847	-73.9568378330302	40.788031780276604	30I-PM-1006-04	30I	PM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9568378330302 40.7880317802766)
3008	3008	-73.9503533343658	40.7976543603953	42H-PM-1014-04	42H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		1	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9503533343658 40.7976543603953)

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