2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Age = "Juvenile", Date = 10182018, Eating = 0 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, 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
217	217	-73.9712327308512	40.7748702909218	12E-PM-1018-06	12E	PM	10182018	6	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9712327308512 40.7748702909218)
408	408	-73.9633760173635	40.7818422357619	22G-PM-1018-03	22G	PM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	chilling	0	0	0	0	0	0	1	0	observed	POINT (-73.96337601736352 40.7818422357619)
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)
884	884	-73.96789372898371	40.7782808361645	16E-PM-1018-01	16E	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9678937289837 40.7782808361645)
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)
1262	1262	-73.9683345414813	40.7779016280345	16E-PM-1018-07	16E	PM	10182018	7	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		1	0	0	0	0	0	1	0		POINT (-73.9683345414813 40.7779016280345)
1531	1531	-73.9630381400083	40.7807571827321	21H-PM-1018-02	21H	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9630381400083 40.7807571827321)
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)
1874	1874	-73.96573273328491	40.7747554568985	14I-PM-1018-03	14I	PM	10182018	3	Juvenile	Gray	Black	Gray+Black		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657327332849 40.7747554568985)
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)
2171	2171	-73.9686370726471	40.7780382348833	16E-PM-1018-09	16E	PM	10182018	9	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	3	On trunk	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9686370726471 40.7780382348833)
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)

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