squirrels

16 rows where Above Ground Sighter Measurement = 10, Date = 10102018 and Police Precincts = 13

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	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
188	188	-73.9570528770427	40.7990973804149	41B-AM-1010-07	41B	AM	10102018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	10		false	false	false	false	false		true	false	false	true	false	true	false	false	mad!	POINT (-73.9570528770427 40.7990973804149)	19	4	19	13
191	191	-73.9787105069657	40.7693708133873	3B-AM-1010-08	03B	AM	10102018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	false	true	false	false	together w/ #7	false	false	false	false	false	false	true	false		POINT (-73.9787105069657 40.7693708133873)	19	4	19	13
281	281	-73.9619411917909	40.7923536640283	33B-PM-1010-11	33B	PM	10102018	11	Adult	Gray		Gray+	Above Ground	10		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9619411917909 40.7923536640283)	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
908	908	-73.9594120573719	40.7841945750598	26I-PM-1010-05	26I	PM	10102018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	tree	false	false	true	false	true		false	false	false	false	false	false	true	false		POINT (-73.9594120573719 40.7841945750598)	19	4	19	13
1125	1125	-73.9775735077285	40.7692872082165	4C-PM-1010-08	04C	PM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	on stone arch	true	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9775735077285 40.7692872082165)	19	4	19	13
1268	1268	-73.9623984262936	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White	Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9623984262936 40.7913900453449)	19	4	19	13
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+	Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9791648157033 40.767625444347)	19	4	19	13
1768	1768	-73.9773696455031	40.7687241866704	3D-PM-1010-14	03D	PM	10102018	14	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	false	false	false	false	crying out	true	true	false	false	false	false	false	false		POINT (-73.9773696455031 40.7687241866704)	19	4	19	13
1799	1799	-73.978844141973	40.7696046074378	4B-AM-1010-05	04B	AM	10102018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10		false	true	false	false	false	chasing squirrel #6	true	true	false	false	true	false	false	false		POINT (-73.978844141973 40.7696046074378)	19	4	19	13
2226	2226	-73.9624296435843	40.791320813687	31C-PM-1010-02	31C	PM	10102018	2	Adult	Gray	White	Gray+White	Above Ground	10		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9624296435843 40.791320813687)	19	4	19	13
2297	2297	-73.9787771053108	40.769356212275	3B-AM-1010-07	03B	AM	10102018	7	Adult	Gray		Gray+	Above Ground	10		false	false	true	false	false	together w/ #8	false	false	false	true	false	false	true	false		POINT (-73.9787771053108 40.76935621227501)	19	4	19	13
2497	2497	-73.9622050752008	40.7886373772305	29D-PM-1010-01	29D	PM	10102018	1	Juvenile	Gray	White	Gray+White	Above Ground	10		false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9622050752008 40.7886373772305)	19	4	19	13
2744	2744	-73.9752915601718	40.7739329570033	9B-AM-1010-04	09B	AM	10102018	4				+	Above Ground	10		true	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9752915601718 40.7739329570033)	19	4	19	13
2896	2896	-73.970595860252	40.7832060751268	20A-AM-1010-01	20A	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	false	true	false	false		false	false	false	false	true	false	true	false		POINT (-73.970595860252 40.7832060751268)	19	4	19	13
2956	2956	-73.9654741695628	40.7890427851106	28B-PM-1010-01	28B	PM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	10	in a tree	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9654741695628 40.7890427851106)	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
);