2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Date = 10102018, Foraging = 0, Indifferent = 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, Eating, Kuks, Quaas, 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
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)
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)
317	317	-73.9545799024508	40.7908084039886	34I-PM-1010-01	34I	PM	10102018	1	Adult	Gray		Gray+		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545799024508 40.7908084039886)
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)
522	522	-73.97738211356109	40.769045349438294	4C-PM-1010-06	04C	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	behind playground benches	0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9773821135611 40.7690453494383)
572	572	-73.97636222692721	40.7704671295941	5C-PM-1010-10	05C	PM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0	fed by woman	POINT (-73.9763622269272 40.7704671295941)
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)
678	678	-73.977447585355	40.769716782800295	4C-PM-1010-11	04C	PM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.977447585355 40.7697167828003)
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)
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)
1361	1361	-73.961934398055	40.79247895485221	33B-PM-1010-07	33B	PM	10102018	7	Adult			+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.961934398055 40.7924789548522)
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)
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)
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)
2229	2229	-73.9620719414292	40.788637452988	29D-PM-1010-02	29D	PM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9620719414292 40.788637452988)
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)
2575	2575	-73.97357533521291	40.7687061447032	5G-PM-1010-04	05G	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9735753352129 40.7687061447032)
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)
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)
2912	2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9632164738341 40.7921270121312)
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)

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