squirrels

39 rows where Climbing = "true", Eating = "true" and Location = "Ground Plane" sorted by Kuks

✎ 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, Foraging, Other Activities, Kuks, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Tail flags ✖

Location ✖

  • Ground Plane · 39 ✖

Eating ✖

  • true · 39 ✖

Climbing ✖

  • true · 39 ✖
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
52 52 -73.9675634326877 40.7813477352507 19D-AM-1007-01 19D AM 10072018 1 Juvenile Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false false fenced off area can't approach POINT (-73.9675634326877 40.7813477352507)   19 4 19 13
130 130 -73.9581655949437 40.7997708190022 41A-PM-1007-06 41A PM 10072018 6 Adult Black   Black+   Ground Plane FALSE   true false true true false   false false false false false false false true   POINT (-73.9581655949437 40.7997708190022)   19 4 19 13
274 274 -73.9639832886071 40.7909532437095 30B-PM-1019-08 30B PM 10192018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9639832886071 40.7909532437095)   19 4 19 13
303 303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true true true climbed fence staring at me - went up tree false false false false false false false true   POINT (-73.97623482246482 40.7694522315322)   19 4 19 13
373 373 -73.9672127283283 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   true false true true false a lot of activity false false false true false false false false   POINT (-73.9672127283283 40.7810666805133)   19 4 19 13
461 461 -73.9648195433192 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false staring false false false false true false false false   POINT (-73.9648195433192 40.7796399955868)   19 4 19 13
511 511 -73.9653142636891 40.7760015129298 15I-AM-1008-04 15I AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9653142636891 40.7760015129298)   19 4 19 13
768 768 -73.9729394928432 40.7743256716496 11D-AM-1010-01 11D AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9729394928432 40.7743256716496)   19 4 19 13
798 798 -73.980854228628 40.7678702158382 1B-AM-1012-17 01B AM 10122018 17 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.98085422862802 40.7678702158382)   19 4 19 13
850 850 -73.9642288873015 40.7820439983567 22F-AM-1007-06 22F AM 10072018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false   false false false false false true false false   POINT (-73.9642288873015 40.7820439983567)   19 4 19 13
964 964 -73.9631045499811 40.7906180969472 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false false false false true   POINT (-73.9631045499811 40.7906180969472)   19 4 19 13
1067 1067 -73.9695305996721 40.7745386896959 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9695305996721 40.7745386896959)   19 4 19 13
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9584106786233 40.7902777556926)   19 4 19 13
1215 1215 -73.9728895595977 40.7699378332299 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false true false false   POINT (-73.9728895595977 40.7699378332299)   19 4 19 13
1354 1354 -73.9765269282059 40.7746876635248 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9765269282059 40.7746876635248)   19 4 19 13
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   true false true true false got fed twice by grandpa,grabbed from grass and ate in tree false false false false false true true true approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)   19 4 19 13
1444 1444 -73.9763852372393 40.768876248561 4D-AM-1012-02 04D AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9763852372393 40.768876248561)   19 4 19 13
1480 1480 -73.9628525533831 40.7938449345017 34A-PM-1013-02 34A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true eating upside down on tree trunk false false false false false false false false   POINT (-73.9628525533831 40.7938449345017)   19 4 19 13
1667 1667 -73.9645989003589 40.7782157459155 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9645989003589 40.7782157459155)   19 4 19 13
1732 1732 -73.9767141407274 40.7737313251559 8A-PM-1014-02 08A PM 10142018 2 Juvenile Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true runs from (goes up a tree) POINT (-73.9767141407274 40.7737313251559)   19 4 19 13
1739 1739 -73.9639700434449 40.7775003050028 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings true false true true false   false false false false false false true false   POINT (-73.9639700434449 40.7775003050028)   19 4 19 13
1983 1983 -73.9784144867639 40.7718177667511 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false false false   POINT (-73.9784144867639 40.7718177667511)   19 4 19 13
2118 2118 -73.958369699409 40.7902456668332 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.958369699409 40.7902456668332)   19 4 19 13
2174 2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9684092812839 40.7711445841928)   19 4 19 13
2187 2187 -73.9699134052609 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false true true false   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
2317 2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   19 4 19 13
2338 2338 -73.9716621112698 40.7742862219469 11E-AM-1013-01 11E AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9716621112698 40.7742862219469)   19 4 19 13
2352 2352 -73.9727310397798 40.7787016773517 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree false false true true true digging,chewing on tree—has nut in mouth! false false false false false false false true   POINT (-73.97273103977982 40.7787016773517)   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
2471 2471 -73.964274290774 40.7795319556023 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false ran from human w/ dog POINT (-73.964274290774 40.7795319556023)   19 4 19 13
2485 2485 -73.9584950620879 40.7902770710643 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.9584950620879 40.7902770710643)   19 4 19 13
2508 2508 -73.979381450452 40.7709033697887 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false true false true false   POINT (-73.979381450452 40.770903369788705)   19 4 19 13
2511 2511 -73.9584561537421 40.7911211164754 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false true false false false   POINT (-73.9584561537421 40.7911211164754)   19 4 19 13
2604 2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false true true false   false false false false true false false true   POINT (-73.9605163698302 40.7914179994956)   19 4 19 13
2607 2607 -73.9642988690682 40.7795591281979 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true true runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)   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
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9576094432477 40.7965342664074)   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
643 643 -73.976730206737 40.773709213914 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   true false false false false false false true runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)   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 69.287ms