squirrels

12 rows where Combination of Primary and Highlight Color = "Gray+White", Date = 10072018 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	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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
115	115	-73.9530040923555	40.7922896176936	36I-PM-1007-10	36I	PM	10072018	10	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false	stole (found?) an entire sandwich	false	false	false	false	false	false	true	false	POINT (-73.9530040923555 40.7922896176936)	19	4	19	13
407	407	-73.9787658435198	40.7689419765393	3B-PM-1007-07	03B	PM	10072018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false	eating loudly <- peanuts w/ shells	false	false	false	false	false	false	true	false	POINT (-73.9787658435198 40.7689419765393)	19	4	19	13
437	437	-73.9793952066038	40.7707837657859	4A-PM-1007-03	04A	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by rock	false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9793952066038 40.77078376578591)	19	4	19	13
475	475	-73.9697855573137	40.7742186391935	12F-PM-1007-05	12F	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9697855573137 40.7742186391935)	19	4	19	13
574	574	-73.9706360005275	40.7717074044466	9G-PM-1007-05	09G	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	false	true	POINT (-73.9706360005275 40.7717074044466)	19	4	19	13
741	741	-73.9790214253443	40.7686791169776	3B-PM-1007-10	03B	PM	10072018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false	hopping	false	false	false	false	false	false	true	false	POINT (-73.9790214253443 40.7686791169776)	19	4	19	13
996	996	-73.9703149829421	40.7785583630323	16D-AM-1007-01	16D	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	3		false	false	true	true	false		false	false	false	false	false	false	false	true	POINT (-73.9703149829421 40.7785583630323)	19	4	19	13
1494	1494	-73.9525752408169	40.7954915417553	39H-AM-1007-03	39H	AM	10072018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	false	false	POINT (-73.9525752408169 40.7954915417553)	19	4	19	13
1826	1826	-73.9707542189896	40.7717032986885	9G-PM-1007-04	09G	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	false	false	POINT (-73.9707542189896 40.77170329868851)	19	4	19	13
1929	1929	-73.9646023053207	40.7810680044024	20F-PM-1007-14	20F	PM	10072018	14	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9646023053207 40.78106800440241)	19	4	19	13
2040	2040	-73.9648167334089	40.7811164976329	20F-PM-1007-02	20F	PM	10072018	2	Adult	Gray	White	Gray+White	white on tail	Ground Plane	FALSE		false	false	false	true	true	digging one hole w/ determination	false	false	false	false	true	false	false	true	POINT (-73.96481673340891 40.7811164976329)	19	4	19	13
2730	2730	-73.9653575758687	40.7805339953372	20F-PM-1007-12	20F	PM	10072018	12	Adult	Gray	White	Gray+White		Above Ground	20	in tree	false	false	true	true	false		false	false	false	false	false	false	false	false	POINT (-73.9653575758687 40.7805339953372)	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
);