squirrels

26 rows where Combination of Primary and Highlight Color = "+" and Shift = "PM" sorted by Chasing

✎ 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, Eating, Foraging, Other Activities, Kuks, Quaas, Moans, Tail twitches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

Climbing ✖

Shift ✖

Combination of Primary and Highlight 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
1 1 -73.9561344937861 40.7940823884086 37F-PM-1014-03 37F PM 10142018 3       +         false false false false false   false false false false false false false false   POINT (-73.9561344937861 40.7940823884086)   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
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
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
861 861 -73.953287300494 40.793520326789 37H-PM-1006-04 37H PM 10062018 4       +   Above Ground 43 tree false false true false false   false false false false false false false false   POINT (-73.953287300494 40.793520326789)   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
1372 1372 -73.9528353702209 40.7976456178263 41F-PM-1019-02 41F PM 10192018 2       +         false false false false false   false false false false false false false false   POINT (-73.9528353702209 40.7976456178263)   19 4 19 13
1388 1388 -73.9685709455958 40.7744877026506 12G-PM-1007-07 12G PM 10072018 7 Juvenile     +   Above Ground 45   false false false true false acorns false false false false false false false false   POINT (-73.9685709455958 40.7744877026506)   19 4 19 13
1406 1406 -73.9746204802221 40.7699294840733 6E-PM-1010-01 06E PM 10102018 1 Juvenile     +   Ground Plane FALSE along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail false false false false false   false false false false false false true false   POINT (-73.9746204802221 40.7699294840733)   19 4 19 13
1475 1475 -73.9686778167484 40.7765625256946 14F-PM-1012-04 14F PM 10122018 4       +         false false false false false   true true false false false false false false   POINT (-73.96867781674841 40.7765625256946)   19 4 19 13
1554 1554 -73.9597462612063 40.7832801145306 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree false false false false false   false true false false false false false false   POINT (-73.9597462612063 40.7832801145306)   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
1764 1764 -73.9534878316472 40.7978951981698 41F-PM-1019-01 41F PM 10192018 1       +         false false false false false   false false false false false false false false   POINT (-73.9534878316472 40.7978951981698)   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
1842 1842 -73.9532804650089 40.7934579333341 37H-PM-1006-05 37H PM 10062018 5       +   Above Ground   tree false false false false false   false false false false false false false false   POINT (-73.9532804650089 40.7934579333341)   19 4 19 13
1931 1931 -73.9533085932603 40.7934877861075 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree false false true false false   true false false false false false false false   POINT (-73.9533085932603 40.7934877861075)   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
2141 2141 -73.9787015184662 40.7690114585688 3B-PM-1007-06 03B PM 10072018 6 Juvenile     +         false false false true false   false false false false false false true false   POINT (-73.9787015184662 40.7690114585688)   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
2606 2606 -73.96143417385 40.7945464262112 35B-PM-1013-02 35B PM 10132018 2 Juvenile     +   Ground Plane FALSE   false false false true false did not notice dog sitting a few yards away (10-20 ft) false false false false true false true false   POINT (-73.96143417385 40.7945464262112)   19 4 19 13
2714 2714 -73.9600738985438 40.7938328798752 35C-PM-1013-08 35C PM 10132018 8       +         false false false false false   true false false false false false false false did not *see* POINT (-73.9600738985438 40.7938328798752)   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
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
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
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

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