squirrels

9 rows where Combination of Primary and Highlight Color = "Gray+White", Hectare Squirrel Number = 4 and Running = "true"

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	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
743	743	-73.9565035705619	40.7937382705056	36F-AM-1017-04	36F	AM	10172018	4	Juvenile	Gray	White	Gray+White	White legs, front & back	Ground Plane	FALSE		true	false	false	true	true		true	false	false	false	false	true	false	true	approaches (me),runs from (me)	POINT (-73.9565035705619 40.7937382705056)	19	4	19	13
999	999	-73.980948293606	40.7685688850628	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.980948293606 40.7685688850628)	19	4	19	13
1182	1182	-73.9667206046912	40.7779993565098	17G-PM-1017-04	17G	PM	10172018	4	Adult	Gray	White	Gray+White		Above Ground	10	tree & ground	true	true	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9667206046912 40.7779993565098)	19	4	19	13
1356	1356	-73.9534910562766	40.7935774443789	37H-AM-1018-04	37H	AM	10182018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	true	false	false	true	was with a lot of robins	POINT (-73.9534910562766 40.7935774443789)	19	4	19	13
1453	1453	-73.9555856074105	40.7969457685677	40E-AM-1014-04	40E	AM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	on rocks/bushy rocks	true	false	false	false	false	hiding from bird	false	true	false	false	true	false	true	false		POINT (-73.9555856074105 40.79694576856771)	19	4	19	13
1529	1529	-73.9692401421068	40.7707128895661	8I-AM-1006-04	08I	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9692401421068 40.7707128895661)	19	4	19	13
1767	1767	-73.958719099962	40.7947587726617	36C-AM-1014-04	36C	AM	10142018	4		Gray	White	Gray+White		Above Ground	15	Ground then tree to eat	true	false	true	true	false		false	false	false	false	false	false	false	true		POINT (-73.958719099962 40.7947587726617)	19	4	19	13
2094	2094	-73.9701630539326	40.7779553961101	15D-AM-1007-04	15D	AM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.97016305393261 40.7779553961101)	19	4	19	13
2618	2618	-73.95795157569	40.7961254697958	38C-PM-1014-04	38C	PM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	true	false		false	false	false	true	false	false	false	true		POINT (-73.95795157569 40.7961254697958)	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
);