squirrels

8 rows where Date = 10122018 and Primary Fur Color = "Black"

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
325	325	-73.9630990823243	40.7885764284016	28D-AM-1012-02	28D	AM	10122018	2	Adult	Black		Black+	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	false	true	POINT (-73.9630990823243 40.7885764284016)	19	4	19	13
1232	1232	-73.9589254878322	40.7914467650712	33E-PM-1012-09	33E	PM	10122018	9	Adult	Black		Black+	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	false	false	false	true	POINT (-73.9589254878322 40.7914467650712)	19	4	19	13
1473	1473	-73.9584064190878	40.7912992852442	33F-PM-1012-03	33F	PM	10122018	3	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE	false	false	false	true	true		false	false	false	false	true	false	true	false	POINT (-73.9584064190878 40.7912992852442)	19	4	19	13
1516	1516	-73.9625383795297	40.7883862331728	28D-AM-1012-03	28D	AM	10122018	3	Adult	Black		Black+	Above Ground	30	true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9625383795297 40.7883862331728)	19	4	19	13
1845	1845	-73.9626560807032	40.7884633049896	28D-AM-1012-05	28D	AM	10122018	5	Juvenile	Black		Black+	Above Ground	30	false	false	true	false	false		false	false	false	false	false	false	false	false	POINT (-73.9626560807032 40.7884633049896)	19	4	19	13
1959	1959	-73.9707737073771	40.7800373465838	17B-PM-1012-02	17B	PM	10122018	2	Adult	Black		Black+	Ground Plane	FALSE	true	true	false	false	true	2/3 chasing each other	true	true	false	true	true	false	true	false	POINT (-73.9707737073771 40.7800373465838)	19	4	19	13
2113	2113	-73.9582904814652	40.7905915749564	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black		Black+	Ground Plane	FALSE	true	false	false	false	false		false	false	false	false	false	false	false	false	POINT (-73.9582904814652 40.7905915749564)	19	4	19	13
2638	2638	-73.9598973337711	40.7933346360478	34C-PM-1012-01	34C	PM	10122018	1	Adult	Black		Black+	Ground Plane	FALSE	false	false	false	false	true	digging	false	false	false	false	false	false	true	false	POINT (-73.9598973337711 40.7933346360478)	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
);