2018_Central_Park_Squirrel_Census_-_Squirrel_Data

62 rows where Date = 10182018 and Running = 1 sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 28
  • 1 4

Running ✖

Date ✖

  • 10182018 · 32 ✖
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
1889 1889 -73.9679319758284 40.782115480239895 20C-PM-1018-07 20C PM 10182018 7 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9679319758284 40.7821154802399)
1895 1895 -73.954699659637 40.7951308856929 38F-AM-1018-02 38F AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.954699659637 40.7951308856929)
1989 1989 -73.96316467546471 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9631646754647 40.7925716810884)
2018 2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9697924026634 40.7803611152023)
2033 2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0 cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)
2164 2164 -73.955013129397 40.7954024311542 38F-AM-1018-05 38F AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 ran up tree 0 0 0 0 0 0 0 1   POINT (-73.955013129397 40.7954024311542)
2170 2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9678923667678 40.781967562623606)
2301 2301 -73.968906907671 40.781627826784295 19C-PM-1018-07 19C PM 10182018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.968906907671 40.7816278267843)
2313 2313 -73.9646174034945 40.778128752826206 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other 1 1 0 0 0 playing? 0 0 0 0 0 0 0 0   POINT (-73.9646174034945 40.7781287528262)
2407 2407 -73.95557243517759 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9555724351776 40.7967602498249)
2422 2422 -73.9683066605832 40.7781213930544 16E-PM-1018-03 16E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9683066605832 40.7781213930544)
2444 2444 -73.966590487009 40.780246905289104 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.96659048700901 40.7802469052891)
2522 2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
2543 2543 -73.96914249979191 40.780542852496 18C-AM-1018-02 18C AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691424997919 40.780542852496)
2581 2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9635981227569 40.7928169540326)
2611 2611 -73.951448051873 40.7973951649254 42G-AM-1018-02 42G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.951448051873 40.7973951649254)
2647 2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.954499539822 40.7949716693686)
2676 2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692849074642 40.7708755098145)
2687 2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550235589287 40.7951312356844)
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9690174442945 40.7817617696508)
2772 2772 -73.9677368646039 40.782155096483706 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.96773686460392 40.782155096483706)
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9647845655965 40.7816573808695)
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2822 2822 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)
2838 2838 -73.9507699667119 40.7955166039555 40I-AM-1018-02 40I AM 10182018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9507699667119 40.795516603955505)
2897 2897 -73.9689554458632 40.777859339395704 16E-PM-1018-10 16E PM 10182018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689554458632 40.7778593393957)
2930 2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692563597762 40.770904999952)
2991 2991 -73.96846326736029 40.784890952519795 23A-AM-1018-05 23A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9684632673603 40.7848909525198)
21 21 -73.9703781726172 40.778752613032104 16C-PM-1018-03 16C PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9703781726172 40.7787526130321)
82 82 -73.96882712024009 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9688271202401 40.7809719445309)
1242 1242 -73.9714512125212 40.77602752501139 13D-PM-1018-03 13D PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714512125212 40.7760275250114)
2294 2294 -73.96308205774409 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9630820577441 40.7821632293136)

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