2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Date = 10072018, Hectare Squirrel Number = 3 and Shift = "AM"

- 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, Eating, Foraging, Quaas, Tail flags, Tail twitches, 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
226	226	-73.97756817314591	40.7676421190309	2D-AM-1007-03	02D	AM	10072018	3	Adult	Gray		Gray+		Above Ground	100		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9775681731459 40.7676421190309)
347	347	-73.96116961447841	40.7816692895155	22I-AM-1007-03	22I	AM	10072018	3	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611696144784 40.7816692895155)
480	480	-73.9641293283734	40.7907654006019	30B-AM-1007-03	30B	AM	10072018	3	Adult	Gray		Gray+		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9641293283734 40.7907654006019)
612	612	-73.9629420113622	40.789133072717	29C-AM-1007-03	29C	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9629420113622 40.789133072717)
660	660	-73.9638298997554	40.78259663323671	22F-AM-1007-03	22F	AM	10072018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	large white highlight	Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9638298997554 40.7825966332367)
714	714	-73.96915857561909	40.776340465695	14F-AM-1007-03	14F	AM	10072018	3	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.9691585756191 40.776340465695)
954	954	-73.96584435488221	40.7796704898979	19F-AM-1007-03	19F	AM	10072018	3	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	scared	POINT (-73.9658443548822 40.7796704898979)
1068	1068	-73.96660639702	40.7756655031741	14H-AM-1007-03	14H	AM	10072018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96660639702002 40.7756655031741)
1126	1126	-73.97001860010491	40.7826052184658	20B-AM-1007-03	20B	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground			0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9700186001049 40.7826052184658)
1244	1244	-73.9565260889843	40.7991807924337	42C-AM-1007-03	42C	AM	10072018	3				+					0	0	0	0	0		0	1	0	0	0	0	0	0		POINT (-73.9565260889843 40.79918079243371)
1328	1328	-73.9765758043111	40.771380315403206	6C-AM-1007-03	06C	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	8	another tree	1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765758043111 40.7713803154032)
1418	1418	-73.9673924060436	40.7788781851716	17F-AM-1007-03	17F	AM	10072018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9673924060436 40.7788781851716)
1425	1425	-73.95862528758559	40.7852027586217	27I-AM-1007-03	27I	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	had .5 of a tail	Above Ground	20		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9586252875856 40.7852027586217)
1494	1494	-73.95257524081691	40.7954915417553	39H-AM-1007-03	39H	AM	10072018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9525752408169 40.7954915417553)
1658	1658	-73.9736016229655	40.772378137671396	8D-AM-1007-03	08D	AM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.9736016229655 40.77237813767141)
1701	1701	-73.9701634768603	40.777869143321794	15D-AM-1007-03	15D	AM	10072018	3	Adult	Gray		Gray+		Above Ground	10		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9701634768603 40.7778691433218)
1796	1796	-73.9765355395622	40.7735653237366	8B-AM-1007-03	08B	AM	10072018	3	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97653553956222 40.7735653237366)
1858	1858	-73.9742010726136	40.769150169929	5F-AM-1007-03	05F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9742010726136 40.769150169929006)
1968	1968	-73.9699088881236	40.775277835162605	13F-AM-1007-03	13F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699088881236 40.7752778351626)
2034	2034	-73.96991351872971	40.7782354186163	16D-AM-1007-03	16D	AM	10072018	3	Adult			+	ran away before I could take a good look	Above Ground	2		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699135187297 40.7782354186163)
2228	2228	-73.9714045891597	40.771541833397606	9G-AM-1007-03	09G	AM	10072018	3	Adult	Gray	Black	Gray+Black		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.97140458915972 40.7715418333976)
2238	2238	-73.95361987261741	40.798013510222795	41E-AM-1007-03	41E	AM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9536198726174 40.7980135102228)
2241	2241	-73.95752586279659	40.787715550749	30H-AM-1007-03	30H	AM	10072018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9575258627966 40.787715550749)
2388	2388	-73.9604476047877	40.7938014328732	35C-AM-1007-03	35C	AM	10072018	3	Adult			+		Above Ground	40		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9604476047877 40.7938014328732)
2413	2413	-73.959701727877	40.790660026971004	32E-AM-1007-03	32E	AM	10072018	3	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.959701727877 40.790660026971)
2491	2491	-73.98069052596709	40.76811522108579	1A-AM-1007-03	01A	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	looking in bush	0	0	0	0	0	0	1	0		POINT (-73.9806905259671 40.7681152210858)
2524	2524	-73.9743877909071	40.7754706115974	11B-AM-1007-03	11B	AM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9743877909071 40.7754706115974)
2603	2603	-73.97087815045279	40.7724138070355	10F-AM-1007-03	10F	AM	10072018	3	Adult	Gray		Gray+		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9708781504528 40.7724138070355)
2679	2679	-73.9794481602391	40.770638572864	4A-AM-1007-03	04A	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9794481602391 40.770638572864)
2719	2719	-73.973425927351	40.7781929919344	14B-AM-1007-03	14B	AM	10072018	3	Adult	Gray		Gray+					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.973425927351 40.7781929919344)
2789	2789	-73.96868007849409	40.77667390291379	15F-AM-1007-03	15F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686800784941 40.7766739029138)

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