2018_Central_Park_Squirrel_Census_-_Squirrel_Data

42 rows where Foraging = 0, Hectare Squirrel Number = 2, Highlight Fur Color = "White" and Tail twitches = 0

- 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: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Quaas, Tail flags, Approaches, 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
167	167	-73.95976427784271	40.7976368003915	39A-PM-1014-02	39A	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9597642778427 40.7976368003915)
189	189	-73.9735489537928	40.76812579115229	4G-AM-1006-02	04G	AM	10062018	2		Gray	White	Gray+White		Above Ground	12	tree	0	0	0	0	0	sitting in tree	0	0	0	0	0	0	1	0		POINT (-73.9735489537928 40.7681257911523)
199	199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		1	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9771614686616 40.7709677983247)
359	359	-73.9716404781264	40.7753181851766	12D-PM-1014-02	12D	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0	seems to be grinding teeth on a piece of material (sounds from grinding)	0	0	0	0	0	0	1	0		POINT (-73.9716404781264 40.7753181851766)
428	428	-73.96362827608	40.780799459524204	21G-AM-1014-02	21G	AM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	3	fence	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.96362827608 40.7807994595242)
464	464	-73.96644503991209	40.788784490469496	27A-AM-1008-02	27A	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664450399121 40.7887844904695)
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)
600	600	-73.9808202088503	40.7682921842325	1A-PM-1014-02	01A	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9808202088503 40.7682921842325)
732	732	-73.9695041366722	40.779787880948206	17D-AM-1008-02	17D	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695041366722 40.7797878809482)
742	742	-73.9767016963397	40.7674012784541	2E-PM-1014-02	02E	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767016963397 40.7674012784541)
1047	1047	-73.9580111056675	40.785433940148295	27I-PM-1020-02	27I	PM	10202018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580111056675 40.7854339401483)
1075	1075	-73.9640534906634	40.777738389983604	17I-AM-1014-02	17I	AM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0	standing upright	0	0	0	0	0	1	0	1	runs from (only ran away when a grandpa chased it off)	POINT (-73.9640534906634 40.7777383899836)
1085	1085	-73.9722265046794	40.7700916895929	7G-PM-1018-02	07G	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9722265046794 40.7700916895929)
1139	1139	-73.9716271494641	40.7796462634184	16B-PM-1017-02	16B	PM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9716271494641 40.7796462634184)
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)
1203	1203	-73.9616999731028	40.7954126939561	36A-AM-1018-02	36A	AM	10182018	2	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9616999731028 40.7954126939561)
1204	1204	-73.97629653413091	40.775112516678	10A-AM-1006-02	10A	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE	Bridle Path lawn	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9762965341309 40.775112516678)
1252	1252	-73.9777998932399	40.770981586533395	5B-PM-1013-02	05B	PM	10132018	2	Adult	Gray	White	Gray+White		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9777998932399 40.7709815865334)
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)
1414	1414	-73.9580513096783	40.79909641532	41B-AM-1010-02	41B	AM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	16		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580513096783 40.79909641532)
1439	1439	-73.9729645190377	40.7723310150843	9E-AM-1008-02	09E	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9729645190377 40.7723310150843)
1561	1561	-73.9642397829547	40.7918992406575	31A-PM-1017-02	31A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.96423978295472 40.7918992406575)
1652	1652	-73.94984217462209	40.7969397424182	42I-PM-1014-02	42I	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	8		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9498421746221 40.7969397424182)
1916	1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	1	0	0	0	0	0	0	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)
1933	1933	-73.95848243616551	40.7934247634031	35D-PM-1013-02	35D	PM	10132018	2	Adult	Gray	White	Gray+White		Above Ground	24		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9584824361655 40.7934247634031)
1956	1956	-73.98089749771201	40.7690578709841	2A-PM-1019-02	02A	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	0		POINT (-73.980897497712 40.7690578709841)
1972	1972	-73.9558370309765	40.7921977208472	35G-AM-1007-02	35G	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9558370309765 40.7921977208472)
1984	1984	-73.9739249209875	40.7768528386853	13B-PM-1008-02	13B	PM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9739249209875 40.7768528386853)
2051	2051	-73.9544808708211	40.7906575852286	34I-AM-1012-02	34I	AM	10122018	2	Adult	Gray	White	Gray+White	Short tail	Ground Plane	FALSE		0	0	0	0	0	hiding	0	0	0	0	0	0	0	1		POINT (-73.9544808708211 40.7906575852286)
2112	2112	-73.9655206571055	40.7764851568746	16H-PM-1014-02	16H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9655206571055 40.7764851568746)
2225	2225	-73.95623234556741	40.7946180656349	37E-AM-1013-02	37E	AM	10132018	2		Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9562323455674 40.79461806563491)
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)
2231	2231	-73.95454276114769	40.793035381744104	36G-PM-1012-02	36G	PM	10122018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545427611477 40.7930353817441)
2249	2249	-73.9785709201168	40.7674391934208	2C-PM-1013-02	02C	PM	10132018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785709201168 40.7674391934208)
2298	2298	-73.97553718499721	40.7733561233828	9C-PM-1006-02	09C	PM	10062018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755371849972 40.7733561233828)
2394	2394	-73.97858295460459	40.7719652299132	6A-PM-1012-02	06A	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785829546046 40.7719652299132)
2444	2444	-73.966590487009	40.780246905289104	19E-PM-1018-02	19E	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	0	0	0		POINT (-73.96659048700901 40.7802469052891)
2551	2551	-73.970138810251	40.770579297644	8H-PM-1014-02	08H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	froze & watched me,then went back to eating	POINT (-73.970138810251 40.770579297644)
2632	2632	-73.95082755733499	40.797579073666	42H-PM-1014-02	42H	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		Running along stone ledge	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.950827557335 40.797579073666)
2688	2688	-73.9799302952205	40.767720720979796	1B-PM-1019-02	01B	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9799302952205 40.7677207209798)
2886	2886	-73.9729265300533	40.774176829164205	10D-AM-1008-02	10D	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9729265300533 40.7741768291642)
2949	2949	-73.9651206201297	40.778527906484705	18G-AM-1014-02	18G	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9651206201297 40.7785279064847)

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