2018_Central_Park_Squirrel_Census_-_Squirrel_Data

39 rows where Date = 10132018, Eating = 0, Hectare Squirrel Number = 1 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: Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, 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
51	51	-73.9801666435401	40.7686905339212	2B-PM-1013-01	02B	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	running (with nut)	0	0	0	0	0	0	0	0		POINT (-73.9801666435401 40.7686905339212)
118	118	-73.9566346046453	40.7973923396512	40D-PM-1013-01	40D	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9566346046453 40.7973923396512)
135	135	-73.9694168118643	40.7728877377977	11G-PM-1013-01	11G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	In the Woods/Brush	0	0	1	0	1		0	0	0	0	0	0	0	1	watching me	POINT (-73.9694168118643 40.7728877377977)
195	195	-73.97377736133109	40.7673662611015	3G-PM-1013-01	03G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9737773613311 40.7673662611015)
197	197	-73.9679336341793	40.7754186579647	14G-PM-1013-01	14G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0	watching	POINT (-73.9679336341793 40.7754186579647)
403	403	-73.9597470659927	40.797321593541604	38A-PM-1013-01	38A	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9597470659927 40.7973215935416)
422	422	-73.9694630409125	40.769737659647	8I-PM-1013-01	08I	PM	10132018	1	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.9694630409125 40.769737659647)
478	478	-73.954482814186	40.7987031768001	42D-PM-1013-01	42D	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Drawing included.	Ground Plane	FALSE		0	0	0	0	1	watching passers-by	0	0	0	0	0	1	1	0		POINT (-73.954482814186 40.7987031768001)
622	622	-73.97548367967059	40.7738879545412	9B-PM-1013-01	09B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	1	0	1	0		POINT (-73.9754836796706 40.7738879545412)
653	653	-73.97034013856842	40.7795238784266	17C-PM-1013-01	17C	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE	then perched on 2-ft high border fencing	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9703401385684 40.7795238784266)
918	918	-73.9681093100008	40.7731753915361	11H-PM-1013-01	11H	PM	10132018	1	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.9681093100008 40.7731753915361)
927	927	-73.9609885686834	40.796110864031895	37A-PM-1013-01	37A	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.96098856868342 40.7961108640319)
965	965	-73.97083010709241	40.7820200927465	19A-PM-1013-01	19A	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	planting acorns	0	0	0	0	0	0	1	0		POINT (-73.9708301070924 40.7820200927465)
1027	1027	-73.9640016324897	40.7921759097124	32A-PM-1013-01	32A	PM	10132018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9640016324897 40.7921759097124)
1180	1180	-73.9639726817977	40.7829083461049	23F-PM-1013-01	23F	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.)	POINT (-73.9639726817977 40.7829083461049)
1189	1189	-73.95776297445391	40.7897460758298	32G-PM-1013-01	32G	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon belly	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	allowed me to approach within 10 ft	POINT (-73.9577629744539 40.789746075829804)
1205	1205	-73.9611118778753	40.7952007875354	36A-PM-1013-01	36A	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	1	0	0		POINT (-73.9611118778753 40.7952007875354)
1211	1211	-73.9549337398033	40.794655273162796	38F-PM-1013-01	38F	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon tail & belly	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9549337398033 40.7946552731628)
1225	1225	-73.95848035139392	40.7933802077327	35D-PM-1013-01	35D	PM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	12		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9584803513939 40.7933802077327)
1264	1264	-73.97853537753821	40.7674923683184	2C-PM-1013-01	02C	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785353775382 40.7674923683184)
1306	1306	-73.9755974646331	40.767343579828896	3F-PM-1013-01	03F	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9755974646331 40.7673435798289)
1343	1343	-73.95636629637029	40.799195210194895	42C-PM-1013-01	42C	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9563662963703 40.7991952101949)
1526	1526	-73.96209645764691	40.791733200173795	32C-PM-1013-01	32C	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9620964576469 40.7917332001738)
1683	1683	-73.9790889008147	40.7676402781925	1C-PM-1013-01	01C	PM	10132018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	1	0	0		POINT (-73.9790889008147 40.7676402781925)
1689	1689	-73.9547031549299	40.797886753932204	41E-PM-1013-01	41E	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9547031549299 40.7978867539322)
1848	1848	-73.96040944813359	40.795145147879296	36B-PM-1013-01	36B	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9604094481336 40.7951451478793)
1865	1865	-73.9558118887106	40.796885713436	39E-PM-1013-01	39E	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9558118887106 40.796885713436005)
1869	1869	-73.9718248273522	40.780199897002895	17A-PM-1013-01	17A	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	crossing path	0	0	0	0	0	0	1	0		POINT (-73.9718248273522 40.78019989700291)
1894	1894	-73.96997808572979	40.7688706046944	6I-PM-1013-01	06I	PM	10132018	1	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9699780857298 40.7688706046944)
1896	1896	-73.973998077367	40.773902913391105	10C-PM-1013-01	10C	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.973998077367 40.7739029133911)
1945	1945	-73.9530257401736	40.795139740737	39G-PM-1013-01	39G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9530257401736 40.79513974073701)
1952	1952	-73.96818104666929	40.7720638449419	10I-PM-1013-01	10I	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9681810466693 40.7720638449419)
2143	2143	-73.9596232170232	40.7959550843229	37B-PM-1013-01	37B	PM	10132018	1	Adult	Gray		Gray+	Sighting was far away	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9596232170232 40.795955084322905)
2278	2278	-73.96453903109901	40.78099163100121	20G-PM-1013-01	20G	PM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.964539031099 40.7809916310012)
2302	2302	-73.9754333866435	40.773239091613796	8C-PM-1013-01	08C	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9754333866435 40.7732390916138)
2378	2378	-73.9747592855901	40.776376287041295	12A-PM-1013-01	12A	PM	10132018	1	Adult	Gray		Gray+	But it was kind of dark?	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9747592855901 40.7763762870413)
2438	2438	-73.969532160039	40.7822616641357	20B-PM-1013-01	20B	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.969532160039 40.7822616641357)
2700	2700	-73.9601988871514	40.7943473161329	35C-PM-1013-01	35C	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	1		1	1	0	1	1	0	1	0		POINT (-73.9601988871514 40.7943473161329)
2997	2997	-73.96197353854829	40.7944667974974	35A-PM-1013-01	35A	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9619735385483 40.7944667974974)

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