squirrels

7 rows where Above Ground Sighter Measurement = 3 and Date = 10102018 sorted by Community Districts

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
110	110	-73.9711318790279	40.7701941550273	7G-AM-1010-02	07G	AM	10102018	2	Adult	Gray		Gray+	Above Ground	3		true	false	false	false	false	false	false	false	false	true	false	false	true	POINT (-73.9711318790279 40.7701941550273)	19	4	19	13
237	237	-73.967895656898	40.7767409597341	15F-PM-1010-07	15F	PM	10102018	7	Adult	Gray		Gray+	Above Ground	3	on fence	true	false	false	false	false	false	false	false	false	false	false	false	true	POINT (-73.967895656898 40.7767409597341)	19	4	19	13
822	822	-73.9576559099012	40.7992598626483	41B-AM-1010-09	41B	AM	10102018	9	Adult	Gray		Gray+	Above Ground	3		false	true	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9576559099012 40.7992598626483)	19	4	19	13
899	899	-73.9792754037291	40.7679690700399	2C-AM-1010-08	02C	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3	stay on side of trunk	false	false	true	false	false	false	false	false	false	false	false	false	false	POINT (-73.9792754037291 40.7679690700399)	19	4	19	13
1825	1825	-73.9624209799704	40.7910200972752	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	3		false	false	true	false	false	false	false	false	false	true	false	false	true	POINT (-73.9624209799704 40.7910200972752)	19	4	19	13
2406	2406	-73.9668964315686	40.7777577990886	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	3		false	false	true	false	false	false	false	false	false	true	false	false	true	POINT (-73.9668964315686 40.7777577990886)	19	4	19	13
2476	2476	-73.9710843362124	40.7679739601336	5I-AM-1010-03	05I	AM	10102018	3	Adult	Gray		Gray+	Above Ground	3		false	false	false	false	false	false	false	false	false	false	false	true	false	POINT (-73.9710843362124 40.7679739601336)	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
);