2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Date = 10072018, Hectare Squirrel Number = 1 and Indifferent = 1

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, 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
18	18	-73.9532170504865	40.7919669739962	36I-PM-1007-01	36I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9532170504865 40.7919669739962)
38	38	-73.9742073452913	40.7757957380463	12B-AM-1007-01	12B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9742073452913 40.7757957380463)
94	94	-73.9641971813967	40.781353795943495	21G-PM-1007-01	21G	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9641971813967 40.7813537959435)
97	97	-73.9639744005647	40.782511195076395	22F-AM-1007-01	22F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9639744005647 40.7825111950764)
132	132	-73.9696433533986	40.7828208083804	20B-AM-1007-01	20B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	quietly	0	0	0	0	0	0	1	0		POINT (-73.9696433533986 40.7828208083804)
161	161	-73.9649632550828	40.7809187761995	20F-PM-1007-01	20F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	cinnamon tail	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9649632550828 40.7809187761995)
215	215	-73.9519639918804	40.79499117023921	39H-AM-1007-01	39H	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9519639918804 40.7949911702392)
269	269	-73.9591400366159	40.7891708599318	31F-PM-1007-01	31F	PM	10072018	1	Adult	Gray	White	Gray+White	white neck and belly	Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9591400366159 40.7891708599318)
610	610	-73.96715495660659	40.7751342870705	14H-AM-1007-01	14H	AM	10072018	1	Adult	Gray		Gray+		Above Ground	180	top of tree	1	0	0	0	0	jumping between branches	0	0	0	0	0	0	1	0		POINT (-73.9671549566066 40.7751342870705)
685	685	-73.9658181813014	40.7798160637561	19F-AM-1007-01	19F	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	bit scared	POINT (-73.9658181813014 40.7798160637561)
733	733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
781	781	-73.955516031113	40.7923188156277	35G-AM-1007-01	35G	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.955516031113 40.7923188156277)
817	817	-73.9540022445432	40.7979409854977	41E-AM-1007-01	41E	AM	10072018	1	Adult	Gray	White	Gray+White	white haunches	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9540022445432 40.7979409854977)
912	912	-73.958024711869	40.7938724278575	36D-PM-1007-01	36D	PM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.958024711869 40.7938724278575)
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)
976	976	-73.9740381194088	40.7675912588173	4G-PM-1007-01	04G	PM	10072018	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.9740381194088 40.7675912588173)
1010	1010	-73.9689723590015	40.7756860990338	13F-AM-1007-01	13F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689723590015 40.7756860990338)
1044	1044	-73.9693254080548	40.77616003271179	14F-AM-1007-01	14F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9693254080548 40.7761600327118)
1063	1063	-73.97503467782809	40.766540440482395	2G-PM-1007-01	02G	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9750346778281 40.7665404404824)
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)
1190	1190	-73.9728069355821	40.779445813174796	15A-AM-1007-01	15A	AM	10072018	1	Adult	Gray		Gray+	tbd	Ground Plane	FALSE		0	0	0	0	1	hopping	0	0	0	0	0	0	1	0	in fenced in lawn (chill)	POINT (-73.9728069355821 40.7794458131748)
1208	1208	-73.96628049257741	40.7890284642399	28A-PM-1007-01	28A	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9662804925774 40.7890284642399)
1413	1413	-73.98100322064279	40.768162563497896	1A-AM-1007-01	01A	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	7		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9810032206428 40.7681625634979)
1590	1590	-73.9610388059192	40.793952935840004	34B-PM-1007-01	34B	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9610388059192 40.79395293584)
1609	1609	-73.96390249881229	40.777695306584896	18I-PM-1007-01	18I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25		0	0	1	1	1	hanging upside down	0	0	0	0	0	0	1	0		POINT (-73.9639024988123 40.7776953065849)
1612	1612	-73.97460490884751	40.772877688739705	8C-AM-1007-01	08C	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE	behind fence, safe	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9746049088475 40.7728776887397)
1671	1671	-73.9611399573659	40.781130706026	22I-AM-1007-01	22I	AM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9611399573659 40.781130706026005)
1713	1713	-73.97977158132	40.7706273151066	4A-AM-1007-01	04A	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.97977158132 40.7706273151066)
1727	1727	-73.96924722995651	40.7722592187215	10H-PM-1007-01	10H	PM	10072018	1	Adult	Gray	White	Gray+White	dark gray	Above Ground	15	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9692472299565 40.7722592187215)
2111	2111	-73.968446056806	40.785824818871	24A-PM-1007-01	24A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96844605680602 40.785824818871)
2220	2220	-73.963716747038	40.7892160137944	29C-AM-1007-01	29C	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.96371674703802 40.7892160137944)
2359	2359	-73.97007853145371	40.777714111862004	15D-AM-1007-01	15D	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9700785314537 40.777714111862)
2360	2360	-73.95733250010409	40.7874662104558	30H-AM-1007-01	30H	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9573325001041 40.7874662104558)
2382	2382	-73.97439704555329	40.7687880243986	5F-PM-1007-01	05F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9743970455533 40.7687880243986)
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)
2436	2436	-73.95827701417	40.785661023889105	28I-PM-1007-01	28I	PM	10072018	1	Adult	Gray		Gray+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.95827701417 40.7856610238891)
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)
2508	2508	-73.97938145045201	40.770903369788705	4A-PM-1007-01	04A	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1	1		0	0	0	0	1	0	1	0		POINT (-73.979381450452 40.770903369788705)
2771	2771	-73.9735383602914	40.77231247039371	8D-AM-1007-01	08D	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	acknowledged me though	POINT (-73.9735383602914 40.7723124703937)
2833	2833	-73.9552595564798	40.7889533029466	32I-PM-1007-01	32I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	1	chirps	0	0	0	0	1	0	1	0		POINT (-73.9552595564798 40.7889533029466)
2905	2905	-73.9784872728213	40.768812260393204	3C-AM-1007-01	03C	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9784872728213 40.7688122603932)
2943	2943	-73.962534856258	40.7812134517411	22H-PM-1007-01	22H	PM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.962534856258 40.7812134517411)
2995	2995	-73.9668442742942	40.7870781042595	25B-PM-1007-01	25B	PM	10072018	1		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9668442742942 40.7870781042595)
3001	3001	-73.97755922284159	40.7668485329273	1D-PM-1007-01	01D	PM	10072018	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.9775592228416 40.7668485329273)

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