squirrels

5 rows where Date = 10172018 and Hectare Squirrel Number = 9

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
973	973	-73.9705977059862	40.7760413182276	13E-AM-1017-09	13E	AM	10172018	9	Adult	Gray		Gray+	Ground Plane	FALSE		false	false	false	false	true	false	false	false	false	false	false	false	false	POINT (-73.9705977059862 40.776041318227605)	19	4	19	13
1197	1197	-73.9590868748584	40.7906047630418	32E-PM-1017-09	32E	PM	10172018	9	Adult	Gray		Gray+	Ground Plane	FALSE	treed area	false	false	false	true	true	false	false	false	false	false	false	false	true	POINT (-73.9590868748584 40.7906047630418)	19	4	19	13
1479	1479	-73.9707498430394	40.7723724480959	10G-PM-1017-09	10G	PM	10172018	9	Adult	Gray		Gray+	Ground Plane	FALSE		false	true	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9707498430394 40.7723724480959)	19	4	19	13
2293	2293	-73.9675309175947	40.7788649926486	17E-AM-1017-09	17E	AM	10172018	9	Adult	Gray		Gray+	Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9675309175947 40.7788649926486)	19	4	19	13
2731	2731	-73.9595886063173	40.7918405182594	33D-AM-1017-09	33D	AM	10172018	9	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	7		false	false	true	false	false	true	true	false	false	false	false	true	true	POINT (-73.9595886063173 40.7918405182594)	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
);