squirrels

7 rows where Above Ground Sighter Measurement = 30 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	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
767	767	-73.9655734633649	40.7805366922231	20F-AM-1014-02	20F	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	30	false	false	true	false	false	pulling leaves	true	false	false	false	false	false	false	false		POINT (-73.9655734633649 40.7805366922231)	19	4	19	13
835	835	-73.9707900566519	40.7771670550089	14D-AM-1014-09	14D	AM	10142018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	30	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9707900566519 40.7771670550089)	19	4	19	13
1022	1022	-73.9548853492712	40.7984783584388	41D-PM-1014-04	41D	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	30	false	false	true	false	false	jumping tree to tree	false	false	false	false	false	false	false	false		POINT (-73.9548853492712 40.7984783584388)	19	4	19	13
1041	1041	-73.9643236505425	40.7887854771596	28C-AM-1014-02	28C	AM	10142018	2	Adult	Gray		Gray+	Above Ground	30	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9643236505425 40.7887854771596)	19	4	19	13
1355	1355	-73.9655277320465	40.7806120529369	20F-AM-1014-03	20F	AM	10142018	3	Adult	Gray		Gray+	Above Ground	30	false	false	true	false	false		true	false	false	false	false	false	false	false		POINT (-73.9655277320465 40.7806120529369)	19	4	19	13
2016	2016	-73.9589492240754	40.798901118974	40A-PM-1014-01	40A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	30	false	false	true	false	false		false	false	false	false	true	false	true	false	stared & then went back up tree—then ran to different tree	POINT (-73.9589492240754 40.798901118974)	19	4	19	13
2933	2933	-73.9677903197449	40.7826561917755	21C-AM-1014-03	21C	AM	10142018	3	Adult	Gray		Gray+	Above Ground	30	false	true	true	false	false		false	true	false	false	false	false	false	false	looked at us from tree	POINT (-73.9677903197449 40.7826561917755)	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
);