squirrels

33 rows where Above Ground Sighter Measurement = 15 and Indifferent = "false" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Hectare Squirrel Number ✖

Police Precincts ✖

Foraging ✖

Above Ground Sighter Measurement ✖

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
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
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
1887 1887 -73.9586184232889 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   false false true false false jumping false false false false false false false false stared at me POINT (-73.9586184232889 40.7993153832942)   19 4 19 13
210 210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   19 4 19 13
852 852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   true false true false false hopping false false false false false true false true   POINT (-73.9609704650925 40.7938786854735)   19 4 19 13
1939 1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   19 4 19 13
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9632164738341 40.7921270121312)   19 4 19 13
844 844 -73.9642379942652 40.7774792520738 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false false was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)   19 4 19 13
2779 2779 -73.9767835160078 40.7674030330482 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false true   POINT (-73.9767835160078 40.7674030330482)   19 4 19 13
317 317 -73.9545799024508 40.7908084039886 34I-PM-1010-01 34I PM 10102018 1 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9545799024508 40.7908084039886)   19 4 19 13
371 371 -73.964080104186 40.7907898627287 30B-AM-1007-02 30B AM 10072018 2 Adult Gray   Gray+   Above Ground 15   true false false false false   false false false false false false false false   POINT (-73.964080104186 40.7907898627287)   19 4 19 13
387 387 -73.9578316525492 40.7890102959629 31G-PM-1007-01 31G PM 10072018 1 Adult Gray   Gray+   Above Ground 15   false false false false false hiding false false false false true false false false froze,sight of dogs POINT (-73.9578316525492 40.7890102959629)   19 4 19 13
801 801 -73.9743342303548 40.7727742948332 8D-AM-1007-08 08D AM 10072018 8 Adult Gray   Gray+   Above Ground 15   false false false false false communicating from tree false false false false false false false false   POINT (-73.97433423035481 40.7727742948332)   19 4 19 13
1426 1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   true false true false false   false false false false false false false true   POINT (-73.9664986446294 40.778308334318)   19 4 19 13
1624 1624 -73.9737060043988 40.7725660224983 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9737060043988 40.7725660224983)   19 4 19 13
2561 2561 -73.9591513028486 40.7835978067328 25I-PM-1007-01 25I PM 10072018 1 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9591513028486 40.7835978067328)   19 4 19 13
2660 2660 -73.9726056411971 40.7793467904743 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9726056411971 40.7793467904743)   19 4 19 13
510 510 -73.9638590768396 40.7776782114981 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   false false true false false   false false false false true false false true   POINT (-73.9638590768396 40.7776782114981)   19 4 19 13
374 374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false watching me from tree - curious POINT (-73.9556817958407 40.788852000621)   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
591 591 -73.9543323786888 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false true false lying on belly on branch,eating big nut false false false false false false false false   POINT (-73.9543323786888 40.7943086530436)   19 4 19 13
1522 1522 -73.9538970554532 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9538970554532 40.7955196793479)   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
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true false true false true   true false false false true false false true   POINT (-73.9565824187667 40.797312050952)   19 4 19 13
2262 2262 -73.9556177490335 40.7888569161537 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)   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
260 260 -73.978436117932 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree false false true false false   true false false false false false false false   POINT (-73.978436117932 40.7724769242403)   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
966 966 -73.958317581802 40.7916566683158 33E-AM-1014-12 33E AM 10142018 12 Adult Gray White Gray+White   Above Ground 15   false false false false false sleeping false false false false false false false false asleep POINT (-73.958317581802 40.7916566683158)   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
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   false false true false false   false false false false true false false false curious,but wary POINT (-73.97699695480242 40.7710711265211)   19 4 19 13
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat true false true true false   false false false false false false false true   POINT (-73.958719099962 40.7947587726617)   19 4 19 13
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9790980124501 40.7685934093915)   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 127.384ms