2018_Central_Park_Squirrel_Census_-_Squirrel_Data

43 rows where Foraging = 1, Hectare Squirrel Number = 5, 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

- 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, 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
11	11	-73.9702676472613	40.7762126854894	13E-AM-1017-05	13E	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on tree stump	0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9702676472613 40.7762126854894)
50	50	-73.96806350709491	40.779249873647	17E-AM-1017-05	17E	AM	10172018	5	Adult	Black		Black+		Above Ground	10	Branch	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9680635070949 40.779249873647)
90	90	-73.97871808707359	40.7715877863274	5A-AM-1006-05	05A	AM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	near 65th St arch	0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9787180870736 40.7715877863274)
104	104	-73.9764036522984	40.7705846185121	5C-AM-1006-05	05C	AM	10062018	5	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.9764036522984 40.7705846185121)
131	131	-73.9755560786227	40.7662992317575	2F-AM-1006-05	02F	AM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	curious but shy	POINT (-73.9755560786227 40.7662992317575)
231	231	-73.9527808174534	40.7924167234441	36I-AM-1017-05	36I	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1	runs from (me)	POINT (-73.9527808174534 40.7924167234441)
261	261	-73.9552861155228	40.788973931872	32I-AM-1013-05	32I	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3	In and below shrub	0	0	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9552861155228 40.788973931872)
313	313	-73.9646610347972	40.7790583544252	19H-AM-1010-05	19H	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	near a brush	0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9646610347972 40.7790583544252)
370	370	-73.95489578620841	40.794484446461894	37G-AM-1014-05	37G	AM	10142018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9548957862084 40.7944844464619)
397	397	-73.9690416961886	40.7716618670996	10H-AM-1014-05	10H	AM	10142018	5		Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9690416961886 40.7716618670996)
439	439	-73.9589770206691	40.791240542172	33E-AM-1014-05	33E	AM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9589770206691 40.791240542172)
527	527	-73.9632646049622	40.781740129208295	22G-AM-1018-05	22G	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9632646049622 40.7817401292083)
538	538	-73.9553113771098	40.797843198020395	41D-AM-1014-05	41D	AM	10142018	5	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9553113771098 40.7978431980204)
810	810	-73.967418114684	40.7764595360054	15G-AM-1008-05	15G	AM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.967418114684 40.7764595360054)
921	921	-73.9698959071826	40.7716763799299	9H-AM-1006-05	09H	AM	10062018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9698959071826 40.7716763799299)
975	975	-73.95686908603099	40.798885877111395	41C-AM-1017-05	41C	AM	10172018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.956869086031 40.7988858771114)
994	994	-73.9718553361982	40.7748584798761	11D-AM-1010-05	11D	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9718553361982 40.7748584798761)
1020	1020	-73.97016933635	40.770545252978295	8H-AM-1017-05	08H	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.97016933635001 40.7705452529783)
1320	1320	-73.9554327683595	40.7953846381499	38E-AM-1010-05	38E	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	interested in my presence	POINT (-73.9554327683595 40.7953846381499)
1347	1347	-73.9616693665254	40.792971019627	33B-AM-1010-05	33B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616693665254 40.792971019627)
1382	1382	-73.9611274898661	40.7915250069086	32C-AM-1014-05	32C	AM	10142018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9611274898661 40.7915250069086)
1483	1483	-73.9545773579075	40.7898684635744	33I-AM-1008-05	33I	AM	10082018	5	Adult			+		Above Ground	100		0	0	1	0	1		0	0	0	0	0	0	1	0	nearly dropped shell on my head!	POINT (-73.9545773579075 40.7898684635744)
1722	1722	-73.98025646852649	40.768175909819895	2B-AM-1010-05	02B	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9802564685265 40.7681759098199)
1784	1784	-73.9748318777506	40.7771821378056	13A-AM-1017-05	13A	AM	10172018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9748318777506 40.7771821378056)
1800	1800	-73.970962498391	40.7766899040856	14D-AM-1014-05	14D	AM	10142018	5	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.970962498391 40.7766899040856)
1849	1849	-73.9788436368415	40.7691104998969	3B-AM-1010-05	03B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9788436368415 40.7691104998969)
1923	1923	-73.9743795190073	40.7692030411004	5E-AM-1008-05	05E	AM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9743795190073 40.7692030411004)
1944	1944	-73.97432920664129	40.7756090404121	11B-AM-1007-05	11B	AM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0	1	0	0		POINT (-73.9743292066413 40.7756090404121)
2061	2061	-73.9608834102446	40.790624710005005	31D-AM-1014-05	31D	AM	10142018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9608834102446 40.790624710005)
2106	2106	-73.9801651470389	40.767769865693495	1B-AM-1012-05	01B	AM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9801651470389 40.7677698656935)
2196	2196	-73.96233563694321	40.7888693815168	29D-AM-1014-05	29D	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Rocky area	0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9623356369432 40.7888693815168)
2464	2464	-73.96913180449691	40.770980197469605	9I-AM-1014-05	09I	AM	10142018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9691318044969 40.7709801974696)
2506	2506	-73.9719038949487	40.770353349248204	7G-AM-1010-05	07G	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9719038949487 40.7703533492482)
2531	2531	-73.9599424115626	40.79574725853271	37B-AM-1018-05	37B	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9599424115626 40.7957472585327)
2651	2651	-73.9632993246327	40.78881995196561	29C-AM-1007-05	29C	AM	10072018	5	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9632993246327 40.7888199519656)
2685	2685	-73.9601851468038	40.7968698151479	38A-AM-1019-05	38A	AM	10192018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon head, White belly	Ground Plane	FALSE		0	0	0	0	1	standing on back legs	0	0	0	0	0	1	1	0		POINT (-73.9601851468038 40.7968698151479)
2701	2701	-73.97912175106559	40.767658347539395	2C-AM-1010-05	02C	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	right at the base of the same tree as #3	0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9791217510656 40.7676583475394)
2805	2805	-73.9711634340673	40.7760553338671	13D-AM-1014-05	13D	AM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9711634340673 40.7760553338671)
2854	2854	-73.9772908667333	40.7697207404744	4C-AM-1006-05	04C	AM	10062018	5	Juvenile	Gray	White	Gray+White		Above Ground	20		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9772908667333 40.7697207404744)
2876	2876	-73.95589957376541	40.7960097734603	39E-AM-1018-05	39E	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9558995737654 40.7960097734603)
2907	2907	-73.96852016269341	40.783329261225	21B-AM-1019-05	21B	AM	10192018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9685201626934 40.783329261225)
2944	2944	-73.97394038506219	40.769316228750895	5F-AM-1007-05	05F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	2	tree	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9739403850622 40.7693162287509)
2962	2962	-73.9722530826293	40.7667138028361	3I-AM-1010-05	03I	AM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9722530826293 40.7667138028361)

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