2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Date = 10132018, Foraging = 1 and Shift = "AM"

- 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, 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
29	29	-73.96717867152559	40.7867352791232	25A-AM-1013-04	25A	AM	10132018	4		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9671786715256 40.7867352791232)
30	30	-73.96929432916109	40.776953610248796	15E-AM-1013-01	15E	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9692943291611 40.7769536102488)
79	79	-73.9610705592868	40.7914829661051	32D-AM-1013-06	32D	AM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	1	1	eating (a mushroom),circles around us,really fat,scratching himself,grooming activity	0	0	0	0	1	1	0	0		POINT (-73.9610705592868 40.7914829661051)
88	88	-73.9683608295976	40.784292740532706	22B-AM-1013-04	22B	AM	10132018	4	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	Under bench	0	0	0	0	1		0	0	0	0	0	0	0	1	ran from dog-walker	POINT (-73.9683608295976 40.7842927405327)
145	145	-73.971970670614	40.7720868124544	9F-AM-1013-04	09F	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.971970670614 40.7720868124544)
204	204	-73.96795381633409	40.7837103696906	22C-AM-1013-03	22C	AM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1	eating (mushroom)	0	0	0	0	0	0	0	1		POINT (-73.9679538163341 40.7837103696906)
228	228	-73.97286607796221	40.7753294525644	12C-AM-1013-03	12C	AM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9728660779622 40.7753294525644)
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)
308	308	-73.9554095823557	40.788730580204394	32I-AM-1013-01	32I	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9554095823557 40.7887305802044)
323	323	-73.9573469787503	40.7944044592573	36E-AM-1013-03	36E	AM	10132018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	indifferent (moving very fast)	POINT (-73.9573469787503 40.7944044592573)
346	346	-73.9712971568288	40.7745520717065	11E-AM-1013-02	11E	AM	10132018	2	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712971568288 40.7745520717065)
384	384	-73.968045072743	40.783662671722496	22C-AM-1013-02	22C	AM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		0	0	1	0	1		1	0	0	1	0	0	0	1		POINT (-73.968045072743 40.7836626717225)
481	481	-73.9714303315699	40.774593494770606	11E-AM-1013-04	11E	AM	10132018	4	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9714303315699 40.7745934947706)
662	662	-73.9721854790038	40.776108635243794	12C-AM-1013-01	12C	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9721854790038 40.7761086352438)
681	681	-73.9552880892701	40.7889040503316	32I-AM-1013-04	32I	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9552880892701 40.7889040503316)
915	915	-73.9770235090023	40.774135208066	9A-AM-1013-02	09A	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9770235090023 40.774135208066)
1017	1017	-73.9552035011902	40.7889851896334	32I-AM-1013-06	32I	AM	10132018	6	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.9552035011902 40.7889851896334)
1130	1130	-73.95190816277679	40.7973148719421	41G-AM-1013-02	41G	AM	10132018	2	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.9519081627768 40.7973148719421)
1308	1308	-73.95603964408441	40.7945080361909	37E-AM-1013-01	37E	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9560396440844 40.7945080361909)
1412	1412	-73.9594676326588	40.7984457363388	39A-AM-1013-01	39A	AM	10132018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9594676326588 40.7984457363388)
1493	1493	-73.96847906578509	40.7838818717863	22B-AM-1013-01	22B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	looked at me,standing on back feet	POINT (-73.9684790657851 40.7838818717863)
1558	1558	-73.968200390984	40.783709576948205	22B-AM-1013-02	22B	AM	10132018	2	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1	climbed tree	0	0	0	0	0	0	1	0		POINT (-73.968200390984 40.7837095769482)
1578	1578	-73.97352989433209	40.771493999358896	8E-AM-1013-02	08E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9735298943321 40.7714939993589)
1623	1623	-73.97701191330229	40.773294909000505	8A-AM-1013-04	08A	AM	10132018	4	Juvenile			+		Above Ground	4	fence	1	1	0	1	1	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770119133023 40.7732949090005)
1719	1719	-73.955429970986	40.797816862987496	40D-AM-1013-02	40D	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955429970986 40.7978168629875)
1748	1748	-73.955710327539	40.797451079756705	40D-AM-1013-03	40D	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955710327539 40.7974510797567)
1809	1809	-73.96901686738441	40.777761204391396	15E-AM-1013-04	15E	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9690168673844 40.7777612043914)
2050	2050	-73.9555255950648	40.7977720808005	40D-AM-1013-04	40D	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9555255950648 40.7977720808005)
2065	2065	-73.9768411547701	40.7741377018895	9A-AM-1013-03	09A	AM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9768411547701 40.7741377018895)
2126	2126	-73.96126235775479	40.7911558714527	32D-AM-1013-02	32D	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9612623577548 40.7911558714527)
2161	2161	-73.9715375915057	40.7751212088827	12D-AM-1013-01	12D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9715375915057 40.7751212088827)
2179	2179	-73.95596639495109	40.7974497269789	40D-AM-1013-07	40D	AM	10132018	7	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	1		0	0	0	0	0	0	0	1	curious	POINT (-73.9559663949511 40.7974497269789)
2186	2186	-73.9561103688639	40.794914085004	37E-AM-1013-03	37E	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9561103688639 40.794914085004)
2202	2202	-73.95560399976209	40.7977549157287	40D-AM-1013-05	40D	AM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9556039997621 40.7977549157287)
2242	2242	-73.9565824187667	40.797312050952	40D-AM-1013-06	40D	AM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		1	0	1	0	1		1	0	0	0	1	0	0	1		POINT (-73.9565824187667 40.797312050952)
2275	2275	-73.96142184133559	40.793894505879294	34B-AM-1013-01	34B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	hopping	0	0	0	0	1	1	0	0		POINT (-73.9614218413356 40.7938945058793)
2284	2284	-73.9730181306326	40.779460132242704	16A-AM-1013-02	16A	AM	10132018	2	Adult	Black		Black+		Above Ground			0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9730181306326 40.7794601322427)
2409	2409	-73.97259471799521	40.7794481577234	16A-AM-1013-01	16A	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9725947179952 40.7794481577234)
2411	2411	-73.9686907918759	40.7839462261858	22B-AM-1013-03	22B	AM	10132018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686907918759 40.7839462261858)
2446	2446	-73.95227045119691	40.796566887896105	41G-AM-1013-01	41G	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9522704511969 40.7965668878961)
2473	2473	-73.9613347295946	40.7938900965153	34B-AM-1013-02	34B	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9613347295946 40.7938900965153)
2585	2585	-73.9771726831497	40.7732320781799	8A-AM-1013-01	08A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	trail	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9771726831497 40.7732320781799)
2848	2848	-73.97159771705479	40.774217265062205	11E-AM-1013-03	11E	AM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9715977170548 40.774217265062205)
2969	2969	-73.9654409838612	40.7901338748522	29A-AM-1013-01	29A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	climbed tree (oak)	0	0	0	0	1	0	0	1		POINT (-73.9654409838612 40.7901338748522)

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