2018_Central_Park_Squirrel_Census_-_Squirrel_Data

33 rows where Foraging = 1, Highlight Fur Color = "Cinnamon, White", Indifferent = 0 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

- 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, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Tail twitches, Approaches, 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
60	60	-73.9768674812942	40.7735232648872	8B-PM-1012-02	08B	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hiding in bushes	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9768674812942 40.7735232648872)
119	119	-73.9592038887673	40.796382675378	38B-PM-1018-02	38B	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	burying nut	0	0	0	0	0	0	0	0		POINT (-73.9592038887673 40.796382675378)
162	162	-73.957219204335	40.7931529059779	35E-PM-1006-01	35E	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	looking/begging for food	POINT (-73.957219204335 40.7931529059779)
246	246	-73.9779805668091	40.768093156679704	2D-PM-1012-02	02D	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9779805668091 40.7680931566797)
270	270	-73.9767191629692	40.7730786298701	8B-PM-1012-03	08B	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9767191629692 40.7730786298701)
274	274	-73.9639832886071	40.7909532437095	30B-PM-1019-08	30B	PM	10192018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9639832886071 40.7909532437095)
362	362	-73.9571407991577	40.793191739640605	35E-PM-1006-02	35E	PM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	begging for food	POINT (-73.9571407991577 40.7931917396406)
482	482	-73.97217978245759	40.7801213843628	16A-PM-1019-07	16A	PM	10192018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0	approaches (very friendly)	POINT (-73.9721797824576 40.7801213843628)
523	523	-73.9793103340869	40.767820153596794	1C-PM-1013-06	01C	PM	10132018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9793103340869 40.76782015359681)
540	540	-73.97468021940121	40.7731347452245	9C-PM-1006-01	09C	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9746802194012 40.7731347452245)
740	740	-73.95834778506341	40.7914073632782	33F-PM-1012-06	33F	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	1	1		1	0	0	0	1	0	0	0		POINT (-73.9583477850634 40.7914073632782)
870	870	-73.97187204036571	40.770233505633705	7G-PM-1018-04	07G	PM	10182018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9718720403657 40.7702335056337)
964	964	-73.9631045499811	40.790618096947206	30B-PM-1019-04	30B	PM	10192018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9631045499811 40.7906180969472)
1462	1462	-73.9584064203778	40.7912272455454	33F-PM-1012-04	33F	PM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	1		POINT (-73.9584064203778 40.7912272455454)
1655	1655	-73.96957001271599	40.7816501516863	19B-PM-1018-04	19B	PM	10182018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.969570012716 40.7816501516863)
1669	1669	-73.9691821206863	40.776320316433896	14F-PM-1012-03	14F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9691821206863 40.7763203164339)
1866	1866	-73.96360276644391	40.790075966587	30B-PM-1019-01	30B	PM	10192018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	1		POINT (-73.9636027664439 40.790075966587)
1950	1950	-73.96430161168391	40.7904796216068	30B-PM-1019-05	30B	PM	10192018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1	hiding a nut	0	0	0	0	1	0	0	1		POINT (-73.9643016116839 40.7904796216068)
1953	1953	-73.9644974196807	40.7810020292593	20G-PM-1013-02	20G	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.96449741968071 40.7810020292593)
2019	2019	-73.9566705412766	40.7935560645735	36F-PM-1012-01	36F	PM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	Near rock	0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9566705412766 40.7935560645735)
2082	2082	-73.9696802053043	40.781605740612505	19B-PM-1018-03	19B	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9696802053043 40.7816057406125)
2090	2090	-73.9569759970802	40.7931497452294	35F-PM-1012-03	35F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9569759970802 40.79314974522941)
2333	2333	-73.9771924901559	40.766672272947105	1E-PM-1007-01	01E	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	people feeding squirrel	POINT (-73.9771924901559 40.7666722729471)
2428	2428	-73.9755643404768	40.769756914938796	5E-PM-1012-03	05E	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9755643404768 40.7697569149388)
2511	2511	-73.95845615374209	40.791121116475395	33F-PM-1012-02	33F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	1	0	0	0		POINT (-73.9584561537421 40.7911211164754)
2556	2556	-73.96398284313679	40.7910151996207	30B-PM-1019-09	30B	PM	10192018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9639828431368 40.7910151996207)
2610	2610	-73.9713379914423	40.7696367609606	7H-PM-1006-01	07H	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	middle of grass	0	0	0	1	1		0	0	0	0	1	1	0	0		POINT (-73.9713379914423 40.7696367609606)
2644	2644	-73.97754454411941	40.7697096533728	4C-PM-1010-13	04C	PM	10102018	13	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9775445441194 40.7697096533728)
2673	2673	-73.9768867959365	40.7734803954589	8B-PM-1012-01	08B	PM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9768867959365 40.7734803954589)
2858	2858	-73.9728723853967	40.7670816164986	4H-PM-1006-01	04H	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9728723853967 40.7670816164986)
2873	2873	-73.955068474109	40.79117881528779	34H-PM-1006-05	34H	PM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	white tail tip	Ground Plane	FALSE	in grass	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.955068474109 40.7911788152878)
2901	2901	-73.9735833104203	40.7786318041581	14A-PM-1014-08	14A	PM	10142018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	new movement flailing arms while foraging	0	0	0	0	0	0	0	1		POINT (-73.9735833104203 40.7786318041581)
2931	2931	-73.9730926233232	40.7781330751738	14B-PM-1014-08	14B	PM	10142018	8		Gray	Cinnamon, White	Gray+Cinnamon, White	White belly & stripes on tail, Cinnamon face & stripes on back	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9730926233232 40.7781330751738)

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