2018_Central_Park_Squirrel_Census_-_Squirrel_Data

14 rows where Eating = 0, Hectare Squirrel Number = 4, Highlight Fur Color = "Gray" and Runs from = 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, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail flags, Tail twitches, Indifferent

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
604	604	-73.9540908513075	40.794201225045	37G-PM-1007-04	37G	PM	10072018	4		Cinnamon	Gray	Cinnamon+Gray	gray tail	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9540908513075 40.794201225045)
687	687	-73.96369718436651	40.78256385373621	22F-AM-1007-04	22F	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray					0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9636971843665 40.7825638537362)
960	960	-73.9623922773932	40.7814944428327	22H-PM-1007-04	22H	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9623922773932 40.7814944428327)
971	971	-73.978392591149	40.7668993398193	1D-PM-1007-04	01D	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.978392591149 40.7668993398193)
1003	1003	-73.9645547556826	40.776877007081	16I-AM-1008-04	16I	AM	10082018	4	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	9	tree hollow	0	0	0	0	0	in hollow	0	0	0	0	0	0	0	0	curious	POINT (-73.9645547556826 40.776877007081)
1034	1034	-73.95531638295509	40.7988610926249	42D-PM-1013-04	42D	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Light Cinnamon	Ground Plane	FALSE		0	0	0	0	0	carrying nut away	0	0	0	0	0	0	1	0		POINT (-73.9553163829551 40.7988610926249)
1056	1056	-73.98110784424621	40.767515940567	1A-AM-1007-04	01A	AM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9811078442462 40.767515940567)
1088	1088	-73.9770985425092	40.7665926744505	1E-AM-1006-04	01E	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9770985425092 40.7665926744505)
2156	2156	-73.96503878480009	40.7814134438394	21F-AM-1018-04	21F	AM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9650387848001 40.7814134438394)
2404	2404	-73.96653096896159	40.7775271020244	16G-AM-1010-04	16G	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9665309689616 40.7775271020244)
2461	2461	-73.9605347462123	40.794207544838706	35B-AM-1010-04	35B	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	lawn	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9605347462123 40.7942075448387)
2514	2514	-73.95744422055	40.7961046528557	38D-AM-1017-04	38D	AM	10172018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.95744422055 40.7961046528557)
2521	2521	-73.976869549792	40.770698245472296	5C-AM-1006-04	05C	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	12	thin branch of tree	0	0	0	0	0	relaxing	0	0	0	1	0	0	1	0		POINT (-73.976869549792 40.7706982454723)
2752	2752	-73.972069937746	40.765940262783204	3I-PM-1013-04	03I	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.97206993774601 40.7659402627832)

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