2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Date = 10072018, Foraging = 0, Highlight Fur Color = "Cinnamon" 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: Hectare, Shift, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches

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
38	38	-73.9742073452913	40.7757957380463	12B-AM-1007-01	12B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9742073452913 40.7757957380463)
57	57	-73.9690175838534	40.77604327200171	14F-AM-1007-05	14F	AM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690175838534 40.7760432720017)
65	65	-73.9741824992294	40.7689486657963	5F-PM-1007-03	05F	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding nut	0	0	0	0	1	0	1	0		POINT (-73.9741824992294 40.7689486657963)
94	94	-73.9641971813967	40.781353795943495	21G-PM-1007-01	21G	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9641971813967 40.7813537959435)
234	234	-73.9741401377844	40.7758134257881	12B-AM-1007-02	12B	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9741401377844 40.7758134257881)
444	444	-73.96414623605409	40.7778316005464	18I-PM-1007-09	18I	PM	10072018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0	canoodling w/ 8	0	0	0	0	0	0	1	0		POINT (-73.9641462360541 40.7778316005464)
446	446	-73.9678774314725	40.7738535171265	12H-PM-1007-04	12H	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon					0	0	0	1	0	mushroom	0	0	0	0	0	0	1	0		POINT (-73.9678774314725 40.7738535171265)
484	484	-73.9666526554772	40.7756111718355	14H-AM-1007-02	14H	AM	10072018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9666526554772 40.77561117183551)
505	505	-73.9677387336667	40.774269591199996	12H-PM-1007-02	12H	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677387336667 40.7742695912)
553	553	-73.9638526062093	40.782693848993	22F-AM-1007-02	22F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	standing	0	0	0	0	0	0	1	0		POINT (-73.9638526062093 40.782693848993)
733	733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
942	942	-73.9533923917973	40.796170187476896	40G-AM-1007-01	40G	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25	large tree	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9533923917973 40.7961701874769)
1010	1010	-73.9689723590015	40.7756860990338	13F-AM-1007-01	13F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689723590015 40.7756860990338)
1044	1044	-73.9693254080548	40.77616003271179	14F-AM-1007-01	14F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9693254080548 40.7761600327118)
1208	1208	-73.96628049257741	40.7890284642399	28A-PM-1007-01	28A	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9662804925774 40.7890284642399)
1300	1300	-73.964280573021	40.777830911491	18I-PM-1007-08	18I	PM	10072018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	1	1	0	0	canoodling w/ #9	0	0	0	0	0	0	1	0		POINT (-73.964280573021 40.777830911491)
1668	1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nut	0	0	0	0	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
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)
2382	2382	-73.97439704555329	40.7687880243986	5F-PM-1007-01	05F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9743970455533 40.7687880243986)
2491	2491	-73.98069052596709	40.76811522108579	1A-AM-1007-03	01A	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	looking in bush	0	0	0	0	0	0	1	0		POINT (-73.9806905259671 40.7681152210858)
2626	2626	-73.9737329655838	40.7726424441344	8D-PM-1007-02	08D	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9737329655838 40.7726424441344)
2954	2954	-73.9677474313377	40.7742119240825	12H-PM-1007-03	12H	PM	10072018	3		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677474313377 40.7742119240825)

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