2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Eating = 1, Indifferent = 1, Shift = "AM" and Tail twitches = 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, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Foraging, Tail flags, Approaches

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
203	203	-73.96387745795491	40.79135321291479	31A-AM-1010-05	31A	AM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1	jumping	0	0	0	1	1	0	1	0	eventually ran from lawnmower (tail flag)	POINT (-73.9638774579549 40.7913532129148)
304	304	-73.9523001834395	40.7949231000186	39H-AM-1007-02	39H	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9523001834395 40.7949231000186)
450	450	-73.96442931957729	40.7813829172072	21F-AM-1018-02	21F	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9644293195773 40.7813829172072)
668	668	-73.9706903740547	40.7726873760687	10G-AM-1006-07	10G	AM	10062018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9706903740547 40.77268737606871)
676	676	-73.9710207438538	40.7682187144432	5I-AM-1010-05	05I	AM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9710207438538 40.7682187144432)
719	719	-73.96268812347421	40.7905208345549	30C-AM-1014-01	30C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9626881234742 40.7905208345549)
756	756	-73.9773079154219	40.7696506688861	4C-AM-1006-02	04C	AM	10062018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9773079154219 40.7696506688861)
816	816	-73.9785300509908	40.772112774842704	6A-AM-1006-07	06A	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9785300509908 40.7721127748427)
860	860	-73.97135191580271	40.7798470142991	17B-AM-1010-01	17B	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9713519158027 40.7798470142991)
895	895	-73.97868986562791	40.7720833097065	6A-AM-1006-08	06A	AM	10062018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9786898656279 40.77208330970651)
1062	1062	-73.957259673402	40.7974442913898	39C-AM-1017-02	39C	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.957259673402 40.7974442913898)
1091	1091	-73.97055600790999	40.7698499183436	7H-AM-1006-07	07H	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon					0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.97055600791 40.7698499183436)
1169	1169	-73.9570391901515	40.7930697207834	35F-AM-1007-01	35F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9570391901515 40.7930697207834)
1349	1349	-73.9806805581636	40.7681537966505	1B-AM-1012-16	01B	AM	10122018	16	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9806805581636 40.7681537966505)
1492	1492	-73.9807078515193	40.768333529264204	2A-AM-1010-04	02A	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9807078515193 40.7683335292642)
1709	1709	-73.9771696835698	40.76970111004871	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771696835698 40.7697011100487)
1885	1885	-73.9594174605642	40.7973128653773	38B-AM-1019-02	38B	AM	10192018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9594174605642 40.7973128653773)
2151	2151	-73.96971787697879	40.77915441024221	17D-AM-1008-03	17D	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.96971787697882 40.7791544102422)
2202	2202	-73.95560399976209	40.7977549157287	40D-AM-1013-05	40D	AM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9556039997621 40.7977549157287)
2219	2219	-73.9709242364673	40.7684217215595	5I-AM-1010-04	05I	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9709242364673 40.7684217215595)
2221	2221	-73.9771847728747	40.769597116498105	4C-AM-1006-01	04C	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771847728747 40.7695971164981)
2255	2255	-73.96429678758571	40.78156523539371	21F-AM-1018-08	21F	AM	10182018	8	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9642967875857 40.7815652353937)
2433	2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	3		0	0	0	1	0		0	0	0	1	1	0	1	0		POINT (-73.9706949930717 40.772362045852)
2489	2489	-73.9663168490265	40.7825083721362	21D-AM-1008-01	21D	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	1	0	1	0		POINT (-73.9663168490265 40.7825083721362)
2641	2641	-73.96155167034941	40.790521938835894	31D-AM-1014-04	31D	AM	10142018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE	Open ground	1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9615516703494 40.7905219388359)
2736	2736	-73.95938952535009	40.797308584408704	38B-AM-1019-03	38B	AM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9593895253501 40.7973085844087)
2739	2739	-73.9681960138614	40.7726867422002	11H-AM-1010-02	11H	AM	10102018	2		Cinnamon	Gray	Cinnamon+Gray					0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9681960138614 40.7726867422002)
2816	2816	-73.9809342290598	40.7687265606227	2A-AM-1010-05	02A	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	base of tree with ~ 30 small birds all eating	0	0	0	1	1		0	0	0	0	1	1	1	0		POINT (-73.9809342290598 40.7687265606227)

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