squirrels

29 rows where Primary Fur Color = "" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, Other Interactions

Runs from ✖

Shift ✖

Primary Fur Color ✖

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
5 5 -73.9593126695714 40.797533370163 39B-AM-1018-01 39B AM 10182018 1       +   Above Ground     false false false false false unknown true false false false false false false false   POINT (-73.9593126695714 40.797533370163)   19 4 19 13
92 92 -73.9565759733611 40.7992461674802 42C-AM-1007-02 42C AM 10072018 2       +         false false false false false   false true false false false false false false   POINT (-73.9565759733611 40.7992461674802)   19 4 19 13
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
222 222 -73.9770273553525 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence true true true true false playing tag together false false false false false true false false   POINT (-73.9770273553525 40.7732399463626)   19 4 19 13
455 455 -73.9688574691102 40.7837825208444 21B-AM-1019-04 21B AM 10192018 4       +         false false false false false   false false false false false false false false   POINT (-73.9688574691102 40.7837825208444)   19 4 19 13
512 512 -73.9586098170241 40.7939653733898 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby false false false false false   true false false false false false false false   POINT (-73.9586098170241 40.7939653733898)   19 4 19 13
686 686 -73.9695745672033 40.7791835122147 17D-AM-1008-06 17D AM 10082018 6       +   Above Ground   high in tree, couldn't see it, only heard it false false false false false   true false false false false false false false   POINT (-73.9695745672033 40.7791835122147)   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
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
1112 1112 -73.9583934264026 40.7854742185504 27I-AM-1007-02 27I AM 10072018 2       +         false false false false false   true false false false false false false false   POINT (-73.9583934264026 40.785474218550405)   19 4 19 13
1244 1244 -73.9565260889843 40.7991807924337 42C-AM-1007-03 42C AM 10072018 3       +         false false false false false   false true false false false false false false   POINT (-73.9565260889843 40.79918079243371)   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
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
1459 1459 -73.9563847867316 40.7906012261163 33G-AM-1013-03 33G AM 10132018 3 ?     + Only peeked head out Above Ground 13   false false false false false peeking out of tree,did *not* come out false false false false false false false false   POINT (-73.9563847867316 40.7906012261163)   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
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
1623 1623 -73.9770119133023 40.7732949090005 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence true true false true true playing tag together false false false false false true false false   POINT (-73.9770119133023 40.7732949090005)   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
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
2028 2028 -73.9687347731861 40.7718955594385 10H-AM-1014-03 10H AM 10142018 3 Juvenile     +   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.9687347731861 40.7718955594385)   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
2327 2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   false false false false false   true false false false false false false false   POINT (-73.9567801028221 40.7960096659564)   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
2693 2693 -73.9561498646036 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks false false false false false   true false false false false false false false   POINT (-73.9561498646036 40.79492885618931)   19 4 19 13
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9752915601718 40.7739329570033)   19 4 19 13
2754 2754 -73.9687025912431 40.7719319822619 10H-AM-1014-04 10H AM 10142018 4 Juvenile     +   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.9687025912431 40.7719319822619)   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
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

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 102.279ms