squirrels

11 rows where Above Ground Sighter Measurement = 6 and Eating = "true"

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
21	21	-73.9703781726172	40.7787526130321	16C-PM-1018-03	16C	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	6		true	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9703781726172 40.7787526130321)	19	4	19	13
44	44	-73.970252675331	40.7705999588222	8H-AM-1017-06	08H	AM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	6		false	true	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.970252675331 40.77059995882221)	19	4	19	13
1020	1020	-73.97016933635	40.7705452529783	8H-AM-1017-05	08H	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	6		true	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.97016933635001 40.7705452529783)	19	4	19	13
1396	1396	-73.9704677007779	40.7786860108302	16C-PM-1018-02	16C	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	6		false	true	false	true	true		false	false	false	false	true	false	true	false	POINT (-73.9704677007779 40.7786860108302)	19	4	19	13
1422	1422	-73.9537356145842	40.7917273773486	35I-PM-1006-02	35I	PM	10062018	2	Adult	Gray		Gray+	Above Ground	6		false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9537356145842 40.7917273773486)	19	4	19	13
1546	1546	-73.976422624924	40.7735818387346	8B-AM-1007-08	08B	AM	10072018	8	Adult	Gray		Gray+	Above Ground	6		false	false	false	true	false	holding nut	false	false	false	false	false	false	true	false	POINT (-73.976422624924 40.7735818387346)	19	4	19	13
1566	1566	-73.9695133370801	40.7765009796853	14E-AM-1008-16	14E	AM	10082018	16	Adult	Gray		Gray+	Above Ground	6		false	false	true	true	true		false	false	false	false	false	false	true	false	POINT (-73.9695133370801 40.7765009796853)	19	4	19	13
1776	1776	-73.9562350820255	40.7913464147989	34G-PM-1006-02	34G	PM	10062018	2	Adult	Gray		Gray+	Above Ground	6		false	false	true	true	true	eating bread it found on ground	false	false	false	false	false	false	false	true	POINT (-73.9562350820255 40.7913464147989)	19	4	19	13
2379	2379	-73.9711865134364	40.7785039981892	15C-AM-1010-03	15C	AM	10102018	3	Adult	Gray		Gray+	Above Ground	6		false	false	false	true	false	sitting	false	false	false	false	false	false	true	false	POINT (-73.9711865134364 40.7785039981892)	19	4	19	13
2613	2613	-73.96393252683	40.7808289765857	21G-AM-1014-04	21G	AM	10142018	4	Adult	Gray	White	Gray+White	Above Ground	6		false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.96393252683 40.7808289765857)	19	4	19	13
2859	2859	-73.9786940945874	40.7690820276888	3B-PM-1007-05	03B	PM	10072018	5	Juvenile	Gray		Gray+	Above Ground	6	on rock	false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9786940945874 40.7690820276888)	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
);