2018_Central_Park_Squirrel_Census_-_Squirrel_Data

34 rows where Date = 10082018, Eating = 1, Foraging = 1 and Tail twitches = 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: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Other Activities, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

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
54	54	-73.97602982411779	40.7681954366911	3E-PM-1008-07	03E	PM	10082018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9760298241178 40.7681954366911)
129	129	-73.9705092958892	40.7761092972965	13E-PM-1008-07	13E	PM	10082018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9705092958892 40.7761092972965)
303	303	-73.9762348224648	40.7694522315322	4D-PM-1008-08	04D	PM	10082018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1	1	1	climbed fence staring at me - went up tree	0	0	0	0	0	0	0	1		POINT (-73.97623482246482 40.7694522315322)
436	436	-73.9734695768004	40.7716297491384	8E-PM-1008-05	08E	PM	10082018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	5, 6, 7 all at same tree trunk base	0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9734695768004 40.7716297491384)
718	718	-73.9661694463488	40.7757530583569	15H-PM-1008-07	15H	PM	10082018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	along bottom of rock outcropping	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9661694463488 40.7757530583569)
749	749	-73.96863045815259	40.7773631337117	15E-PM-1008-01	15E	PM	10082018	1	Adult	Gray		Gray+		Above Ground	4	on fallen tree	1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9686304581526 40.7773631337117)
759	759	-73.969951118124	40.7762756593015	14E-AM-1008-17	14E	AM	10082018	17	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96995111812402 40.7762756593015)
952	952	-73.9699763667769	40.775706073102604	13E-PM-1008-11	13E	PM	10082018	11	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9699763667769 40.775706073102604)
1018	1018	-73.96953055553921	40.7757541971012	13F-PM-1008-03	13F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	15	tree	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305555392 40.7757541971012)
1093	1093	-73.9584106786233	40.7902777556926	32F-PM-1008-02	32F	PM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584106786233 40.7902777556926)
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)
1399	1399	-73.970442878377	40.7763755560359	14E-AM-1008-22	14E	AM	10082018	22	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1	burying	0	0	0	0	0	0	1	0		POINT (-73.970442878377 40.7763755560359)
1419	1419	-73.9756017589251	40.7680335996527	3E-PM-1008-06	03E	PM	10082018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9756017589251 40.7680335996527)
1472	1472	-73.9698611971209	40.7753915552001	13F-PM-1008-02	13F	PM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9698611971209 40.7753915552001)
1566	1566	-73.9695133370801	40.776500979685295	14E-AM-1008-16	14E	AM	10082018	16	Adult	Gray		Gray+		Above Ground	6		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695133370801 40.7765009796853)
1696	1696	-73.96945916677049	40.776651822199796	14E-AM-1008-12	14E	AM	10082018	12	Adult	Gray		Gray+		Above Ground	2		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9694591667705 40.7766518221998)
1802	1802	-73.9736418085696	40.7716931127716	8E-PM-1008-04	08E	PM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass by a grove of tall maples	0	0	0	1	1		0	0	0	0	0	0	1	0	there's a family playing soccer	POINT (-73.9736418085696 40.7716931127716)
1878	1878	-73.9761223919286	40.7685998275864	4E-PM-1008-06	04E	PM	10082018	6	Adult	Gray	Cinnamon	Gray+Cinnamon					0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9761223919286 40.7685998275864)
1946	1946	-73.9692925815903	40.7774506065008	15E-PM-1008-11	15E	PM	10082018	11	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9692925815903 40.7774506065008)
1981	1981	-73.972154069981	40.769012800972206	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	grass	0	0	0	1	1		0	0	0	1	0	0	1	0		POINT (-73.972154069981 40.7690128009722)
2118	2118	-73.958369699409	40.79024566683321	32F-PM-1008-01	32F	PM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.958369699409 40.7902456668332)
2122	2122	-73.9692946938852	40.7767389791452	14E-AM-1008-13	14E	AM	10082018	13	Adult	Gray		Gray+		Above Ground	1		0	0	1	1	1		0	0	0	0	0	0	1	0	curious	POINT (-73.9692946938852 40.7767389791452)
2139	2139	-73.9697471123497	40.777316338832705	15E-PM-1008-10	15E	PM	10082018	10	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9697471123497 40.777316338832705)
2253	2253	-73.973394428186	40.7722933513053	8E-PM-1008-03	08E	PM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in between 2 trees	0	0	0	1	1		0	0	0	0	0	1	0	0	also being lured by mom & baby w/ food	POINT (-73.973394428186 40.7722933513053)
2269	2269	-73.9695518341907	40.776214599393704	14E-AM-1008-15	14E	AM	10082018	15	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1	walking	0	0	0	0	0	0	1	0		POINT (-73.9695518341907 40.7762145993937)
2431	2431	-73.9630054996358	40.790522514702204	30C-PM-1008-01	30C	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9630054996358 40.7905225147022)
2485	2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584950620879 40.7902770710643)
2625	2625	-73.96991885444591	40.7772180370053	15E-PM-1008-09	15E	PM	10082018	9	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9699188544459 40.7772180370053)
2648	2648	-73.97294104880208	40.770948496457706	7F-AM-1008-13	07F	AM	10082018	13	Adult	Gray		Gray+		Above Ground	4	to tree	1	0	0	1	1	ran up tree 4 feet and ate leaves	0	0	0	0	0	0	1	0		POINT (-73.9729410488021 40.7709484964577)
2665	2665	-73.969784066769	40.77669404054029	14E-AM-1008-11	14E	AM	10082018	11	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1	burying	0	0	0	0	0	0	1	0	curious	POINT (-73.969784066769 40.7766940405403)
2775	2775	-73.96971093983021	40.7776218260789	15E-PM-1008-06	15E	PM	10082018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9697109398302 40.7776218260789)
2871	2871	-73.9777124331985	40.7704051056666	5B-AM-1008-03	05B	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9777124331985 40.7704051056666)
2921	2921	-73.9699573485164	40.7765857838015	14E-AM-1008-10	14E	AM	10082018	10	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9699573485164 40.7765857838015)
2984	2984	-73.9700158929437	40.7762359066591	14E-AM-1008-18	14E	AM	10082018	18	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9700158929437 40.7762359066591)

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