2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Above Ground Sighter Measurement = 10, Climbing = 1, Moans = 0, Shift = "AM" and Tail twitches = 0

- 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

- 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: Hectare, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Eating, Kuks, Quaas, Tail flags, 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
191	191	-73.9787105069657	40.7693708133873	3B-AM-1010-08	03B	AM	10102018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0	together w/ #7	0	0	0	0	0	0	1	0		POINT (-73.9787105069657 40.7693708133873)
199	199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		1	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9771614686616 40.7709677983247)
300	300	-73.9528149779809	40.7924984810637	36I-AM-1017-06	36I	AM	10172018	6	Adult	Gray	Black	Gray+Black	Darker than others	Above Ground	10	Running down tree	1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9528149779809 40.7924984810637)
440	440	-73.9642717435966	40.782087049693	22F-AM-1007-05	22F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	10	tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9642717435966 40.782087049693)
593	593	-73.95933528061751	40.7918150568046	33E-AM-1014-02	33E	AM	10142018	2	Juvenile	Black		Black+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9593352806175 40.7918150568046)
667	667	-73.9624538733037	40.7883829851518	28D-AM-1012-04	28D	AM	10122018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9624538733037 40.7883829851518)
858	858	-73.96293834202741	40.7889383725489	29C-AM-1007-02	29C	AM	10072018	2	Adult	Black	Gray	Black+Gray		Above Ground	10		1	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.9629383420274 40.7889383725489)
1116	1116	-73.9729847109778	40.774070904960205	10D-AM-1008-03	10D	AM	10082018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9729847109778 40.7740709049602)
1280	1280	-73.9562469727195	40.79685907654	39D-AM-1008-04	39D	AM	10082018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562469727195 40.79685907654)
1324	1324	-73.954554245377	40.7983935730557	41E-AM-1007-05	41E	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1	man/pit bull mix wandered	POINT (-73.954554245377 40.7983935730557)
1329	1329	-73.9772164524209	40.768839953875606	3D-AM-1006-06	03D	AM	10062018	6		Gray		Gray+		Above Ground	10	tree	1	0	1	0	0		0	0	0	0	0	0	0	0	did not run from humans,but ran straight to tree & climbed up	POINT (-73.9772164524209 40.7688399538756)
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9791648157033 40.767625444347)
1397	1397	-73.9655233748105	40.7792737287734	18G-AM-1014-01	18G	AM	10142018	1	Juvenile	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		1	0	0	0	0	0	1	0	looking	POINT (-73.9655233748105 40.7792737287734)
1569	1569	-73.973047824163	40.7700873791211	7F-AM-1008-03	07F	AM	10082018	3	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.973047824163 40.7700873791211)
1576	1576	-73.96199851876159	40.79432777435321	34A-AM-1012-02	34A	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	chasing from tree to ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9619985187616 40.7943277743532)
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)
1747	1747	-73.96657637976071	40.7761316400012	15H-AM-1013-03	15H	AM	10132018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9665763797607 40.7761316400012)
1938	1938	-73.9719879697272	40.7725625124591	9F-AM-1013-02	09F	AM	10132018	2	Adult	Black		Black+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9719879697272 40.7725625124591)
2002	2002	-73.9581706950566	40.790632139726895	32F-AM-1012-05	32F	AM	10122018	5	Adult	Gray	White	Gray+White		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9581706950566 40.7906321397269)
2005	2005	-73.9755259087781	40.770725612418104	6D-AM-1008-01	06D	AM	10082018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		0	0	1	1	0		1	0	0	0	0	1	0	0		POINT (-73.9755259087781 40.7707256124181)
2206	2206	-73.95944460183459	40.7917800352042	33D-AM-1017-06	33D	AM	10172018	6	Adult	Black		Black+		Above Ground	10		0	0	1	0	0		1	1	0	0	0	0	0	1	runs from (ran into hole in tree trunk)	POINT (-73.9594446018346 40.7917800352042)
2224	2224	-73.9662310606968	40.7747758221226	14I-AM-1013-01	14I	AM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9662310606968 40.7747758221226)
2297	2297	-73.9787771053108	40.769356212275	3B-AM-1010-07	03B	AM	10102018	7	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0	together w/ #8	0	0	0	1	0	0	1	0		POINT (-73.9787771053108 40.76935621227501)
2397	2397	-73.9704592500888	40.772962887933005	10G-AM-1006-03	10G	AM	10062018	3	Juvenile	Gray	White	Gray+White	tuft on butt	Above Ground	10		0	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9704592500888 40.772962887933)
2652	2652	-73.96205425147491	40.794373172213795	34A-AM-1012-01	34A	AM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	chasing from tree to ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9620542514749 40.7943731722138)
2744	2744	-73.9752915601718	40.7739329570033	9B-AM-1010-04	09B	AM	10102018	4				+		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9752915601718 40.7739329570033)
2911	2911	-73.9793923984874	40.770847547458295	5A-AM-1006-01	05A	AM	10062018	1	Adult	Gray		Gray+		Above Ground	10	Oak tree near rock outcropping	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97939239848742 40.7708475474583)
3013	3013	-73.964661337306	40.7769785494935	17I-AM-1014-03	17I	AM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon face	Above Ground	10		0	0	1	0	0	climbing (dog barked & it ran up tree)	0	0	0	0	0	0	1	0		POINT (-73.964661337306 40.7769785494935)

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