2018_Central_Park_Squirrel_Census_-_Squirrel_Data

35 rows where Eating = 1, Indifferent = 0, Location = "Above Ground" and Shift = "PM"

- 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Running, 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
210	210	-73.97112984911321	40.76769026035429	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	15	in tree by arsenal - climbing	0	0	1	1	0		0	0	0	1	0	0	0	0		POINT (-73.9711298491132 40.7676902603543)
220	220	-73.96718161220299	40.7787752287055	17F-PM-1020-03	17F	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35		0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.967181612203 40.7787752287055)
317	317	-73.9545799024508	40.7908084039886	34I-PM-1010-01	34I	PM	10102018	1	Adult	Gray		Gray+		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545799024508 40.7908084039886)
331	331	-73.95448101115	40.7954469678857	39F-PM-1006-03	39F	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15	lower branch of tree	0	0	0	1	0		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.95448101115 40.7954469678857)
381	381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black		Black+		Above Ground	15		1	0	0	1	0		0	0	0	0	1	0	0	1	ran up tree	POINT (-73.959709414696 40.7919745085986)
591	591	-73.95433237868879	40.7943086530436	37G-PM-1007-03	37G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	0	1	0	lying on belly on branch,eating big nut	0	0	0	0	0	0	0	0		POINT (-73.9543323786888 40.7943086530436)
635	635	-73.96732355553209	40.7786749596774	17F-PM-1020-04	17F	PM	10202018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground			0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9673235555321 40.7786749596774)
646	646	-73.954092292214	40.7979800395433	41E-PM-1013-05	41E	PM	10132018	5	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.954092292214 40.7979800395433)
780	780	-73.9675472064204	40.7835947167436	22C-PM-1006-06	22C	PM	10062018	6	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	on tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9675472064204 40.7835947167436)
1060	1060	-73.97288710611909	40.771298365894395	8F-PM-1012-08	08F	PM	10122018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9728871061191 40.7712983658944)
1109	1109	-73.96781540330991	40.774278348448604	12H-PM-1007-01	12H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9678154033099 40.7742783484486)
1165	1165	-73.9689504114652	40.77667701537639	14F-PM-1012-05	14F	PM	10122018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	2	on a fallen branch	1	0	0	1	0	sitting	0	0	0	0	0	0	0	0	looking at me	POINT (-73.9689504114652 40.7766770153764)
1240	1240	-73.96961191797891	40.780292611186496	18C-PM-1018-09	18C	PM	10182018	9	Juvenile	Gray		Gray+		Above Ground	5		0	0	1	1	1		0	0	0	0	0	0	0	0		POINT (-73.9696119179789 40.7802926111865)
1388	1388	-73.9685709455958	40.774487702650596	12G-PM-1007-07	12G	PM	10072018	7	Juvenile			+		Above Ground	45		0	0	0	1	0	acorns	0	0	0	0	0	0	0	0		POINT (-73.9685709455958 40.7744877026506)
1434	1434	-73.9760749752948	40.7703284894392	5D-PM-1018-02	05D	PM	10182018	2	Adult	Gray		Gray+		Above Ground	2	On low fence	0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9760749752948 40.7703284894392)
1776	1776	-73.9562350820255	40.7913464147989	34G-PM-1006-02	34G	PM	10062018	2	Adult	Gray		Gray+		Above Ground	6		0	0	1	1	1	eating bread it found on ground	0	0	0	0	0	0	0	1		POINT (-73.9562350820255 40.7913464147989)
2010	2010	-73.9673821557469	40.7786375267659	17F-PM-1020-06	17F	PM	10202018	6	Adult	Gray		Gray+		Above Ground	20		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.96738215574692 40.7786375267659)
2090	2090	-73.9569759970802	40.7931497452294	35F-PM-1012-03	35F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9569759970802 40.79314974522941)
2154	2154	-73.976716425804	40.7736889979965	8A-PM-1014-03	08A	PM	10142018	3	Juvenile	Gray		Gray+		Above Ground	23		0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.976716425804 40.7736889979965)
2175	2175	-73.9657487923637	40.7786823090663	18G-PM-1013-04	18G	PM	10132018	4	Adult	Gray		Gray+		Above Ground	3		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9657487923637 40.7786823090663)
2215	2215	-73.96749788267509	40.776288410765	15G-PM-1019-10	15G	PM	10192018	10	Adult	Gray		Gray+		Above Ground	1	on a log	0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9674978826751 40.776288410765)
2231	2231	-73.95454276114769	40.793035381744104	36G-PM-1012-02	36G	PM	10122018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545427611477 40.7930353817441)
2288	2288	-73.9577009571427	40.796126044520996	38C-PM-1014-10	38C	PM	10142018	10	Juvenile	Gray	White	Gray+White		Above Ground	10		0	0	1	1	1	climbing (down from ~10')	0	0	0	0	0	0	0	1		POINT (-73.9577009571427 40.796126044521)
2337	2337	-73.9673490137465	40.778272813040104	17F-PM-1020-02	17F	PM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9673490137465 40.7782728130401)
2366	2366	-73.96761918469849	40.777641740816996	16F-PM-1013-04	16F	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9676191846985 40.777641740817)
2380	2380	-73.97613757295049	40.766223189212496	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	1	0		0	0	0	0	0	1	0	0		POINT (-73.9761375729505 40.7662231892125)
2463	2463	-73.9653343572865	40.77752869246171	17H-PM-1007-01	17H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9653343572865 40.7775286924617)
2515	2515	-73.9693338657183	40.775705588453796	13F-PM-1008-05	13F	PM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	tree trunk	1	0	0	1	1		1	0	0	0	1	0	0	0		POINT (-73.9693338657183 40.77570558845381)
2595	2595	-73.9692676659807	40.7700678919108	8I-PM-1013-08	08I	PM	10132018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	1		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.96926766598071 40.7700678919108)
2659	2659	-73.95536034380208	40.7985282963244	41D-PM-1014-05	41D	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9553603438021 40.7985282963244)
2707	2707	-73.97431653210991	40.775467467857396	11B-PM-1014-07	11B	PM	10142018	7		Gray		Gray+		Above Ground	10		1	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9743165321099 40.7754674678574)
2730	2730	-73.96535757586871	40.78053399533721	20F-PM-1007-12	20F	PM	10072018	12	Adult	Gray	White	Gray+White		Above Ground	20	in tree	0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.9653575758687 40.7805339953372)
2862	2862	-73.967466716152	40.782434654827796	21D-PM-1008-04	21D	PM	10082018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1	i scared it	POINT (-73.967466716152 40.7824346548278)
2912	2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9632164738341 40.7921270121312)
2950	2950	-73.9790980124501	40.7685934093915	2B-PM-1013-08	02B	PM	10132018	8	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9790980124501 40.7685934093915)

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