squirrels

53 rows where Date = 10142018, Foraging = "false" and Runs from = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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, Eating, Other Activities, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

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
102 102 -73.9575986161364 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree false false true false false climbing (tree) false false false false false false false true   POINT (-73.9575986161364 40.799368134968)   19 4 19 13
168 168 -73.9745691353018 40.7771035589298 13A-PM-1014-03 13A PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false true false false   false false false false false false false true child chasing POINT (-73.9745691353018 40.7771035589298)   19 4 19 13
224 224 -73.9520592496349 40.7975076299811 42G-PM-1014-03 42G PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 on fence true false false false false prancing false false false false false false false true   POINT (-73.9520592496349 40.7975076299811)   19 4 19 13
236 236 -73.9737266070919 40.7786338379896 14A-PM-1014-01 14A PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9737266070919 40.7786338379896)   19 4 19 13
277 277 -73.9619070229674 40.79525566925 35A-AM-1014-05 35A AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9619070229674 40.79525566925)   19 4 19 13
338 338 -73.9765595553183 40.7748455340432 10A-PM-1014-04 10A PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9765595553183 40.7748455340432)   19 4 19 13
341 341 -73.9703161745884 40.7702610461336 8H-PM-1014-05 08H PM 10142018 5 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false false false false true   POINT (-73.9703161745884 40.7702610461336)   19 4 19 13
386 386 -73.9550351380957 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9550351380957 40.7974681522214)   19 4 19 13
388 388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9592537496995 40.7919271821316)   19 4 19 13
415 415 -73.9570131890379 40.7991786736124 41B-PM-1014-05 41B PM 10142018 5 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true true   POINT (-73.9570131890379 40.7991786736124)   19 4 19 13
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9708798496132 40.7761532088521)   19 4 19 13
581 581 -73.9556218199258 40.7980460204041 41D-PM-1014-01 41D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false digging,drinking false false false false false false false true   POINT (-73.9556218199258 40.7980460204041)   19 4 19 13
593 593 -73.9593352806175 40.7918150568046 33E-AM-1014-02 33E AM 10142018 2 Juvenile Black   Black+   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9593352806175 40.7918150568046)   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
726 726 -73.973305698325 40.7783823311296 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   false false true false false   false false false false false false false true   POINT (-73.973305698325 40.7783823311296)   19 4 19 13
898 898 -73.9542828053256 40.7941797320355 37G-AM-1014-03 37G AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9542828053256 40.7941797320355)   19 4 19 13
974 974 -73.9753744539307 40.7671162211032 2F-PM-1014-12 02F PM 10142018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.97537445393071 40.7671162211032)   19 4 19 13
1075 1075 -73.9640534906634 40.7777383899836 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false standing upright false false false false false true false true runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)   19 4 19 13
1102 1102 -73.9688173465755 40.7782009764626 16E-AM-1014-08 16E AM 10142018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (dog) POINT (-73.9688173465755 40.7782009764626)   19 4 19 13
1183 1183 -73.9525699067954 40.7937125788106 38I-PM-1014-01 38I PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE on the lawn East of the fountain false false false false false scampering thru the grass! false false false false true false false true   POINT (-73.9525699067954 40.7937125788106)   19 4 19 13
1206 1206 -73.9748709206354 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   false false true false false   true false false false false false false true   POINT (-73.9748709206354 40.77608025411)   19 4 19 13
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   true false false false false false false true   POINT (-73.980919134781 40.7683772453336)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1489 1489 -73.9501762527462 40.7975534086077 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   true true false false false   false false false false false false false true   POINT (-73.9501762527462 40.7975534086077) 12423 18 4 36 18
1584 1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false false true   POINT (-73.9581310602492 40.7960214726964)   19 4 19 13
1635 1635 -73.9560731738677 40.7980336018554 41D-PM-1014-02 41D PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9560731738677 40.7980336018554)   19 4 19 13
1652 1652 -73.9498421746221 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   true false false false false   false false false false false false false true   POINT (-73.9498421746221 40.7969397424182)   19 4 19 13
1665 1665 -73.9583944353352 40.7979689846815 39B-PM-1014-04 39B PM 10142018 4 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true true runs from (me—when i approached) POINT (-73.9583944353352 40.7979689846815)   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
1765 1765 -73.9689041600147 40.7781788966185 16E-AM-1014-07 16E AM 10142018 7 Adult Gray   Gray+   Above Ground     true false false false false   false false false false false false false true runs from (dog) POINT (-73.9689041600147 40.7781788966185)   19 4 19 13
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat true false true true false   false false false false false false false true   POINT (-73.958719099962 40.7947587726617)   19 4 19 13
1775 1775 -73.951965247933 40.7938167628067 38I-PM-1014-03 38I PM 10142018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true true   POINT (-73.951965247933 40.7938167628067)   19 4 19 13
1803 1803 -73.9588076804698 40.7912942607296 33E-AM-1014-06 33E AM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9588076804698 40.7912942607296)   19 4 19 13
1807 1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   false false true false false   true true false false false false false true   POINT (-73.9581366214863 40.7988964092722)   19 4 19 13
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9733898487296 40.7666975131518)   19 4 19 13
1908 1908 -73.9588345546879 40.7991830272008 40A-PM-1014-02 40A PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from base of tree into bushes) POINT (-73.9588345546879 40.7991830272008)   19 4 19 13
2070 2070 -73.9725700261894 40.7668793330427 3H-PM-1014-01 03H PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE under a parked car true false false false false   false false false false false false false true   POINT (-73.9725700261894 40.7668793330427)   19 4 19 13
2086 2086 -73.9525627119429 40.7938602867464 38I-PM-1014-02 38I PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hanging out w/ Squirrel #1 false false false false false scampering w/ squirrel #1 false false false false true false false true   POINT (-73.9525627119429 40.7938602867464)   19 4 19 13
2244 2244 -73.9509628195532 40.7977775674178 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false false false false   false false false false true false false true   POINT (-73.9509628195532 40.7977775674178) 12423 18 4 36 18
2261 2261 -73.9609692861012 40.790502891247 31D-AM-1014-07 31D AM 10142018 7   Gray   Gray+   Ground Plane FALSE Crossing path to tree true false false false false   false false false false false false false true   POINT (-73.9609692861012 40.790502891247)   19 4 19 13
2279 2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)   19 4 19 13
2307 2307 -73.9736997033862 40.778497952406 14A-PM-1014-02 14A PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9736997033862 40.778497952406)   19 4 19 13
2416 2416 -73.9588689820908 40.7992384137972 40A-PM-1014-03 40A PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from base of tree into bushes) POINT (-73.9588689820908 40.799238413797205)   19 4 19 13
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false true false false false true   POINT (-73.95795157569 40.7961254697958)   19 4 19 13
2621 2621 -73.9596904740342 40.7897200025671 31E-AM-1014-01 31E AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9596904740342 40.7897200025671)   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
2779 2779 -73.9767835160078 40.7674030330482 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false true   POINT (-73.9767835160078 40.7674030330482)   19 4 19 13
2809 2809 -73.9686756254868 40.7777459102651 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9686756254868 40.7777459102651)   19 4 19 13
2910 2910 -73.9506062997507 40.7976189496674 42H-PM-1014-03 42H PM 10142018 3 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9506062997507 40.7976189496674) 12423 18 4 36 18
2936 2936 -73.9809876538513 40.7683223242143 1A-PM-1014-05 01A PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9809876538513 40.7683223242143)   19 4 19 13
2948 2948 -73.9545225586988 40.7956074663106 39F-AM-1014-03 39F AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9545225586988 40.7956074663106)   19 4 19 13
2975 2975 -73.959412243507 40.7917871123534 33E-AM-1014-01 33E AM 10142018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false digging false false false false false false false true   POINT (-73.959412243507 40.7917871123534)   19 4 19 13
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true true false false false   false false false false true false false true   POINT (-73.9503533343658 40.7976543603953) 12423 18 4 36 18

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 61.997ms