squirrels

51 rows where Date = 10132018, Eating = "true" and Foraging = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, 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
79 79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   19 4 19 13
143 143 -73.9661361310677 40.7787872561177 18G-PM-1013-01 18G PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true burying false false false false false false false true   POINT (-73.9661361310677 40.7787872561177)   19 4 19 13
204 204 -73.9679538163341 40.7837103696906 22C-AM-1013-03 22C AM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true eating (mushroom) false false false false false false false true   POINT (-73.9679538163341 40.7837103696906)   19 4 19 13
252 252 -73.974420668782 40.7749628597465 10C-PM-1013-04 10C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.974420668782 40.7749628597465)   19 4 19 13
275 275 -73.974467903723 40.7686520352868 4F-PM-1013-04 04F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.974467903723 40.7686520352868)   19 4 19 13
346 346 -73.9712971568288 40.7745520717065 11E-AM-1013-02 11E AM 10132018 2 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9712971568288 40.7745520717065)   19 4 19 13
353 353 -73.9740007759509 40.7650077086539 1H-PM-1013-01 01H PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9740007759509 40.7650077086539)   19 4 19 13
516 516 -73.9597418366664 40.7964417084985 37B-PM-1013-05 37B PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9597418366664 40.7964417084985)   19 4 19 13
519 519 -73.9659010238417 40.7791683666215 18G-PM-1013-02 18G PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9659010238417 40.779168366621505)   19 4 19 13
595 595 -73.9742804552383 40.7707167671865 7E-PM-1013-05 07E PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE On rocks false false false true true   false false false false true false true false   POINT (-73.9742804552383 40.7707167671865)   19 4 19 13
636 636 -73.9757536187319 40.7755119810678 11A-PM-1013-03 11A PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9757536187319 40.7755119810678)   19 4 19 13
688 688 -73.9580785600617 40.7957981310897 37C-PM-1013-01 37C PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9580785600617 40.7957981310897)   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
868 868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9738481771673 40.7706540698938)   19 4 19 13
874 874 -73.9591957793992 40.7949568873453 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9591957793992 40.7949568873453)   19 4 19 13
992 992 -73.9708083587471 40.7825429441583 19A-PM-1013-03 19A PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9708083587471 40.7825429441583)   19 4 19 13
1052 1052 -73.9773858189627 40.770807701562 5B-PM-1013-01 05B PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9773858189627 40.770807701562)   19 4 19 13
1108 1108 -73.9638397790384 40.7828950272904 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false true false false true false true false indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)   19 4 19 13
1167 1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9593244415072 40.794964729747)   19 4 19 13
1200 1200 -73.9657721715305 40.778534830257 18G-PM-1013-03 18G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9657721715305 40.778534830257)   19 4 19 13
1221 1221 -73.9796409671481 40.7679049871186 1C-PM-1013-09 01C PM 10132018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9796409671481 40.7679049871186)   19 4 19 13
1341 1341 -73.9611300905602 40.7918743735665 32C-PM-1013-07 32C PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9611300905602 40.7918743735665)   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
1412 1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9594676326588 40.7984457363388)   19 4 19 13
1416 1416 -73.9757313481982 40.7754704051391 11A-PM-1013-04 11A PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true true   false false false false false false false false   POINT (-73.9757313481982 40.7754704051391)   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
1552 1552 -73.9695655231393 40.7698324659513 8I-PM-1013-02 08I PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9695655231393 40.7698324659513)   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
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
1623 1623 -73.9770119133023 40.7732949090005 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence true true false true true playing tag together false false false false false true false false   POINT (-73.9770119133023 40.7732949090005)   19 4 19 13
1677 1677 -73.9594332600733 40.7960622445291 37B-PM-1013-02 37B PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9594332600733 40.7960622445291)   19 4 19 13
1681 1681 -73.9638141923763 40.7829225326288 23F-PM-1013-03 23F PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false indifferent (noticed me,busy eating,foraging) POINT (-73.9638141923763 40.7829225326288)   19 4 19 13
1967 1967 -73.9647247254127 40.7806136565784 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9647247254127 40.7806136565784)   19 4 19 13
1971 1971 -73.9591880400132 40.7950071252836 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   true true false false true false true false   POINT (-73.95918804001322 40.7950071252836)   19 4 19 13
2050 2050 -73.9555255950648 40.7977720808005 40D-AM-1013-04 40D AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9555255950648 40.7977720808005)   19 4 19 13
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       false false false true true watching false false false false false false false true   POINT (-73.9593909381748 40.7961036981921)   19 4 19 13
2109 2109 -73.9744488584414 40.7741627220859 10C-PM-1013-03 10C PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9744488584414 40.7741627220859)   19 4 19 13
2175 2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   false false true true true   false false false false false false false true   POINT (-73.9657487923637 40.7786823090663)   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
2202 2202 -73.9556039997621 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9556039997621 40.7977549157287)   19 4 19 13
2265 2265 -73.9705260103239 40.7826333686599 19A-PM-1013-04 19A PM 10132018 4 Adult Gray Black, White Gray+Black, White Also looks quite brown - minimal body highlight coloring - black edges Above Ground 2   false false false true true   false false false false false false true false   POINT (-73.9705260103239 40.78263336865991)   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
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
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people true false false true true   false false false false true false true true   POINT (-73.9596083366477 40.7949526729608)   19 4 19 13
2549 2549 -73.972248505758 40.7659043693008 3I-PM-1013-01 03I PM 10132018 1 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.972248505758 40.765904369300806)   19 4 19 13
2589 2589 -73.9694166642262 40.7697788641081 8I-PM-1013-03 08I PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9694166642262 40.7697788641081)   19 4 19 13
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true true true   false false false false false false false true   POINT (-73.96926766598071 40.7700678919108)   19 4 19 13
2711 2711 -73.9628842960118 40.7938048572403 34A-PM-1013-01 34A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true took a chestnut false false false false false false false false   POINT (-73.9628842960118 40.7938048572403)   19 4 19 13
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9618094076328 40.7944097368153)   19 4 19 13
2915 2915 -73.9734630412566 40.7653097139415 1H-PM-1013-02 01H PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9734630412566 40.7653097139415)   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 83.053ms