2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Approaches = 1, Location = "Above Ground" and Primary Fur Color = "Gray"

- 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, Date, Hectare Squirrel Number, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Tail twitches

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
271	271	-73.9661262885099	40.7844085550945	23D-AM-1013-01	23D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		0	0	1	0	0		0	0	0	0	0	1	0	0	approaches (he saw me,came towards,then darted up)	POINT (-73.9661262885099 40.7844085550945)
797	797	-73.969345754447	40.7770429650288	15E-AM-1013-02	15E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		1	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.969345754447 40.7770429650288)
917	917	-73.9676514056678	40.7730853732876	11H-AM-1010-01	11H	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	20		0	0	1	0	0		0	0	0	0	0	1	0	0	started climbing down to me	POINT (-73.9676514056678 40.7730853732876)
1661	1661	-73.974519308015	40.7691228794395	5E-AM-1008-02	05E	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	trellis	1	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.974519308015 40.7691228794395)
2233	2233	-73.9754709117681	40.7681421869407	3E-AM-1006-08	03E	AM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9754709117681 40.7681421869407)
2380	2380	-73.97613757295049	40.766223189212496	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	1	0		0	0	0	0	0	1	0	0		POINT (-73.9761375729505 40.7662231892125)
2586	2586	-73.9752965316933	40.775253857578896	10B-AM-1006-03	10B	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		In tree	0	0	1	0	0		0	0	0	0	1	1	0	0		POINT (-73.9752965316933 40.7752538575789)
2762	2762	-73.9656324462902	40.783403475308106	22E-PM-1014-02	22E	PM	10142018	2	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.9656324462902 40.7834034753081)
2942	2942	-73.9672063784809	40.7826070395665	21D-PM-1008-01	21D	PM	10082018	1		Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.9672063784809 40.7826070395665)

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