squirrels

9 rows where Date = 10182018, Highlight Fur Color = "Cinnamon" and Location = "Above Ground"

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
339	339	-73.965509576403	40.7752456763263	14I-PM-1018-05	14I	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	2		false	false	true	true	false		false	false	false	false	true	false	true	false		POINT (-73.96550957640301 40.7752456763263)	19	4	19	13
1262	1262	-73.9683345414813	40.7779016280345	16E-PM-1018-07	16E	PM	10182018	7	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	false	true	false	false		true	false	false	false	false	false	true	false		POINT (-73.9683345414813 40.7779016280345)	19	4	19	13
1338	1338	-73.9716624574422	40.7762037110101	13D-PM-1018-07	13D	PM	10182018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		true	false	true	false	false	scratching	false	false	false	false	false	false	true	false		POINT (-73.9716624574422 40.7762037110101)	19	4	19	13
1451	1451	-73.9645365195454	40.7781531021263	18H-AM-1018-02	18H	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		Tree	true	true	false	false	false	playing?	false	false	false	false	false	false	false	false		POINT (-73.9645365195454 40.7781531021263)	19	4	19	13
1518	1518	-73.9632265832593	40.7816914475461	22G-AM-1018-04	22G	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9632265832593 40.78169144754611)	19	4	19	13
1530	1530	-73.9689305978751	40.7818152496266	19C-PM-1018-06	19C	PM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	2	Climbed fence	true	false	true	false	false	climbing (fence)	false	false	false	false	false	false	true	false		POINT (-73.9689305978751 40.7818152496266)	19	4	19	13
1970	1970	-73.9631464693769	40.793415656751	33A-PM-1018-02	33A	PM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10	Tree cavity [of] London Plane tree	false	false	false	false	false	hanging out,watching world	false	false	false	false	false	false	false	false	watching	POINT (-73.9631464693769 40.793415656751)	19	4	19	13
2522	2522	-73.9658747245917	40.7754033737532	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground		Fallen branch	true	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9658747245917 40.7754033737532)	19	4	19	13
2599	2599	-73.9689893412693	40.785308737683	23A-AM-1018-03	23A	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	8	Tree	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9689893412693 40.785308737683)	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
);