squirrels

58 rows where Climbing = "false", Location = "Above Ground" and Runs from = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

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
80 80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
98 98 -73.9730277911422 40.7712145488828 7F-AM-1008-16 07F AM 10082018 16 Juvenile Gray   Gray+   Above Ground 2 tree false false false false false   false false false false false false false true   POINT (-73.9730277911422 40.7712145488828)   19 4 19 13
109 109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
110 110 -73.9711318790279 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   true false false false false   false false false false true false false true   POINT (-73.9711318790279 40.7701941550273)   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
224 224 -73.9520592496349 40.7975076299811 42G-PM-1014-03 42G PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 on fence true false false false false prancing false false false false false false false true   POINT (-73.9520592496349 40.7975076299811)   19 4 19 13
237 237 -73.967895656898 40.7767409597341 15F-PM-1010-07 15F PM 10102018 7 Adult Gray   Gray+   Above Ground 3 on fence true false false false false   false false false false false false false true   POINT (-73.967895656898 40.7767409597341)   19 4 19 13
258 258 -73.9534333425633 40.7932564163328 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries false false false true false   false true false false false false false true   POINT (-73.9534333425633 40.7932564163328)   19 4 19 13
284 284 -73.9547336666137 40.7938937756332 37G-PM-1007-07 37G PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   true false false false false   false false false false false false false true   POINT (-73.9547336666137 40.7938937756332)   19 4 19 13
331 331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree false false false true false   false false false false false false false true ran up tree when approached POINT (-73.95448101115 40.7954469678857)   19 4 19 13
337 337 -73.9583101927652 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree true false false false false   false false false false false false false true runs from (us) POINT (-73.9583101927652 40.7852649316039)   19 4 19 13
381 381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   true false false true false   false false false false true false false true ran up tree POINT (-73.959709414696 40.7919745085986)   19 4 19 13
497 497 -73.9602166876979 40.7953811003986 36B-AM-1013-04 36B AM 10132018 4   Black   Black+   Above Ground 20 Moved 20+ feet high above top of tree limb false true false false false   false false false false false false false true   POINT (-73.9602166876979 40.7953811003986)   19 4 19 13
503 503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false   false false false false false false false true   POINT (-73.95983407835722 40.7915857030295)   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
528 528 -73.9647284206644 40.7839611840884 23E-PM-1006-01 23E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree true false false false false   false false false false false false false true   POINT (-73.9647284206644 40.7839611840884)   19 4 19 13
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #6 false false false false true false false true   POINT (-73.9559677963727 40.7951124076946)   19 4 19 13
598 598 -73.9698196671161 40.7802972001469 18C-PM-1018-03 18C PM 10182018 3 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9698196671161 40.7802972001469)   19 4 19 13
602 602 -73.9685751595485 40.7709413567859 9I-PM-1010-07 09I PM 10102018 7 Adult Gray White Gray+White   Above Ground 1 ran up tree true false false false false   false false false false false false false true   POINT (-73.9685751595485 40.7709413567859)   19 4 19 13
615 615 -73.9653279069888 40.7758743113817 15I-AM-1008-02 15I AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon Could be same squirrel as #1? Above Ground 4 on fence false false false true false   false false false false false false false true   POINT (-73.9653279069888 40.7758743113817)   19 4 19 13
650 650 -73.9809610117171 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence false false false true false   false false false false true false false true   POINT (-73.9809610117171 40.7683896665502)   19 4 19 13
683 683 -73.9707683621584 40.7759815566123 13E-AM-1017-11 13E AM 10172018 11 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on/in log true false false false false   false false false false false false false true   POINT (-73.9707683621584 40.77598155661231)   19 4 19 13
906 906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false false true   POINT (-73.96641208260151 40.7888022709721)   19 4 19 13
930 930 -73.9622030085794 40.7917723228749 32B-AM-1017-01 32B AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 ran up a tree true false false false true   false false false false false false false true   POINT (-73.9622030085794 40.7917723228749)   19 4 19 13
951 951 -73.971791854883 40.7802971729784 17B-PM-1012-01 17B PM 10122018 1 Adult Gray   Gray+   Above Ground 2 climbed a fence true false false false true   false false false false false false false true   POINT (-73.971791854883 40.7802971729784)   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
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
1070 1070 -73.9674631254594 40.7790076357696 17E-AM-1017-10 17E AM 10172018 10 Juvenile Gray   Gray+   Above Ground 2 Fence true false false false false   false false false false false false false true   POINT (-73.9674631254594 40.7790076357696)   19 4 19 13
1080 1080 -73.9690211935346 40.773038298158 11H-AM-1010-07 11H AM 10102018 7 Adult Gray White Gray+White   Above Ground 4   false false false true false   false false false false false false false true   POINT (-73.9690211935346 40.773038298158)   19 4 19 13
1126 1126 -73.9700186001049 40.7826052184658 20B-AM-1007-03 20B AM 10072018 3 Adult Gray White Gray+White   Above Ground     false false false false true   false false false true false false false true   POINT (-73.9700186001049 40.7826052184658)   19 4 19 13
1162 1162 -73.9568544270881 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock false false false false false   false false false false false false false true   POINT (-73.9568544270881 40.7972517274475)   19 4 19 13
1287 1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   true false false false false was chased by # 11 true false false false false false false true   POINT (-73.9763236949008 40.7686815615335)   19 4 19 13
1297 1297 -73.9802831706033 40.7692763295564 3A-AM-1012-02 03A AM 10122018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Above Ground 1   true false false false false   false false false false true false false true   POINT (-73.9802831706033 40.7692763295564)   19 4 19 13
1348 1348 -73.9599197612389 40.7954836456006 36B-PM-1013-05 36B PM 10132018 5 Adult Gray   Gray+   Above Ground 4   true false false false false   false false false false false false false true   POINT (-73.9599197612389 40.7954836456006)   19 4 19 13
1371 1371 -73.9542733797804 40.795578653743 39F-PM-1006-02 39F PM 10062018 2 Adult Gray   Gray+   Above Ground 20 tree false false false false false   false false false false false false false true ran up tree when approached POINT (-73.9542733797804 40.795578653743)   19 4 19 13
1398 1398 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 10072018 14 Adult Gray   Gray+   Above Ground 50 literally fell to ground from 50 feet up false false false false false falling false false false false false false false true   POINT (-73.9602808042376 40.7906130788763)   19 4 19 13
1434 1434 -73.9760749752948 40.7703284894392 5D-PM-1018-02 05D PM 10182018 2 Adult Gray   Gray+   Above Ground 2 On low fence false false false true false   false false false false false false false true   POINT (-73.9760749752948 40.7703284894392)   19 4 19 13
1489 1489 -73.9501762527462 40.7975534086077 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   true true false false false   false false false false false false false true   POINT (-73.9501762527462 40.7975534086077) 12423 18 4 36 18
1553 1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log false false false false false   false false false false true false false true   POINT (-73.9690645326017 40.7773822116124)   19 4 19 13
1652 1652 -73.9498421746221 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   true false false false false   false false false false false false false true   POINT (-73.9498421746221 40.7969397424182)   19 4 19 13
1662 1662 -73.9561600237284 40.7953143196705 38E-AM-1010-10 38E AM 10102018 10 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 over a log across stream false false false false false chillin' false false false false false false false true runs from leaf blower POINT (-73.9561600237284 40.7953143196705)   19 4 19 13
1765 1765 -73.9689041600147 40.7781788966185 16E-AM-1014-07 16E AM 10142018 7 Adult Gray   Gray+   Above Ground     true false false false false   false false false false false false false true runs from (dog) POINT (-73.9689041600147 40.7781788966185)   19 4 19 13
1871 1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House true false false false false   false false false false false false false true   POINT (-73.9748367344424 40.7693513000034)   19 4 19 13
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
2018 2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9697924026634 40.7803611152023)   19 4 19 13
2067 2067 -73.9725077933574 40.7654562710325 2I-PM-1006-01 02I PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 Sitting on back of bench with food hanging from mouth false false false false false staring at me false false false false false false false true   POINT (-73.9725077933574 40.7654562710325)   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
2215 2215 -73.9674978826751 40.776288410765 15G-PM-1019-10 15G PM 10192018 10 Adult Gray   Gray+   Above Ground 1 on a log false false false true false   false false false false false false false true   POINT (-73.9674978826751 40.776288410765)   19 4 19 13
2244 2244 -73.9509628195532 40.7977775674178 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false false false false   false false false false true false false true   POINT (-73.9509628195532 40.7977775674178) 12423 18 4 36 18
2337 2337 -73.9673490137465 40.7782728130401 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false true false   false false false false false false false true   POINT (-73.9673490137465 40.7782728130401)   19 4 19 13
2389 2389 -73.9801343393329 40.7691512453402 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   false false false true false   false false false false true false false true   POINT (-73.9801343393329 40.7691512453402)   19 4 19 13
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   false false false false false watching me - didn't move false false false false true false false true   POINT (-73.9680741975294 40.7847036778165)   19 4 19 13
2419 2419 -73.9590551473416 40.7891607060794 31F-PM-1007-02 31F PM 10072018 2 Adult Gray   Gray+   Above Ground 2 tree trunk false false false false true   false false false false true false false true   POINT (-73.95905514734162 40.7891607060794)   19 4 19 13
2522 2522 -73.9658747245917 40.7754033737532 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch true false false false true   false false false false true false false true   POINT (-73.9658747245917 40.7754033737532)   19 4 19 13
2742 2742 -73.9628041577934 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   false false false true false   false false false false false false false true   POINT (-73.9628041577934 40.78841801560551)   19 4 19 13
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   true false false false false   false false false false false false false true   POINT (-73.97518067271972 40.7671940332258)   19 4 19 13
2862 2862 -73.967466716152 40.7824346548278 21D-PM-1008-04 21D PM 10082018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   false false false true false   false false false false false false false true i scared it POINT (-73.967466716152 40.7824346548278)   19 4 19 13
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true true false false false   false false false false true false false true   POINT (-73.9503533343658 40.7976543603953) 12423 18 4 36 18

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