squirrels

41 rows where Above Ground Sighter Measurement = 20 and Indifferent = "false"

✎ 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, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

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
111 111 -73.9763243383771 40.7705409315703 5C-PM-1010-13 05C PM 10102018 13 Adult Gray White Gray+White   Above Ground 20 way up a tree! false false true false false   false false false false false false false false   POINT (-73.9763243383771 40.7705409315703)   19 4 19 13
113 113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   true false false false false flying false false false false false false false false   POINT (-73.9700100617602 40.7815739959357)   19 4 19 13
268 268 -73.968107276769 40.7768612676036 15F-AM-1007-09 15F AM 10072018 9 Adult Cinnamon White Cinnamon+White   Above Ground 20   false false true false true   false false false false false false false true   POINT (-73.968107276769 40.7768612676036)   19 4 19 13
306 306 -73.9689700100267 40.7775169562765 15E-PM-1008-05 15E PM 10082018 5 Adult Gray   Gray+   Above Ground 20   false false false false false sitting false true false false false false false false   POINT (-73.9689700100267 40.7775169562765)   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
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   true false true false false   false false false false false false false true   POINT (-73.9685227310735 40.776599466588)   19 4 19 13
698 698 -73.9585537668382 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false bringing green leaves to nest false false false false false false false false   POINT (-73.9585537668382 40.7903905787005)   19 4 19 13
797 797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false   false false false false false true false false   POINT (-73.969345754447 40.7770429650288)   19 4 19 13
917 917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   false false true false false   false false false false false true false false started climbing down to me POINT (-73.9676514056678 40.7730853732876)   19 4 19 13
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree true false true false false   false false false false true false false true   POINT (-73.9722737593623 40.768963018754)   19 4 19 13
1081 1081 -73.9680855277775 40.7769251965381 15F-AM-1007-10 15F AM 10072018 10 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true false false   false false false false false false false true   POINT (-73.9680855277775 40.7769251965381)   19 4 19 13
1148 1148 -73.9707339200738 40.7796333355689 17C-PM-1013-03 17C PM 10132018 3 Adult Gray   Gray+   Above Ground 20 in a tree false false false false false   false false false false false false false false   POINT (-73.9707339200738 40.7796333355689)   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
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
1381 1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1410 1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1431 1431 -73.9601918930677 40.7944134683406 35C-AM-1007-01 35C AM 10072018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20 (white oak) false false false false false sitting still false false false false false false false false   POINT (-73.9601918930677 40.7944134683406)   19 4 19 13
1466 1466 -73.9651177657676 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9651177657676 40.781240810382506)   19 4 19 13
1506 1506 -73.9728339757306 40.7782891207966 14B-PM-1014-04 14B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 running up and down false false false false false   false false false false false false false false   POINT (-73.9728339757306 40.7782891207966)   19 4 19 13
1508 1508 -73.9693894305786 40.7756906748026 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false false false false   true false false false false false false false   POINT (-73.9693894305786 40.7756906748026)   19 4 19 13
1512 1512 -73.9733882364574 40.7683078706597 5G-AM-1006-01 05G AM 10062018 1 Adult Gray Black Gray+Black   Above Ground 20   false false true false false   false false false false false false false false made eye contact with me POINT (-73.9733882364574 40.7683078706597)   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
1560 1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   false false true true false   false false false false false false false true   POINT (-73.9587072763996 40.7850256219415)   19 4 19 13
1572 1572 -73.9540197079615 40.798039260983 41E-PM-1013-03 41E PM 10132018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White Gray on legs Above Ground 20   false false false false true   false false false false false false false false   POINT (-73.9540197079615 40.798039260983)   19 4 19 13
1641 1641 -73.9653135277149 40.7817434070169 21E-PM-1012-01 21E PM 10122018 1 Adult Gray   Gray+   Above Ground 20 in tree false false true false false   false false false false false false false false   POINT (-73.9653135277149 40.7817434070169)   19 4 19 13
1807 1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   false false true false false   true true false false false false false true   POINT (-73.9581366214863 40.7988964092722)   19 4 19 13
1925 1925 -73.9581389870644 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   true false true false false laid down on the branch false false false false false false false true   POINT (-73.9581389870644 40.799308112252305)   19 4 19 13
1999 1999 -73.9549860947234 40.7911550328309 34H-PM-1006-07 34H PM 10062018 7 Juvenile Gray White Gray+White white belly Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9549860947234 40.7911550328309)   19 4 19 13
2010 2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false false false   POINT (-73.96738215574692 40.7786375267659)   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
2145 2145 -73.9651250402583 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree false false true false true   false false false false false false false false   POINT (-73.9651250402583 40.7812884929069)   19 4 19 13
2251 2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   false false true false false   true false false false false false false false   POINT (-73.9587678566254 40.7962656030995)   19 4 19 13
2335 2335 -73.9704679459444 40.7773384236212 14D-PM-1019-10 14D PM 10192018 10 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false true false false false true   POINT (-73.9704679459444 40.7773384236212)   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
2443 2443 -73.9667073186959 40.7840581361598 23C-PM-1014-01 23C PM 10142018 1 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.96670731869591 40.7840581361598)   19 4 19 13
2455 2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   false false true true false   false false false false false true false false   POINT (-73.9577297187155 40.799225295679)   19 4 19 13
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
2729 2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree false false true false false chased by a doggo false false true false false false false true runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)   19 4 19 13
2730 2730 -73.9653575758687 40.7805339953372 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree false false true true false   false false false false false false false false   POINT (-73.9653575758687 40.7805339953372)   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
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.9730027200009 40.7798000868804)   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 57.246ms