squirrels

15 rows where Combination of Primary and Highlight Color = "Cinnamon+White" and Hectare Squirrel Number = 1 sorted by Zip Codes descending

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
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
699	699	-73.9504693544225	40.797225436004	42H-AM-1019-01	42H	AM	10192018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	false	false	false		POINT (-73.9504693544225 40.797225436004)	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
931	931	-73.9785948413883	40.7718908026758	6A-PM-1012-01	06A	PM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	true	false	true		false	false	false	false	false	false	false	false		POINT (-73.9785948413883 40.7718908026758)	19	4	19	13
1650	1650	-73.9762494239719	40.7750175306716	10A-AM-1006-01	10A	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	near Strawberry Fields	false	false	false	true	false	eating (a peanut)	false	false	false	false	false	true	false	false		POINT (-73.9762494239719 40.7750175306716)	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
2044	2044	-73.9771552326199	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		true	false	true	false	false		false	false	false	true	false	true	false	false		POINT (-73.9771552326199 40.7706917595308)	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
2252	2252	-73.9537703231359	40.7915959393814	35I-AM-1013-01	35I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White	White underbelly	Above Ground	18		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9537703231359 40.7915959393814)	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
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
2764	2764	-73.9692660977515	40.7830532310766	21B-PM-1017-01	21B	PM	10172018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	false	false	paused to look at me	POINT (-73.9692660977515 40.7830532310766)	19	4	19	13
2794	2794	-73.9712187890707	40.7750640173134	12E-PM-1018-01	12E	PM	10182018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		true	false	true	false	false		true	false	false	true	false	false	false	true		POINT (-73.9712187890707 40.7750640173134)	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
);