2018_Central_Park_Squirrel_Census_-_Squirrel_Data

21 rows where Climbing = 1, Date = 10072018 and Running = 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

- 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, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Eating, Foraging, Quaas, Tail flags, 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
45	45	-73.9579645940414	40.7918613498407	34F-AM-1007-01	34F	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9579645940414 40.7918613498407)
130	130	-73.95816559494371	40.799770819002205	41A-PM-1007-06	41A	PM	10072018	6	Adult	Black		Black+		Ground Plane	FALSE		1	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9581655949437 40.7997708190022)
369	369	-73.9596398997228	40.793338695384705	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black		Black+		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	0	cautiously aware	POINT (-73.9596398997228 40.7933386953847)
373	373	-73.96721272832829	40.7810666805133	20D-AM-1007-01	20D	AM	10072018	1	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		1	0	1	1	0	a lot of activity	0	0	0	1	0	0	0	0		POINT (-73.9672127283283 40.7810666805133)
525	525	-73.952526164386	40.796375924050395	40G-AM-1007-02	40G	AM	10072018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	18		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.952526164386 40.7963759240504)
555	555	-73.9685227310735	40.776599466588	15F-AM-1007-02	15F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685227310735 40.776599466588)
561	561	-73.95819824864691	40.7992194575293	41A-PM-1007-03	41A	PM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	55		1	0	1	0	0		0	0	0	0	1	0	0	0		POINT (-73.95819824864691 40.7992194575293)
674	674	-73.9779811967788	40.7675178797546	2D-AM-1007-01	02D	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779811967788 40.7675178797546)
795	795	-73.9582523503306	40.7996897499473	41A-PM-1007-05	41A	PM	10072018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9582523503306 40.7996897499473)
858	858	-73.96293834202741	40.7889383725489	29C-AM-1007-02	29C	AM	10072018	2	Adult	Black	Gray	Black+Gray		Above Ground	10		1	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.9629383420274 40.7889383725489)
937	937	-73.97063234587691	40.7713196034265	9G-PM-1007-03	09G	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706323458769 40.771319603426505)
1051	1051	-73.96137470327021	40.7920483852431	33C-PM-1007-01	33C	PM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9613747032702 40.792048385243106)
1081	1081	-73.9680855277775	40.7769251965381	15F-AM-1007-10	15F	AM	10072018	10	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9680855277775 40.7769251965381)
1192	1192	-73.9634811495245	40.790705585077	30B-AM-1007-10	30B	AM	10072018	10	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9634811495245 40.790705585077)
1328	1328	-73.9765758043111	40.771380315403206	6C-AM-1007-03	06C	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	8	another tree	1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765758043111 40.7713803154032)
1925	1925	-73.95813898706442	40.7993081122523	41A-PM-1007-04	41A	PM	10072018	4	Adult	Gray		Gray+		Above Ground	20		1	0	1	0	0	laid down on the branch	0	0	0	0	0	0	0	1		POINT (-73.9581389870644 40.799308112252305)
2210	2210	-73.9699124811406	40.7743016981538	12F-PM-1007-07	12F	PM	10072018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699124811406 40.7743016981538)
2436	2436	-73.95827701417	40.785661023889105	28I-PM-1007-01	28I	PM	10072018	1	Adult	Gray		Gray+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.95827701417 40.7856610238891)
2508	2508	-73.97938145045201	40.770903369788705	4A-PM-1007-01	04A	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1	1		0	0	0	0	1	0	1	0		POINT (-73.979381450452 40.770903369788705)
2776	2776	-73.9789687905912	40.769269313932796	3B-PM-1007-04	03B	PM	10072018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4	At fence	1	0	1	1	0		0	0	0	0	1	0	1	1		POINT (-73.9789687905912 40.7692693139328)
2829	2829	-73.95652309635541	40.798556387711	41C-PM-1007-02	41C	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565230963554 40.798556387711)

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