squirrels

131 rows where Age = "Adult" and Combination of Primary and Highlight Color = "Cinnamon+Gray" sorted by Zip Codes descending

✎ View and edit SQL

This data as json, CSV (advanced)

Climbing ✖

Approaches ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+Gray · 31 ✖

Age ✖

  • Adult · 31 ✖
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
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
2461 2461 -73.9605347462123 40.7942075448387 35B-AM-1010-04 35B AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE lawn false false false false true   false false false false false false true false   POINT (-73.9605347462123 40.7942075448387)   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
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2488 2488 -73.9726920847792 40.7794117463889 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true scared by dog POINT (-73.9726920847792 40.7794117463889)   19 4 19 13
2493 2493 -73.954767265558 40.7973243644491 40E-PM-1017-03 40E PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.954767265558 40.7973243644491)   19 4 19 13
2504 2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   false false false false true   false false false false false true true false   POINT (-73.9550131837533 40.7958617258176)   19 4 19 13
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.95744422055 40.7961046528557)   19 4 19 13
2521 2521 -73.976869549792 40.7706982454723 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree false false false false false relaxing false false false true false false true false   POINT (-73.976869549792 40.7706982454723)   19 4 19 13
2523 2523 -73.9619016393127 40.7925160126921 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9619016393127 40.7925160126921)   19 4 19 13
2583 2583 -73.9769693140651 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree true false true true true digging (?) false false false true false false false true runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)   19 4 19 13
2608 2608 -73.9522677657659 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9522677657659 40.7934034811368)   19 4 19 13
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false false   false false false false true false true false   POINT (-73.9501457233643 40.797094356558)   19 4 19 13
2727 2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false true   false false false false true false false true   POINT (-73.974596903918 40.7765498215674)   19 4 19 13
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
2752 2752 -73.972069937746 40.7659402627832 3I-PM-1013-04 03I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97206993774601 40.7659402627832)   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
2799 2799 -73.9682627382073 40.7730766743452 11H-AM-1010-09 11H AM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9682627382073 40.7730766743452)   19 4 19 13
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9533101544112 40.7938634280159)   19 4 19 13
2822 2822 -73.9711120079542 40.7760801911766 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false false climbing (down) false false false false false false true false   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
2878 2878 -73.969720780557 40.7741105688757 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false false true false false false   POINT (-73.969720780557 40.7741105688757)   19 4 19 13
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   false false false false false wrestling with child false false false false false false false false   POINT (-73.956581233786 40.79021276908371)   19 4 19 13
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9632164738341 40.7921270121312)   19 4 19 13
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   true false false false false   false false false false false false false false   POINT (-73.9621297946132 40.7944058222814)   19 4 19 13
2915 2915 -73.9734630412566 40.7653097139415 1H-PM-1013-02 01H PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9734630412566 40.7653097139415)   19 4 19 13
2938 2938 -73.97033289562 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
2943 2943 -73.962534856258 40.7812134517411 22H-PM-1007-01 22H PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.962534856258 40.7812134517411)   19 4 19 13
2971 2971 -73.9639801411692 40.7778921302618 18I-PM-1007-04 18I PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false false walking sitting up false false false false false false false true   POINT (-73.9639801411692 40.7778921302618)   19 4 19 13
2998 2998 -73.9752079247419 40.7755376979002 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true true false false   POINT (-73.9752079247419 40.7755376979002)   19 4 19 13
3003 3003 -73.9698663926657 40.773999710413 12F-PM-1007-09 12F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9698663926657 40.773999710413)   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 9.966ms