squirrels

17 rows where Combination of Primary and Highlight Color = "Cinnamon+", Foraging = "false" and Shift = "AM" sorted by Approaches

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
3	3	-73.9768311751004	40.7667178072558	2E-AM-1010-03	02E	AM	10102018	3	Adult	Cinnamon	Cinnamon+		Above Ground	4		false	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9768311751004 40.76671780725581)	19	4	19	13
254	254	-73.9762246600197	40.775164077652	10A-AM-1006-03	10A	AM	10062018	3	Juvenile	Cinnamon	Cinnamon+		Ground Plane	FALSE	Bridle Path lawn	false	false	false	true	false		false	false	false	false	false	false	false	false		POINT (-73.9762246600197 40.775164077652)	19	4	19	13
255	255	-73.9800669115792	40.7676825134384	1B-AM-1012-07	01B	AM	10122018	7	Adult	Cinnamon	Cinnamon+		Above Ground	2	on tree trunk	false	true	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9800669115792 40.7676825134384)	19	4	19	13
454	454	-73.9752793195744	40.7733960128931	9C-AM-1006-03	09C	AM	10062018	3	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9752793195744 40.7733960128931)	19	4	19	13
1006	1006	-73.9686296217893	40.771812308875	10H-AM-1014-02	10H	AM	10142018	2	Juvenile	Cinnamon	Cinnamon+		Above Ground	6		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9686296217893 40.771812308875)	19	4	19	13
1038	1038	-73.9563311167069	40.7950901563337	38E-AM-1010-12	38E	AM	10102018	12	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE	running on rocks	false	true	false	false	false		false	false	false	true	false	false	false	false	runs toward something	POINT (-73.9563311167069 40.7950901563337)	19	4	19	13
1212	1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9761792189352 40.7745745517215)	19	4	19	13
1230	1230	-73.9790822606486	40.7714466633386	5A-AM-1006-03	05A	AM	10062018	3	Juvenile	Cinnamon	Cinnamon+		Above Ground	8		false	false	true	true	false		false	false	false	true	false	false	false	true		POINT (-73.9790822606486 40.7714466633386)	19	4	19	13
1260	1260	-73.9811585807616	40.768706748732	2A-AM-1010-06	02A	AM	10102018	6	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE		true	true	false	false	false	chasing #5	false	false	false	false	false	false	false	false		POINT (-73.9811585807616 40.768706748732)	19	4	19	13
1323	1323	-73.9744387347626	40.7776953143835	13A-AM-1017-03	13A	AM	10172018	3	Adult	Cinnamon	Cinnamon+					false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9744387347626 40.7776953143835)	19	4	19	13
1640	1640	-73.9564632239432	40.7904807427954	33G-AM-1013-01	33G	AM	10132018	1	Adult	Cinnamon	Cinnamon+		Above Ground	13	shelter in hole in tree	false	false	true	false	false		false	false	false	false	false	false	true	true		POINT (-73.9564632239432 40.7904807427954)	19	4	19	13
2025	2025	-73.9766541879006	40.7674077265375	2E-AM-1010-06	02E	AM	10102018	6	Adult	Cinnamon	Cinnamon+		Above Ground	35		false	false	false	false	false	leaping branch to branch	false	false	false	false	false	false	true	false		POINT (-73.9766541879006 40.7674077265375)	19	4	19	13
2941	2941	-73.9690266660317	40.7853134751509	23A-AM-1018-01	23A	AM	10182018	1	Juvenile	Cinnamon	Cinnamon+		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9690266660317 40.7853134751509)	19	4	19	13
850	850	-73.9642288873015	40.7820439983567	22F-AM-1007-06	22F	AM	10072018	6	Adult	Cinnamon	Cinnamon+		Ground Plane	FALSE		false	false	true	true	false		false	false	false	false	false	true	false	false		POINT (-73.9642288873015 40.7820439983567)	19	4	19	13
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon	Cinnamon+		Above Ground	4	on bar	false	false	false	true	false		false	false	false	true	true	true	false	false		POINT (-73.9594357049738 40.7840678890949)	19	4	19	13
1294	1294	-73.9604089940153	40.7910028063138	32D-AM-1013-04	32D	AM	10132018	4	Adult	Cinnamon	Cinnamon+	Brown legs	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	true	true	false	true		POINT (-73.9604089940153 40.7910028063138)	19	4	19	13
2205	2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon	Cinnamon+		Above Ground	8	on turn, see map	true	true	false	true	false		false	false	false	false	true	true	false	false		POINT (-73.9594986107981 40.7840083040604)	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
);