squirrels

7 rows where Date = 10192018 and Primary Fur Color = "Cinnamon" sorted by Approaches

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	Specific Location	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
495	495	-73.9801007327506	40.7677455633932	1B-PM-1019-06	01B	PM	10192018	6	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9801007327506 40.7677455633932)	19	4	19	13
699	699	-73.9504693544225	40.797225436004	42H-AM-1019-01	42H	AM	10192018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	false	false		POINT (-73.9504693544225 40.797225436004)	19	4	19	13
2153	2153	-73.9797122322834	40.7678347587435	1B-PM-1019-10	01B	PM	10192018	10	Adult	Cinnamon	White	Cinnamon+White		Above Ground		Dog chased up tree	false	false	true	false	false		false	false	false	false	true	false	false	false		POINT (-73.97971223228342 40.7678347587435)	19	4	19	13
2488	2488	-73.9726920847792	40.7794117463889	16A-PM-1019-02	16A	PM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	true	scared by dog	POINT (-73.9726920847792 40.7794117463889)	19	4	19	13
2608	2608	-73.9522677657659	40.7934034811368	38I-AM-1019-02	38I	AM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9522677657659 40.7934034811368)	19	4	19	13
2802	2802	-73.9533101544112	40.7938634280159	38H-AM-1019-01	38H	AM	10192018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9533101544112 40.7938634280159)	19	4	19	13
2882	2882	-73.956581233786	40.7902127690837	33H-AM-1019-01	33H	AM	10192018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Cinnamon patches	Ground Plane	FALSE		false	false	false	false	false	wrestling with child	false	false	false	false	false	false	false	false		POINT (-73.956581233786 40.79021276908371)	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
);