2018_Central_Park_Squirrel_Census_-_Squirrel_Data

36 rows where Climbing = 0, Foraging = 0, Hectare Squirrel Number = 6 and Indifferent = 1

- 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, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Tail flags, Tail twitches, 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
44	44	-73.970252675331	40.7705999588222	8H-AM-1017-06	08H	AM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.970252675331 40.77059995882221)
47	47	-73.9640032826529	40.782030982544796	22F-PM-1014-06	22F	PM	10142018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9640032826529 40.7820309825448)
81	81	-73.9578237168359	40.7980959471034	40B-PM-1014-06	40B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9578237168359 40.7980959471034)
352	352	-73.970540988328	40.769810306706205	7H-AM-1006-06	07H	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.970540988328 40.7698103067062)
458	458	-73.97357503529591	40.7694500333777	6F-PM-1008-06	06F	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	White patches. Almost looks like fox squirrel				0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9735750352959 40.7694500333777)
495	495	-73.9801007327506	40.7677455633932	1B-PM-1019-06	01B	PM	10192018	6	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9801007327506 40.7677455633932)
573	573	-73.9674688433583	40.7789728381912	17E-AM-1017-06	17E	AM	10172018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9674688433583 40.7789728381912)
576	576	-73.96220476777009	40.7945126358465	35A-AM-1014-06	35A	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9622047677701 40.7945126358465)
725	725	-73.9689627791	40.776062004359005	14F-AM-1007-06	14F	AM	10072018	6	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689627791 40.776062004359)
799	799	-73.9529413156461	40.7920963446605	36I-PM-1007-06	36I	PM	10072018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9529413156461 40.7920963446605)
814	814	-73.9607608482656	40.7954687648248	36A-PM-1013-06	36A	PM	10132018	6		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	EDGE OF WOODS	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9607608482656 40.7954687648248)
818	818	-73.96087574240521	40.790668650465705	31D-AM-1014-06	31D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9608757424052 40.7906686504657)
988	988	-73.97870401924729	40.767901024728104	2C-AM-1010-06	02C	AM	10102018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	stood still & watched me then jumped on a fence and ran away	0	0	0	0	0	0	1	1		POINT (-73.9787040192473 40.7679010247281)
1049	1049	-73.9564606426367	40.788054657260794	30I-PM-1006-06	30I	PM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	1	ran up tree	POINT (-73.9564606426367 40.7880546572608)
1074	1074	-73.9724657562746	40.7658015504376	3I-PM-1013-06	03I	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9724657562746 40.7658015504376)
1233	1233	-73.9722281263634	40.770408328801295	7G-AM-1010-06	07G	AM	10102018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9722281263634 40.7704083288013)
1770	1770	-73.97281709807791	40.770355783043705	7F-AM-1008-06	07F	AM	10082018	6	Adult	Gray		Gray+		Above Ground	28	in hole in tree	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9728170980779 40.770355783043705)
1815	1815	-73.96032682553171	40.7900154505092	31E-PM-1006-06	31E	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9603268255317 40.7900154505092)
1948	1948	-73.9738410069766	40.7691686156505	5F-PM-1007-06	05F	PM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	jumping on fence	0	0	0	0	1	0	1	0		POINT (-73.9738410069766 40.7691686156505)
1963	1963	-73.96515918613991	40.781183828857	20F-PM-1007-06	20F	PM	10072018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9651591861399 40.781183828857)
1966	1966	-73.97509119964991	40.772244521017896	8C-PM-1013-06	08C	PM	10132018	6		Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9750911996499 40.7722445210179)
2007	2007	-73.9684834138222	40.772428912021105	11H-AM-1010-06	11H	AM	10102018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9684834138222 40.7724289120211)
2025	2025	-73.97665418790059	40.7674077265375	2E-AM-1010-06	02E	AM	10102018	6	Adult	Cinnamon		Cinnamon+		Above Ground	35		0	0	0	0	0	leaping branch to branch	0	0	0	0	0	0	1	0		POINT (-73.9766541879006 40.7674077265375)
2052	2052	-73.97464934414141	40.7750478734868	11B-PM-1014-06	11B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	0	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.9746493441414 40.7750478734868)
2141	2141	-73.97870151846621	40.7690114585688	3B-PM-1007-06	03B	PM	10072018	6	Juvenile			+					0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9787015184662 40.7690114585688)
2190	2190	-73.9657040391563	40.7755567428199	15I-AM-1008-06	15I	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9657040391563 40.7755567428199)
2203	2203	-73.97105314852979	40.7773757069445	14D-PM-1019-06	14D	PM	10192018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.97105314852982 40.777375706944504)
2247	2247	-73.95595201371721	40.7950536287174	38E-AM-1010-06	38E	AM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #7	0	0	0	0	1	0	1	0		POINT (-73.95595201371721 40.7950536287174)
2385	2385	-73.9787552947847	40.7690779628762	3B-AM-1010-06	03B	AM	10102018	6	Adult	Gray		Gray+		Above Ground	20		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9787552947847 40.7690779628762)
2410	2410	-73.97551920769341	40.7664413570796	2F-PM-1014-06	02F	PM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755192076934 40.7664413570796)
2635	2635	-73.97638367403421	40.7706121151491	5C-AM-1006-06	05C	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9763836740342 40.7706121151491)
2725	2725	-73.9658867660358	40.7756523577509	15H-PM-1008-06	15H	PM	10082018	6	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	base of gingko tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9658867660358 40.7756523577509)
2845	2845	-73.9765016413674	40.77406728629529	9A-AM-1013-06	09A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765016413674 40.7740672862953)
2855	2855	-73.9690832219322	40.782343340985996	20B-PM-1013-06	20B	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.96908322193221 40.782343340986)
2935	2935	-73.96045994773449	40.7915035010169	32D-PM-1006-06	32D	PM	10062018	6	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9604599477345 40.7915035010169)
2980	2980	-73.97164145863809	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	running (from birds)	0	0	0	1	0	0	1	0		POINT (-73.9716414586381 40.771760114722)

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