squirrels

33 rows where Climbing = "true", Combination of Primary and Highlight Color = "Gray+" and Hectare Squirrel Number = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, 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
226 226 -73.9775681731459 40.7676421190309 2D-AM-1007-03 02D AM 10072018 3 Adult Gray   Gray+   Above Ground 100   false false true false false   false false false false false false false false   POINT (-73.9775681731459 40.7676421190309)   19 4 19 13
279 279 -73.9550082056509 40.7894521543449 33I-AM-1008-03 33I AM 10082018 3 Adult Gray   Gray+   Above Ground 2 98th @ edge of park false false true false false   false false false false false false true false   POINT (-73.9550082056509 40.7894521543449)   19 4 19 13
347 347 -73.9611696144784 40.7816692895155 22I-AM-1007-03 22I AM 10072018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9611696144784 40.7816692895155)   19 4 19 13
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false true runs from the dog POINT (-73.9681917366128 40.7723298813768)   19 4 19 13
414 414 -73.9721899838568 40.7761519045651 13C-AM-1010-03 13C AM 10102018 3 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9721899838568 40.7761519045651)   19 4 19 13
530 530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   false false true true false   false false false false false false true false   POINT (-73.9696360756453 40.7786545659072)   19 4 19 13
569 569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree true false true false false   false false false true false false true false   POINT (-73.9709040623777 40.7701163892686)   19 4 19 13
665 665 -73.9563661256875 40.7966823114508 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9563661256875 40.7966823114508)   19 4 19 13
757 757 -73.9783185278595 40.7724861675504 7A-AM-1006-03 07A AM 10062018 3 Adult Gray   Gray+ 3/4 length tail, hair loss Above Ground 20 in trees, then to ground true false true false false jumping false false false false false false true false   POINT (-73.9783185278595 40.7724861675504)   19 4 19 13
778 778 -73.9677054870327 40.778992870166 17E-AM-1017-03 17E AM 10172018 3 Adult Gray   Gray+   Above Ground 9 Tree trunk false false true false false   false false false false false false false false   POINT (-73.9677054870327 40.778992870166)   19 4 19 13
869 869 -73.9629483374528 40.7936809905265 33A-PM-1018-03 33A PM 10182018 3 Adult Gray   Gray+   Above Ground 6   true false true false false   false false false false false false false true   POINT (-73.9629483374528 40.7936809905265)   19 4 19 13
958 958 -73.9613862251332 40.791282169715 32C-AM-1014-03 32C AM 10142018 3 Adult Gray   Gray+   Above Ground 3   false true true false false   false false false false false false false false   POINT (-73.9613862251332 40.791282169715)   19 4 19 13
1301 1301 -73.9552146665714 40.7892909102377 32I-PM-1007-03 32I PM 10072018 3 Adult Gray   Gray+ small adult Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9552146665714 40.7892909102377)   19 4 19 13
1355 1355 -73.9655277320465 40.7806120529369 20F-AM-1014-03 20F AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9655277320465 40.7806120529369)   19 4 19 13
1569 1569 -73.973047824163 40.7700873791211 7F-AM-1008-03 07F AM 10082018 3 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.973047824163 40.7700873791211)   19 4 19 13
1610 1610 -73.9607056611532 40.7889786103871 30E-AM-1008-03 30E AM 10082018 3 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false false false true false   POINT (-73.9607056611532 40.7889786103871)   19 4 19 13
1701 1701 -73.9701634768603 40.7778691433218 15D-AM-1007-03 15D AM 10072018 3 Adult Gray   Gray+   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9701634768603 40.7778691433218)   19 4 19 13
1715 1715 -73.9745709109056 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   true false true false false in tree false false false false false false true false   POINT (-73.9745709109056 40.7672225695415)   19 4 19 13
1796 1796 -73.9765355395622 40.7735653237366 8B-AM-1007-03 08B AM 10072018 3 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.97653553956222 40.7735653237366)   19 4 19 13
1890 1890 -73.9787723082807 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9787723082807 40.7713655754004)   19 4 19 13
2015 2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! false false true false true throwing down acorns false false false false false false false false   POINT (-73.9574365550758 40.7886924675052)   19 4 19 13
2076 2076 -73.9712636931964 40.77998098773 17B-AM-1010-03 17B AM 10102018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   false false false false false false false false   POINT (-73.9712636931964 40.77998098773)   19 4 19 13
2154 2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   false false true true false   false false false false false false false false   POINT (-73.976716425804 40.7736889979965)   19 4 19 13
2377 2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9704328573603 40.7739347247552)   19 4 19 13
2396 2396 -73.9704339422613 40.7740149529644 11F-PM-1006-03 11F PM 10062018 3 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false true false true false   POINT (-73.9704339422613 40.7740149529644)   19 4 19 13
2441 2441 -73.9579865329778 40.794906535675 37D-PM-1014-03 37D PM 10142018 3 Adult Gray   Gray+   Above Ground 40   false false true false false   false false false false false false false false   POINT (-73.9579865329778 40.794906535675)   19 4 19 13
2452 2452 -73.9727323797981 40.7669035463955 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest false false true false false   false false false false false false true false   POINT (-73.9727323797981 40.7669035463955)   19 4 19 13
2534 2534 -73.9744368038675 40.7674281958115 3G-PM-1013-03 03G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true runs from (climbed tree to run from) POINT (-73.97443680386752 40.7674281958115)   19 4 19 13
2598 2598 -73.976658503418 40.7686868456917 4D-AM-1012-03 04D AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   false true true false false   false false false false true false true false   POINT (-73.976658503418 40.7686868456917)   19 4 19 13
2603 2603 -73.9708781504528 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9708781504528 40.7724138070355)   19 4 19 13
2660 2660 -73.9726056411971 40.7793467904743 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9726056411971 40.7793467904743)   19 4 19 13
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false true true false false   false true false false false false false false looked at us from tree POINT (-73.9677903197449 40.7826561917755)   19 4 19 13
2960 2960 -73.962524814515 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true false   POINT (-73.962524814515 40.7810022923615)   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 61.359ms