squirrels

9 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Date = 10062018 and Tail flags = "true" sorted by Approaches

descending

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	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	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
78	78	-73.964474836001	40.7883840104749	28C-PM-1006-01	28C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	false	false	gathering acorns	false	false	false	true	false	false	false	true	gnd to tree	POINT (-73.964474836001 40.7883840104749)	19	4	19	13
90	90	-73.9787180870736	40.7715877863274	5A-AM-1006-05	05A	AM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	near 65th St arch	false	false	false	false	true		false	false	false	true	false	false	false	true		POINT (-73.9787180870736 40.7715877863274)	19	4	19	13
133	133	-73.9664711607022	40.787896428768	26A-PM-1006-06	26A	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Tree 90th left 90th & 89	false	false	true	false	false		false	false	false	true	false	false	false	false	studying us looking for food	POINT (-73.9664711607022 40.787896428768)	19	4	19	13
1523	1523	-73.9673103881521	40.7874267409618	26A-PM-1006-01	26A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	false	true		POINT (-73.9673103881521 40.7874267409618)	19	4	19	13
1815	1815	-73.9603268255317	40.7900154505092	31E-PM-1006-06	31E	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	false		false	false	false	true	false	false	true	false		POINT (-73.9603268255317 40.7900154505092)	19	4	19	13
1995	1995	-73.9603366992925	40.7899612889539	31E-PM-1006-05	31E	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	false		false	false	false	true	false	false	true	false		POINT (-73.9603366992925 40.789961288953904)	19	4	19	13
2142	2142	-73.9598535425706	40.7915589343685	33D-PM-1006-01	33D	PM	10062018	1		Gray	Cinnamon	Gray+Cinnamon	Above Ground	15		false	true	false	false	false	hanging on fence	true	false	false	true	false	false	false	true		POINT (-73.9598535425706 40.7915589343685)	19	4	19	13
2425	2425	-73.9791141532217	40.7714888835416	5A-AM-1006-04	05A	AM	10062018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9791141532217 40.77148888354161)	19	4	19	13
2928	2928	-73.9767953468937	40.7676376977667	3E-AM-1006-03	03E	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	false	true	checkin' his stashes	false	false	false	true	false	true	false	true		POINT (-73.9767953468937 40.7676376977667)	19	4	19	13

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);