2018_Central_Park_Squirrel_Census_-_Squirrel_Data

45 rows where Date = 10102018, Eating = 0, Foraging = 0 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, Specific Location, Running, Chasing, Climbing, Kuks, 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
19	19	-73.9768603630674	40.7702795904962	5C-PM-1010-09	05C	PM	10102018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9768603630674 40.7702795904962)
111	111	-73.9763243383771	40.770540931570295	5C-PM-1010-13	05C	PM	10102018	13	Adult	Gray	White	Gray+White		Above Ground	20	way up a tree!	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9763243383771 40.7705409315703)
140	140	-73.97686527856641	40.768483816820705	3D-PM-1010-03	03D	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.97686527856641 40.7684838168207)
237	237	-73.96789565689801	40.7767409597341	15F-PM-1010-07	15F	PM	10102018	7	Adult	Gray		Gray+		Above Ground	3	on fence	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.967895656898 40.7767409597341)
256	256	-73.976798124308	40.774131657411296	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon		Cinnamon+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97679812430802 40.7741316574113)
281	281	-73.9619411917909	40.7923536640283	33B-PM-1010-11	33B	PM	10102018	11	Adult	Gray		Gray+		Above Ground	10		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9619411917909 40.7923536640283)
434	434	-73.96766397404859	40.7745369616499	13H-PM-1010-07	13H	PM	10102018	7	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9676639740486 40.7745369616499)
520	520	-73.97494466297059	40.77206596960671	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9749446629706 40.7720659696067)
602	602	-73.96857515954851	40.7709413567859	9I-PM-1010-07	09I	PM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	1	ran up tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685751595485 40.7709413567859)
609	609	-73.9698762023146	40.778205568811295	16D-PM-1010-09	16D	PM	10102018	9	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9698762023146 40.77820556881131)
690	690	-73.9767949141123	40.774454583585	9A-PM-1010-01	09A	PM	10102018	1	Adult			+		Ground Plane	FALSE	by large tree in sectioned off area	0	0	1	0	0	i think it climbed the tree when i first saw it.	0	0	0	0	0	0	1	0		POINT (-73.9767949141123 40.774454583585)
711	711	-73.97679809251241	40.774362775678	9A-PM-1010-02	09A	PM	10102018	2	Adult			+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767980925124 40.774362775678)
729	729	-73.97760445784459	40.7697607308033	4C-PM-1010-15	04C	PM	10102018	15	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on tree	0	1	0	0	0	chasing #14	0	0	0	0	0	0	1	0		POINT (-73.9776044578446 40.7697607308033)
752	752	-73.9768617690725	40.7741877060705	9A-PM-1010-03	09A	PM	10102018	3		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0	froze - standing on hind legs for ~10 seconds then scampered off	POINT (-73.97686176907251 40.7741877060705)
1084	1084	-73.96988397502491	40.778143307669204	16D-PM-1010-08	16D	PM	10102018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9698839750249 40.7781433076692)
1125	1125	-73.9775735077285	40.7692872082165	4C-PM-1010-08	04C	PM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	on stone arch	1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9775735077285 40.7692872082165)
1154	1154	-73.9786936992465	40.771394367466606	5A-PM-1010-02	05A	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9786936992465 40.7713943674666)
1226	1226	-73.97684509716998	40.7709430375069	5C-PM-1010-07	05C	PM	10102018	7	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	13		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.97684509717 40.7709430375069)
1238	1238	-73.97736921314409	40.767977115014894	3D-PM-1010-02	03D	PM	10102018	2	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9773692131441 40.7679771150149)
1259	1259	-73.976864402584	40.7705663751959	5C-PM-1010-05	05C	PM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.976864402584 40.7705663751959)
1268	1268	-73.96239842629359	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623984262936 40.7913900453449)
1333	1333	-73.9754527701832	40.7656088463928	1G-PM-1010-02	01G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0	laying on tree branch	0	0	0	1	1	0	0	0		POINT (-73.9754527701832 40.7656088463928)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1374	1374	-73.9653739273979	40.788976209696706	28B-PM-1010-02	28B	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653739273979 40.7889762096967)
1406	1406	-73.97462048022209	40.769929484073295	6E-PM-1010-01	06E	PM	10102018	1	Juvenile			+		Ground Plane	FALSE	along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail	0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9746204802221 40.7699294840733)
1645	1645	-73.9619673317128	40.7924176673037	33B-PM-1010-08	33B	PM	10102018	8	Juvenile	Gray		Gray+		Above Ground		running up tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619673317128 40.7924176673037)
1768	1768	-73.97736964550309	40.7687241866704	3D-PM-1010-14	03D	PM	10102018	14	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	0	0	crying out	1	1	0	0	0	0	0	0		POINT (-73.9773696455031 40.7687241866704)
1822	1822	-73.9775099290913	40.76976090631371	4C-PM-1010-14	04C	PM	10102018	14	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	1	0	0	0	chasing #15	0	0	0	0	0	0	0	0		POINT (-73.9775099290913 40.7697609063137)
1824	1824	-73.9617250054003	40.7925390432044	33B-PM-1010-03	33B	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9617250054003 40.7925390432044)
1825	1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
1882	1882	-73.9541601469123	40.7907832744689	34I-PM-1010-04	34I	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE	across the lawn and climb up a small tree	1	0	1	0	0	grooming	0	0	0	0	0	0	0	0		POINT (-73.9541601469123 40.79078327446891)
1890	1890	-73.97877230828071	40.7713655754004	5A-PM-1010-03	05A	PM	10102018	3	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9787723082807 40.7713655754004)
1951	1951	-73.9548431601579	40.7906346271566	34I-PM-1010-02	34I	PM	10102018	2	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9548431601579 40.7906346271566)
1976	1976	-73.9770920860805	40.769469804008295	4C-PM-1010-01	04C	PM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	1	0	0		0	1	0	0	0	0	1	0		POINT (-73.9770920860805 40.7694698040083)
2107	2107	-73.9772624834791	40.769282191854295	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9772624834791 40.7692821918543)
2226	2226	-73.9624296435843	40.791320813687	31C-PM-1010-02	31C	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9624296435843 40.791320813687)
2235	2235	-73.9748522796455	40.771958662100296	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9748522796455 40.7719586621003)
2620	2620	-73.97718000981308	40.7708863131336	5C-PM-1010-03	05C	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9771800098131 40.7708863131336)
2628	2628	-73.9770439076963	40.7685720141731	3D-PM-1010-13	03D	PM	10102018	13	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9770439076963 40.7685720141731)
2735	2735	-73.97680969536471	40.7708185213129	5C-PM-1010-08	05C	PM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9768096953647 40.7708185213129)
2780	2780	-73.9700634278	40.778422372245295	16D-PM-1010-07	16D	PM	10102018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9700634278 40.7784223722453)
2889	2889	-73.9771646835311	40.769304916508396	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9771646835311 40.7693049165084)
2939	2939	-73.9680204438195	40.774388232265395	13H-PM-1010-08	13H	PM	10102018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9680204438195 40.77438823226541)
2956	2956	-73.9654741695628	40.7890427851106	28B-PM-1010-01	28B	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	10	in a tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9654741695628 40.7890427851106)
2970	2970	-73.9619019299709	40.7924476439693	33B-PM-1010-05	33B	PM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9619019299709 40.7924476439693)

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