2018_Central_Park_Squirrel_Census_-_Squirrel_Data

27 rows where Date = 10102018, Foraging = 0 and Hectare Squirrel Number = 2

- 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Tail flags, 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
110	110	-73.97113187902791	40.7701941550273	7G-AM-1010-02	07G	AM	10102018	2	Adult	Gray		Gray+		Above Ground	3		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9711318790279 40.7701941550273)
535	535	-73.9772396728545	40.7668696411765	2E-AM-1010-02	02E	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0	totally indifferent	POINT (-73.9772396728545 40.7668696411765)
650	650	-73.98096101171708	40.7683896665502	2A-AM-1010-02	02A	AM	10102018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground		perched on small fence	0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9809610117171 40.7683896665502)
671	671	-73.9709244006956	40.7676942639697	5I-AM-1010-02	05I	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9709244006956 40.7676942639697)
680	680	-73.95640114211221	40.7958097849369	38E-AM-1010-02	38E	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0	climbs	POINT (-73.95640114211221 40.7958097849369)
711	711	-73.97679809251241	40.774362775678	9A-PM-1010-02	09A	PM	10102018	2	Adult			+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767980925124 40.774362775678)
923	923	-73.9578924882613	40.789806297824	32G-AM-1010-02	32G	AM	10102018	2	Adult	Gray		Gray+		Above Ground	13		0	0	1	1	0		0	0	0	0	1	0	0	1		POINT (-73.9578924882613 40.789806297824)
1154	1154	-73.9786936992465	40.771394367466606	5A-PM-1010-02	05A	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9786936992465 40.7713943674666)
1238	1238	-73.97736921314409	40.767977115014894	3D-PM-1010-02	03D	PM	10102018	2	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9773692131441 40.7679771150149)
1333	1333	-73.9754527701832	40.7656088463928	1G-PM-1010-02	01G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0	laying on tree branch	0	0	0	1	1	0	0	0		POINT (-73.9754527701832 40.7656088463928)
1374	1374	-73.9653739273979	40.788976209696706	28B-PM-1010-02	28B	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653739273979 40.7889762096967)
1414	1414	-73.9580513096783	40.79909641532	41B-AM-1010-02	41B	AM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	16		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580513096783 40.79909641532)
1643	1643	-73.95305356247809	40.7929809144271	37I-AM-1010-02	37I	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9530535624781 40.7929809144271)
1951	1951	-73.9548431601579	40.7906346271566	34I-PM-1010-02	34I	PM	10102018	2	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9548431601579 40.7906346271566)
2038	2038	-73.98035621370491	40.7685780990634	2B-AM-1010-02	02B	AM	10102018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9803562137049 40.7685780990634)
2136	2136	-73.97218979152109	40.7660434203132	3I-AM-1010-02	03I	AM	10102018	2	Adult	Gray		Gray+		Above Ground	40		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9721897915211 40.76604342031321)
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)
2229	2229	-73.9620719414292	40.788637452988	29D-PM-1010-02	29D	PM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9620719414292 40.788637452988)
2361	2361	-73.9708032298419	40.7784265674544	15C-AM-1010-02	15C	AM	10102018	2	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0	nest building	0	0	0	0	0	0	1	0		POINT (-73.9708032298419 40.77842656745441)
2426	2426	-73.9790203973636	40.768883711483205	3B-AM-1010-02	03B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	together w/ #3	0	0	0	0	0	0	0	1		POINT (-73.9790203973636 40.7688837114832)
2474	2474	-73.97214488797658	40.7762112840981	13C-AM-1010-02	13C	AM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		0	0	1	0	0	burying	0	0	0	0	0	0	1	0		POINT (-73.9721448879766 40.7762112840981)
2578	2578	-73.97653869653709	40.766371971272996	1F-AM-1010-02	01F	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765386965371 40.766371971273)
2739	2739	-73.9681960138614	40.7726867422002	11H-AM-1010-02	11H	AM	10102018	2		Cinnamon	Gray	Cinnamon+Gray					0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9681960138614 40.7726867422002)
2807	2807	-73.9618213644671	40.792764881973795	33B-AM-1010-02	33B	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.96182136446711 40.7927648819738)
2968	2968	-73.9587236619579	40.799185018043396	40A-AM-1010-02	40A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park at 108th West	1	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9587236619579 40.7991850180434)
3006	3006	-73.97443902173859	40.7663168362582	2G-AM-1010-02	02G	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9744390217386 40.7663168362582)
3022	3022	-73.9639941227864	40.7899152327912	29B-PM-1010-02	29B	PM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9639941227864 40.7899152327912)

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