squirrels

14 rows where Hectare Squirrel Number = 1, Indifferent = "false", Primary Fur Color = "Cinnamon" and Tail twitches = "true" sorted by Combination of Primary and Highlight Color

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	Zip Codes	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	false	false	false	true	false		false	false	false	true	true	true	false	false		POINT (-73.9594357049738 40.7840678890949)		19	4	19	13
2757	2757	-73.9671419119456	40.7758602486862	14G-AM-1012-01	14G	AM	10122018	1	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9671419119456 40.7758602486862)		19	4	19	13
534	534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		true	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.9650499507011 40.7908191782173)		19	4	19	13
1939	1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	false	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.9540151828782 40.7920066170587)		19	4	19	13
2033	2033	-73.9500167570283	40.7966185836685	41I-AM-1018-01	41I	AM	10182018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	true	false	false	false	cautious,observant,runs off	POINT (-73.9500167570283 40.7966185836685)		19	4	19	13
2244	2244	-73.9509628195532	40.7977775674178	42H-PM-1014-01	42H	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2		false	false	false	false	false		false	false	false	false	true	false	false	true		POINT (-73.9509628195532 40.7977775674178)	12423	18	4	36	18
2998	2998	-73.9752079247419	40.7755376979002	11B-AM-1007-01	11B	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	true	true	false	false		POINT (-73.9752079247419 40.7755376979002)		19	4	19	13
2030	2030	-73.9749251267433	40.7679111971294	4F-PM-1013-01	04F	PM	10132018	1	Adult	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	true	false	false		POINT (-73.9749251267433 40.7679111971294)		19	4	19	13
982	982	-73.9676424599715	40.7777766106807	16F-AM-1008-01	16F	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	near fence	false	false	false	false	true		false	false	false	false	true	true	false	false		POINT (-73.9676424599715 40.7777766106807)		19	4	19	13
2989	2989	-73.9643538221947	40.7917565604735	31A-PM-1017-01	31A	PM	10172018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White	Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9643538221947 40.7917565604735)		19	4	19	13
27	27	-73.9670628558161	40.7734991420941	12I-AM-1013-01	12I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on tree roots	false	false	false	false	false	sitting	false	false	false	false	true	false	false	true		POINT (-73.9670628558161 40.77349914209411)		19	4	19	13
2278	2278	-73.964539031099	40.7809916310012	20G-PM-1013-01	20G	PM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.964539031099 40.7809916310012)		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
2900	2900	-73.9631005470369	40.7885494057193	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9631005470369 40.7885494057193)		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
);