squirrels

6 rows where Date = 10122018 and Hectare Squirrel Number = 8

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	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
424	424	-73.9756557086441	40.773296289824	8B-PM-1012-08	08B	PM	10122018	8	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	false	false	false	false	true	false	false	false	false	false	false	true	false	POINT (-73.9756557086441 40.773296289824)	19	4	19	13
1060	1060	-73.9728871061191	40.7712983658944	8F-PM-1012-08	08F	PM	10122018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10	false	false	false	true	false	false	false	false	false	false	false	false	true	POINT (-73.9728871061191 40.7712983658944)	19	4	19	13
1772	1772	-73.9690540696008	40.7766014124609	14F-PM-1012-08	14F	PM	10122018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE	true	true	false	true	true	false	false	false	false	false	false	true	false	POINT (-73.9690540696008 40.7766014124609)	19	4	19	13
2023	2023	-73.9663977261879	40.775645134229	14H-PM-1012-08	14H	PM	10122018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	false	false	true	true	false	false	false	false	false	false	true	false	POINT (-73.9663977261879 40.775645134229)	19	4	19	13
2214	2214	-73.9583688637255	40.791388958496	33E-PM-1012-08	33E	PM	10122018	8	Adult	Gray	White	Gray+White	Ground Plane	FALSE	true	true	false	false	false	false	false	false	false	false	false	false	false	POINT (-73.9583688637255 40.791388958496)	19	4	19	13
2369	2369	-73.9801956082236	40.767836440957	1B-AM-1012-08	01B	AM	10122018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	false	true	false	true	false	false	false	false	false	false	false	true	false	POINT (-73.9801956082236 40.767836440957)	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
);