2018_Central_Park_Squirrel_Census_-_Squirrel_Data

39 rows where Date = 10062018, Hectare Squirrel Number = 1 and Indifferent = 0 sorted by Age

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from

Eating ✖

  • 0 26
  • 1 13

Indifferent ✖

Hectare Squirrel Number ✖

Date ✖

  • 10062018 · 39 ✖
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
91 91 -73.95659058682759 40.7895654068546 32H-PM-1006-01 32H PM 10062018 1   Gray   Gray+   Above Ground   in the European Beech 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565905868276 40.7895654068546)
2142 2142 -73.95985354257058 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0 hanging on fence 1 0 0 1 0 0 0 1   POINT (-73.9598535425706 40.7915589343685)
15 15 -73.9674285955293 40.7829723919744 21C-PM-1006-01 21C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 1 1 0 0 0   POINT (-73.9674285955293 40.7829723919744)
78 78 -73.964474836001 40.7883840104749 28C-PM-1006-01 28C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 gathering acorns 0 0 0 1 0 0 0 1 gnd to tree POINT (-73.964474836001 40.7883840104749)
137 137 -73.97824171151392 40.77246650364471 7A-AM-1006-01 07A AM 10062018 1 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 0 0 1   0 1 0 0 1 0 0 0 looked at us POINT (-73.9782417115139 40.7724665036447)
162 162 -73.957219204335 40.7931529059779 35E-PM-1006-01 35E PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 looking/begging for food POINT (-73.957219204335 40.7931529059779)
479 479 -73.95694033658471 40.795659960879796 38D-PM-1006-01 38D PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 didn't see me or others POINT (-73.9569403365847 40.7956599608798)
528 528 -73.9647284206644 40.7839611840884 23E-PM-1006-01 23E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9647284206644 40.7839611840884)
540 540 -73.97468021940121 40.7731347452245 9C-PM-1006-01 09C PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9746802194012 40.7731347452245)
675 675 -73.9759830650957 40.7683034739069 3E-AM-1006-01 03E AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9759830650957 40.7683034739069)
730 730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 0 1   POINT (-73.9607280801601 40.7901506706248)
837 837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
872 872 -73.9551524422379 40.7910535596756 34H-PM-1006-01 34H PM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9551524422379 40.7910535596756)
944 944 -73.97388173881579 40.7712709366093 7E-AM-1006-01 07E AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE under a tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9738817388158 40.7712709366093)
1303 1303 -73.9603302382958 40.7910100435196 32D-PM-1006-01 32D PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9603302382958 40.7910100435196)
1305 1305 -73.9569324958684 40.7877748374259 30I-PM-1006-01 30I PM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 sitting there 0 0 0 0 0 0 0 1   POINT (-73.9569324958684 40.78777483742591)
1373 1373 -73.956737220098 40.797580989254996 40C-PM-1006-01 40C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95673722009802 40.797580989255)
1429 1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)
1440 1440 -73.9748669205206 40.7743879232016 10B-AM-1006-01 10B AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9748669205206 40.7743879232016)
1512 1512 -73.97338823645741 40.768307870659704 5G-AM-1006-01 05G AM 10062018 1 Adult Gray Black Gray+Black   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0 made eye contact with me POINT (-73.9733882364574 40.7683078706597)
1581 1581 -73.97157754108001 40.7776249963967 14C-PM-1006-01 14C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97157754108 40.7776249963967)
1650 1650 -73.97624942397191 40.775017530671605 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields 0 0 0 1 0 eating (a peanut) 0 0 0 0 0 1 0 0   POINT (-73.9762494239719 40.7750175306716)
1867 1867 -73.9745204169071 40.7736282868469 9C-AM-1006-01 09C AM 10062018 1 Adult Gray   Gray+   Above Ground 40 Tree 1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9745204169071 40.7736282868469)
1918 1918 -73.9632866142841 40.7890043294436 29C-PM-1006-01 29C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0 not too shy POINT (-73.96328661428412 40.78900432944361)
1983 1983 -73.97841448676391 40.771817766751106 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 0   POINT (-73.9784144867639 40.7718177667511)
2044 2044 -73.97715523261991 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 1 0 0   POINT (-73.9771552326199 40.7706917595308)
2067 2067 -73.97250779335741 40.7654562710325 2I-PM-1006-01 02I PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 Sitting on back of bench with food hanging from mouth 0 0 0 0 0 staring at me 0 0 0 0 0 0 0 1   POINT (-73.9725077933574 40.7654562710325)
2150 2150 -73.9557710118271 40.791916118555704 34G-PM-1006-01 34G PM 10062018 1 Adult Black   Black+ Skinny, thin tail Ground Plane FALSE   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9557710118271 40.7919161185557)
2345 2345 -73.965738547469 40.78869627401671 27B-PM-1006-01 27B PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE By large tree 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.965738547469 40.7886962740167)
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)
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2741 2741 -73.9545877741228 40.79000012103529 33I-PM-1006-01 33I PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9545877741228 40.7900001210353)
2858 2858 -73.9728723853967 40.7670816164986 4H-PM-1006-01 04H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9728723853967 40.7670816164986)
1004 1004 -73.9670850805619 40.7833747810387 22C-PM-1006-01 22C PM 10062018 1 Juvenile Gray   Gray+   Ground Plane FALSE   1 1 0 0 0 for food 0 1 0 0 0 0 0 0   POINT (-73.9670850805619 40.7833747810387)
1107 1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
1215 1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1523 1523 -73.9673103881521 40.78742674096179 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9673103881521 40.7874267409618)
1549 1549 -73.97779784978941 40.7668620784309 1D-AM-1006-01 01D AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9777978497894 40.7668620784309)
1685 1685 -73.96788229832741 40.7802960985637 18E-PM-1006-01 18E PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678822983274 40.7802960985637)

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