squirrels

9 rows where Date = 10062018 and Quaas = "true" sorted by Lat/Long

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	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
453	453	-73.959514034869	40.789911786416	31E-PM-1006-02	31E	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	under bushes	false	false	false	true	true		false	true	false	false	false	false	true	false		POINT (-73.959514034869 40.789911786416)	19	4	19	13
775	775	-73.9595757792683	40.7899242643847	31E-PM-1006-01	31E	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	under bushes	false	false	false	false	true		false	true	false	false	false	false	true	false		POINT (-73.9595757792683 40.7899242643847)	19	4	19	13
411	411	-73.9669366401071	40.7836023897982	22C-PM-1006-09	22C	PM	10062018	9	Adult	Gray		Gray+	Ground Plane	FALSE		true	false	false	false	false		false	true	false	false	false	false	false	false		POINT (-73.96693664010711 40.7836023897982)	19	4	19	13
1004	1004	-73.9670850805619	40.7833747810387	22C-PM-1006-01	22C	PM	10062018	1	Juvenile	Gray		Gray+	Ground Plane	FALSE		true	true	false	false	false	for food	false	true	false	false	false	false	false	false		POINT (-73.9670850805619 40.7833747810387)	19	4	19	13
1002	1002	-73.9672070423666	40.783337354891	22C-PM-1006-02	22C	PM	10062018	2	Adult	Gray		Gray+	Ground Plane	FALSE		true	false	false	false	false		false	true	false	false	false	false	false	false		POINT (-73.9672070423666 40.783337354891)	19	4	19	13
476	476	-73.9690968160819	40.769923269444	8I-AM-1006-08	08I	AM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	6	tree	false	false	false	false	false		true	true	false	false	false	false	false	false	not backing down	POINT (-73.9690968160819 40.769923269444)	19	4	19	13
449	449	-73.9701335162984	40.7722051011357	10G-AM-1006-10	10G	AM	10062018	10	Adult	Gray		Gray+	Ground Plane	FALSE		false	true	false	false	false		false	true	false	false	false	false	false	false		POINT (-73.9701335162984 40.7722051011357)	19	4	19	13
1581	1581	-73.97157754108	40.7776249963967	14C-PM-1006-01	14C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	false	true	false	false		false	true	false	false	false	false	false	true		POINT (-73.97157754108 40.7776249963967)	19	4	19	13
137	137	-73.9782417115139	40.7724665036447	7A-AM-1006-01	07A	AM	10062018	1	Adult	Gray	White	Gray+White	Above Ground	10	in tree	false	false	false	false	true		false	true	false	false	true	false	false	false	looked at us	POINT (-73.9782417115139 40.7724665036447)	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
);