squirrels

23 rows where Hectare Squirrel Number = 7 and Primary Fur Color = "Cinnamon" sorted by Lat/Long

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, 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, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Primary Fur Color ✖

  • Cinnamon · 23 ✖

Police Precincts ✖

Hectare Squirrel Number ✖

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 Other Interactions Lat/Long ▼ Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
2746 2746 -73.9561432836863 40.7982665347234 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9561432836863 40.7982665347234)   19 4 19 13
2454 2454 -73.9565151662506 40.7946647987447 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true me POINT (-73.9565151662506 40.7946647987447)   19 4 19 13
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
1334 1334 -73.957134662576 40.7872395604122 30I-PM-1006-07 30I PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.957134662576 40.7872395604122)   19 4 19 13
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false true false false false alert & aware POINT (-73.9646597452128 40.7827698220703)   19 4 19 13
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9647845655965 40.7816573808695)   19 4 19 13
125 125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9651601541795 40.7761841788025)   19 4 19 13
1846 1846 -73.9653311136561 40.780193490343 19F-PM-1017-07 19F PM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9653311136561 40.78019349034301)   19 4 19 13
1889 1889 -73.9679319758284 40.7821154802399 20C-PM-1018-07 20C PM 10182018 7 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9679319758284 40.7821154802399)   19 4 19 13
2174 2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9684092812839 40.7711445841928)   19 4 19 13
1843 1843 -73.9685940262068 40.776932102013 15F-AM-1007-07 15F AM 10072018 7 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9685940262068 40.776932102013)   19 4 19 13
684 684 -73.9691057326088 40.7765973509721 14F-PM-1012-07 14F PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9691057326088 40.7765973509721)   19 4 19 13
2554 2554 -73.9701505245419 40.768998364571 6I-PM-1013-07 06I PM 10132018 7 Adult Cinnamon   Cinnamon+   Above Ground 11   false false true false false   false false false false false false false false   POINT (-73.9701505245419 40.768998364571004)   19 4 19 13
2986 2986 -73.9756533763813 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9756533763813 40.7733537881363)   19 4 19 13
1142 1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn true true false false false   false false false false false false true false   POINT (-73.9765805609072 40.7692807820935)   19 4 19 13
1226 1226 -73.97684509717 40.7709430375069 5C-PM-1010-07 05C PM 10102018 7 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 13   false true false false false   false false false false false false false false   POINT (-73.97684509717 40.7709430375069)   19 4 19 13
2462 2462 -73.9768544488742 40.7680069500977 3D-AM-1006-07 03D AM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false running (with food in mouth) false false false false false false true false   POINT (-73.9768544488742 40.7680069500977)   19 4 19 13
1127 1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9776445567926 40.768119107973)   19 4 19 13
640 640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   19 4 19 13
2165 2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9794371709817 40.768387910254)   19 4 19 13
1281 1281 -73.9795728289645 40.7678669804787 1C-PM-1013-07 01C PM 10132018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9795728289645 40.7678669804787)   19 4 19 13
1132 1132 -73.9798390387307 40.7700761090896 3A-PM-1017-07 03A PM 10172018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9798390387307 40.7700761090896)   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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);
Powered by Datasette · Query took 89.139ms