2018_Central_Park_Squirrel_Census_-_Squirrel_Data

34 rows where Climbing = 0, Date = 10122018, Eating = 0 and Foraging = 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

- 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, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Other Activities, 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
142	142	-73.9724063986771	40.7705711897977	7F-PM-1012-01	07F	PM	10122018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9724063986771 40.7705711897977)
229	229	-73.97241624297101	40.7714260236636	8F-PM-1012-04	08F	PM	10122018	4	Adult	Gray		Gray+		Above Ground	6		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.972416242971 40.7714260236636)
285	285	-73.9691433356733	40.7731708333242	11G-AM-1012-01	11G	AM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9691433356733 40.77317083332421)
392	392	-73.98023761310341	40.768070751662705	1B-AM-1012-12	01B	AM	10122018	12	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9802376131034 40.7680707516627)
447	447	-73.97259060164741	40.7713889729739	8F-PM-1012-05	08F	PM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9725906016474 40.7713889729739)
549	549	-73.9549082481152	40.7933537584624	36G-PM-1012-01	36G	PM	10122018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	crossing east drive	0	0	0	0	0	0	0	0		POINT (-73.9549082481152 40.7933537584624)
568	568	-73.97994414934041	40.767149999752704	1C-AM-1012-01	01C	AM	10122018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9799441493404 40.7671499997527)
772	772	-73.95841884610591	40.7913241048498	33E-PM-1012-07	33E	PM	10122018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9584188461059 40.7913241048498)
907	907	-73.95806099213101	40.7907158878729	32F-AM-1012-06	32F	AM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958060992131 40.7907158878729)
947	947	-73.9736543790582	40.7651444188432	1H-AM-1012-02	01H	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9736543790582 40.7651444188432)
1090	1090	-73.967767372181	40.784702631615	23B-PM-1012-07	23B	PM	10122018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.967767372181 40.784702631615)
1100	1100	-73.98054238861499	40.768204880479395	1B-AM-1012-14	01B	AM	10122018	14		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.980542388615 40.7682048804794)
1219	1219	-73.96618922004741	40.7836798072777	22D-PM-1012-06	22D	PM	10122018	6	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9661892200474 40.7836798072777)
1292	1292	-73.959019987128	40.791254669180496	33E-PM-1012-05	33E	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	0	0	0	0		POINT (-73.959019987128 40.7912546691805)
1297	1297	-73.9802831706033	40.7692763295564	3A-AM-1012-02	03A	AM	10122018	2	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments.	Above Ground	1		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9802831706033 40.7692763295564)
1461	1461	-73.95692690934399	40.7965323262487	39D-PM-1012-03	39D	PM	10122018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.956926909344 40.7965323262487)
1475	1475	-73.96867781674841	40.7765625256946	14F-PM-1012-04	14F	PM	10122018	4				+					0	0	0	0	0		1	1	0	0	0	0	0	0		POINT (-73.96867781674841 40.7765625256946)
1516	1516	-73.9625383795297	40.7883862331728	28D-AM-1012-03	28D	AM	10122018	3	Adult	Black		Black+		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9625383795297 40.7883862331728)
1721	1721	-73.95873307074629	40.7907682009641	32F-AM-1012-02	32F	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray patches on back legs	Ground Plane	FALSE		0	0	0	0	0	curious about me	0	0	0	0	0	1	0	1		POINT (-73.9587330707463 40.7907682009641)
1805	1805	-73.9590328527128	40.791221441757706	33E-PM-1012-06	33E	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	0	0	0	0		POINT (-73.9590328527128 40.7912214417577)
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)
1871	1871	-73.9748367344424	40.7693513000034	5E-PM-1012-06	05E	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	10	oak tree at end of ramp from Chess House	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9748367344424 40.7693513000034)
2051	2051	-73.9544808708211	40.7906575852286	34I-AM-1012-02	34I	AM	10122018	2	Adult	Gray	White	Gray+White	Short tail	Ground Plane	FALSE		0	0	0	0	0	hiding	0	0	0	0	0	0	0	1		POINT (-73.9544808708211 40.7906575852286)
2113	2113	-73.95829048146521	40.790591574956395	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9582904814652 40.7905915749564)
2213	2213	-73.9707487237344	40.7800822831001	17B-PM-1012-03	17B	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	10		1	1	0	0	0	2/3 chasing each other	0	0	0	0	1	0	1	0		POINT (-73.9707487237344 40.7800822831001)
2214	2214	-73.9583688637255	40.791388958496	33E-PM-1012-08	33E	PM	10122018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9583688637255 40.791388958496)
2390	2390	-73.9680741975294	40.7847036778165	23B-PM-1012-04	23B	PM	10122018	4	Adult	Gray	White	Gray+White		Above Ground	20		0	0	0	0	0	watching me - didn't move	0	0	0	0	1	0	0	1		POINT (-73.9680741975294 40.7847036778165)
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)
2480	2480	-73.9546780963388	40.790321652211105	34I-AM-1012-03	34I	AM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	0	nut in mouth	0	0	0	0	0	0	1	0		POINT (-73.9546780963388 40.7903216522111)
2487	2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	31	on tree	1	1	0	0	0		0	0	0	1	1	0	1	0		POINT (-73.9595222999173 40.7833202577782)
2617	2617	-73.9564228238736	40.7936908887644	36F-PM-1012-06	36F	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9564228238736 40.7936908887644)
2733	2733	-73.9690082314914	40.7738993942891	12G-AM-1012-05	12G	AM	10122018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	0	1		POINT (-73.9690082314914 40.7738993942891)
2821	2821	-73.97545365660129	40.769860491877104	5E-PM-1012-04	05E	PM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9754536566013 40.7698604918771)
3011	3011	-73.96788313129359	40.7847605974975	23B-PM-1012-06	23B	PM	10122018	6	Adult	Gray		Gray+		Above Ground	30		0	0	0	0	0		1	0	0	0	0	0	0	0	scolding	POINT (-73.9678831312936 40.7847605974975)

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