2018_Central_Park_Squirrel_Census_-_Squirrel_Data

21 rows where Date = 10062018, Foraging = 1, Runs from = 1 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Indifferent

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
134	134	-73.9575943815564	40.7933755266787	35E-PM-1006-07	35E	PM	10062018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9575943815564 40.7933755266787)
504	504	-73.95334760207359	40.7933003544685	37H-PM-1006-02	37H	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	tree	1	0	1	0	1		1	0	0	0	0	0	0	1	dogs	POINT (-73.9533476020736 40.7933003544685)
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)
550	550	-73.9714465493257	40.7772135587308	14C-PM-1006-02	14C	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9714465493257 40.7772135587308)
658	658	-73.9704575848926	40.7693499326095	7H-PM-1006-09	07H	PM	10062018	9	Adult	Black		Black+		Ground Plane	FALSE	by tree	0	0	0	1	1		0	0	0	1	0	1	0	1		POINT (-73.9704575848926 40.7693499326095)
697	697	-73.97046560040201	40.770112577324795	7H-PM-1006-05	07H	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Ran across path to eat behind fence, next to the fence.	1	0	0	1	1		0	0	0	0	1	0	0	1		POINT (-73.970465600402 40.7701125773248)
730	730	-73.9607280801601	40.7901506706248	31D-PM-1006-01	31D	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0	0	0	1		POINT (-73.9607280801601 40.7901506706248)
774	774	-73.9673603655908	40.787697417778205	26A-PM-1006-03	26A	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9673603655908 40.7876974177782)
825	825	-73.9580105174865	40.7974468322692	39C-PM-1006-03	39C	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9580105174865 40.7974468322692)
1106	1106	-73.97029709193171	40.7696883113413	7H-PM-1006-08	07H	PM	10062018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass	0	0	0	0	1		0	0	0	0	1	1	0	1		POINT (-73.9702970919317 40.7696883113413)
1107	1107	-73.95307395621309	40.7932034409546	37H-PM-1006-01	37H	PM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1	from voice	POINT (-73.95307395621312 40.7932034409546)
1334	1334	-73.957134662576	40.7872395604122	30I-PM-1006-07	30I	PM	10062018	7	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.957134662576 40.7872395604122)
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)
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)
1678	1678	-73.95687265085459	40.7878795081255	30I-PM-1006-03	30I	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1	up tree	POINT (-73.9568726508546 40.7878795081255)
1700	1700	-73.965675791028	40.7887310058451	27B-PM-1006-02	27B	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE	By large tree chasing #1	0	1	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.965675791028 40.7887310058451)
1776	1776	-73.9562350820255	40.7913464147989	34G-PM-1006-02	34G	PM	10062018	2	Adult	Gray		Gray+		Above Ground	6		0	0	1	1	1	eating bread it found on ground	0	0	0	0	0	0	0	1		POINT (-73.9562350820255 40.7913464147989)
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)
2329	2329	-73.9717515173863	40.7747999274418	11D-PM-1006-04	11D	PM	10062018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9717515173863 40.7747999274418)
2345	2345	-73.965738547469	40.78869627401671	27B-PM-1006-01	27B	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE	By large tree	0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.965738547469 40.7886962740167)
2782	2782	-73.9563473341712	40.7893712398425	32H-PM-1006-03	32H	PM	10062018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	1	0	1		POINT (-73.9563473341712 40.78937123984251)

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