2018_Central_Park_Squirrel_Census_-_Squirrel_Data

45 rows where Age = "Juvenile", Runs from = 1 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: Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent

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
4	4	-73.9757249834141	40.7697032606755	5D-PM-1018-05	05D	PM	10182018	5	Juvenile	Gray		Gray+		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9757249834141 40.7697032606755)
209	209	-73.97107601968679	40.7725506006789	10F-PM-1019-02	10F	PM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head & stripe	Ground Plane	FALSE	Behind fence, grass	1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9710760196868 40.7725506006789)
341	341	-73.9703161745884	40.7702610461336	8H-PM-1014-05	08H	PM	10142018	5	Juvenile	Gray		Gray+		Above Ground	2		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9703161745884 40.7702610461336)
356	356	-73.97610364001441	40.77054826845939	6D-PM-1020-03	06D	PM	10202018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9761036400144 40.7705482684594)
598	598	-73.9698196671161	40.7802972001469	18C-PM-1018-03	18C	PM	10182018	3	Juvenile	Gray		Gray+		Above Ground	1		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9698196671161 40.7802972001469)
706	706	-73.95701325709341	40.793201415908705	35F-PM-1012-01	35F	PM	10122018	1	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	1	0	0	1	1		POINT (-73.9570132570934 40.7932014159087)
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)
888	888	-73.9674177504573	40.7769569731993	15G-PM-1019-03	15G	PM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9674177504573 40.7769569731993)
1024	1024	-73.9521514669041	40.7949515182825	39H-PM-1013-03	39H	PM	10132018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	1	1		POINT (-73.9521514669041 40.7949515182825)
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)
1077	1077	-73.9541837143178	40.7944340477396	38G-PM-1020-06	38G	PM	10202018	6	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	1	0	0	0	0	0	1		POINT (-73.9541837143178 40.7944340477396)
1107	1107	-73.95307395621309	40.7932034409546	37H-PM-1006-01	37H	PM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1	from voice	POINT (-73.95307395621312 40.7932034409546)
1270	1270	-73.967762162893	40.7823359027165	20C-PM-1018-08	20C	PM	10182018	8	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	1	runs from (dog)	POINT (-73.967762162893 40.7823359027165)
1314	1314	-73.980919134781	40.7683772453336	1A-PM-1014-06	01A	PM	10142018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	0	1		POINT (-73.980919134781 40.7683772453336)
1345	1345	-73.95813265542058	40.7918074743129	34E-PM-1006-02	34E	PM	10062018	2	Juvenile	Black	Gray, White	Black+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9581326554206 40.7918074743129)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1392	1392	-73.96480906981759	40.7903882097837	29A-PM-1019-03	29A	PM	10192018	3	Juvenile	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	1	0	1	ran from,but now approaching. kind of weirding me out.	POINT (-73.9648090698176 40.7903882097837)
1466	1466	-73.96511776576759	40.7812408103825	20F-PM-1007-05	20F	PM	10072018	5	Juvenile	Gray	White	Gray+White	white tail	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9651177657676 40.781240810382506)
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)
1524	1524	-73.97259615083159	40.7795720444974	16A-PM-1019-06	16A	PM	10192018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9725961508316 40.7795720444974)
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)
1631	1631	-73.9527196716568	40.792363826828	36I-PM-1007-11	36I	PM	10072018	11	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	1	me!	POINT (-73.9527196716568 40.792363826828)
1645	1645	-73.9619673317128	40.7924176673037	33B-PM-1010-08	33B	PM	10102018	8	Juvenile	Gray		Gray+		Above Ground		running up tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619673317128 40.7924176673037)
1651	1651	-73.97633735105359	40.774116893392794	9B-PM-1013-09	09B	PM	10132018	9	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1	runs from (people)	POINT (-73.9763373510536 40.7741168933928)
1732	1732	-73.97671414072741	40.7737313251559	8A-PM-1014-02	08A	PM	10142018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.9767141407274 40.7737313251559)
1840	1840	-73.9733222531339	40.764997537154606	1I-PM-1012-01	01I	PM	10122018	1	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9733222531339 40.7649975371546)
1932	1932	-73.96169725573041	40.7953872829374	36A-PM-1013-03	36A	PM	10132018	3	Juvenile	Cinnamon		Cinnamon+	COULD HAVE BEEN CHIPPY, DEEP BROWN	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9616972557304 40.7953872829374)
1999	1999	-73.95498609472341	40.79115503283089	34H-PM-1006-07	34H	PM	10062018	7	Juvenile	Gray	White	Gray+White	white belly	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9549860947234 40.7911550328309)
2018	2018	-73.9697924026634	40.7803611152023	18C-PM-1018-04	18C	PM	10182018	4	Juvenile	Gray		Gray+		Above Ground	1		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9697924026634 40.7803611152023)
2132	2132	-73.967472660349	40.7772125619715	16F-PM-1013-03	16F	PM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4	Woods	0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.96747266034902 40.7772125619715)
2288	2288	-73.9577009571427	40.796126044520996	38C-PM-1014-10	38C	PM	10142018	10	Juvenile	Gray	White	Gray+White		Above Ground	10		0	0	1	1	1	climbing (down from ~10')	0	0	0	0	0	0	0	1		POINT (-73.9577009571427 40.796126044521)
2357	2357	-73.96323010348829	40.7925707244111	32A-PM-1013-06	32A	PM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9632301034883 40.7925707244111)
2432	2432	-73.9657203199746	40.775173008911	14I-PM-1018-02	14I	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9657203199746 40.775173008911)
2522	2522	-73.9658747245917	40.77540337375321	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		Fallen branch	1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9658747245917 40.7754033737532)
2544	2544	-73.9713680837672	40.77716615083639	14D-PM-1019-03	14D	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9713680837672 40.77716615083641)
2604	2604	-73.9605163698302	40.7914179994956	32D-PM-1006-05	32D	PM	10062018	5	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	1	1	0		0	0	0	0	1	0	0	1		POINT (-73.9605163698302 40.7914179994956)
2672	2672	-73.9614599022015	40.7945181285991	35A-PM-1013-11	35A	PM	10132018	11	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9614599022015 40.7945181285991)
2745	2745	-73.97296259363002	40.7652601851275	1I-PM-1012-04	01I	PM	10122018	4	Juvenile	Cinnamon	White	Cinnamon+White	Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	2	on ledge	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.97296259363 40.7652601851275)
2776	2776	-73.9789687905912	40.769269313932796	3B-PM-1007-04	03B	PM	10072018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4	At fence	1	0	1	1	0		0	0	0	0	1	0	1	1		POINT (-73.9789687905912 40.7692693139328)
2794	2794	-73.9712187890707	40.7750640173134	12E-PM-1018-01	12E	PM	10182018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		1	0	0	1	0	0	0	1		POINT (-73.9712187890707 40.7750640173134)
2862	2862	-73.967466716152	40.782434654827796	21D-PM-1008-04	21D	PM	10082018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1	i scared it	POINT (-73.967466716152 40.7824346548278)
2927	2927	-73.96501200660741	40.7805932882407	20F-PM-1007-13	20F	PM	10072018	13	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9650120066074 40.78059328824071)
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)
3016	3016	-73.9756457597888	40.7703559775625	6D-PM-1020-02	06D	PM	10202018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9756457597888 40.7703559775625)
3018	3018	-73.9645437409662	40.7811599933331	21F-PM-1018-02	21F	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9645437409662 40.7811599933331)

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