2018_Central_Park_Squirrel_Census_-_Squirrel_Data

133 rows where Highlight Fur Color = "Gray" and Tail twitches = 0 sorted by Specific Location

✎ View and edit SQL

This data as json, CSV (advanced)

Running ✖

  • 0 24
  • 1 9

Highlight Fur Color ✖

  • Gray · 33 ✖
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
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   0 0 0 0 0 wrestling with child 0 0 0 0 0 0 0 0   POINT (-73.956581233786 40.79021276908371)
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9621297946132 40.7944058222814)
2915 2915 -73.9734630412566 40.7653097139415 1H-PM-1013-02 01H PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9734630412566 40.7653097139415)
2927 2927 -73.96501200660741 40.7805932882407 20F-PM-1007-13 20F PM 10072018 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9650120066074 40.78059328824071)
2943 2943 -73.962534856258 40.7812134517411 22H-PM-1007-01 22H PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962534856258 40.7812134517411)
2971 2971 -73.9639801411692 40.7778921302618 18I-PM-1007-04 18I PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 walking sitting up 0 0 0 0 0 0 0 1   POINT (-73.9639801411692 40.7778921302618)
2992 2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9746063250438 40.7687654196811)
3003 3003 -73.96986639266571 40.773999710413 12F-PM-1007-09 12F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698663926657 40.773999710413)
3018 3018 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9645437409662 40.7811599933331)
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench 0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9700264128414 40.7692014637698)
1636 1636 -73.97014086231209 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass 1 0 0 1 0   0 0 0 1 0 0 0 0   POINT (-73.9701408623121 40.7695511718541)
261 261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552861155228 40.788973931872)
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552035011902 40.7889851896334)
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree 0 1 0 0 0 watching me 0 1 0 1 0 0 0 0 observant POINT (-73.9667474482967 40.7760643720793)
1103 1103 -73.9541500874008 40.7920329989756 35H-AM-1013-02 35H AM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 Sitting on tree limb 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0 watching me from tree,but calm POINT (-73.9541500874008 40.7920329989756)
2496 2496 -73.96962742914171 40.7691980808067 7I-PM-1013-03 07I PM 10132018 3 Adult Black Gray Black+Gray   Ground Plane FALSE Trash bins 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9696274291417 40.7691980808067)
2725 2725 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 10082018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9658867660358 40.7756523577509)
1311 1311 -73.9694169352433 40.774440829385796 12G-PM-1007-03 12G PM 10072018 3   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE bushes 0 0 0 0 1   0 0 0 0 0 0 0 0 friendly POINT (-73.9694169352433 40.7744408293858)
2919 2919 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 10132018 12 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE foot of tree 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9768563402344 40.7744487310786)
1253 1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527227282134 40.7935061484064)
2461 2461 -73.9605347462123 40.794207544838706 35B-AM-1010-04 35B AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE lawn 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9605347462123 40.7942075448387)
2026 2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch 0 0 0 0 0 watching me scratching 1 0 0 1 0 0 1 0   POINT (-73.9622752768962 40.7814921913101)
695 695 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.77453097941551)
224 224 -73.9520592496349 40.797507629981105 42G-PM-1014-03 42G PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 on fence 1 0 0 0 0 prancing 0 0 0 0 0 0 0 1   POINT (-73.9520592496349 40.7975076299811)
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
780 780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9675472064204 40.7835947167436)
2521 2521 -73.976869549792 40.770698245472296 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree 0 0 0 0 0 relaxing 0 0 0 1 0 0 1 0   POINT (-73.976869549792 40.7706982454723)
789 789 -73.9675023138703 40.7872554700995 25A-PM-1007-01 25A PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 40 tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9675023138703 40.7872554700995)
2280 2280 -73.97671436441509 40.76847569413211 3D-AM-1006-02 03D AM 10062018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25 tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767143644151 40.7684756941321)
1003 1003 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 10082018 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9 tree hollow 0 0 0 0 0 in hollow 0 0 0 0 0 0 0 0 curious POINT (-73.9645547556826 40.776877007081)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
377 377 -73.9757001944781 40.769499790547 5E-AM-1008-09 05E AM 10082018 9 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2 went up tree 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9757001944781 40.769499790547)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 6.653ms