2018_Central_Park_Squirrel_Census_-_Squirrel_Data

64 rows where Date = 10172018 and Eating = 1 sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 34
  • 1 5

Eating ✖

Date ✖

  • 10172018 · 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
461 461 -73.96481954331921 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 1 1 0 staring 0 0 0 0 1 0 0 0   POINT (-73.9648195433192 40.7796399955868)
1139 1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9716271494641 40.7796462634184)
2843 2843 -73.97147871782009 40.779804947074496 16B-PM-1017-01 16B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714787178201 40.7798049470745)
723 723 -73.9654397484763 40.7798863522904 19F-PM-1017-03 19F PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9654397484763 40.7798863522904)
1846 1846 -73.96533111365609 40.780193490342995 19F-PM-1017-07 19F PM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9653311136561 40.78019349034301)
1499 1499 -73.96252055381709 40.7810785055136 21H-AM-1017-01 21H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9625205538171 40.7810785055136)
1241 1241 -73.9651817987035 40.781908283833396 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree 0 0 0 1 1   0 0 0 0 1 0 0 0 walks from POINT (-73.9651817987035 40.7819082838334)
2764 2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 paused to look at me POINT (-73.9692660977515 40.7830532310766)
2983 2983 -73.9689586689061 40.7839613907139 21B-PM-1017-04 21B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9689586689061 40.7839613907139)
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)
10 10 -73.9596413903948 40.790312888902896 32E-PM-1017-14 32E PM 10172018 14 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9596413903948 40.7903128889029)
64 64 -73.95950023395079 40.7903365788694 32E-PM-1017-13 32E PM 10172018 13 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9595002339508 40.7903365788694)
463 463 -73.95921030643271 40.7904390691553 32E-PM-1017-10 32E PM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9592103064327 40.7904390691553)
2376 2376 -73.9594204646985 40.790592376521296 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9594204646985 40.7905923765213)
1197 1197 -73.95908687485841 40.7906047630418 32E-PM-1017-09 32E PM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590868748584 40.7906047630418)
2593 2593 -73.9590191812452 40.790616698140894 32E-PM-1017-08 32E PM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590191812452 40.7906166981409)
1674 1674 -73.9589698681439 40.7906520520417 32E-PM-1017-06 32E PM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589698681439 40.7906520520417)
1789 1789 -73.9596271142953 40.790661231367295 32E-PM-1017-12 32E PM 10172018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 1 0 0 0 0 0 0   POINT (-73.9596271142953 40.7906612313673)
1812 1812 -73.9590074024938 40.7907059424675 32E-PM-1017-05 32E PM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590074024938 40.7907059424675)
245 245 -73.95894143392421 40.790707388827705 32E-PM-1017-04 32E PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589414339242 40.7907073888277)
105 105 -73.9589249555235 40.7908193284981 32E-PM-1017-03 32E PM 10172018 3 Adult Gray   Gray+   Above Ground 2 bottom of tree 0 0 0 1 0 still 0 0 0 0 0 0 1 0   POINT (-73.9589249555235 40.7908193284981)
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9621253644004 40.7912082086879)
900 900 -73.9626527908786 40.7912472380247 31B-AM-1017-03 31B AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9626527908786 40.7912472380247)
3007 3007 -73.9635140434993 40.7912807969365 31B-AM-1017-01 31B AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9635140434993 40.7912807969365)
106 106 -73.9634623418761 40.7917685404482 31A-PM-1017-04 31A PM 10172018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9634623418761 40.7917685404482)
1191 1191 -73.9634835346077 40.7918244310746 31A-PM-1017-03 31A PM 10172018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9634835346077 40.7918244310746)
1561 1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96423978295472 40.7918992406575)
1911 1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1 runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)
231 231 -73.9527808174534 40.7924167234441 36I-AM-1017-05 36I AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9527808174534 40.7924167234441)
786 786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
1375 1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9564741038174 40.7938845572816)
1120 1120 -73.9564079273261 40.7939340053805 36F-AM-1017-02 36F AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9564079273261 40.7939340053805)
703 703 -73.95763044737221 40.795981062234205 38D-AM-1017-05 38D AM 10172018 5 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Black stripe along sides Ground Plane FALSE   1 0 0 1 0 eating (nut) 0 0 0 0 0 0 0 1   POINT (-73.9576304473722 40.7959810622342)
618 618 -73.957976896139 40.797027128241 39C-AM-1017-04 39C AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.957976896139 40.797027128241005)
679 679 -73.955018489069 40.7971235333699 40E-PM-1017-02 40E PM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.955018489069 40.7971235333699)
1062 1062 -73.957259673402 40.7974442913898 39C-AM-1017-02 39C AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.957259673402 40.7974442913898)
629 629 -73.95737241332641 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 0 chasing (#1) 0 0 0 0 0 0 0 1   POINT (-73.9573724133264 40.7980080911115)
2993 2993 -73.95707222626929 40.798570614351895 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1 chasing (#3) 0 0 0 0 0 0 1 0   POINT (-73.9570722262693 40.7985706143519)

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