2018_Central_Park_Squirrel_Census_-_Squirrel_Data

35 rows where Date = 10182018, Indifferent = 1 and Shift = "AM"

- 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, 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
166	166	-73.96384633980401	40.7834051716226	23F-AM-1018-01	23F	AM	10182018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.963846339804 40.7834051716226)
380	380	-73.9649590119935	40.782210792076896	21F-AM-1018-01	21F	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9649590119935 40.7822107920769)
450	450	-73.96442931957729	40.7813829172072	21F-AM-1018-02	21F	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9644293195773 40.7813829172072)
467	467	-73.95797241199429	40.794870990001606	37D-AM-1018-01	37D	AM	10182018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9579724119943 40.7948709900016)
488	488	-73.9615751148595	40.795455123814605	36A-AM-1018-01	36A	AM	10182018	1	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9615751148595 40.7954551238146)
527	527	-73.9632646049622	40.781740129208295	22G-AM-1018-05	22G	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9632646049622 40.7817401292083)
746	746	-73.9591407691	40.796084690312206	37B-AM-1018-01	37B	AM	10182018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9591407691 40.7960846903122)
945	945	-73.9532838338416	40.79311126745829	37H-AM-1018-01	37H	AM	10182018	1	Adult	Gray		Gray+		Ground Plane	FALSE	Right behind fence of the conservatory	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9532838338416 40.7931112674583)
1007	1007	-73.96353178229771	40.7821352080233	22G-AM-1018-01	22G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		1	0	0	1	0	0	1	0		POINT (-73.9635317822977 40.7821352080233)
1061	1061	-73.9532657715601	40.7949046809422	39G-AM-1018-02	39G	AM	10182018	2	Juvenile	Gray		Gray+		Above Ground	25	Tree	0	0	0	0	0	sitting & watching	0	0	0	0	0	0	1	0		POINT (-73.9532657715601 40.7949046809422)
1147	1147	-73.96318185288159	40.7925332194132	32A-AM-1018-01	32A	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9631818528816 40.7925332194132)
1203	1203	-73.9616999731028	40.7954126939561	36A-AM-1018-02	36A	AM	10182018	2	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9616999731028 40.7954126939561)
1337	1337	-73.9750986553543	40.7740671171292	10C-AM-1018-03	10C	AM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9750986553543 40.7740671171292)
1402	1402	-73.9745009906157	40.7741574075364	10C-AM-1018-01	10C	AM	10182018	1	Adult	Gray		Gray+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9745009906157 40.7741574075364)
1509	1509	-73.9556450015702	40.796718805800204	39E-AM-1018-04	39E	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9556450015702 40.7967188058002)
1528	1528	-73.9690104245067	40.7853358193723	23A-AM-1018-02	23A	AM	10182018	2	Juvenile	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690104245067 40.7853358193723)
1736	1736	-73.9743873549635	40.7745426051392	10C-AM-1018-04	10C	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9743873549635 40.7745426051392)
1737	1737	-73.9640741640547	40.7807274581426	20G-AM-1018-01	20G	AM	10182018	1	Juvenile	Gray		Gray+		Above Ground	7	Tree limb	0	0	0	0	0	sitting still on limb	0	0	0	0	0	0	1	0		POINT (-73.9640741640547 40.7807274581426)
1895	1895	-73.954699659637	40.7951308856929	38F-AM-1018-02	38F	AM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.954699659637 40.7951308856929)
1978	1978	-73.9579689996645	40.794933848991704	37D-AM-1018-02	37D	AM	10182018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9579689996645 40.7949338489917)
1989	1989	-73.96316467546471	40.7925716810884	32A-AM-1018-02	32A	AM	10182018	2	Adult	Gray		Gray+		Above Ground	15		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9631646754647 40.7925716810884)
2255	2255	-73.96429678758571	40.78156523539371	21F-AM-1018-08	21F	AM	10182018	8	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9642967875857 40.7815652353937)
2407	2407	-73.95557243517759	40.7967602498249	39E-AM-1018-03	39E	AM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9555724351776 40.7967602498249)
2510	2510	-73.9748635473782	40.7742591029151	10C-AM-1018-02	10C	AM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0	sitting in the sun	0	0	0	0	0	0	1	0		POINT (-73.9748635473782 40.7742591029151)
2531	2531	-73.9599424115626	40.79574725853271	37B-AM-1018-05	37B	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9599424115626 40.7957472585327)
2543	2543	-73.96914249979191	40.780542852496	18C-AM-1018-02	18C	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9691424997919 40.780542852496)
2581	2581	-73.9635981227569	40.7928169540326	32A-AM-1018-05	32A	AM	10182018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9635981227569 40.7928169540326)
2599	2599	-73.96898934126929	40.785308737683	23A-AM-1018-03	23A	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	Tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689893412693 40.785308737683)
2611	2611	-73.951448051873	40.7973951649254	42G-AM-1018-02	42G	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.951448051873 40.7973951649254)
2830	2830	-73.9556083695689	40.7965223709493	39E-AM-1018-02	39E	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9556083695689 40.7965223709493)
2838	2838	-73.9507699667119	40.7955166039555	40I-AM-1018-02	40I	AM	10182018	2	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9507699667119 40.795516603955505)
2876	2876	-73.95589957376541	40.7960097734603	39E-AM-1018-05	39E	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9558995737654 40.7960097734603)
2941	2941	-73.96902666603171	40.7853134751509	23A-AM-1018-01	23A	AM	10182018	1	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690266660317 40.7853134751509)
2966	2966	-73.9630596103391	40.792572062055605	32A-AM-1018-04	32A	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE	Base of tree	0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9630596103391 40.7925720620556)
2972	2972	-73.9631468456897	40.7926110399714	32A-AM-1018-03	32A	AM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9631468456897 40.7926110399714)

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