squirrels

6 rows where Approaches = "true" and Primary Fur Color = "Black"

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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
42	42	-73.9579564338627	40.7959337795027	38C-PM-1014-09	38C	PM	10142018	9	Adult	Black		Black+	Ground Plane	FALSE		false	false	false	true	false	false	false	false	false	false	true	false	false		POINT (-73.9579564338627 40.7959337795027)	19	4	19	13
658	658	-73.9704575848926	40.7693499326095	7H-PM-1006-09	07H	PM	10062018	9	Adult	Black		Black+	Ground Plane	FALSE	by tree	false	false	false	true	true	false	false	false	true	false	true	false	true		POINT (-73.9704575848926 40.7693499326095)	19	4	19	13
1057	1057	-73.9594406225891	40.7918533707789	33D-AM-1017-02	33D	AM	10172018	2	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		false	false	false	false	true	false	false	false	false	true	true	false	false		POINT (-73.9594406225891 40.7918533707789)	19	4	19	13
1392	1392	-73.9648090698176	40.7903882097837	29A-PM-1019-03	29A	PM	10192018	3	Juvenile	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		false	false	false	false	false	false	false	false	false	false	true	false	true	ran from,but now approaching. kind of weirding me out.	POINT (-73.9648090698176 40.7903882097837)	19	4	19	13
1892	1892	-73.9745908987975	40.7655191512308	1G-AM-1006-03	01G	AM	10062018	3	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		false	true	false	false	true	false	false	false	false	false	true	false	false		POINT (-73.9745908987975 40.7655191512308)	19	4	19	13
2284	2284	-73.9730181306326	40.7794601322427	16A-AM-1013-02	16A	AM	10132018	2	Adult	Black		Black+	Above Ground			false	false	false	false	true	false	false	false	false	false	true	false	false		POINT (-73.9730181306326 40.7794601322427)	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
);