2018_Central_Park_Squirrel_Census_-_Squirrel_Data

34 rows where Date = 10062018, Foraging = 1 and Hectare Squirrel Number = 1 sorted by longitude

✎ 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, Chasing, Climbing, Eating, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Running ✖

  • 0 29
  • 1 5

Hectare Squirrel Number ✖

Foraging ✖

Date ✖

  • 10062018 · 34 ✖
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
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)
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)
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)
2709 2709 -73.97750689157151 40.7664424394736 1E-AM-1006-01 01E AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775068915715 40.7664424394736)
2221 2221 -73.9771847728747 40.769597116498105 4C-AM-1006-01 04C AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9771847728747 40.7695971164981)
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)
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)
160 160 -73.9756015005821 40.7670090327736 2F-AM-1006-01 02F AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE walking along path 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97560150058212 40.7670090327736)
836 836 -73.975086415444 40.7671990131313 3F-AM-1006-01 03F AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE just to right when enter sanctuary 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.975086415444 40.7671990131313)
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)
2351 2351 -73.97458184501092 40.765449887362706 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9745818450109 40.7654498873627)
2605 2605 -73.97368963630059 40.767763086262605 4G-AM-1006-01 04G AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9736896363006 40.7677630862626)
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)
2792 2792 -73.97237364945971 40.766950134329704 4H-AM-1006-01 04H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9723736494597 40.7669501343297)
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)
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)
1213 1213 -73.9693202078293 40.771043472925 9H-AM-1006-01 09H AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9693202078293 40.771043472925)
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)
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)
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 0 0 0 1 1 walking up & down branches 0 0 0 0 0 0 1 0   POINT (-73.9667560049684 40.7882333830729)
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)
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)
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)
775 775 -73.95957577926829 40.7899242643847 31E-PM-1006-01 31E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes 0 0 0 0 1   0 1 0 0 0 0 1 0   POINT (-73.9595757792683 40.7899242643847)
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)
1703 1703 -73.956998502609 40.7948117428147 37E-PM-1006-01 37E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.956998502609 40.7948117428147)
55 55 -73.9568802149818 40.7972399133816 39C-PM-1006-01 39C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9568802149818 40.7972399133816)
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)
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)
2958 2958 -73.9541748083177 40.795275844289705 39F-PM-1006-01 39F PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 carrying leaves 0 0 0 0 0 0 1 0   POINT (-73.9541748083177 40.7952758442897)
2650 2650 -73.9538251716292 40.7919360198175 35I-PM-1006-01 35I PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538251716292 40.7919360198175)
2336 2336 -73.95312632141359 40.7965675089932 40F-PM-1006-01 40F PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9531263214136 40.7965675089932)
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)
2008 2008 -73.95243640874371 40.792846505434 37I-PM-1006-01 37I PM 10062018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Above Ground 5   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9524364087437 40.792846505434)

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