squirrels

5 rows where Above Ground Sighter Measurement = 40 and Date = 10142018

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	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
920	920	-73.9571233640232	40.7992458980266	41B-PM-1014-04	41B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	40	false	false	true	false	false	false	false	false	false	false	false	false	false	climbing	POINT (-73.9571233640232 40.7992458980266)	19	4	19	13
1045	1045	-73.9730420696993	40.7786151019726	15B-AM-1014-01	15B	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	40	false	false	true	false	true	false	false	false	false	false	false	false	false		POINT (-73.9730420696993 40.7786151019726)	19	4	19	13
1630	1630	-73.9710025484537	40.7792529489016	16C-AM-1014-01	16C	AM	10142018	1	Juvenile	Gray		Gray+	Above Ground	40	false	false	true	false	false	false	false	false	false	false	false	true	false		POINT (-73.9710025484537 40.7792529489016)	19	4	19	13
2243	2243	-73.9579967047318	40.7948682042252	37D-PM-1014-02	37D	PM	10142018	2	Adult	Gray		Gray+	Above Ground	40	false	false	true	false	false	false	false	false	false	false	false	false	false		POINT (-73.95799670473181 40.7948682042252)	19	4	19	13
2441	2441	-73.9579865329778	40.794906535675	37D-PM-1014-03	37D	PM	10142018	3	Adult	Gray		Gray+	Above Ground	40	false	false	true	false	false	false	false	false	false	false	false	false	false		POINT (-73.9579865329778 40.794906535675)	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
);