squirrels

33 rows where Hectare Squirrel Number = 8 and Location = "Above Ground" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foraging ✖

Location ✖

  • Above Ground · 33 ✖

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
191 191 -73.9787105069657 40.7693708133873 3B-AM-1010-08 03B AM 10102018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false together w/ #7 false false false false false false true false   POINT (-73.9787105069657 40.7693708133873)   19 4 19 13
430 430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9710116801402 40.7723689301989)   19 4 19 13
476 476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree false false false false false   true true false false false false false false not backing down POINT (-73.9690968160819 40.769923269444)   19 4 19 13
526 526 -73.9680833729772 40.7741871025115 12H-PM-1007-08 12H PM 10072018 8       +   Above Ground 7 in tree false false false false false   false false false false false false false true   POINT (-73.9680833729772 40.7741871025115)   19 4 19 13
758 758 -73.9703621616472 40.775032271482 12E-AM-1017-08 12E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false false true false chilling false false false false false false true false   POINT (-73.9703621616472 40.775032271482)   19 4 19 13
801 801 -73.9743342303548 40.7727742948332 8D-AM-1007-08 08D AM 10072018 8 Adult Gray   Gray+   Above Ground 15   false false false false false communicating from tree false false false false false false false false   POINT (-73.97433423035481 40.7727742948332)   19 4 19 13
899 899 -73.9792754037291 40.7679690700399 2C-AM-1010-08 02C AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 stay on side of trunk false false true false false   false false false false false false false false   POINT (-73.9792754037291 40.7679690700399)   19 4 19 13
1037 1037 -73.9677409841969 40.7763579140639 15G-PM-1019-08 15G PM 10192018 8 Adult     +   Above Ground 5   false true false false false   false true true false false false false false   POINT (-73.9677409841969 40.7763579140639)   19 4 19 13
1060 1060 -73.9728871061191 40.7712983658944 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false true false   false false false false false false false true   POINT (-73.9728871061191 40.7712983658944)   19 4 19 13
1065 1065 -73.9769700777377 40.7728489574967 7B-AM-1008-08 07B AM 10082018 8 Adult Gray   Gray+   Above Ground 5   true false false false false   false false false false false false true false   POINT (-73.9769700777377 40.7728489574967)   19 4 19 13
1069 1069 -73.9595485734618 40.7835326425693 25I-PM-1007-08 25I PM 10072018 8 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #7 false false false false false   false false false false false false false false   POINT (-73.9595485734618 40.7835326425693)   19 4 19 13
1125 1125 -73.9775735077285 40.7692872082165 4C-PM-1010-08 04C PM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 on stone arch true false true false false   false false false false false false false true   POINT (-73.9775735077285 40.7692872082165)   19 4 19 13
1300 1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false true true false false canoodling w/ #9 false false false false false false true false   POINT (-73.964280573021 40.777830911491)   19 4 19 13
1378 1378 -73.9669762657479 40.7835913293646 22C-PM-1006-08 22C PM 10062018 8 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9669762657479 40.7835913293646)   19 4 19 13
1527 1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#7),playing? false false false false false false true false   POINT (-73.970216605149 40.7702960667277)   19 4 19 13
1546 1546 -73.976422624924 40.7735818387346 8B-AM-1007-08 08B AM 10072018 8 Adult Gray   Gray+   Above Ground 6   false false false true false holding nut false false false false false false true false   POINT (-73.976422624924 40.7735818387346)   19 4 19 13
1598 1598 -73.9726828460055 40.7705707694822 7F-AM-1008-08 07F AM 10082018 8 Adult Gray   Gray+   Above Ground 20   false false true false false playing w/ #9 false false false false false false true false   POINT (-73.9726828460055 40.7705707694822)   19 4 19 13
1645 1645 -73.9619673317128 40.7924176673037 33B-PM-1010-08 33B PM 10102018 8 Juvenile Gray   Gray+   Above Ground   running up tree false false true false false   false false false false false false false true   POINT (-73.9619673317128 40.7924176673037)   19 4 19 13
1654 1654 -73.9766342125035 40.7715437147052 6C-AM-1007-08 06C AM 10072018 8 Adult     +   Above Ground 35   false false true false false dropping acorns false false false false false false false false   POINT (-73.9766342125035 40.7715437147052)   19 4 19 13
1684 1684 -73.9637824756607 40.7904737110761 30B-AM-1007-08 30B AM 10072018 8 Adult Gray   Gray+   Above Ground 40   true false false true false   false false false false false false false false   POINT (-73.9637824756607 40.7904737110761)   19 4 19 13
1820 1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false true false true false   POINT (-73.9546337446865 40.7898772579576)   19 4 19 13
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.97428114848522 40.775533619083)   19 4 19 13
2056 2056 -73.9589600626433 40.7913690265064 33E-AM-1014-08 33E AM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   false false true false false   true false false false false false true false   POINT (-73.9589600626433 40.7913690265064)   19 4 19 13
2223 2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   false false true false false   false false false false false false false false   POINT (-73.9784863123685 40.7669225020831)   19 4 19 13
2233 2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false false true false   false false false false false true false false   POINT (-73.9754709117681 40.7681421869407)   19 4 19 13
2266 2266 -73.9716402454355 40.7665133780672 3I-PM-1013-08 03I PM 10132018 8 Adult Black   Black+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9716402454355 40.7665133780672)   19 4 19 13
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   false false false true false   false false false true true false true false   POINT (-73.9706949930717 40.772362045852)   19 4 19 13
2455 2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   false false true true false   false false false false false true false false   POINT (-73.9577297187155 40.799225295679)   19 4 19 13
2535 2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   false false true false false   false false false false true false false false   POINT (-73.9700101107283 40.7696729501144)   19 4 19 13
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true true true   false false false false false false false true   POINT (-73.96926766598071 40.7700678919108)   19 4 19 13
2826 2826 -73.9600357018376 40.7906539766881 32E-AM-1007-08 32E AM 10072018 8 Adult Gray   Gray+   Above Ground 65 tree top false false true false false   false false false false false false false false   POINT (-73.9600357018376 40.7906539766881)   19 4 19 13
2945 2945 -73.9649103330443 40.7823913860445 22F-PM-1014-08 22F PM 10142018 8 Adult Gray   Gray+   Above Ground 10 CLIMBED THE TREE false false true false false   false false false false false false true false   POINT (-73.9649103330443 40.7823913860445)   19 4 19 13
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9790980124501 40.7685934093915)   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 5539.675ms