squirrels

13 rows where Climbing = "false", Combination of Primary and Highlight Color = "Black+", Indifferent = "false" and Runs from = "false"

descending

Link	rowid ▼	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary 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
42	42	-73.9579564338627	40.7959337795027	38C-PM-1014-09	38C	PM	10142018	9	Adult	Black	Black+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	true	false	false		POINT (-73.9579564338627 40.7959337795027)	19	4	19	13
227	227	-73.9598155300913	40.7905887826983	32E-AM-1007-10	32E	AM	10072018	10	Adult	Black	Black+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9598155300913 40.7905887826983)	19	4	19	13
691	691	-73.9695964983454	40.7802302192799	18C-PM-1018-08	18C	PM	10182018	8	Juvenile	Black	Black+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9695964983454 40.7802302192799)	19	4	19	13
721	721	-73.9718262034469	40.7666771797442	4I-PM-1007-02	04I	PM	10072018	2	Adult	Black	Black+		Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9718262034469 40.7666771797442)	19	4	19	13
872	872	-73.9551524422379	40.7910535596756	34H-PM-1006-01	34H	PM	10062018	1	Adult	Black	Black+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9551524422379 40.7910535596756)	19	4	19	13
1101	1101	-73.95912925497	40.7925530280455	34D-AM-1008-01	34D	AM	10082018	1	Adult	Black	Black+		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false	staring at us	POINT (-73.95912925497001 40.7925530280455)	19	4	19	13
1267	1267	-73.9701010964667	40.7688919314508	6I-PM-1013-02	06I	PM	10132018	2	Adult	Black	Black+		Ground Plane	FALSE	Bushes	false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9701010964667 40.76889193145081)	19	4	19	13
2113	2113	-73.9582904814652	40.7905915749564	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black	Black+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9582904814652 40.7905915749564)	19	4	19	13
2150	2150	-73.9557710118271	40.7919161185557	34G-PM-1006-01	34G	PM	10062018	1	Adult	Black	Black+	Skinny, thin tail	Ground Plane	FALSE		false	false	false	false	false	digging	false	false	false	false	false	false	false	false		POINT (-73.9557710118271 40.7919161185557)	19	4	19	13
2284	2284	-73.9730181306326	40.7794601322427	16A-AM-1013-02	16A	AM	10132018	2	Adult	Black	Black+		Above Ground			false	false	false	false	true		false	false	false	false	false	true	false	false		POINT (-73.9730181306326 40.7794601322427)	19	4	19	13
2322	2322	-73.9723677854798	40.7667315410871	3H-AM-1008-04	03H	AM	10082018	4	Adult	Black	Black+		Above Ground	50		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9723677854798 40.7667315410871)	19	4	19	13
2413	2413	-73.959701727877	40.790660026971	32E-AM-1007-03	32E	AM	10072018	3	Adult	Black	Black+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.959701727877 40.790660026971)	19	4	19	13
2557	2557	-73.9712454251679	40.7674262749891	5I-PM-1008-02	05I	PM	10082018	2	Adult	Black	Black+		Ground Plane	FALSE	crossing pavement in front of arsenal	true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9712454251679 40.7674262749891)	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
);