squirrels

11 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 7 and Running = "true"

descending

Link	rowid ▼	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary 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
28	28	-73.958736593111	40.7908524370626	32F-PM-1008-07	32F	PM	10082018	7	Adult	Gray	Gray+	Ground Plane	FALSE		true	true	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.958736593111 40.7908524370626)	19	4	19	13
237	237	-73.967895656898	40.7767409597341	15F-PM-1010-07	15F	PM	10102018	7	Adult	Gray	Gray+	Above Ground	3	on fence	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.967895656898 40.7767409597341)	19	4	19	13
322	322	-73.9546042927016	40.7898133734952	33I-PM-1006-07	33I	PM	10062018	7	Adult	Gray	Gray+	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9546042927016 40.7898133734952)	19	4	19	13
434	434	-73.9676639740486	40.7745369616499	13H-PM-1010-07	13H	PM	10102018	7	Adult	Gray	Gray+	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9676639740486 40.7745369616499)	19	4	19	13
1442	1442	-73.961241953418	40.7941677113011	35B-PM-1013-07	35B	PM	10132018	7	Adult	Gray	Gray+	Ground Plane	FALSE		true	false	true	true	false	got fed twice by grandpa,grabbed from grass and ate in tree	false	false	false	false	false	true	true	true	approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up.	POINT (-73.961241953418 40.7941677113011)	19	4	19	13
1517	1517	-73.970041085185	40.7834427580313	21A-AM-1019-07	21A	AM	10192018	7	Adult	Gray	Gray+	Above Ground	25		true	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.970041085185 40.783442758031306)	19	4	19	13
1765	1765	-73.9689041600147	40.7781788966185	16E-AM-1014-07	16E	AM	10142018	7	Adult	Gray	Gray+	Above Ground			true	false	false	false	false		false	false	false	false	false	false	false	true	runs from (dog)	POINT (-73.9689041600147 40.7781788966185)	19	4	19	13
2080	2080	-73.954530253849	40.7910247489879	34I-PM-1010-07	34I	PM	10102018	7	Adult	Gray	Gray+				true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.954530253849 40.7910247489879)	19	4	19	13
2193	2193	-73.9569318105253	40.7973442139041	40C-PM-1006-07	40C	PM	10062018	7	Adult	Gray	Gray+	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9569318105253 40.7973442139041)	19	4	19	13
2261	2261	-73.9609692861012	40.790502891247	31D-AM-1014-07	31D	AM	10142018	7		Gray	Gray+	Ground Plane	FALSE	Crossing path to tree	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9609692861012 40.790502891247)	19	4	19	13
2707	2707	-73.9743165321099	40.7754674678574	11B-PM-1014-07	11B	PM	10142018	7		Gray	Gray+	Above Ground	10		true	false	false	true	true		false	false	false	false	false	false	false	false		POINT (-73.9743165321099 40.7754674678574)	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
);