squirrels

8 rows where Combination of Primary and Highlight Color = "Cinnamon+", Indifferent = "true" and Running = "true" sorted by Approaches

descending

Link	rowid	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches ▼	Indifferent	Runs from	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
256	256	-73.976798124308	40.7741316574113	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon	Cinnamon+		Above Ground	20		true	false	true	false	false	false	false	false	false	false	false	true	false	POINT (-73.97679812430802 40.7741316574113)	19	4	19	13
454	454	-73.9752793195744	40.7733960128931	9C-AM-1006-03	09C	AM	10062018	3	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9752793195744 40.7733960128931)	19	4	19	13
805	805	-73.9706851546184	40.7780777016038	15D-PM-1017-04	15D	PM	10172018	4	Adult	Cinnamon	Cinnamon+		Above Ground	2	on fence	true	false	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9706851546184 40.7780777016038)	19	4	19	13
1199	1199	-73.9756993198381	40.7681956641913	3E-PM-1008-08	03E	PM	10082018	8	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	false	false	false	true	false	false	false	false	false	false	true	false	POINT (-73.9756993198381 40.7681956641913)	19	4	19	13
1212	1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9761792189352 40.7745745517215)	19	4	19	13
1394	1394	-73.95488263914	40.7959474571251	39F-AM-1014-05	39F	AM	10142018	5	Juvenile	Cinnamon	Cinnamon+		Above Ground	2	up/down tree	true	false	true	false	true	false	false	false	false	true	false	true	false	POINT (-73.95488263914 40.7959474571251)	19	4	19	13
2483	2483	-73.9596083366477	40.7949526729608	36C-PM-1013-05	36C	PM	10132018	5	Adult	Cinnamon	Cinnamon+	"Warm brown" written in for Primary.	Ground Plane	FALSE	Ran across path in front of people	true	false	false	true	true	false	false	false	false	true	false	true	true	POINT (-73.9596083366477 40.7949526729608)	19	4	19	13
2838	2838	-73.9507699667119	40.7955166039555	40I-AM-1018-02	40I	AM	10182018	2	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	false	false	false	true	false	false	false	false	false	false	true	false	POINT (-73.9507699667119 40.795516603955505)	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
);