2018_Central_Park_Squirrel_Census_-_Squirrel_Data

40 rows where Date = 10182018, Eating = 0, Indifferent = 1 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, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, 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
67	67	-73.968381325559	40.7780143443779	16E-PM-1018-06	16E	PM	10182018	6	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	On a rock	0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.968381325559 40.7780143443779)
114	114	-73.971905618214	40.776238547062995	13D-PM-1018-10	13D	PM	10182018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.971905618214 40.776238547063)
164	164	-73.9758676144255	40.7701671581939	5D-PM-1018-03	05D	PM	10182018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9758676144255 40.7701671581939)
182	182	-73.9691050656013	40.780813953822204	18C-PM-1018-01	18C	PM	10182018	1		Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9691050656013 40.7808139538222)
217	217	-73.9712327308512	40.7748702909218	12E-PM-1018-06	12E	PM	10182018	6	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9712327308512 40.7748702909218)
329	329	-73.967832992543	40.778366991340796	17E-PM-1018-03	17E	PM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.967832992543 40.7783669913408)
408	408	-73.9633760173635	40.7818422357619	22G-PM-1018-03	22G	PM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	chilling	0	0	0	0	0	0	1	0	observed	POINT (-73.96337601736352 40.7818422357619)
443	443	-73.9720887275538	40.776079953797606	13D-PM-1018-08	13D	PM	10182018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9720887275538 40.7760799537976)
469	469	-73.9717201378775	40.776120280884	13D-PM-1018-02	13D	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9717201378775 40.776120280884)
556	556	-73.9721670042434	40.776085913838	13D-PM-1018-09	13D	PM	10182018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9721670042434 40.776085913838)
592	592	-73.9712256765283	40.776094287248796	13D-PM-1018-13	13D	PM	10182018	13	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray, Cinnamon & White selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9712256765283 40.7760942872488)
620	620	-73.9655905300923	40.775261463802295	14I-PM-1018-06	14I	PM	10182018	6	Adult	Cinnamon	Black	Cinnamon+Black		Above Ground	2		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9655905300923 40.7752614638023)
710	710	-73.9695569897042	40.771206214717104	9H-PM-1018-01	09H	PM	10182018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96955698970422 40.7712062147171)
884	884	-73.96789372898371	40.7782808361645	16E-PM-1018-01	16E	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9678937289837 40.7782808361645)
938	938	-73.96994511963959	40.7710409982701	9H-PM-1018-02	09H	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9699451196396 40.7710409982701)
1086	1086	-73.9713399316534	40.77506780267571	12E-PM-1018-02	12E	PM	10182018	2	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	3		0	0	1	0	0	lounging on tree upside down	0	0	0	0	1	0	1	0		POINT (-73.9713399316534 40.7750678026757)
1092	1092	-73.9711319254625	40.7760324859879	13D-PM-1018-12	13D	PM	10182018	12	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9711319254625 40.776032485987905)
1133	1133	-73.9712550584322	40.7764273475386	13D-PM-1018-06	13D	PM	10182018	6	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.9712550584322 40.7764273475386)
1262	1262	-73.9683345414813	40.7779016280345	16E-PM-1018-07	16E	PM	10182018	7	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		1	0	0	0	0	0	1	0		POINT (-73.9683345414813 40.7779016280345)
1312	1312	-73.97120343207409	40.7764415506669	13D-PM-1018-05	13D	PM	10182018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	1	0		POINT (-73.9712034320741 40.7764415506669)
1338	1338	-73.9716624574422	40.776203711010105	13D-PM-1018-07	13D	PM	10182018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		1	0	1	0	0	scratching	0	0	0	0	0	0	1	0		POINT (-73.9716624574422 40.7762037110101)
1370	1370	-73.9681627331154	40.7785099665602	17E-PM-1018-02	17E	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE	On the rock	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9681627331154 40.7785099665602)
1393	1393	-73.96871341377859	40.7812207913391	19C-PM-1018-03	19C	PM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9687134137786 40.7812207913391)
1438	1438	-73.97168547522399	40.7706668465923	7G-PM-1018-07	07G	PM	10182018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.971685475224 40.7706668465923)
1454	1454	-73.9753818829907	40.76978409861629	5D-PM-1018-06	05D	PM	10182018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9753818829907 40.7697840986163)
1463	1463	-73.96300972763659	40.7936658446251	33A-PM-1018-04	33A	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9630097276366 40.79366584462511)
1530	1530	-73.96893059787509	40.781815249626604	19C-PM-1018-06	19C	PM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	Climbed fence	1	0	1	0	0	climbing (fence)	0	0	0	0	0	0	1	0		POINT (-73.9689305978751 40.7818152496266)
1531	1531	-73.9630381400083	40.7807571827321	21H-PM-1018-02	21H	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9630381400083 40.7807571827321)
1541	1541	-73.9711617997772	40.7761212878075	13D-PM-1018-04	13D	PM	10182018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9711617997772 40.7761212878075)
1874	1874	-73.96573273328491	40.7747554568985	14I-PM-1018-03	14I	PM	10182018	3	Juvenile	Gray	Black	Gray+Black		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657327332849 40.7747554568985)
1942	1942	-73.96249054313	40.793538903878705	33A-PM-1018-01	33A	PM	10182018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	stopped to see what i would do 1st	POINT (-73.96249054313 40.7935389038787)
2099	2099	-73.9685612289881	40.7778488829217	16E-PM-1018-08	16E	PM	10182018	8	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9685612289881 40.7778488829217)
2171	2171	-73.9686370726471	40.7780382348833	16E-PM-1018-09	16E	PM	10182018	9	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	3	On trunk	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9686370726471 40.7780382348833)
2201	2201	-73.9717135461165	40.7761780680083	13D-PM-1018-01	13D	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9717135461165 40.776178068008306)
2582	2582	-73.9665004148497	40.780565641175606	19E-PM-1018-05	19E	PM	10182018	5		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9665004148497 40.7805656411756)
2612	2612	-73.97116730065241	40.77479796145771	12E-PM-1018-05	12E	PM	10182018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9711673006524 40.7747979614577)
2712	2712	-73.9682760864462	40.778072756941704	16E-PM-1018-04	16E	PM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		1	0	0	0	0	0	1	0		POINT (-73.9682760864462 40.7780727569417)
2822	2822	-73.9711120079542	40.776080191176604	13D-PM-1018-14	13D	PM	10182018	14	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	0	climbing (down)	0	0	0	0	0	0	1	0		POINT (-73.9711120079542 40.7760801911766)
2897	2897	-73.9689554458632	40.777859339395704	16E-PM-1018-10	16E	PM	10182018	10	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689554458632 40.7778593393957)
2960	2960	-73.96252481451499	40.7810022923615	21H-PM-1018-03	21H	PM	10182018	3	Adult	Gray		Gray+		Above Ground	25		0	0	1	0	0		1	0	0	0	0	0	1	0		POINT (-73.962524814515 40.7810022923615)

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