squirrels

10 rows where Combination of Primary and Highlight Color = "Black+" and Date = 10072018 sorted by Other Activities

descending

Link	rowid	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary 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
130	130	-73.9581655949437	40.7997708190022	41A-PM-1007-06	41A	PM	10072018	6	Adult	Black	Black+	Ground Plane	FALSE	true	false	true	true	false		false	false	false	false	false	false	false	true		POINT (-73.9581655949437 40.7997708190022)	19	4	19	13
227	227	-73.9598155300913	40.7905887826983	32E-AM-1007-10	32E	AM	10072018	10	Adult	Black	Black+	Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9598155300913 40.7905887826983)	19	4	19	13
369	369	-73.9596398997228	40.7933386953847	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black	Black+	Above Ground	25	true	false	true	false	false		false	false	false	false	false	false	false	false	cautiously aware	POINT (-73.9596398997228 40.7933386953847)	19	4	19	13
634	634	-73.9596375907038	40.7907347708353	32E-AM-1007-05	32E	AM	10072018	5	Adult	Black	Black+	Above Ground	30	false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9596375907038 40.79073477083531)	19	4	19	13
721	721	-73.9718262034469	40.7666771797442	4I-PM-1007-02	04I	PM	10072018	2	Adult	Black	Black+	Ground Plane	FALSE	false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9718262034469 40.7666771797442)	19	4	19	13
1307	1307	-73.9565197137317	40.7986011403785	41C-PM-1007-01	41C	PM	10072018	1	Adult	Black	Black+	Ground Plane	FALSE	true	false	false	true	false		false	false	false	false	false	false	false	true		POINT (-73.9565197137317 40.7986011403785)	19	4	19	13
2166	2166	-73.9711178122133	40.7672642958437	4I-PM-1007-01	04I	PM	10072018	1	Adult	Black	Black+	Ground Plane	FALSE	true	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9711178122133 40.76726429584371)	19	4	19	13
2413	2413	-73.959701727877	40.790660026971	32E-AM-1007-03	32E	AM	10072018	3	Adult	Black	Black+	Ground Plane	FALSE	true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.959701727877 40.790660026971)	19	4	19	13
2469	2469	-73.9600963639087	40.7934962325313	34C-AM-1007-01	34C	AM	10072018	1	Adult	Black	Black+	Ground Plane	FALSE	true	false	false	false	false		false	false	false	true	false	false	false	true	dog	POINT (-73.9600963639087 40.7934962325313)	19	4	19	13
1887	1887	-73.9586184232889	40.7993153832942	41A-PM-1007-02	41A	PM	10072018	2	Adult	Black	Black+	Above Ground	15	false	false	true	false	false	jumping	false	false	false	false	false	false	false	false	stared at me	POINT (-73.9586184232889 40.7993153832942)	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
);