squirrels

41 rows where Date = 10132018, Highlight Fur Color = "Cinnamon" and Runs from = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Age, Primary Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Indifferent, Other Interactions

Eating ✖

Combination of Primary and Highlight Color ✖

Runs from ✖

  • true · 41 ✖

Highlight Fur Color ✖

  • Cinnamon · 41 ✖

Date ✖

  • 10132018 · 41 ✖
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
8 8 -73.9602609920814 40.7942883045566 35C-PM-1013-03 35C PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9602609920814 40.79428830455661)   19 4 19 13
135 135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush false false true false true   false false false false false false false true watching me POINT (-73.9694168118643 40.7728877377977)   19 4 19 13
195 195 -73.9737773613311 40.7673662611015 3G-PM-1013-01 03G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9737773613311 40.7673662611015)   19 4 19 13
292 292 -73.9674069524601 40.7772529662424 16F-PM-1013-02 16F PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Woods false false false false true   false false false false false false false true   POINT (-73.9674069524601 40.7772529662424)   19 4 19 13
403 403 -73.9597470659927 40.7973215935416 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9597470659927 40.7973215935416)   19 4 19 13
536 536 -73.9561141662309 40.7976258458604 40D-PM-1013-05 40D PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9561141662309 40.7976258458604)   19 4 19 13
583 583 -73.9612398509782 40.7950033150385 35A-PM-1013-12 35A PM 10132018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9612398509782 40.7950033150385)   19 4 19 13
628 628 -73.9600165785486 40.7952466761832 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false true false false true   POINT (-73.9600165785486 40.7952466761832)   19 4 19 13
630 630 -73.9580109357087 40.7855654405447 28I-AM-1013-01 28I AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Jumped onto path & then back into brush false false false false false stood on fence false false false false false false false true   POINT (-73.9580109357087 40.7855654405447)   19 4 19 13
779 779 -73.9745305540008 40.7742043234014 10C-PM-1013-02 10C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true true   POINT (-73.9745305540008 40.7742043234014)   19 4 19 13
943 943 -73.9773096718574 40.7738053862489 8A-AM-1013-06 08A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9773096718574 40.7738053862489)   19 4 19 13
993 993 -73.9772422664657 40.773436329163 8A-AM-1013-02 08A AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE playground true false false false false   false false false false false false false true   POINT (-73.9772422664657 40.773436329163)   19 4 19 13
1029 1029 -73.9601259189134 40.7955350609057 36B-PM-1013-04 36B PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9601259189134 40.7955350609057)   19 4 19 13
1059 1059 -73.9749457516921 40.7676712372245 3F-PM-1013-07 03F PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9749457516921 40.7676712372245)   19 4 19 13
1176 1176 -73.9553263156025 40.7975592060572 40D-PM-1013-04 40D PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9553263156025 40.7975592060572)   19 4 19 13
1273 1273 -73.9558943880051 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false false false false false true   POINT (-73.9558943880051 40.7971535141896)   19 4 19 13
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false false true true   false false false false false false false true   POINT (-73.9735655529245 40.7716072681474)   19 4 19 13
1501 1501 -73.9608167300104 40.7954348688268 36A-PM-1013-05 36A PM 10132018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS false false false false true   false false false false false false false true   POINT (-73.9608167300104 40.7954348688268)   19 4 19 13
1520 1520 -73.968021326951 40.7778807692445 16F-PM-1013-06 16F PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Big rock in meadow false false false false true   false false false false false false false true   POINT (-73.968021326951 40.7778807692445)   19 4 19 13
1571 1571 -73.9673129010312 40.7778169845999 16F-PM-1013-05 16F PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Pine tree near utility shed false false false true true   false false false false false false false true   POINT (-73.9673129010312 40.7778169845999)   19 4 19 13
1621 1621 -73.9734969320943 40.7722754599865 8E-AM-1013-01 08E AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9734969320943 40.7722754599865)   19 4 19 13
1622 1622 -73.9615090149261 40.7945150173918 35A-PM-1013-09 35A PM 10132018 9   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9615090149261 40.7945150173918)   19 4 19 13
1656 1656 -73.9557399927792 40.7971563708988 40D-PM-1013-07 40D PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false false false false true   POINT (-73.9557399927792 40.7971563708988)   19 4 19 13
1809 1809 -73.9690168673844 40.7777612043914 15E-AM-1013-04 15E AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9690168673844 40.7777612043914)   19 4 19 13
1865 1865 -73.9558118887106 40.796885713436 39E-PM-1013-01 39E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9558118887106 40.796885713436005)   19 4 19 13
1896 1896 -73.973998077367 40.7739029133911 10C-PM-1013-01 10C PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.973998077367 40.7739029133911)   19 4 19 13
2011 2011 -73.9603245806655 40.7942712477697 35C-PM-1013-04 35C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9603245806655 40.7942712477697)   19 4 19 13
2132 2132 -73.967472660349 40.7772125619715 16F-PM-1013-03 16F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 4 Woods false false true false true   false false false false false false false true   POINT (-73.96747266034902 40.7772125619715)   19 4 19 13
2183 2183 -73.967334936601 40.7773289724189 16F-PM-1013-01 16F PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Woods false false false true true   false false false false false false false true   POINT (-73.967334936601 40.7773289724189)   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
2357 2357 -73.9632301034883 40.7925707244111 32A-PM-1013-06 32A PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9632301034883 40.7925707244111)   19 4 19 13
2366 2366 -73.9676191846985 40.777641740817 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true true true   false false false false false false false true   POINT (-73.9676191846985 40.777641740817)   19 4 19 13
2371 2371 -73.9769520212123 40.774006725863 9A-AM-1013-01 09A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9769520212123 40.774006725863)   19 4 19 13
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false true true true   false false false false false false false true   POINT (-73.973552877209 40.7715638228207)   19 4 19 13
2446 2446 -73.9522704511969 40.7965668878961 41G-AM-1013-01 41G AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9522704511969 40.7965668878961)   19 4 19 13
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.9615643742864 40.7944678447843)   19 4 19 13
2585 2585 -73.9771726831497 40.7732320781799 8A-AM-1013-01 08A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE trail true false false false true   false false false false false false false true   POINT (-73.9771726831497 40.7732320781799)   19 4 19 13
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag false false true true false   false false false false false false true true   POINT (-73.9566300789162 40.7993692120774)   19 4 19 13
2810 2810 -73.9614659899028 40.7945562907624 35A-PM-1013-10 35A PM 10132018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9614659899028 40.7945562907624)   19 4 19 13
2969 2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true climbed tree (oak) false false false false true false false true   POINT (-73.9654409838612 40.7901338748522)   19 4 19 13
2985 2985 -73.9721159387757 40.7660503188637 3I-PM-1013-03 03I PM 10132018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9721159387757 40.7660503188637)   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 4397.07ms