squirrels

38 rows where Climbing = "true", Hectare Squirrel Number = 1 and Highlight Fur Color = "Cinnamon" sorted by Kuks

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Foraging, Other Activities, Kuks, Quaas, Moans, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Tail flags ✖

Eating ✖

Highlight Fur Color ✖

  • Cinnamon · 38 ✖

Hectare Squirrel Number ✖

Climbing ✖

  • true · 38 ✖
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
97 97 -73.9639744005647 40.7825111950764 22F-AM-1007-01 22F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false true false   POINT (-73.9639744005647 40.7825111950764)   19 4 19 13
112 112 -73.9651754464439 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree false false true true false   false false false false false false true false   POINT (-73.9651754464439 40.7755181941559)   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
197 197 -73.9679336341793 40.7754186579647 14G-PM-1013-01 14G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false false false watching POINT (-73.9679336341793 40.7754186579647)   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
271 271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false true false false approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)   19 4 19 13
457 457 -73.965848283831 40.7797243033057 19F-PM-1017-01 19F PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.965848283831 40.7797243033057)   19 4 19 13
462 462 -73.9661785940531 40.7742569936186 13I-PM-1008-01 13I PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 climbed tree true false true false false   false false false false false false true false   POINT (-73.9661785940531 40.7742569936186)   19 4 19 13
641 641 -73.9719036217446 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree true false true false true   false false false false true false false true   POINT (-73.9719036217446 40.7803588122409)   19 4 19 13
733 733 -73.9764397550289 40.7737004557104 8B-AM-1007-01 08B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false true false true false   POINT (-73.9764397550289 40.7737004557104)   19 4 19 13
837 837 -73.9557172336815 40.7921125657722 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9557172336815 40.7921125657722)   19 4 19 13
942 942 -73.9533923917973 40.7961701874769 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree false false true true false   false false false false false false true false   POINT (-73.9533923917973 40.7961701874769)   19 4 19 13
984 984 -73.9672950266018 40.7782477517567 17F-PM-1020-01 17F PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   false false true false false   false false false false false false false true   POINT (-73.9672950266018 40.7782477517567)   19 4 19 13
1010 1010 -73.9689723590015 40.7756860990338 13F-AM-1007-01 13F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9689723590015 40.7756860990338)   19 4 19 13
1044 1044 -73.9693254080548 40.7761600327118 14F-AM-1007-01 14F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9693254080548 40.7761600327118)   19 4 19 13
1045 1045 -73.9730420696993 40.7786151019726 15B-AM-1014-01 15B AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   false false true false true   false false false false false false false false   POINT (-73.9730420696993 40.7786151019726)   19 4 19 13
1055 1055 -73.9632337134707 40.7914682370734 31B-PM-1007-01 31B PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #2 and climbing tree w/ #2 false false false false false false false true   POINT (-73.9632337134707 40.7914682370734)   19 4 19 13
1152 1152 -73.9608399003798 40.7817704502248 23I-AM-1019-01 23I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 18 on a tree false false true false false   false false false false false false false false eyed me warily,then went up the tree POINT (-73.9608399003798 40.7817704502248)   19 4 19 13
1429 1429 -73.9706533131129 40.768902033819 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     true false true true true   false false false false false false false true runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)   19 4 19 13
1503 1503 -73.9732193290631 40.7748791447746 11D-PM-1006-01 11D PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9732193290631 40.7748791447746)   19 4 19 13
1581 1581 -73.97157754108 40.7776249963967 14C-PM-1006-01 14C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false true false false false false false true   POINT (-73.97157754108 40.7776249963967)   19 4 19 13
1609 1609 -73.9639024988123 40.7776953065849 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639024988123 40.7776953065849)   19 4 19 13
1918 1918 -73.9632866142841 40.7890043294436 29C-PM-1006-01 29C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false false false not too shy POINT (-73.96328661428412 40.78900432944361)   19 4 19 13
1976 1976 -73.9770920860805 40.7694698040083 4C-PM-1010-01 04C PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false true false false   false true false false false false true false   POINT (-73.9770920860805 40.7694698040083)   19 4 19 13
2016 2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false   false false false false true false true false stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)   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
2463 2463 -73.9653343572865 40.7775286924617 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true false   false false false true false false false true   POINT (-73.9653343572865 40.7775286924617)   19 4 19 13
2517 2517 -73.9710221361528 40.7724939691584 10F-PM-1019-01 10F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Above Ground 2 Behind fence, tree trunk false false true false false sitting false false false false false false true false   POINT (-73.9710221361528 40.7724939691584)   19 4 19 13
2559 2559 -73.9572383478774 40.7876857380722 30H-PM-1006-01 30H PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false false true false false   false false false false true false true false   POINT (-73.9572383478774 40.7876857380722)   19 4 19 13
2569 2569 -73.9559663734409 40.7945828261377 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false true false false true false   POINT (-73.9559663734409 40.7945828261377)   19 4 19 13
2652 2652 -73.9620542514749 40.7943731722138 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9620542514749 40.7943731722138)   19 4 19 13
2724 2724 -73.9611434082667 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   false false true false false   false true false false false false false false   POINT (-73.9611434082667 40.7893671772846)   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
2748 2748 -73.960094705031 40.7916066137699 33D-AM-1017-01 33D AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.960094705031 40.7916066137699)   19 4 19 13
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true chirps false false false false true false true false   POINT (-73.9552595564798 40.7889533029466)   19 4 19 13
2872 2872 -73.9615396457996 40.7923594366783 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615396457996 40.7923594366783)   19 4 19 13
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false true false true false   POINT (-73.970595860252 40.7832060751268)   19 4 19 13
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false true   true true false true true false true false   POINT (-73.9601988871514 40.7943473161329)   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 197.065ms