squirrels

46 rows where Date = 10082018 and Hectare Squirrel Number = 2 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Hectare Squirrel Number ✖

Date ✖

  • 10082018 · 46 ✖
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
14 14 -73.9582694312289 40.7917367820255 33F-AM-1008-02 33F AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9582694312289 40.7917367820255)   19 4 19 13
40 40 -73.9535410657077 40.7928711760061 36H-PM-1008-02 36H PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9535410657077 40.79287117600611)   19 4 19 13
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true false true false false   false false false false true false true false   POINT (-73.9574648097543 40.78925084286221)   19 4 19 13
56 56 -73.9724642436394 40.7690526441109 6G-AM-1008-02 06G AM 10082018 2 Juvenile Gray   Gray+   Ground Plane FALSE bush false false false false true   false false false false false false true false   POINT (-73.9724642436394 40.7690526441109)   19 4 19 13
95 95 -73.9692883970928 40.7768553703082 14E-AM-1008-02 14E AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false true walking false false false false false false false true   POINT (-73.9692883970928 40.7768553703082)   19 4 19 13
127 127 -73.9664100504436 40.7828778892276 21D-AM-1008-02 21D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9664100504436 40.7828778892276)   19 4 19 13
249 249 -73.9786339295735 40.7684918638639 3C-PM-1008-02 03C PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9786339295735 40.7684918638639)   19 4 19 13
250 250 -73.9726747666002 40.7703022669308 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true see stories and locations POINT (-73.9726747666002 40.7703022669308)   19 4 19 13
464 464 -73.9664450399121 40.7887844904695 27A-AM-1008-02 27A AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9664450399121 40.7887844904695)   19 4 19 13
615 615 -73.9653279069888 40.7758743113817 15I-AM-1008-02 15I AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon Could be same squirrel as #1? Above Ground 4 on fence false false false true false   false false false false false false false true   POINT (-73.9653279069888 40.7758743113817)   19 4 19 13
732 732 -73.9695041366722 40.7797878809482 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9695041366722 40.7797878809482)   19 4 19 13
747 747 -73.9771422625274 40.772361415776 7B-AM-1008-02 07B AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771422625274 40.772361415776)   19 4 19 13
821 821 -73.959077668148 40.7926045823346 34D-AM-1008-02 34D AM 10082018 2 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.959077668148 40.7926045823346)   19 4 19 13
890 890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree false true true false false   false false false false false false false true   POINT (-73.9667755678511 40.7760256836088)   19 4 19 13
896 896 -73.9755055978764 40.7707438681742 6D-AM-1008-02 06D AM 10082018 2 Juvenile Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9755055978764 40.7707438681742)   19 4 19 13
939 939 -73.9761447791484 40.7690147873986 4D-PM-1008-02 04D PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761447791484 40.7690147873986)   19 4 19 13
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9584106786233 40.7902777556926)   19 4 19 13
1153 1153 -73.9688523924488 40.7844018035948 22A-AM-1008-02 22A AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9688523924488 40.7844018035948)   19 4 19 13
1266 1266 -73.9709897849823 40.768627964006 6H-AM-1008-02 06H AM 10082018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9709897849823 40.768627964006)   19 4 19 13
1274 1274 -73.9745859998733 40.7671634885616 3G-AM-1008-02 03G AM 10082018 2 Adult Gray   Gray+ Big one! Beautiful tail Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9745859998733 40.7671634885616)   19 4 19 13
1319 1319 -73.9562105506291 40.7966991197909 39D-AM-1008-02 39D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9562105506291 40.7966991197909)   19 4 19 13
1439 1439 -73.9729645190377 40.7723310150843 9E-AM-1008-02 09E AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729645190377 40.7723310150843)   19 4 19 13
1472 1472 -73.9698611971209 40.7753915552001 13F-PM-1008-02 13F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9698611971209 40.7753915552001)   19 4 19 13
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence false false false false true   false false false false true false false false   POINT (-73.9676539688726 40.7777229934129)   19 4 19 13
1661 1661 -73.974519308015 40.7691228794395 5E-AM-1008-02 05E AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 trellis true false false false true   false false false false false true false false   POINT (-73.974519308015 40.7691228794395)   19 4 19 13
1702 1702 -73.9752699507508 40.7688069184057 4E-PM-1008-02 04E PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9752699507508 40.76880691840571)   19 4 19 13
1741 1741 -73.9736995552241 40.7722712518637 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree true false true false false   false false false false false false false false   POINT (-73.9736995552241 40.7722712518637)   19 4 19 13
1778 1778 -73.9685598106128 40.7807054868066 19D-PM-1008-02 19D PM 10082018 2       + unknown - cannot see, only hear Above Ground     false false false false false   true false false false false false false false   POINT (-73.9685598106128 40.7807054868066)   19 4 19 13
1904 1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree false false true false true   false false false false false false true false   POINT (-73.9684058476942 40.7753959833776)   19 4 19 13
1955 1955 -73.9606559309874 40.7889527629826 30E-AM-1008-02 30E AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   true false false false false false true false   POINT (-73.9606559309874 40.7889527629826)   19 4 19 13
1960 1960 -73.9730158913661 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true true false false false chasing #2 false false false false false false false false   POINT (-73.9730158913661 40.7701310707272)   19 4 19 13
1984 1984 -73.9739249209875 40.7768528386853 13B-PM-1008-02 13B PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false false false true false   POINT (-73.9739249209875 40.7768528386853)   19 4 19 13
1990 1990 -73.9774584305147 40.7708133986192 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9774584305147 40.7708133986192)   19 4 19 13
2020 2020 -73.9691453885964 40.7770524089712 15E-PM-1008-02 15E PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9691453885964 40.7770524089712)   19 4 19 13
2095 2095 -73.9747762992858 40.7768579078578 12A-AM-1008-02 12A AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.9747762992858 40.7768579078578)   19 4 19 13
2185 2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   false false false false true   false false false true false false true false   POINT (-73.9707571364399 40.7758859812524)   19 4 19 13
2258 2258 -73.9547785081171 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th false false true false false   false false false false true false true false   POINT (-73.9547785081171 40.789612183711)   19 4 19 13
2318 2318 -73.967458693983 40.7769922522105 15G-AM-1008-02 15G AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.967458693983 40.7769922522105)   19 4 19 13
2347 2347 -73.9663124560664 40.779544003786 18F-PM-1008-02 18F PM 10082018 2 Adult Gray   Gray+         false false false false false hopping around false false false false false false false true   POINT (-73.9663124560664 40.779544003786)   19 4 19 13
2516 2516 -73.9649823687651 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9649823687651 40.7763395359636)   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
2584 2584 -73.9727187453699 40.7669595710626 3H-AM-1008-02 03H AM 10082018 2 Adult Gray   Gray+   Above Ground     false false true false false   false false false false false false true false   POINT (-73.9727187453699 40.7669595710626)   19 4 19 13
2675 2675 -73.9762227323096 40.768453603768 3E-PM-1008-02 03E PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9762227323096 40.768453603768)   19 4 19 13
2793 2793 -73.9742847552668 40.7731740123046 9D-AM-1008-02 09D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9742847552668 40.7731740123046)   19 4 19 13
2886 2886 -73.9729265300533 40.7741768291642 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9729265300533 40.7741768291642)   19 4 19 13
3009 3009 -73.9675637870968 40.7823880671728 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9675637870968 40.7823880671728)   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 72.47ms