squirrels

15 rows where Above Ground Sighter Measurement = "" and Tail twitches = "true" sorted by Quaas descending

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	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
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
248	248	-73.9751729403694	40.7743284123118	10B-PM-1014-02	10B	PM	10142018	2	Adult	Gray	White	Gray+White	Above Ground	gingko tree by traffic light in front of Strawberry Fields	false	false	false	false	true		false	false	false	false	true	false	false	false	came over on tree to see me then disappeared	POINT (-73.9751729403694 40.7743284123118)	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
650	650	-73.9809610117171	40.7683896665502	2A-AM-1010-02	02A	AM	10102018	2		Gray	Cinnamon	Gray+Cinnamon	Above Ground	perched on small fence	false	false	false	true	false		false	false	false	false	true	false	false	true		POINT (-73.9809610117171 40.7683896665502)	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
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
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
2153	2153	-73.9797122322834	40.7678347587435	1B-PM-1019-10	01B	PM	10192018	10	Adult	Cinnamon	White	Cinnamon+White	Above Ground	Dog chased up tree	false	false	true	false	false		false	false	false	false	true	false	false	false		POINT (-73.97971223228342 40.7678347587435)	19	4	19	13
2522	2522	-73.9658747245917	40.7754033737532	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	Fallen branch	true	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9658747245917 40.7754033737532)	19	4	19	13
2586	2586	-73.9752965316933	40.7752538575789	10B-AM-1006-03	10B	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	In tree	false	false	true	false	false		false	false	false	false	true	true	false	false		POINT (-73.9752965316933 40.7752538575789)	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
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

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