squirrels

16 rows where Combination of Primary and Highlight Color = "Cinnamon+White", Indifferent = "false" and Location = "Above Ground" sorted by Zip Codes

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
268	268	-73.968107276769	40.7768612676036	15F-AM-1007-09	15F	AM	10072018	9	Adult	Cinnamon	White	Cinnamon+White		Above Ground	20		false	false	true	false	true		false	false	false	false	false	false	false	true		POINT (-73.968107276769 40.7768612676036)	19	4	19	13
600	600	-73.9808202088503	40.7682921842325	1A-PM-1014-02	01A	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9808202088503 40.7682921842325)	19	4	19	13
667	667	-73.9624538733037	40.7883829851518	28D-AM-1012-04	28D	AM	10122018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9624538733037 40.7883829851518)	19	4	19	13
844	844	-73.9642379942652	40.7774792520738	17I-PM-1017-01	17I	PM	10172018	1	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	15		false	false	true	false	false		false	false	false	false	false	false	false	false	was in a tree,so i couldn't really tell	POINT (-73.9642379942652 40.7774792520738)	19	4	19	13
1652	1652	-73.9498421746221	40.7969397424182	42I-PM-1014-02	42I	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	8		true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9498421746221 40.7969397424182)	19	4	19	13
1832	1832	-73.9693159934697	40.7831212338295	21B-PM-1017-03	21B	PM	10172018	3	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9693159934697 40.7831212338295)	19	4	19	13
1916	1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		false	true	false	false	false		false	true	false	false	false	false	false	false	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)	19	4	19	13
2005	2005	-73.9755259087781	40.7707256124181	6D-AM-1008-01	06D	AM	10082018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		false	false	true	true	false		true	false	false	false	false	true	false	false		POINT (-73.9755259087781 40.7707256124181)	19	4	19	13
2114	2114	-73.9651541395415	40.7798283208748	19G-PM-1017-01	19G	PM	10172018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12		false	false	false	false	false	watching	false	false	false	false	false	true	false	false		POINT (-73.9651541395415 40.7798283208748)	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
2387	2387	-73.9808517324721	40.7683154647217	1A-PM-1014-01	01A	PM	10142018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		false	true	false	false	false		false	false	false	false	true	false	false	false		POINT (-73.9808517324721 40.7683154647217)	19	4	19	13
2503	2503	-73.974382557804	40.7674812627373	3F-AM-1006-10	03F	AM	10062018	10	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6	on fence	false	false	true	false	false		false	false	false	false	false	false	false	false	clueless	POINT (-73.974382557804 40.7674812627373)	19	4	19	13
2550	2550	-73.9694805745522	40.7743556902843	12F-AM-1020-01	12F	AM	10202018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	17	Tree	false	false	false	false	false	jumping	false	false	false	false	false	false	false	false		POINT (-73.9694805745522 40.7743556902843)	19	4	19	13
2742	2742	-73.9628041577934	40.7884180156055	28D-AM-1012-06	28D	AM	10122018	6	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	5		false	false	false	true	false		false	false	false	false	false	false	false	true		POINT (-73.9628041577934 40.78841801560551)	19	4	19	13
2745	2745	-73.97296259363	40.7652601851275	1I-PM-1012-04	01I	PM	10122018	4	Juvenile	Cinnamon	White	Cinnamon+White	Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	2	on ledge	false	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.97296259363 40.7652601851275)	19	4	19	13
2779	2779	-73.9767835160078	40.7674030330482	2E-PM-1014-04	02E	PM	10142018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	15		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9767835160078 40.7674030330482)	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
);