squirrels

11 rows where Date = 10082018 and Tail flags = "true" sorted by Lat/Long

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	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
2489	2489	-73.9663168490265	40.7825083721362	21D-AM-1008-01	21D	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	true	true		false	false	false	true	true	false	true	false		POINT (-73.9663168490265 40.7825083721362)	19	4	19	13
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10	Oak tree	false	true	false	false	false	watching me	false	true	false	true	false	false	false	false	observant	POINT (-73.9667474482967 40.7760643720793)	19	4	19	13
80	80	-73.9688454483585	40.7845301288163	22A-AM-1008-05	22A	AM	10082018	5	Adult	Gray	White	Gray+White	Above Ground	3	trash can	false	false	false	true	false		false	false	false	true	false	false	false	true		POINT (-73.9688454483585 40.7845301288163)	19	4	19	13
2185	2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White	Above Ground	10		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9707571364399 40.7758859812524)	19	4	19	13
210	210	-73.9711298491132	40.7676902603543	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	15	in tree by arsenal - climbing	false	false	true	true	false		false	false	false	true	false	false	false	false		POINT (-73.9711298491132 40.7676902603543)	19	4	19	13
1981	1981	-73.972154069981	40.7690128009722	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE	grass	false	false	false	true	true		false	false	false	true	false	false	true	false		POINT (-73.972154069981 40.7690128009722)	19	4	19	13
2429	2429	-73.9726699686943	40.7701123791223	7F-AM-1008-01	07F	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	under bench	false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9726699686943 40.7701123791223)	19	4	19	13
1982	1982	-73.9729979174723	40.7742904356698	10D-PM-1008-01	10D	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9729979174723 40.7742904356698)	19	4	19	13
507	507	-73.9744835563086	40.7729521433235	9D-AM-1008-01	09D	AM	10082018	1	Adult	Gray		Gray+	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	false	true		POINT (-73.9744835563086 40.7729521433235)	19	4	19	13
150	150	-73.9763430829342	40.7686351097159	4D-PM-1008-11	04D	PM	10082018	11	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	3	on tree facing downward	false	true	false	false	false	chased #12	true	false	false	true	false	false	false	true		POINT (-73.9763430829342 40.7686351097159)	19	4	19	13
194	194	-73.9764839973068	40.7691725326976	4D-PM-1008-06	04D	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		false	false	false	false	true		false	false	false	true	false	false	true	false		POINT (-73.9764839973068 40.7691725326976)	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
);