squirrels

17 rows where Above Ground Sighter Measurement = "" and Running = "true" sorted by Chasing

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
528	528	-73.9647284206644	40.7839611840884	23E-PM-1006-01	23E	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	on a tree	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9647284206644 40.7839611840884)	19	4	19	13
683	683	-73.9707683621584	40.7759815566123	13E-AM-1017-11	13E	AM	10172018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	on/in log	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9707683621584 40.77598155661231)	19	4	19	13
1064	1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon			true	false	true	false	false		false	false	false	false	false	false	true	true		POINT (-73.9540257319561 40.798408619116)	19	4	19	13
1429	1429	-73.9706533131129	40.768902033819	6I-AM-1006-01	06I	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		true	false	true	true	true		false	false	false	false	false	false	false	true	runs from (someone sneezed)	POINT (-73.9706533131129 40.768902033819)	19	4	19	13
1648	1648	-73.9790263372004	40.7683513714892	2C-PM-1013-07	02C	PM	10132018	7	Adult	Gray	White	Gray+White			true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9790263372004 40.7683513714892)	19	4	19	13
1765	1765	-73.9689041600147	40.7781788966185	16E-AM-1014-07	16E	AM	10142018	7	Adult	Gray		Gray+	Above Ground		true	false	false	false	false		false	false	false	false	false	false	false	true	runs from (dog)	POINT (-73.9689041600147 40.7781788966185)	19	4	19	13
1823	1823	-73.9612854506075	40.7920830673571	32C-PM-1013-04	32C	PM	10132018	4	Juvenile	Gray		Gray+	Above Ground		true	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9612854506075 40.7920830673571)	19	4	19	13
1850	1850	-73.975809362521	40.7734702737835	8B-PM-1012-09	08B	PM	10122018	9	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	tree	true	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.975809362521 40.7734702737835)	19	4	19	13
2080	2080	-73.954530253849	40.7910247489879	34I-PM-1010-07	34I	PM	10102018	7	Adult	Gray		Gray+			true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.954530253849 40.7910247489879)	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
2632	2632	-73.950827557335	40.797579073666	42H-PM-1014-02	42H	PM	10142018	2	Adult	Gray	White	Gray+White	Above Ground	Running along stone ledge	true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.950827557335 40.797579073666)	18	4	36	18
2836	2836	-73.953092053256	40.7982256930243	42F-PM-1017-03	42F	PM	10172018	3		Gray	Cinnamon	Gray+Cinnamon			true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.953092053256 40.7982256930243)	19	4	19	13
2840	2840	-73.9532163535175	40.7982970313067	42F-PM-1017-04	42F	PM	10172018	4		Gray		Gray+			true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9532163535175 40.7982970313067)	19	4	19	13
2866	2866	-73.9744025383371	40.7777296605765	13A-AM-1017-04	13A	AM	10172018	4	Adult	Gray		Gray+			true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9744025383371 40.7777296605765)	19	4	19	13
1451	1451	-73.9645365195454	40.7781531021263	18H-AM-1018-02	18H	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	Tree	true	true	false	false	false	playing?	false	false	false	false	false	false	false	false		POINT (-73.9645365195454 40.7781531021263)	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
2699	2699	-73.9743509423821	40.7690043677328	5F-AM-1007-02	05F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	tree	true	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.97435094238212 40.7690043677328)	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
);