squirrels

17 rows where Above Ground Sighter Measurement = 5 and Climbing = "false"

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
46	46	-73.9673253417305	40.7749505252981	13H-PM-1010-02	13H	PM	10102018	2	Adult	Gray		Gray+		Above Ground	5	tree	false	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9673253417305 40.7749505252981)	19	4	19	13
284	284	-73.9547336666137	40.7938937756332	37G-PM-1007-07	37G	PM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		true	false	false	false	false		false	false	false	false	false	false	false	true	POINT (-73.9547336666137 40.7938937756332)	19	4	19	13
747	747	-73.9771422625274	40.772361415776	7B-AM-1008-02	07B	AM	10082018	2	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9771422625274 40.772361415776)	19	4	19	13
811	811	-73.9771695272048	40.7724277276263	7B-AM-1008-03	07B	AM	10082018	3	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9771695272048 40.7724277276263)	19	4	19	13
901	901	-73.9702228131711	40.7742131587983	12F-PM-1007-12	12F	PM	10072018	12	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	5		false	false	false	false	true	going down tree	false	false	false	false	false	false	true	false	POINT (-73.9702228131711 40.7742131587983)	19	4	19	13
1037	1037	-73.9677409841969	40.7763579140639	15G-PM-1019-08	15G	PM	10192018	8	Adult			+		Above Ground	5		false	true	false	false	false		false	true	true	false	false	false	false	false	POINT (-73.9677409841969 40.7763579140639)	19	4	19	13
1065	1065	-73.9769700777377	40.7728489574967	7B-AM-1008-08	07B	AM	10082018	8	Adult	Gray		Gray+		Above Ground	5		true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9769700777377 40.7728489574967)	19	4	19	13
1408	1408	-73.973230162241	40.7689824531444	5F-AM-1007-01	05F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	fence	true	false	false	true	false		false	false	false	false	false	false	false	false	POINT (-73.973230162241 40.7689824531444)	19	4	19	13
1527	1527	-73.970216605149	40.7702960667277	8H-PM-1014-08	08H	PM	10142018	8	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false	chasing (#7),playing?	false	false	false	false	false	false	true	false	POINT (-73.970216605149 40.7702960667277)	19	4	19	13
1688	1688	-73.9677593344667	40.7763054313195	15G-PM-1019-07	15G	PM	10192018	7	Adult			+		Above Ground	5		false	true	false	false	false		false	false	false	false	true	false	false	false	POINT (-73.9677593344667 40.7763054313195)	19	4	19	13
1817	1817	-73.9703076450783	40.770158422629	8H-PM-1014-07	08H	PM	10142018	7	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false	chasing (#8),playing?	false	false	false	false	false	false	true	false	POINT (-73.9703076450783 40.770158422629)	19	4	19	13
1863	1863	-73.9682830510954	40.7810151087286	19D-PM-1008-03	19D	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	may be same squirrel as #1 - male	Above Ground	5	on branch of dead tree	false	false	false	true	false		false	false	false	false	false	false	true	false	POINT (-73.9682830510954 40.7810151087286)	19	4	19	13
1955	1955	-73.9606559309874	40.7889527629826	30E-AM-1008-02	30E	AM	10082018	2	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false		true	false	false	false	false	false	true	false	POINT (-73.9606559309874 40.7889527629826)	19	4	19	13
2008	2008	-73.9524364087437	40.792846505434	37I-PM-1006-01	37I	PM	10062018	1	Adult	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Above Ground	5		false	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9524364087437 40.792846505434)	19	4	19	13
2654	2654	-73.9549261242548	40.7944701994615	37G-AM-1014-04	37G	AM	10142018	4	Adult	Gray		Gray+		Above Ground	5		false	true	false	false	false	playing	false	false	false	false	false	false	true	false	POINT (-73.9549261242548 40.7944701994615)	19	4	19	13
2708	2708	-73.9528429238071	40.7922651848867	36I-PM-1007-09	36I	PM	10072018	9	Juvenile	Gray		Gray+		Above Ground	5		true	true	false	false	false	burying nut	false	false	false	false	true	false	false	false	POINT (-73.9528429238071 40.7922651848867)	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

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
);