squirrels

9 rows where Location = "" and Tail twitches = "true" sorted by Other Interactions

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	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
12	12	-73.9683613516225	40.7725908847499	11H-AM-1010-03	11H	AM	10102018	3	Adult	Cinnamon	White	Cinnamon+White	false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9683613516225 40.7725908847499)	19	4	19	13
537	537	-73.9682803241007	40.7724510558327	11H-AM-1010-04	11H	AM	10102018	4		Gray	White	Gray+White	false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9682803241007 40.7724510558327)	19	4	19	13
607	607	-73.9547711796823	40.7908540751983	34I-PM-1010-06	34I	PM	10102018	6	Adult	Gray		Gray+	false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9547711796823 40.7908540751983)	19	4	19	13
1091	1091	-73.97055600791	40.7698499183436	7H-AM-1006-07	07H	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	true	false		false	false	false	false	true	false	true	false		POINT (-73.97055600791 40.7698499183436)	19	4	19	13
1988	1988	-73.957138794884	40.7985389822719	40C-AM-1017-03	40C	AM	10172018	3	Adult	Gray	White	Gray+White	true	true	true	false	false	chasing (#4),digging	false	false	false	false	true	false	true	false		POINT (-73.957138794884 40.7985389822719)	19	4	19	13
2739	2739	-73.9681960138614	40.7726867422002	11H-AM-1010-02	11H	AM	10102018	2		Cinnamon	Gray	Cinnamon+Gray	false	false	false	true	false		false	false	false	false	true	false	true	false		POINT (-73.9681960138614 40.7726867422002)	19	4	19	13
2875	2875	-73.9546616782922	40.790974533739	34I-PM-1010-05	34I	PM	10102018	5	Adult	Gray		Gray+	false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9546616782922 40.790974533739)	19	4	19	13
2918	2918	-73.9745152462626	40.7655415515908	1G-AM-1006-04	01G	AM	10062018	4	Adult	Gray	White	Gray+White	false	true	false	false	true	collecting nest material	false	false	false	false	true	false	true	false		POINT (-73.9745152462626 40.76554155159081)	19	4	19	13
1342	1342	-73.9662063642345	40.7890778665307	28A-PM-1007-04	28A	PM	10072018	4	Adult	Gray	White	Gray+White	false	false	false	false	false	looking at me & #5	true	false	false	false	true	false	false	false	freezes	POINT (-73.9662063642345 40.7890778665307)	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
);