squirrels

11 rows where Above Ground Sighter Measurement = "" and Hectare Squirrel Number = 1 sorted by City Council Districts

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	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
5	5	-73.9593126695714	40.797533370163	39B-AM-1018-01	39B	AM	10182018	1				+	Above Ground		false	false	false	false	false	unknown	true	false	false	false	false	false	false	false		POINT (-73.9593126695714 40.797533370163)	19	4	19	13
91	91	-73.9565905868276	40.7895654068546	32H-PM-1006-01	32H	PM	10062018	1		Gray		Gray+	Above Ground	in the European Beech	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9565905868276 40.7895654068546)	19	4	19	13
333	333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	on a tree	false	false	false	true	true	walking up & down branches	false	false	false	false	false	false	true	false		POINT (-73.9667560049684 40.7882333830729)	19	4	19	13
385	385	-73.979316275899	40.7692134727555	3B-PM-1007-01	03B	PM	10072018	1	Adult	Gray	White	Gray+White	Above Ground	in tree	false	false	false	false	false	chased by dog	false	false	false	false	false	false	false	false		POINT (-73.979316275899 40.7692134727555)	19	4	19	13
498	498	-73.9669432929573	40.779136518298	18F-AM-1014-01	18F	AM	10142018	1	Adult	Gray	White	Gray+White	Above Ground	Low tree	false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9669432929573 40.779136518298)	19	4	19	13
512	512	-73.9586098170241	40.7939653733898	35D-AM-1019-01	35D	AM	10192018	1				+	Above Ground	on tree, blue jays gathering nearby	false	false	false	false	false		true	false	false	false	false	false	false	false		POINT (-73.9586098170241 40.7939653733898)	19	4	19	13
528	528	-73.9647284206644	40.7839611840884	23E-PM-1006-01	23E	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	on a tree	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9647284206644 40.7839611840884)	19	4	19	13
1429	1429	-73.9706533131129	40.768902033819	6I-AM-1006-01	06I	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		true	false	true	true	true		false	false	false	false	false	false	false	true	runs from (someone sneezed)	POINT (-73.9706533131129 40.768902033819)	19	4	19	13
1764	1764	-73.9534878316472	40.7978951981698	41F-PM-1019-01	41F	PM	10192018	1				+			false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9534878316472 40.7978951981698)	19	4	19	13
1928	1928	-73.9725669210177	40.7681496989029	5H-AM-1007-01	05H	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon			false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9725669210177 40.7681496989029)	19	4	19	13
2522	2522	-73.9658747245917	40.7754033737532	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	Fallen branch	true	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9658747245917 40.7754033737532)	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
);