squirrels

6 rows where Combination of Primary and Highlight Color = "Cinnamon+Gray" and Date = 10122018 sorted by Zip Codes descending

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	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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
392	392	-73.9802376131034	40.7680707516627	1B-AM-1012-12	01B	AM	10122018	12	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9802376131034 40.7680707516627)	19	4	19	13
788	788	-73.9687476703117	40.7742856696093	12G-AM-1012-01	12G	AM	10122018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2		false	false	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9687476703117 40.7742856696093)	19	4	19	13
1098	1098	-73.9604954276129	40.7965682182001	37A-AM-1012-01	37A	AM	10122018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Drawing included on tally sheet	Ground Plane	FALSE		false	false	false	false	true	scanning (drawing included)	false	false	false	false	false	false	false	true	POINT (-73.9604954276129 40.7965682182001)	19	4	19	13
1716	1716	-73.9797425262459	40.7679120246352	1B-AM-1012-02	01B	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9797425262459 40.7679120246352)	19	4	19	13
2309	2309	-73.966824257293	40.7753405377869	14H-PM-1012-04	14H	PM	10122018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.966824257293 40.7753405377869)	19	4	19	13
2487	2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	31	on tree	true	true	false	false	false		false	false	false	true	true	false	true	false	POINT (-73.9595222999173 40.7833202577782)	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
);