squirrels

35 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 3, Indifferent = "true", Police Precincts = 13, Runs from = "false" and Shift = "AM" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail twitches, Approaches, Other Interactions

Shift ✖

Runs from ✖

  • false · 35 ✖

Hectare Squirrel Number ✖

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
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
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
452 452 -73.960300330029 40.7953475871869 36B-AM-1013-03 36B AM 10132018 3   Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.960300330029 40.7953475871869)   19 4 19 13
811 811 -73.9771695272048 40.7724277276263 7B-AM-1008-03 07B AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771695272048 40.7724277276263)   19 4 19 13
900 900 -73.9626527908786 40.7912472380247 31B-AM-1017-03 31B AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9626527908786 40.7912472380247)   19 4 19 13
998 998 -73.9600546294497 40.7914969165757 33D-AM-1017-03 33D AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true true false   POINT (-73.9600546294497 40.7914969165757)   19 4 19 13
1337 1337 -73.9750986553543 40.7740671171292 10C-AM-1018-03 10C AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9750986553543 40.7740671171292)   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
1611 1611 -73.9655238539833 40.7815633947684 21E-AM-1017-03 21E AM 10172018 3 Adult Gray   Gray+   Above Ground 7   false true false false false   false false false false false false true false   POINT (-73.9655238539833 40.7815633947684)   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
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
1819 1819 -73.9711378905748 40.7696218346333 7H-AM-1006-03 07H AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE on rock (large) false false false false true   false false false false true false true false   POINT (-73.9711378905748 40.769621834633305)   19 4 19 13
1829 1829 -73.9746965894947 40.7664351724309 2G-AM-1010-03 02G AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9746965894947 40.7664351724309)   19 4 19 13
1834 1834 -73.9739038832156 40.7730354890554 9D-AM-1008-03 09D AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9739038832156 40.7730354890554)   19 4 19 13
1912 1912 -73.9698064901149 40.7842538115839 21A-AM-1019-03 21A AM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE Tree & ground false true false false false   false false false false false false true false   POINT (-73.9698064901149 40.78425381158391)   19 4 19 13
2172 2172 -73.9642900903774 40.7917017168842 31A-AM-1010-03 31A AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9642900903774 40.7917017168842)   19 4 19 13
2238 2238 -73.9536198726174 40.7980135102228 41E-AM-1007-03 41E AM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9536198726174 40.7980135102228)   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
2476 2476 -73.9710843362124 40.7679739601336 5I-AM-1010-03 05I AM 10102018 3 Adult Gray   Gray+   Above Ground 3   false false false false false   false false false false false false true false   POINT (-73.9710843362124 40.7679739601336)   19 4 19 13
2563 2563 -73.9664536611195 40.7827694131949 21D-AM-1008-03 21D AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9664536611195 40.7827694131949)   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
2630 2630 -73.965019827314 40.7759864291323 15I-AM-1008-03 15I AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.965019827314 40.7759864291323)   19 4 19 13
2736 2736 -73.9593895253501 40.7973085844087 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9593895253501 40.7973085844087)   19 4 19 13
2763 2763 -73.9626065672894 40.788722645116 29D-AM-1014-03 29D AM 10142018 3 Juvenile Gray   Gray+   Above Ground 35 End of tree limb foraging false false false false true   false false false false false false true false   POINT (-73.9626065672894 40.788722645116)   19 4 19 13
2914 2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   true false false false false   false false false false false false true false   POINT (-73.9722053355548 40.7662094993614)   19 4 19 13
2972 2972 -73.9631468456897 40.7926110399714 32A-AM-1018-03 32A AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9631468456897 40.7926110399714)   19 4 19 13
783 783 -73.9677654289757 40.786785529449 25A-AM-1013-03 25A AM 10132018 3   Gray   Gray+   Above Ground 15 BIG TREE false false false false false being chased by #2 false false false false false false true false   POINT (-73.9677654289757 40.786785529449)   19 4 19 13
228 228 -73.9728660779622 40.7753294525644 12C-AM-1013-03 12C AM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true burying false false false false false false true false   POINT (-73.9728660779622 40.7753294525644)   19 4 19 13
2848 2848 -73.9715977170548 40.7742172650622 11E-AM-1013-03 11E AM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true burying false false false false false false true false   POINT (-73.9715977170548 40.774217265062205)   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
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
2379 2379 -73.9711865134364 40.7785039981892 15C-AM-1010-03 15C AM 10102018 3 Adult Gray   Gray+   Above Ground 6   false false false true false sitting false false false false false false true false   POINT (-73.9711865134364 40.7785039981892)   19 4 19 13
2006 2006 -73.9695641121727 40.7769562886685 14E-AM-1008-03 14E AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false false true false unaware of POINT (-73.9695641121727 40.7769562886685)   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 5999.835ms