squirrels

25 rows where Age = "Adult" and Combination of Primary and Highlight Color = "+" sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Moans, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Police Precincts ✖

Combination of Primary and Highlight Color ✖

Age ✖

  • Adult · 25 ✖
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
198 198 -73.9761107065353 40.769642060286 5D-AM-1020-01 05D AM 10202018 1 Adult     + Too far & cloudy to tell Above Ground 30   false false false false true   false false false false false false false false   POINT (-73.9761107065353 40.769642060286)   19 4 19 13
708 708 -73.9592819491968 40.7941062008626 35C-AM-1007-06 35C AM 10072018 6 Adult     +   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9592819491968 40.7941062008626)   19 4 19 13
794 794 -73.9790010565108 40.7685732369544 2C-PM-1013-09 02C PM 10132018 9 Adult     +   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9790010565108 40.7685732369544)   19 4 19 13
867 867 -73.9762257701293 40.7744032758323 9A-AM-1013-08 09A AM 10132018 8 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9762257701293 40.7744032758323)   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
1248 1248 -73.9719729323923 40.7668318394546 4I-AM-1006-03 04I AM 10062018 3 Adult     + Can't tell :( Above Ground 28 Tree false false true false false building nest! false false false false false false false false   POINT (-73.9719729323923 40.7668318394546)   19 4 19 13
1361 1361 -73.961934398055 40.7924789548522 33B-PM-1010-07 33B PM 10102018 7 Adult     +   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.961934398055 40.7924789548522)   19 4 19 13
1407 1407 -73.9704778551644 40.7783119113627 15D-AM-1007-05 15D AM 10072018 5 Adult     +         false false false false false   false false false false false false false false   POINT (-73.9704778551644 40.7783119113627)   19 4 19 13
1607 1607 -73.9770508584979 40.7710769301257 6C-AM-1007-02 06C AM 10072018 2 Adult     +   Above Ground 15   false false true false false pulling things off branches false false false false false false false false   POINT (-73.9770508584979 40.7710769301257)   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
1688 1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   false true false false false   false false false false true false false false   POINT (-73.9677593344667 40.7763054313195)   19 4 19 13
1755 1755 -73.9714798196777 40.7695231949631 6H-PM-1020-02 06H PM 10202018 2 Adult     +   Above Ground   Fence pole false false true false false   false false false false false false false true runs from (me) POINT (-73.9714798196777 40.7695231949631)   19 4 19 13
2034 2034 -73.9699135187297 40.7782354186163 16D-AM-1007-03 16D AM 10072018 3 Adult     + ran away before I could take a good look Above Ground 2   false false true false false   false false false false false false false true   POINT (-73.9699135187297 40.7782354186163)   19 4 19 13
2388 2388 -73.9604476047877 40.7938014328732 35C-AM-1007-03 35C AM 10072018 3 Adult     +   Above Ground 40   false false false false true   false false false false false false false false   POINT (-73.9604476047877 40.7938014328732)   19 4 19 13
2392 2392 -73.9578981223015 40.7989967754358 41B-AM-1010-03 41B AM 10102018 3 Adult     +   Above Ground 60   false false false false false   false false false false false false false false   POINT (-73.9578981223015 40.7989967754358)   19 4 19 13
2501 2501 -73.9616944195776 40.7927250423024 33B-PM-1010-02 33B PM 10102018 2 Adult     +   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616944195776 40.7927250423024)   19 4 19 13
2784 2784 -73.9763722433833 40.7744121430891 9A-AM-1013-07 09A AM 10132018 7 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9763722433833 40.7744121430891)   19 4 19 13
2910 2910 -73.9506062997507 40.7976189496674 42H-PM-1014-03 42H PM 10142018 3 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9506062997507 40.7976189496674) 12423 18 4 36 18
690 690 -73.9767949141123 40.774454583585 9A-PM-1010-01 09A PM 10102018 1 Adult     +   Ground Plane FALSE by large tree in sectioned off area false false true false false i think it climbed the tree when i first saw it. false false false false false false true false   POINT (-73.9767949141123 40.774454583585)   19 4 19 13
711 711 -73.9767980925124 40.774362775678 9A-PM-1010-02 09A PM 10102018 2 Adult     +   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9767980925124 40.774362775678)   19 4 19 13
1483 1483 -73.9545773579075 40.7898684635744 33I-AM-1008-05 33I AM 10082018 5 Adult     +   Above Ground 100   false false true false true   false false false false false false true false nearly dropped shell on my head! POINT (-73.9545773579075 40.7898684635744)   19 4 19 13
1993 1993 -73.9546367558712 40.789840987798 33I-AM-1008-04 33I AM 10082018 4 Adult     +   Above Ground 100   false false true false true   false false false false false false true false   POINT (-73.9546367558712 40.789840987798)   19 4 19 13
2031 2031 -73.9795454787631 40.7688026892741 3B-PM-1007-09 03B PM 10072018 9 Adult     +         false false false false false   false false false false false false true false   POINT (-73.9795454787631 40.7688026892741)   19 4 19 13
2790 2790 -73.9673554935258 40.7827527249594 21C-AM-1014-04 21C AM 10142018 4 Adult     + High in tree, unable to tell Above Ground 60   false false true false false   false false false true false false true false   POINT (-73.96735549352582 40.7827527249594)   19 4 19 13
2851 2851 -73.955208233231 40.7890574331084 32I-PM-1007-02 32I PM 10072018 2 Adult     +   Above Ground 30   false false true false false different sound - happy,playful chirps false false false false true false true false   POINT (-73.955208233231 40.7890574331084)   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 74.253ms