squirrels

5 rows where Above Ground Sighter Measurement = 10, Climbing = "true" and Date = 10122018

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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
667	667	-73.9624538733037	40.7883829851518	28D-AM-1012-04	28D	AM	10122018	4	Adult	Cinnamon	White	Cinnamon+White	Above Ground	10		false	false	true	false	false	false	false	false	false	false	false	false	true	POINT (-73.9624538733037 40.7883829851518)	19	4	19	13
1576	1576	-73.9619985187616	40.7943277743532	34A-AM-1012-02	34A	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	chasing from tree to ground	true	true	true	false	false	false	false	false	false	false	false	true	false	POINT (-73.9619985187616 40.7943277743532)	19	4	19	13
2002	2002	-73.9581706950566	40.7906321397269	32F-AM-1012-05	32F	AM	10122018	5	Adult	Gray	White	Gray+White	Above Ground	10		true	false	true	false	false	false	false	false	false	false	false	false	false	POINT (-73.9581706950566 40.7906321397269)	19	4	19	13
2232	2232	-73.9566277721581	40.7966674587803	39D-PM-1012-04	39D	PM	10122018	4	Juvenile	Gray	White	Gray+White	Above Ground	10	on tree trunk (descending from height of ~10 ft)	false	false	true	false	false	false	false	false	false	false	false	true	false	POINT (-73.95662777215811 40.7966674587803)	19	4	19	13
2652	2652	-73.9620542514749	40.7943731722138	34A-AM-1012-01	34A	AM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10	chasing from tree to ground	true	true	true	false	false	false	false	false	false	false	false	true	false	POINT (-73.9620542514749 40.7943731722138)	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
);