2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Date = 10102018, Eating = 0, Foraging = 1 and Highlight Fur Color = "White"

- 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: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Kuks, Quaas, Tail twitches, 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
12	12	-73.96836135162249	40.772590884749896	11H-AM-1010-03	11H	AM	10102018	3	Adult	Cinnamon	White	Cinnamon+White					0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9683613516225 40.7725908847499)
123	123	-73.9671147090087	40.7772624641112	16G-AM-1010-03	16G	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	was hanging out w/ #2 until i showed up	1	0	0	0	0	0	0	1		POINT (-73.9671147090087 40.7772624641112)
157	157	-73.9637946878735	40.791570044687795	31A-AM-1010-04	31A	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9637946878735 40.7915700446878)
278	278	-73.9787796921165	40.7707526535381	5A-PM-1010-01	05A	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9787796921165 40.7707526535381)
307	307	-73.9683965841952	40.771867984897796	10I-AM-1010-03	10I	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9683965841952 40.7718679848978)
514	514	-73.9768357173861	40.7683813358343	3D-PM-1010-12	03D	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	1	0	0	1		0	1	0	0	0	0	0	0		POINT (-73.9768357173861 40.7683813358343)
537	537	-73.9682803241007	40.772451055832704	11H-AM-1010-04	11H	AM	10102018	4		Gray	White	Gray+White					0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9682803241007 40.7724510558327)
807	807	-73.97772590224409	40.76820599079029	3D-PM-1010-10	03D	PM	10102018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9777259022441 40.7682059907903)
1127	1127	-73.9776445567926	40.768119107973	3D-PM-1010-07	03D	PM	10102018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9776445567926 40.768119107973)
1256	1256	-73.9679457364586	40.7717350221981	10I-AM-1010-02	10I	AM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9679457364586 40.7717350221981)
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)
1532	1532	-73.97792631145721	40.7682681855369	3D-PM-1010-08	03D	PM	10102018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9779263114572 40.7682681855369)
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)
1580	1580	-73.9775079672882	40.7691500357424	4C-PM-1010-07	04C	PM	10102018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9775079672882 40.7691500357424)
1849	1849	-73.9788436368415	40.7691104998969	3B-AM-1010-05	03B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9788436368415 40.7691104998969)
1901	1901	-73.9680237209555	40.771702220822505	10I-AM-1010-04	10I	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9680237209555 40.7717022208225)
1913	1913	-73.97746308218541	40.7680626674086	3D-PM-1010-11	03D	PM	10102018	11	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9774630821854 40.76806266740861)
1996	1996	-73.977641787698	40.769583026578395	4C-PM-1010-10	04C	PM	10102018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.977641787698 40.7695830265784)
2097	2097	-73.9773486521595	40.77084549021129	5C-PM-1010-02	05C	PM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9773486521595 40.7708454902113)
2633	2633	-73.9776151109912	40.7694681558386	4C-PM-1010-09	04C	PM	10102018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9776151109912 40.7694681558386)
2674	2674	-73.97710090245809	40.7688793288864	3D-PM-1010-06	03D	PM	10102018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9771009024581 40.7688793288864)
2778	2778	-73.9761799699276	40.774213409933	9B-AM-1010-07	09B	AM	10102018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9761799699276 40.774213409933)
2824	2824	-73.97506180080991	40.773752116709396	9B-AM-1010-05	09B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9750618008099 40.7737521167094)

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