2018_Central_Park_Squirrel_Census_-_Squirrel_Data

25 rows where Date = 10122018, Hectare Squirrel Number = 2 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

- 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, 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
60	60	-73.9768674812942	40.7735232648872	8B-PM-1012-02	08B	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hiding in bushes	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9768674812942 40.7735232648872)
246	246	-73.9779805668091	40.768093156679704	2D-PM-1012-02	02D	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9779805668091 40.7680931566797)
267	267	-73.97547422950909	40.769699832724704	5E-PM-1012-02	05E	PM	10122018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9754742295091 40.7696998327247)
328	328	-73.96523572796708	40.781929688714705	21E-PM-1012-02	21E	PM	10122018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9652357279671 40.7819296887147)
762	762	-73.96792913479558	40.7846973096665	23B-PM-1012-02	23B	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1	2/3 were chasing each other	0	0	0	0	1	0	0	1		POINT (-73.9679291347956 40.7846973096665)
776	776	-73.9686816795392	40.775770422666994	14F-PM-1012-02	14F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9686816795392 40.775770422667)
880	880	-73.95656845779891	40.79360039404129	36F-PM-1012-02	36F	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9565684577989 40.7936003940413)
1064	1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon					1	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9540257319561 40.798408619116)
1123	1123	-73.9670858934045	40.7753505024976	14H-PM-1012-02	14H	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9670858934045 40.7753505024976)
1283	1283	-73.9566785136491	40.7963368332834	39D-PM-1012-02	39D	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9566785136491 40.7963368332834)
1625	1625	-73.9736873018042	40.76491066771379	1I-PM-1012-02	01I	PM	10122018	2	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments.	Above Ground	1	tree	0	0	1	0	0		1	0	0	0	0	0	0	1		POINT (-73.9736873018042 40.7649106677138)
1697	1697	-73.9568610943394	40.7935959584643	36E-PM-1012-02	36E	PM	10122018	2	Adult	Gray		Gray+		Above Ground	28	on tree branch	0	0	1	0	1	picking acorns off oak tree	0	0	0	0	0	0	1	0		POINT (-73.95686109433942 40.7935959584643)
1706	1706	-73.965215665278	40.7761309082202	15I-PM-1012-02	15I	PM	10122018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.965215665278 40.7761309082202)
1720	1720	-73.9725844658514	40.7701092834201	7F-PM-1012-02	07F	PM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	observes	POINT (-73.9725844658514 40.7701092834201)
1781	1781	-73.96005650463	40.793404850298295	34C-PM-1012-02	34C	PM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.96005650463 40.7934048502983)
1806	1806	-73.9657504643585	40.783121081359205	22D-PM-1012-02	22D	PM	10122018	2	Adult	Gray	Black, White	Gray+Black, White	No Primary Fur Color selected. Made executive adjustment based on other squirrels.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9657504643585 40.7831210813592)
1959	1959	-73.97077370737709	40.780037346583796	17B-PM-1012-02	17B	PM	10122018	2	Adult	Black		Black+		Ground Plane	FALSE		1	1	0	0	1	2/3 chasing each other	1	1	0	1	1	0	1	0		POINT (-73.9707737073771 40.7800373465838)
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)
2391	2391	-73.9721497679014	40.771616019938605	8F-PM-1012-02	08F	PM	10122018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9721497679014 40.7716160199386)
2394	2394	-73.97858295460459	40.7719652299132	6A-PM-1012-02	06A	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785829546046 40.7719652299132)
2405	2405	-73.9588361742943	40.791115225155	33E-PM-1012-02	33E	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9588361742943 40.791115225155)
2430	2430	-73.9569811285656	40.793091234605	35F-PM-1012-02	35F	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9569811285656 40.793091234605)
2511	2511	-73.95845615374209	40.791121116475395	33F-PM-1012-02	33F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	1	0	0	0		POINT (-73.9584561537421 40.7911211164754)
2806	2806	-73.9714298880357	40.774105786890004	11E-PM-1012-02	11E	PM	10122018	2	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.9714298880357 40.77410578689)
2818	2818	-73.9681664642028	40.77246696819579	11I-PM-1012-02	11I	PM	10122018	2	Adult	Gray		Gray+		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	0	1	runs away from the ball	POINT (-73.9681664642028 40.7724669681958)

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