squirrels

45 rows where Date = 10122018 and Highlight Fur Color = "Cinnamon" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions

Foraging ✖

Highlight Fur Color ✖

  • Cinnamon · 45 ✖

Date ✖

  • 10122018 · 45 ✖
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
285 285 -73.9691433356733 40.7731708333242 11G-AM-1012-01 11G AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9691433356733 40.77317083332421)   19 4 19 13
324 324 -73.9587879699956 40.7908135158551 32F-AM-1012-01 32F AM 10122018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true made a back-door escape from dog off-leash false false false false false false false true   POINT (-73.9587879699956 40.7908135158551)   19 4 19 13
345 345 -73.9724452296309 40.7715792113505 8F-PM-1012-03 08F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true buried an acorn false false false false false false true false   POINT (-73.9724452296309 40.7715792113505)   19 4 19 13
404 404 -73.9680774548516 40.7762491903691 14F-PM-1012-01 14F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9680774548516 40.7762491903691)   19 4 19 13
447 447 -73.9725906016474 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9725906016474 40.7713889729739)   19 4 19 13
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615402629655 40.7924082330328)   19 4 19 13
606 606 -73.9717580228664 40.7715726159383 8F-PM-1012-01 08F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.97175802286641 40.7715726159383)   19 4 19 13
657 657 -73.9679008849677 40.7759013923034 14G-AM-1012-02 14G AM 10122018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9679008849677 40.7759013923034)   19 4 19 13
698 698 -73.9585537668382 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false bringing green leaves to nest false false false false false false false false   POINT (-73.9585537668382 40.7903905787005)   19 4 19 13
760 760 -73.9718234159557 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true true burying false false false true false false false true   POINT (-73.9718234159557 40.7810842503715)   19 4 19 13
765 765 -73.96797780019 40.7847629473258 23B-PM-1012-05 23B PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 chain link fence false true true false false   false false false false false false true false   POINT (-73.96797780019 40.7847629473258)   19 4 19 13
832 832 -73.9676206022477 40.784594234984 23B-PM-1012-01 23B PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9676206022477 40.784594234984)   19 4 19 13
880 880 -73.9565684577989 40.7936003940413 36F-PM-1012-02 36F PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9565684577989 40.7936003940413)   19 4 19 13
1060 1060 -73.9728871061191 40.7712983658944 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false true false   false false false false false false false true   POINT (-73.9728871061191 40.7712983658944)   19 4 19 13
1064 1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         true false true false false   false false false false false false true true   POINT (-73.9540257319561 40.798408619116)   19 4 19 13
1090 1090 -73.967767372181 40.784702631615 23B-PM-1012-07 23B PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.967767372181 40.784702631615)   19 4 19 13
1100 1100 -73.980542388615 40.7682048804794 1B-AM-1012-14 01B AM 10122018 14   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.980542388615 40.7682048804794)   19 4 19 13
1159 1159 -73.9682129261841 40.7754232358118 14G-AM-1012-03 14G AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9682129261841 40.7754232358118)   19 4 19 13
1166 1166 -73.980048119915 40.7676638655026 1B-AM-1012-06 01B AM 10122018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true true false false   false false false false false false true false   POINT (-73.980048119915 40.7676638655026)   19 4 19 13
1249 1249 -73.9590132705889 40.7952248279764 37C-AM-1012-03 37C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9590132705889 40.7952248279764)   19 4 19 13
1284 1284 -73.9570891696776 40.7935448802241 36E-PM-1012-01 36E PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9570891696776 40.7935448802241)   19 4 19 13
1332 1332 -73.9774928245781 40.7720464606979 6B-AM-1012-02 06B AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE by bike racks at Tavern on the Green false false false false true walking,exploring - digging in flower bed false false false false false false false true   POINT (-73.9774928245781 40.7720464606979)   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
1447 1447 -73.9601968065017 40.7935831836482 34C-PM-1012-03 34C PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9601968065017 40.79358318364821)   19 4 19 13
1477 1477 -73.9589635326362 40.7951748673846 37C-AM-1012-02 37C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks, light band across nose Ground Plane FALSE   false false false false true caching false false false false false false true false   POINT (-73.9589635326362 40.7951748673846)   19 4 19 13
1565 1565 -73.9803895322385 40.7680730789944 1B-AM-1012-13 01B AM 10122018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9803895322385 40.7680730789944)   19 4 19 13
1579 1579 -73.9768309556127 40.7717803706095 6B-AM-1012-01 06B AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Started in field, crossed busy street, ran up tree true false false false true   false false false false false false true false   POINT (-73.97683095561271 40.7717803706095)   19 4 19 13
1720 1720 -73.9725844658514 40.7701092834201 7F-PM-1012-02 07F PM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false observes POINT (-73.9725844658514 40.7701092834201)   19 4 19 13
1781 1781 -73.96005650463 40.7934048502983 34C-PM-1012-02 34C PM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.96005650463 40.7934048502983)   19 4 19 13
1850 1850 -73.975809362521 40.7734702737835 8B-PM-1012-09 08B PM 10122018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree true false true false false   false false false false false false false true   POINT (-73.975809362521 40.7734702737835)   19 4 19 13
2023 2023 -73.9663977261879 40.775645134229 14H-PM-1012-08 14H PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9663977261879 40.775645134229)   19 4 19 13
2106 2106 -73.9801651470389 40.7677698656935 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9801651470389 40.7677698656935)   19 4 19 13
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9651217998407 40.7761115392738)   19 4 19 13
2369 2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9801956082236 40.767836440957)   19 4 19 13
2372 2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   false false true false false gathering false false false false false false false false   POINT (-73.9724879969884 40.771098202397)   19 4 19 13
2381 2381 -73.9588414980489 40.7953525481367 37C-AM-1012-01 37C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true caching false false false false false false false true   POINT (-73.9588414980489 40.7953525481367)   19 4 19 13
2447 2447 -73.9589670987899 40.7952127039287 37C-AM-1012-04 37C AM 10122018 4 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9589670987899 40.7952127039287)   19 4 19 13
2627 2627 -73.9766348078633 40.7717715634438 7C-AM-1012-01 07C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping around grass false false false false false false true false   POINT (-73.9766348078633 40.7717715634438)   19 4 19 13
2652 2652 -73.9620542514749 40.7943731722138 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9620542514749 40.7943731722138)   19 4 19 13
2666 2666 -73.9763593390732 40.7717297058549 7C-AM-1012-03 07C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true foraging (loving the acorns!) false false false false false false true false   POINT (-73.97635933907321 40.7717297058549)   19 4 19 13
2808 2808 -73.9765027953575 40.7717327360835 7C-AM-1012-02 07C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping around false false false false false false true false   POINT (-73.9765027953575 40.7717327360835)   19 4 19 13
2823 2823 -73.9664054327771 40.7756180893318 14H-PM-1012-07 14H PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9664054327771 40.7756180893318)   19 4 19 13
2872 2872 -73.9615396457996 40.7923594366783 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615396457996 40.7923594366783)   19 4 19 13
2880 2880 -73.9726598256924 40.7707862446236 7F-PM-1012-03 07F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true digging false false false false false false false true   POINT (-73.9726598256924 40.7707862446236)   19 4 19 13
2981 2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9800094828465 40.7677782585639)   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 156.543ms