2018_Central_Park_Squirrel_Census_-_Squirrel_Data

59 rows where Running = 0, Shift = "PM" and Tail flags = 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: Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, 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
15	15	-73.9674285955293	40.7829723919744	21C-PM-1006-01	21C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	1	1	0	0	0		POINT (-73.9674285955293 40.7829723919744)
74	74	-73.95466541841459	40.7947639241491	38G-PM-1020-09	38G	PM	10202018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0	0	1	0		POINT (-73.9546654184146 40.7947639241491)
78	78	-73.964474836001	40.7883840104749	28C-PM-1006-01	28C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	gathering acorns	0	0	0	1	0	0	0	1	gnd to tree	POINT (-73.964474836001 40.7883840104749)
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)
133	133	-73.9664711607022	40.787896428768	26A-PM-1006-06	26A	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Tree 90th left 90th & 89	0	0	1	0	0		0	0	0	1	0	0	0	0	studying us looking for food	POINT (-73.9664711607022 40.787896428768)
150	150	-73.97634308293419	40.7686351097159	4D-PM-1008-11	04D	PM	10082018	11	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	3	on tree facing downward	0	1	0	0	0	chased #12	1	0	0	1	0	0	0	1		POINT (-73.9763430829342 40.7686351097159)
159	159	-73.9638270331336	40.7810450065235	21G-PM-1007-02	21G	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9638270331336 40.7810450065235)
192	192	-73.9651654887991	40.7777806006951	17H-PM-1007-02	17H	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9651654887991 40.7777806006951)
194	194	-73.9764839973068	40.7691725326976	4D-PM-1008-06	04D	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9764839973068 40.7691725326976)
210	210	-73.97112984911321	40.76769026035429	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	15	in tree by arsenal - climbing	0	0	1	1	0		0	0	0	1	0	0	0	0		POINT (-73.9711298491132 40.7676902603543)
239	239	-73.97584649051329	40.77259574088411	8C-PM-1013-05	08C	PM	10132018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9758464905133 40.7725957408841)
294	294	-73.9756573579063	40.7656644063024	1G-PM-1010-01	01G	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	1	0		0	0	0	1	0	0	1	0	too busy eating in his tree	POINT (-73.9756573579063 40.7656644063024)
379	379	-73.9606817053484	40.7917320450401	32D-PM-1006-07	32D	PM	10062018	7	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9606817053484 40.7917320450401)
416	416	-73.9702788578386	40.7694484997295	7I-PM-1013-05	07I	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Rock	0	0	0	1	0		0	0	0	1	0	0	0	0		POINT (-73.9702788578386 40.7694484997295)
427	427	-73.9589367709165	40.78964653034829	31F-PM-1007-04	31F	PM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9589367709165 40.7896465303483)
614	614	-73.9642411990432	40.7779692777193	18H-PM-1014-03	18H	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9642411990432 40.7779692777193)
658	658	-73.9704575848926	40.7693499326095	7H-PM-1006-09	07H	PM	10062018	9	Adult	Black		Black+		Ground Plane	FALSE	by tree	0	0	0	1	1		0	0	0	1	0	1	0	1		POINT (-73.9704575848926 40.7693499326095)
727	727	-73.9634563222926	40.780992836417	21G-PM-1007-04	21G	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9634563222926 40.780992836417)
730	730	-73.9607280801601	40.7901506706248	31D-PM-1006-01	31D	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0	0	0	1		POINT (-73.9607280801601 40.7901506706248)
784	784	-73.9649658099293	40.782326236907394	22F-PM-1014-03	22F	PM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9649658099293 40.7823262369074)
815	815	-73.9753283783695	40.7733043910649	8C-PM-1013-02	08C	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9753283783695 40.7733043910649)
855	855	-73.9808247660048	40.76894088312871	2A-PM-1019-01	02A	PM	10192018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	runs from	0	0	0	1	0	0	0	1		POINT (-73.9808247660048 40.7689408831287)
887	887	-73.9635028497015	40.7928207574906	32A-PM-1013-05	32A	PM	10132018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9635028497015 40.7928207574906)
1058	1058	-73.97371007431829	40.7708360121735	7E-PM-1013-03	07E	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Ground & Tree Base	0	0	0	0	1		0	0	0	1	1	0	1	0		POINT (-73.9737100743183 40.7708360121735)
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Oak tree	0	1	0	0	0	watching me	0	1	0	1	0	0	0	0	observant	POINT (-73.9667474482967 40.7760643720793)
1174	1174	-73.9682067129876	40.7779911208015	16E-PM-1018-05	16E	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	staring	0	0	0	1	0	1	0	0	approaches (very close)	POINT (-73.9682067129876 40.7779911208015)
1175	1175	-73.9803282698463	40.7680809889384	1B-PM-1019-09	01B	PM	10192018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE	Tree to ground	0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9803282698463 40.7680809889384)
1198	1198	-73.9762187733662	40.7739282973004	9B-PM-1013-08	09B	PM	10132018	8	Juvenile	Cinnamon	Black, White	Cinnamon+Black, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9762187733662 40.7739282973004)
1218	1218	-73.953375642605	40.7947144477885	38G-PM-1020-02	38G	PM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.953375642605 40.7947144477885)
1333	1333	-73.9754527701832	40.7656088463928	1G-PM-1010-02	01G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0	laying on tree branch	0	0	0	1	1	0	0	0		POINT (-73.9754527701832 40.7656088463928)
1367	1367	-73.9542684235907	40.7944237164092	38G-PM-1020-05	38G	PM	10202018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	1	0	1	0	0	1	0		POINT (-73.9542684235907 40.7944237164092)
1368	1368	-73.95427708888809	40.794361036685295	38G-PM-1020-04	38G	PM	10202018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	1	0	1	0	0	1	0		POINT (-73.9542770888881 40.79436103668531)
1415	1415	-73.9678561384348	40.77828773978221	16E-PM-1018-02	16E	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	0	0	gets distance from people but then continues to chase #1	POINT (-73.9678561384348 40.7782877397822)
1421	1421	-73.9595022290348	40.7831151330074	25I-PM-1007-02	25I	PM	10072018	2	Adult	Gray	White	Gray+White	white belly	Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	1	0	0	1		POINT (-73.9595022290348 40.783115133007406)
1514	1514	-73.9548006161673	40.7945503341011	38G-PM-1020-08	38G	PM	10202018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		1	0	0	1	0	0	1	0		POINT (-73.9548006161673 40.7945503341011)
1523	1523	-73.9673103881521	40.78742674096179	26A-PM-1006-01	26A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9673103881521 40.7874267409618)
1531	1531	-73.9630381400083	40.7807571827321	21H-PM-1018-02	21H	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9630381400083 40.7807571827321)
1616	1616	-73.9642666013207	40.7810384867375	21G-PM-1007-03	21G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.96426660132072 40.7810384867375)
1660	1660	-73.98004994980342	40.7702181099573	4A-PM-1007-05	04A	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	At rock	0	0	0	0	1		0	0	0	1	1	0	1	0		POINT (-73.9800499498034 40.770218109957305)
1815	1815	-73.96032682553171	40.7900154505092	31E-PM-1006-06	31E	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9603268255317 40.7900154505092)
1836	1836	-73.9751056714758	40.7732060035215	8C-PM-1013-03	08C	PM	10132018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9751056714758 40.7732060035215)
1967	1967	-73.96472472541271	40.780613656578396	20G-PM-1013-03	20G	PM	10132018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0	0	0	1		POINT (-73.9647247254127 40.7806136565784)
1982	1982	-73.9729979174723	40.7742904356698	10D-PM-1008-01	10D	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9729979174723 40.7742904356698)
1995	1995	-73.9603366992925	40.7899612889539	31E-PM-1006-05	31E	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9603366992925 40.789961288953904)
2026	2026	-73.9622752768962	40.7814921913101	22H-PM-1007-02	22H	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	low branch	0	0	0	0	0	watching me scratching	1	0	0	1	0	0	1	0		POINT (-73.9622752768962 40.7814921913101)
2134	2134	-73.9614373639552	40.7945051962914	35B-PM-1013-01	35B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	did not notice dog sitting a few yards away (10-20 ft)	0	0	0	1	0	0	1	0		POINT (-73.9614373639552 40.7945051962914)
2142	2142	-73.95985354257058	40.7915589343685	33D-PM-1006-01	33D	PM	10062018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	1	0	0	0	hanging on fence	1	0	0	1	0	0	0	1		POINT (-73.9598535425706 40.7915589343685)
2185	2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9707571364399 40.7758859812524)
2203	2203	-73.97105314852979	40.7773757069445	14D-PM-1019-06	14D	PM	10192018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.97105314852982 40.777375706944504)
2335	2335	-73.9704679459444	40.7773384236212	14D-PM-1019-10	14D	PM	10192018	10	Adult	Gray		Gray+		Above Ground	20		0	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9704679459444 40.7773384236212)
2348	2348	-73.9531965469704	40.794743798397704	38G-PM-1020-11	38G	PM	10202018	11	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	1	1	0		POINT (-73.9531965469704 40.7947437983977)
2463	2463	-73.9653343572865	40.77752869246171	17H-PM-1007-01	17H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9653343572865 40.7775286924617)
2505	2505	-73.9762974698771	40.7740076116964	9B-PM-1013-06	09B	PM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9762974698771 40.7740076116964)
2591	2591	-73.9786351029146	40.771611416400205	6A-PM-1012-06	06A	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	elevated ground	0	1	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9786351029146 40.771611416400205)
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)
2759	2759	-73.9543373703455	40.7943889087123	38G-PM-1020-07	38G	PM	10202018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	1		0	1	0	1	0	0	1	0		POINT (-73.9543373703455 40.7943889087123)
2852	2852	-73.9728146482385	40.7652951714745	1I-PM-1012-03	01I	PM	10122018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.97281464823851 40.765295171474506)
2857	2857	-73.9649230271173	40.7821766215675	22F-PM-1014-02	22F	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9649230271173 40.7821766215675)
2992	2992	-73.9746063250438	40.7687654196811	4F-PM-1013-03	04F	PM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9746063250438 40.7687654196811)

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