squirrels

125 rows where Combination of Primary and Highlight Color = "Gray+White" and Location = "Above Ground" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Foraging ✖

Location ✖

  • Above Ground · 25 ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 25 ✖
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
2298 2298 -73.9755371849972 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9755371849972 40.7733561233828)   19 4 19 13
2331 2331 -73.9694681803635 40.770585795359 8I-AM-1006-06 08I AM 10062018 6 Adult Gray White Gray+White   Above Ground     false false false false true   false false false false false false true false   POINT (-73.9694681803635 40.770585795359)   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
2397 2397 -73.9704592500888 40.772962887933 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   false false true false false   false false false true false false false true   POINT (-73.9704592500888 40.772962887933)   19 4 19 13
2406 2406 -73.9668964315686 40.7777577990886 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   false false true false false   false false false false true false false true   POINT (-73.9668964315686 40.7777577990886)   19 4 19 13
2412 2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.9809446489564 40.7685032165879)   19 4 19 13
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9657958433575 40.7763496875058)   19 4 19 13
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9622050752008 40.7886373772305)   19 4 19 13
2528 2528 -73.9676529780724 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9676529780724 40.7823206990549)   19 4 19 13
2542 2542 -73.9754802138871 40.773300804412 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9754802138871 40.773300804412)   19 4 19 13
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   false false false true false   false false false false false false true false   POINT (-73.96393252683 40.7808289765857)   19 4 19 13
2659 2659 -73.9553603438021 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   false false false true false   false false false false false false false false   POINT (-73.9553603438021 40.7985282963244)   19 4 19 13
2692 2692 -73.9801636400744 40.7690192055926 2A-AM-1010-09 02A AM 10102018 9 Adult Gray White Gray+White   Above Ground   climbing in bush false false true false false hopping & flipping around. this one was very energetic & jumping aorund false false false false true false false false climbed a foot up a tree and watched me POINT (-73.9801636400744 40.7690192055926)   19 4 19 13
2706 2706 -73.9745141185576 40.7691479781207 5E-AM-1008-01 05E AM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on a checker table false false false true false   false false false false false false true false   POINT (-73.9745141185576 40.7691479781207)   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
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
2811 2811 -73.9756889766089 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   true false true false false running from dog false false false false false false false true   POINT (-73.9756889766089 40.7676078308589)   19 4 19 13
2815 2815 -73.9747311312394 40.7677319725044 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   false false true false false   false true false false false false false true   POINT (-73.97473113123941 40.7677319725044)   19 4 19 13
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   19 4 19 13
2865 2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.98028424040162 40.7678257384977)   19 4 19 13
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree false false true false false   false false false false false false false false   POINT (-73.9653873284496 40.7804699882574)   19 4 19 13
2944 2944 -73.9739403850622 40.7693162287509 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree true false false false true   false false false false false false false false   POINT (-73.9739403850622 40.7693162287509)   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
2956 2956 -73.9654741695628 40.7890427851106 28B-PM-1010-01 28B PM 10102018 1 Adult Gray White Gray+White   Above Ground 10 in a tree false false true false false   false false false false false false false false   POINT (-73.9654741695628 40.7890427851106)   19 4 19 13
2973 2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse false false true false false   false false false false false false true false   POINT (-73.9766693184436 40.7708879215854)   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 8.596ms