2018_Central_Park_Squirrel_Census_-_Squirrel_Data

33 rows where Hectare Squirrel Number = 2, Highlight Fur Color = "White", Indifferent = 1 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, Foraging, Tail flags

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
68	68	-73.96942403275091	40.7755898126674	13F-AM-1007-02	13F	AM	10072018	2	Adult	Cinnamon	White	Cinnamon+White					0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96942403275091 40.7755898126674)
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)
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)
694	694	-73.9698032734704	40.7782343912417	16D-AM-1007-02	16D	AM	10072018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9698032734704 40.7782343912417)
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)
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)
1093	1093	-73.9584106786233	40.7902777556926	32F-PM-1008-02	32F	PM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584106786233 40.7902777556926)
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)
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)
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)
1482	1482	-73.95886101956991	40.7945269936639	36C-AM-1014-02	36C	AM	10142018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	Crossing path	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9588610195699 40.7945269936639)
1536	1536	-73.9746128451271	40.770095704670894	6E-PM-1010-02	06E	PM	10102018	2	Adult	Cinnamon	White	Cinnamon+White	white back legs	Ground Plane	FALSE	small open area but w/ 7 large oak trees	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9746128451271 40.7700957046709)
1717	1717	-73.97149520927671	40.7748063281815	12E-AM-1017-02	12E	AM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9714952092767 40.7748063281815)
1873	1873	-73.955754300682	40.795681399740005	38E-PM-1014-02	38E	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955754300682 40.79568139974)
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)
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)
1978	1978	-73.9579689996645	40.794933848991704	37D-AM-1018-02	37D	AM	10182018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9579689996645 40.7949338489917)
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)
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)
2185	2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9707571364399 40.7758859812524)
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)
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)
2594	2594	-73.9638812060405	40.7923714941429	32A-PM-1013-02	32A	PM	10132018	2	?	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9638812060405 40.792371494142905)
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)
2689	2689	-73.97041219894871	40.7824040236981	19A-PM-1013-02	19A	PM	10132018	2	Adult	Gray	White	Gray+White	Looks very brown, not like English red squirrels	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9704121989487 40.7824040236981)
2885	2885	-73.9530811255728	40.7983069118579	42F-AM-1019-02	42F	AM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9530811255728 40.79830691185791)
2887	2887	-73.964593167562	40.7780374890066	18H-PM-1014-02	18H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.964593167562 40.7780374890066)
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
);