squirrels

12 rows where Above Ground Sighter Measurement = 15 and Running = "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	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	Zip Codes	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
371	371	-73.964080104186	40.7907898627287	30B-AM-1007-02	30B	AM	10072018	2	Adult	Gray		Gray+	Above Ground	15		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.964080104186 40.7907898627287)		19	4	19	13
381	381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black		Black+	Above Ground	15		true	false	false	true	false		false	false	false	false	true	false	false	true	ran up tree	POINT (-73.959709414696 40.7919745085986)		19	4	19	13
852	852	-73.9609704650925	40.7938786854735	34B-AM-1013-03	34B	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	15		true	false	true	false	false	hopping	false	false	false	false	false	true	false	true		POINT (-73.9609704650925 40.7938786854735)		19	4	19	13
999	999	-73.980948293606	40.7685688850628	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White	Above Ground	15	in tree!	true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.980948293606 40.7685688850628)		19	4	19	13
1147	1147	-73.9631818528816	40.7925332194132	32A-AM-1018-01	32A	AM	10182018	1	Adult	Gray		Gray+	Above Ground	15		true	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9631818528816 40.7925332194132)		19	4	19	13
1426	1426	-73.9664986446294	40.778308334318	17G-PM-1017-02	17G	PM	10172018	2	Adult	Gray		Gray+	Above Ground	15		true	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9664986446294 40.778308334318)		19	4	19	13
1489	1489	-73.9501762527462	40.7975534086077	42H-PM-1014-05	42H	PM	10142018	5	Adult	Gray	White	Gray+White	Above Ground	15		true	true	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9501762527462 40.7975534086077)	12423	18	4	36	18
1767	1767	-73.958719099962	40.7947587726617	36C-AM-1014-04	36C	AM	10142018	4		Gray	White	Gray+White	Above Ground	15	Ground then tree to eat	true	false	true	true	false		false	false	false	false	false	false	false	true		POINT (-73.958719099962 40.7947587726617)		19	4	19	13
1989	1989	-73.9631646754647	40.7925716810884	32A-AM-1018-02	32A	AM	10182018	2	Adult	Gray		Gray+	Above Ground	15		true	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9631646754647 40.7925716810884)		19	4	19	13
2242	2242	-73.9565824187667	40.797312050952	40D-AM-1013-06	40D	AM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	15		true	false	true	false	true		true	false	false	false	true	false	false	true		POINT (-73.9565824187667 40.797312050952)		19	4	19	13
2412	2412	-73.9809446489564	40.7685032165879	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White	Above Ground	15	in tree!	true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9809446489564 40.7685032165879)		19	4	19	13
3008	3008	-73.9503533343658	40.7976543603953	42H-PM-1014-04	42H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	15		true	true	false	false	false		false	false	false	false	true	false	false	true		POINT (-73.9503533343658 40.7976543603953)	12423	18	4	36	18

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