2018_Central_Park_Squirrel_Census_-_Squirrel_Data

26 rows where Date = 10062018, Eating = 0, Hectare Squirrel Number = 1 and Indifferent = 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: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, 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
15	15	-73.9674285955293	40.7829723919744	21C-PM-1006-01	21C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	1	1	0	0	0		POINT (-73.9674285955293 40.7829723919744)
78	78	-73.964474836001	40.7883840104749	28C-PM-1006-01	28C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	gathering acorns	0	0	0	1	0	0	0	1	gnd to tree	POINT (-73.964474836001 40.7883840104749)
91	91	-73.95659058682759	40.7895654068546	32H-PM-1006-01	32H	PM	10062018	1		Gray		Gray+		Above Ground		in the European Beech	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565905868276 40.7895654068546)
137	137	-73.97824171151392	40.77246650364471	7A-AM-1006-01	07A	AM	10062018	1	Adult	Gray	White	Gray+White		Above Ground	10	in tree	0	0	0	0	1		0	1	0	0	1	0	0	0	looked at us	POINT (-73.9782417115139 40.7724665036447)
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)
479	479	-73.95694033658471	40.795659960879796	38D-PM-1006-01	38D	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	didn't see me or others	POINT (-73.9569403365847 40.7956599608798)
528	528	-73.9647284206644	40.7839611840884	23E-PM-1006-01	23E	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on a tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9647284206644 40.7839611840884)
675	675	-73.9759830650957	40.7683034739069	3E-AM-1006-01	03E	AM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9759830650957 40.7683034739069)
837	837	-73.9557172336815	40.79211256577221	35G-PM-1006-01	35G	PM	10062018	1	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9557172336815 40.7921125657722)
872	872	-73.9551524422379	40.7910535596756	34H-PM-1006-01	34H	PM	10062018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9551524422379 40.7910535596756)
1004	1004	-73.9670850805619	40.7833747810387	22C-PM-1006-01	22C	PM	10062018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0	for food	0	1	0	0	0	0	0	0		POINT (-73.9670850805619 40.7833747810387)
1305	1305	-73.9569324958684	40.7877748374259	30I-PM-1006-01	30I	PM	10062018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	sitting there	0	0	0	0	0	0	0	1		POINT (-73.9569324958684 40.78777483742591)
1373	1373	-73.956737220098	40.797580989254996	40C-PM-1006-01	40C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.95673722009802 40.797580989255)
1440	1440	-73.9748669205206	40.7743879232016	10B-AM-1006-01	10B	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9748669205206 40.7743879232016)
1512	1512	-73.97338823645741	40.768307870659704	5G-AM-1006-01	05G	AM	10062018	1	Adult	Gray	Black	Gray+Black		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	0	made eye contact with me	POINT (-73.9733882364574 40.7683078706597)
1523	1523	-73.9673103881521	40.78742674096179	26A-PM-1006-01	26A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9673103881521 40.7874267409618)
1549	1549	-73.97779784978941	40.7668620784309	1D-AM-1006-01	01D	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	1	0	0	0		POINT (-73.9777978497894 40.7668620784309)
1581	1581	-73.97157754108001	40.7776249963967	14C-PM-1006-01	14C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.97157754108 40.7776249963967)
1685	1685	-73.96788229832741	40.7802960985637	18E-PM-1006-01	18E	PM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9678822983274 40.7802960985637)
1867	1867	-73.9745204169071	40.7736282868469	9C-AM-1006-01	09C	AM	10062018	1	Adult	Gray		Gray+		Above Ground	40	Tree	1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9745204169071 40.7736282868469)
1918	1918	-73.9632866142841	40.7890043294436	29C-PM-1006-01	29C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	0	not too shy	POINT (-73.96328661428412 40.78900432944361)
2044	2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	1	0	0		POINT (-73.9771552326199 40.7706917595308)
2067	2067	-73.97250779335741	40.7654562710325	2I-PM-1006-01	02I	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	2	Sitting on back of bench with food hanging from mouth	0	0	0	0	0	staring at me	0	0	0	0	0	0	0	1		POINT (-73.9725077933574 40.7654562710325)
2142	2142	-73.95985354257058	40.7915589343685	33D-PM-1006-01	33D	PM	10062018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	1	0	0	0	hanging on fence	1	0	0	1	0	0	0	1		POINT (-73.9598535425706 40.7915589343685)
2150	2150	-73.9557710118271	40.791916118555704	34G-PM-1006-01	34G	PM	10062018	1	Adult	Black		Black+	Skinny, thin tail	Ground Plane	FALSE		0	0	0	0	0	digging	0	0	0	0	0	0	0	0		POINT (-73.9557710118271 40.7919161185557)
2741	2741	-73.9545877741228	40.79000012103529	33I-PM-1006-01	33I	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9545877741228 40.7900001210353)

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