2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Eating = 0, Hectare Squirrel Number = 5, Highlight Fur Color = "White" and Indifferent = 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, Foraging, 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
277	277	-73.96190702296741	40.795255669250004	35A-AM-1014-05	35A	AM	10142018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619070229674 40.79525566925)
590	590	-73.97851333014259	40.77182602883379	6A-PM-1012-05	06A	PM	10122018	5	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9785133301426 40.7718260288338)
887	887	-73.9635028497015	40.7928207574906	32A-PM-1013-05	32A	PM	10132018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9635028497015 40.7928207574906)
1054	1054	-73.9570050460867	40.7985192250745	40C-AM-1017-05	40C	AM	10172018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9570050460867 40.7985192250745)
1157	1157	-73.9704449096084	40.76899707783029	6I-PM-1013-05	06I	PM	10132018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	playing with #6	0	0	0	0	1	0	0	0		POINT (-73.9704449096084 40.7689970778303)
1224	1224	-73.95725308434791	40.7987460430546	41B-AM-1010-05	41B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9572530843479 40.7987460430546)
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)
1292	1292	-73.959019987128	40.791254669180496	33E-PM-1012-05	33E	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	0	0	0	0		POINT (-73.959019987128 40.7912546691805)
1324	1324	-73.954554245377	40.7983935730557	41E-AM-1007-05	41E	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1	man/pit bull mix wandered	POINT (-73.954554245377 40.7983935730557)
1347	1347	-73.9616693665254	40.792971019627	33B-AM-1010-05	33B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616693665254 40.792971019627)
1466	1466	-73.96511776576759	40.7812408103825	20F-PM-1007-05	20F	PM	10072018	5	Juvenile	Gray	White	Gray+White	white tail	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9651177657676 40.781240810382506)
1489	1489	-73.9501762527462	40.797553408607705	42H-PM-1014-05	42H	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	15		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9501762527462 40.7975534086077)
1587	1587	-73.9805517765469	40.7683044693163	2B-PM-1013-05	02B	PM	10132018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0	climbing fence!	0	0	0	0	0	0	0	0	snuck into bike cart!	POINT (-73.9805517765469 40.7683044693163)
1728	1728	-73.9787846880249	40.768254590348796	2C-PM-1013-05	02C	PM	10132018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9787846880249 40.7682545903488)
1758	1758	-73.9581241870185	40.7961057536141	38C-AM-1019-05	38C	AM	10192018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9581241870185 40.7961057536141)
2002	2002	-73.9581706950566	40.790632139726895	32F-AM-1012-05	32F	AM	10122018	5	Adult	Gray	White	Gray+White		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9581706950566 40.7906321397269)
2061	2061	-73.9608834102446	40.790624710005005	31D-AM-1014-05	31D	AM	10142018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9608834102446 40.790624710005)
2084	2084	-73.9567255763265	40.7936331899263	36F-AM-1017-05	36F	AM	10172018	5	Adult	Gray	White	Gray+White		Above Ground	8		0	0	0	0	0	staying very still to avoid two very curious dogs on the ground	0	0	0	0	0	0	0	0	petrified,frozen (tail over its back,frozen)	POINT (-73.9567255763265 40.7936331899263)
2087	2087	-73.956502663005	40.788160908881004	30I-PM-1006-05	30I	PM	10062018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.956502663005 40.788160908881)
2173	2173	-73.95461232594408	40.7941434862099	37G-PM-1007-05	37G	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	jumping around!	0	0	0	0	0	0	0	0		POINT (-73.9546123259441 40.7941434862099)
2767	2767	-73.9751806727197	40.7671940332258	3F-PM-1013-05	03F	PM	10132018	5	Adult	Gray	White	Gray+White		Above Ground	13		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97518067271972 40.7671940332258)
2944	2944	-73.97394038506219	40.769316228750895	5F-AM-1007-05	05F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	2	tree	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9739403850622 40.7693162287509)

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