2018_Central_Park_Squirrel_Census_-_Squirrel_Data

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

- 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, Climbing, 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
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)
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)
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)
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)
1043	1043	-73.9758564394842	40.7674758942811	3E-AM-1006-05	03E	AM	10062018	5	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9758564394842 40.7674758942811)
1196	1196	-73.95801114962751	40.7985365971474	40B-AM-1019-05	40B	AM	10192018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	1	0		POINT (-73.9580111496275 40.7985365971474)
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)
1394	1394	-73.95488263914001	40.7959474571251	39F-AM-1014-05	39F	AM	10142018	5	Juvenile	Cinnamon		Cinnamon+		Above Ground	2	up/down tree	1	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.95488263914 40.7959474571251)
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)
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)
2135	2135	-73.9596251284566	40.7916254797561	33D-AM-1017-05	33D	AM	10172018	5	Adult	Black		Black+		Above Ground	5		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9596251284566 40.7916254797561)
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)
2486	2486	-73.9766317094163	40.7734230472026	8B-AM-1007-05	08B	AM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9766317094163 40.7734230472026)
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)
2824	2824	-73.97506180080991	40.773752116709396	9B-AM-1010-05	09B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9750618008099 40.7737521167094)
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
);