2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Date = 10082018, Foraging = 0 and Highlight Fur Color = "White"

- 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, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, 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
63	63	-73.9745630038492	40.7692602628745	5E-AM-1008-06	05E	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.9745630038492 40.7692602628745)
80	80	-73.9688454483585	40.78453012881629	22A-AM-1008-05	22A	AM	10082018	5	Adult	Gray	White	Gray+White		Above Ground	3	trash can	0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9688454483585 40.7845301288163)
382	382	-73.9735946835545	40.7724155751282	8E-PM-1008-01	08E	PM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by tree trunk base	0	0	0	1	0		0	0	0	0	0	1	0	0	eating food being thrown at it by a mom & baby	POINT (-73.9735946835545 40.7724155751282)
426	426	-73.9741944367138	40.7769889953596	13B-PM-1008-01	13B	PM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on railing	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9741944367138 40.7769889953596)
464	464	-73.96644503991209	40.788784490469496	27A-AM-1008-02	27A	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664450399121 40.7887844904695)
732	732	-73.9695041366722	40.779787880948206	17D-AM-1008-02	17D	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695041366722 40.7797878809482)
773	773	-73.95661891453521	40.7883417969746	31H-PM-1008-01	31H	PM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9566189145352 40.7883417969746)
792	792	-73.97301156879641	40.7741018274312	10D-AM-1008-05	10D	AM	10082018	5	Juvenile	Gray	White	Gray+White		Above Ground	25		0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.9730115687964 40.7741018274312)
879	879	-73.9735120882106	40.7715915415169	8E-PM-1008-07	08E	PM	10082018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE	5, 6, 7 all at same tree trunk base	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9735120882106 40.7715915415169)
1116	1116	-73.9729847109778	40.774070904960205	10D-AM-1008-03	10D	AM	10082018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9729847109778 40.7740709049602)
1290	1290	-73.96681408040659	40.77681001473329	15G-AM-1008-06	15G	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9668140804066 40.7768100147333)
1430	1430	-73.970804709441	40.7758611111219	13E-PM-1008-01	13E	PM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.970804709441 40.7758611111219)
1439	1439	-73.9729645190377	40.7723310150843	9E-AM-1008-02	09E	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9729645190377 40.7723310150843)
1534	1534	-73.9695226023739	40.7797527775804	17D-AM-1008-01	17D	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695226023739 40.7797527775804)
1545	1545	-73.9669207809051	40.779276785012605	18F-PM-1008-01	18F	PM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9669207809051 40.7792767850126)
1644	1644	-73.9734654671008	40.7715988711659	8E-PM-1008-06	08E	PM	10082018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	5, 6, 7 all at same tree trunk base	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9734654671008 40.7715988711659)
1663	1663	-73.96967203626271	40.779185159819704	17D-AM-1008-04	17D	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9696720362627 40.7791851598197)
1984	1984	-73.9739249209875	40.7768528386853	13B-PM-1008-02	13B	PM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9739249209875 40.7768528386853)
2005	2005	-73.9755259087781	40.770725612418104	6D-AM-1008-01	06D	AM	10082018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		0	0	1	1	0		1	0	0	0	0	1	0	0		POINT (-73.9755259087781 40.7707256124181)
2151	2151	-73.96971787697879	40.77915441024221	17D-AM-1008-03	17D	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.96971787697882 40.7791544102422)
2190	2190	-73.9657040391563	40.7755567428199	15I-AM-1008-06	15I	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9657040391563 40.7755567428199)
2268	2268	-73.9590191655172	40.7926139425111	34D-AM-1008-03	34D	AM	10082018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9590191655172 40.7926139425111)
2340	2340	-73.9730284815849	40.7702462529502	7F-AM-1008-04	07F	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	bush	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9730284815849 40.7702462529502)
2355	2355	-73.9728654439465	40.7724853142211	9E-AM-1008-04	09E	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9728654439465 40.7724853142211)
2526	2526	-73.96464954504991	40.7791203699027	19H-PM-1008-01	19H	PM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9646495450499 40.7791203699027)
2528	2528	-73.96765297807241	40.7823206990549	21D-PM-1008-03	21D	PM	10082018	3	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676529780724 40.7823206990549)
2706	2706	-73.9745141185576	40.76914797812071	5E-AM-1008-01	05E	AM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on a checker table	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9745141185576 40.7691479781207)
2713	2713	-73.9687214684206	40.779284172016396	17D-AM-1008-07	17D	AM	10082018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9687214684206 40.7792841720164)
2886	2886	-73.9729265300533	40.774176829164205	10D-AM-1008-02	10D	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9729265300533 40.7741768291642)

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