squirrels

10 rows where Hectare Squirrel Number = 9 and Tail twitches = "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
298	298	-73.957342596188	40.7944359654227	37E-PM-1006-09	37E	PM	10062018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	false	false	moseying	false	false	false	false	true	true	false	false		POINT (-73.957342596188 40.7944359654227)	19	4	19	13
314	314	-73.960601067176	40.7917243850136	32D-PM-1006-09	32D	PM	10062018	9	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	true	false	false		POINT (-73.960601067176 40.7917243850136)	19	4	19	13
405	405	-73.9786603147149	40.7671937837017	1D-AM-1006-09	01D	AM	10062018	9	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9786603147149 40.7671937837017)	19	4	19	13
546	546	-73.9547423290276	40.7899702628835	33I-PM-1006-09	33I	PM	10062018	9	Adult	Black		Black+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9547423290276 40.7899702628835)	19	4	19	13
979	979	-73.9612349421547	40.7959586475744	36A-PM-1013-09	36A	PM	10132018	9		Gray		Gray+		Ground Plane	FALSE	THICK UNDERGROWTH	true	false	false	false	false		false	false	false	false	true	false	false	true		POINT (-73.9612349421547 40.7959586475744)	19	4	19	13
1651	1651	-73.9763373510536	40.7741168933928	9B-PM-1013-09	09B	PM	10132018	9	Juvenile	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	true	runs from (people)	POINT (-73.9763373510536 40.7741168933928)	19	4	19	13
1977	1977	-73.9586570546871	40.796349417475	38C-AM-1019-09	38C	AM	10192018	9	Adult	Gray	White	Gray+White	Gray & White selected as Primary & Highlights. Made executive adjustments.	Above Ground	3	Between ground & tree	false	false	false	true	true		false	false	false	false	true	false	false	true		POINT (-73.9586570546871 40.796349417475)	19	4	19	13
2171	2171	-73.9686370726471	40.7780382348833	16E-PM-1018-09	16E	PM	10182018	9	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	3	On trunk	false	false	true	false	false		false	false	false	false	true	false	true	false		POINT (-73.9686370726471 40.7780382348833)	19	4	19	13
2692	2692	-73.9801636400744	40.7690192055926	2A-AM-1010-09	02A	AM	10102018	9	Adult	Gray	White	Gray+White		Above Ground		climbing in bush	false	false	true	false	false	hopping & flipping around. this one was very energetic & jumping aorund	false	false	false	false	true	false	false	false	climbed a foot up a tree and watched me	POINT (-73.9801636400744 40.7690192055926)	19	4	19	13
2708	2708	-73.9528429238071	40.7922651848867	36I-PM-1007-09	36I	PM	10072018	9	Juvenile	Gray		Gray+		Above Ground	5		true	true	false	false	false	burying nut	false	false	false	false	true	false	false	false		POINT (-73.9528429238071 40.7922651848867)	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
);