squirrels

12 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", 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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Zip Codes	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
240	240	-73.9767080512177	40.7717708794221	6B-PM-1017-04	06B	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	true	false	false	true	false	false	false	false	false	false	false	false		POINT (-73.9767080512177 40.7717708794221)		19	4	19	13
338	338	-73.9765595553183	40.7748455340432	10A-PM-1014-04	10A	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	false	false	false	true		POINT (-73.9765595553183 40.7748455340432)		19	4	19	13
499	499	-73.9657288055011	40.7764580036287	16H-PM-1014-04	16H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	false	false	true	false		POINT (-73.9657288055011 40.7764580036287)		19	4	19	13
619	619	-73.9769887473852	40.7707561532949	5C-PM-1010-04	05C	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	true	false	false	false	false	false	false	false	true	false		POINT (-73.97698874738522 40.7707561532949)		19	4	19	13
868	868	-73.9738481771673	40.7706540698938	7E-PM-1013-04	07E	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	true	true	false	false	false	false	true	false	false	false		POINT (-73.9738481771673 40.7706540698938)		19	4	19	13
916	916	-73.9561887624471	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	true	false	false	false	false	false	true	false	false	false	true	me	POINT (-73.95618876244711 40.7958187455815)		19	4	19	13
1029	1029	-73.9601259189134	40.7955350609057	36B-PM-1013-04	36B	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	true	false	false	false	false	false	false	false	false	true		POINT (-73.9601259189134 40.7955350609057)		19	4	19	13
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	true	false	true	false	false	false	false	false	false	true	false	false	true		POINT (-73.9722737593623 40.768963018754)		19	4	19	13
1176	1176	-73.9553263156025	40.7975592060572	40D-PM-1013-04	40D	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	false	false	false	true		POINT (-73.9553263156025 40.7975592060572)		19	4	19	13
2271	2271	-73.9673949458096	40.7826218539496	21D-AM-1008-04	21D	AM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	true	false	false	true		POINT (-73.9673949458096 40.78262185394961)		19	4	19	13
2981	2981	-73.9800094828465	40.7677782585639	1B-AM-1012-04	01B	AM	10122018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	true	false	false	false	false	false	false	false	true	false		POINT (-73.9800094828465 40.7677782585639)		19	4	19	13
3008	3008	-73.9503533343658	40.7976543603953	42H-PM-1014-04	42H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		true	true	false	false	false	false	false	false	false	true	false	false	true		POINT (-73.9503533343658 40.7976543603953)	12423	18	4	36	18

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
);