squirrels

124 rows where Climbing = "false" and Tail flags = "true" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

Tail flags ✖

  • true · 24 ✖

Climbing ✖

  • false · 24 ✖
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
2857 2857 -73.9649230271173 40.7821766215675 22F-PM-1014-02 22F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9649230271173 40.7821766215675)   19 4 19 13
2876 2876 -73.9558995737654 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9558995737654 40.7960097734603)   19 4 19 13
2923 2923 -73.9672160533827 40.7830263908749 21C-AM-1014-05 21C AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9672160533827 40.7830263908749)   19 4 19 13
2966 2966 -73.9630596103391 40.7925720620556 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree false false false false true   false false false true false false true false   POINT (-73.9630596103391 40.7925720620556)   19 4 19 13
2992 2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9746063250438 40.7687654196811)   19 4 19 13
1959 1959 -73.9707737073771 40.7800373465838 17B-PM-1012-02 17B PM 10122018 2 Adult Black   Black+   Ground Plane FALSE   true true false false true 2/3 chasing each other true true false true true false true false   POINT (-73.9707737073771 40.7800373465838)   19 4 19 13
150 150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
582 582 -73.9677779408464 40.7867482211349 25A-AM-1013-02 25A AM 10132018 2   Gray   Gray+   Above Ground 15 BIG TREE false true false false false chasing #3 false false false true false false true false   POINT (-73.9677779408464 40.7867482211349)   19 4 19 13
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true checkin' his stashes false false false true false true false true   POINT (-73.9767953468937 40.7676376977667)   19 4 19 13
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false did not notice dog sitting a few yards away (10-20 ft) false false false true false false true false   POINT (-73.9614373639552 40.7945051962914)   19 4 19 13
78 78 -73.964474836001 40.7883840104749 28C-PM-1006-01 28C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false gathering acorns false false false true false false false true gnd to tree POINT (-73.964474836001 40.7883840104749)   19 4 19 13
2142 2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
1011 1011 -73.9719111470164 40.7758789855474 12D-AM-1013-02 12D AM 10132018 2 Adult Gray   Gray+   Above Ground 7 Was on top of the edge of Bow Bridge false false false false false jumped off false false false true false false false true   POINT (-73.9719111470164 40.7758789855474)   19 4 19 13
203 203 -73.9638774579549 40.7913532129148 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true jumping false false false true true false true false eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)   19 4 19 13
1235 1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false jumping back & forth on tree false false false true true false true false   POINT (-73.9679686793869 40.7825993867876)   19 4 19 13
1333 1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false false false false laying on tree branch false false false true true false false false   POINT (-73.9754527701832 40.7656088463928)   19 4 19 13
2521 2521 -73.976869549792 40.7706982454723 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree false false false false false relaxing false false false true false false true false   POINT (-73.976869549792 40.7706982454723)   19 4 19 13
2980 2980 -73.9716414586381 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false running (from birds) false false false true false false true false   POINT (-73.9716414586381 40.771760114722)   19 4 19 13
855 855 -73.9808247660048 40.7689408831287 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false runs from false false false true false false false true   POINT (-73.9808247660048 40.7689408831287)   19 4 19 13
2295 2295 -73.9590632051055 40.7963146584827 38B-AM-1019-04 38B AM 10192018 4 Adult Gray   Gray+   Above Ground 20   false false false false false sitting in tree true true false true false false true false observant POINT (-73.9590632051055 40.7963146584827)   19 4 19 13
1174 1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false true false true false false approaches (very close) POINT (-73.9682067129876 40.7779911208015)   19 4 19 13
2217 2217 -73.9652746477521 40.7809326848536 20F-PM-1007-07 20F PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   true false false false false watching false false false true false false false true   POINT (-73.96527464775211 40.7809326848536)   19 4 19 13
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
2026 2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch false false false false false watching me scratching true false false true false false true false   POINT (-73.9622752768962 40.7814921913101)   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 6.674ms