squirrels

11 rows where Chasing = "true", Hectare Squirrel Number = 1, Indifferent = "false" and Runs from = "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	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
144	144	-73.9730750601212	40.7701304211944	6F-PM-1008-01	06F	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9730750601212 40.7701304211944)	19	4	19	13
633	633	-73.9673243699918	40.7875392957722	26A-AM-1014-01	26A	AM	10142018	1		Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	false	false	could not get close due to fences	POINT (-73.9673243699918 40.7875392957722)	19	4	19	13
751	751	-73.9683479943823	40.7815827298303	20C-PM-1018-01	20C	PM	10182018	1	Juvenile	Gray		Gray+	Ground Plane	FALSE		true	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9683479943823 40.7815827298303)	19	4	19	13
1004	1004	-73.9670850805619	40.7833747810387	22C-PM-1006-01	22C	PM	10062018	1	Juvenile	Gray		Gray+	Ground Plane	FALSE		true	true	false	false	false	for food	false	true	false	false	false	false	false	false		POINT (-73.9670850805619 40.7833747810387)	19	4	19	13
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10	Oak tree	false	true	false	false	false	watching me	false	true	false	true	false	false	false	false	observant	POINT (-73.9667474482967 40.7760643720793)	19	4	19	13
1264	1264	-73.9785353775382	40.7674923683184	2C-PM-1013-01	02C	PM	10132018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE		true	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9785353775382 40.7674923683184)	19	4	19	13
1835	1835	-73.9562068537632	40.7967332853238	39D-AM-1008-01	39D	AM	10082018	1	Adult	Gray		Gray+	Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9562068537632 40.7967332853238)	19	4	19	13
1864	1864	-73.9694344956258	40.7742869276902	12G-PM-1007-01	12G	PM	10072018	1		Gray		Gray+	Above Ground	40	in tree	false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9694344956258 40.7742869276902)	19	4	19	13
1997	1997	-73.9714637683084	40.7768984561563	14D-PM-1019-01	14D	PM	10192018	1	Adult	Gray		Gray+	Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9714637683084 40.7768984561563)	19	4	19	13
2313	2313	-73.9646174034945	40.7781287528262	18H-AM-1018-01	18H	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Running from one tree to the other	true	true	false	false	false	playing?	false	false	false	false	false	false	false	false		POINT (-73.9646174034945 40.7781287528262)	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

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