2018_Central_Park_Squirrel_Census_-_Squirrel_Data

26 rows where Age = "Juvenile", Climbing = 0, Date = 10132018 and Indifferent = 1

- 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, Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, 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
23	23	-73.9638179439747	40.7924173263904	32A-PM-1013-03	32A	PM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9638179439747 40.7924173263904)
149	149	-73.9576349321357	40.7904409912437	32G-PM-1013-03	32G	PM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon belly	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9576349321357 40.7904409912437)
155	155	-73.9522142360388	40.7949598486683	39H-PM-1013-02	39H	PM	10132018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9522142360388 40.7949598486683)
238	238	-73.9760942252437	40.7742035674209	9B-PM-1013-07	09B	PM	10132018	7	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.97609422524371 40.7742035674209)
299	299	-73.9586214081667	40.7937473968735	35D-PM-1013-03	35D	PM	10132018	3	Juvenile	Gray	White	Gray+White	No Tail!	Above Ground	2	bench	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9586214081667 40.7937473968735)
375	375	-73.9752000129992	40.773291812223896	8C-PM-1013-04	08C	PM	10132018	4	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9752000129992 40.7732918122239)
399	399	-73.97634332024009	40.773847349068106	9B-PM-1013-10	09B	PM	10132018	10	Juvenile	Cinnamon	Gray	Cinnamon+Gray	"Brown" written in as Primary	Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9763433202401 40.7738473490681)
423	423	-73.97567542977471	40.7738518843446	9B-PM-1013-02	09B	PM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9756754297747 40.7738518843446)
432	432	-73.9757787135906	40.7737231427345	9B-PM-1013-03	09B	PM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9757787135906 40.7737231427345)
596	596	-73.9769319450348	40.7743883576247	9A-AM-1013-11	09A	AM	10132018	11	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9769319450348 40.7743883576247)
622	622	-73.97548367967059	40.7738879545412	9B-PM-1013-01	09B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	1	0	1	0		POINT (-73.9754836796706 40.7738879545412)
854	854	-73.95771130260559	40.7904332453456	32G-PM-1013-02	32G	PM	10132018	2	Juvenile	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9577113026056 40.7904332453456)
1024	1024	-73.9521514669041	40.7949515182825	39H-PM-1013-03	39H	PM	10132018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	1	1		POINT (-73.9521514669041 40.7949515182825)
1103	1103	-73.9541500874008	40.7920329989756	35H-AM-1013-02	35H	AM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Sitting on tree limb	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0	watching me from tree,but calm	POINT (-73.9541500874008 40.7920329989756)
1189	1189	-73.95776297445391	40.7897460758298	32G-PM-1013-01	32G	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon belly	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	allowed me to approach within 10 ft	POINT (-73.9577629744539 40.789746075829804)
1198	1198	-73.9762187733662	40.7739282973004	9B-PM-1013-08	09B	PM	10132018	8	Juvenile	Cinnamon	Black, White	Cinnamon+Black, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9762187733662 40.7739282973004)
1212	1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9761792189352 40.7745745517215)
1403	1403	-73.9761632586697	40.7741085606149	9B-PM-1013-05	09B	PM	10132018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9761632586697 40.7741085606149)
1705	1705	-73.97654172820009	40.7740994735325	9A-AM-1013-05	09A	AM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765417282001 40.7740994735325)
1836	1836	-73.9751056714758	40.7732060035215	8C-PM-1013-03	08C	PM	10132018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9751056714758 40.7732060035215)
1985	1985	-73.9530791622513	40.79598856039671	40G-PM-1013-03	40G	PM	10132018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9530791622513 40.7959885603967)
2065	2065	-73.9768411547701	40.7741377018895	9A-AM-1013-03	09A	AM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9768411547701 40.7741377018895)
2134	2134	-73.9614373639552	40.7945051962914	35B-PM-1013-01	35B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	did not notice dog sitting a few yards away (10-20 ft)	0	0	0	1	0	0	1	0		POINT (-73.9614373639552 40.7945051962914)
2606	2606	-73.96143417385001	40.794546426211205	35B-PM-1013-02	35B	PM	10132018	2	Juvenile			+		Ground Plane	FALSE		0	0	0	1	0	did not notice dog sitting a few yards away (10-20 ft)	0	0	0	0	1	0	1	0		POINT (-73.96143417385 40.7945464262112)
2845	2845	-73.9765016413674	40.77406728629529	9A-AM-1013-06	09A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765016413674 40.7740672862953)
2919	2919	-73.9768563402344	40.7744487310786	9A-AM-1013-12	09A	AM	10132018	12	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9768563402344 40.7744487310786)

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