2018_Central_Park_Squirrel_Census_-_Squirrel_Data

13 rows where Eating = 0 and Hectare = "33I"

- 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, Date, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail twitches, 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
279	279	-73.9550082056509	40.7894521543449	33I-AM-1008-03	33I	AM	10082018	3	Adult	Gray		Gray+		Above Ground	2	98th @ edge of park	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9550082056509 40.7894521543449)
322	322	-73.9546042927016	40.7898133734952	33I-PM-1006-07	33I	PM	10062018	7	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9546042927016 40.7898133734952)
546	546	-73.9547423290276	40.7899702628835	33I-PM-1006-09	33I	PM	10062018	9	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9547423290276 40.7899702628835)
1458	1458	-73.9545037193355	40.7900225055417	33I-PM-1006-04	33I	PM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9545037193355 40.7900225055417)
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)
1486	1486	-73.9545807749923	40.790050753764895	33I-PM-1006-02	33I	PM	10062018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9545807749923 40.7900507537649)
1679	1679	-73.9545399102352	40.7898646267709	33I-PM-1006-06	33I	PM	10062018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545399102352 40.7898646267709)
1820	1820	-73.9546337446865	40.7898772579576	33I-PM-1006-08	33I	PM	10062018	8	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9546337446865 40.7898772579576)
1920	1920	-73.95453837191879	40.7899711263765	33I-PM-1006-03	33I	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.95453837191882 40.7899711263765)
1993	1993	-73.9546367558712	40.789840987798	33I-AM-1008-04	33I	AM	10082018	4	Adult			+		Above Ground	100		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9546367558712 40.789840987798)
2146	2146	-73.95473986848171	40.7896483795302	33I-AM-1008-01	33I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park @ 98th (north)	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9547398684817 40.7896483795302)
2258	2258	-73.95477850811709	40.789612183711	33I-AM-1008-02	33I	AM	10082018	2	Adult	Gray		Gray+		Above Ground	3	edge of park @ 98th	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9547785081171 40.789612183711)
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
);