squirrels

5 rows where Date = 10182018 and Primary Fur Color = "Black" sorted by Other Activities

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	Color notes	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
182	182	-73.9691050656013	40.7808139538222	18C-PM-1018-01	18C	PM	10182018	1		Black		Black+		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9691050656013 40.7808139538222)	19	4	19	13
691	691	-73.9695964983454	40.7802302192799	18C-PM-1018-08	18C	PM	10182018	8	Juvenile	Black		Black+		Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9695964983454 40.7802302192799)	19	4	19	13
746	746	-73.9591407691	40.7960846903122	37B-AM-1018-01	37B	AM	10182018	1	Adult	Black		Black+		Ground Plane	FALSE	true	false	false	false	false		false	false	false	false	true	false	true	false	POINT (-73.9591407691 40.7960846903122)	19	4	19	13
1528	1528	-73.9690104245067	40.7853358193723	23A-AM-1018-02	23A	AM	10182018	2	Juvenile	Black		Black+		Ground Plane	FALSE	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9690104245067 40.7853358193723)	19	4	19	13
1086	1086	-73.9713399316534	40.7750678026757	12E-PM-1018-02	12E	PM	10182018	2	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	3	false	false	true	false	false	lounging on tree upside down	false	false	false	false	true	false	true	false	POINT (-73.9713399316534 40.7750678026757)	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
);