2018_Central_Park_Squirrel_Census_-_Squirrel_Data

160 rows where Date = 10062018, Foraging = 0 and Tail twitches = 0 sorted by Chasing

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

Foraging ✖

Date ✖

  • 10062018 · 60 ✖
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
2063 2063 -73.95447632818859 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9544763281886 40.7969645476349)
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)
2087 2087 -73.956502663005 40.788160908881004 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.956502663005 40.788160908881)
2101 2101 -73.957600085245 40.7936111607879 35E-PM-1006-04 35E PM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.957600085245 40.7936111607879)
2103 2103 -73.9782983634755 40.766831436426294 1D-AM-1006-04 01D AM 10062018 4 Adult Gray White Gray+White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782983634755 40.7668314364263)
2120 2120 -73.9733905460282 40.7656337147768 2H-PM-1006-03 02H PM 10062018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9733905460282 40.7656337147768)
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)
2180 2180 -73.960864328605 40.7902122634639 31D-PM-1006-02 31D PM 10062018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960864328605 40.7902122634639)
2193 2193 -73.95693181052529 40.7973442139041 40C-PM-1006-07 40C PM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9569318105253 40.7973442139041)
2197 2197 -73.9672413354558 40.7838116138235 22C-PM-1006-03 22C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9672413354558 40.7838116138235)
2223 2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9784863123685 40.7669225020831)
2233 2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9754709117681 40.7681421869407)
2245 2245 -73.9774228454023 40.7686399839016 3D-AM-1006-05 03D AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (chased by boy),wary of humans in playground POINT (-73.9774228454023 40.7686399839016)
2272 2272 -73.9569670900695 40.7948792856813 37E-PM-1006-03 37E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 me POINT (-73.9569670900695 40.794879285681304)
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)
2292 2292 -73.96698919404629 40.7835635162331 22C-PM-1006-07 22C PM 10062018 7 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669891940463 40.7835635162331)
2299 2299 -73.9605554843228 40.7901473714024 31E-PM-1006-09 31E PM 10062018 9 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.9605554843228 40.7901473714024)
2368 2368 -73.9731925179247 40.7748962746181 11D-PM-1006-02 11D PM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731925179247 40.7748962746181)
2397 2397 -73.9704592500888 40.772962887933005 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704592500888 40.772962887933)
2408 2408 -73.9596949258862 40.79000794792171 31E-PM-1006-04 31E PM 10062018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9596949258862 40.7900079479217)
2457 2457 -73.9569896638974 40.7911914507504 33G-PM-1006-02 33G PM 10062018 2 Adult Gray   Gray+ my favorite Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 engaged w/ me POINT (-73.9569896638974 40.7911914507504)
2462 2462 -73.9768544488742 40.76800695009771 3D-AM-1006-07 03D AM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0 running (with food in mouth) 0 0 0 0 0 0 1 0   POINT (-73.9768544488742 40.7680069500977)
2475 2475 -73.9736489041867 40.7712143385426 7E-AM-1006-04 07E AM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE under a tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9736489041867 40.7712143385426)
2502 2502 -73.9758375334287 40.7676793289765 3E-AM-1006-06 03E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 14   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9758375334287 40.7676793289765)
2503 2503 -73.974382557804 40.7674812627373 3F-AM-1006-10 03F AM 10062018 10 Adult Cinnamon White Cinnamon+White   Above Ground 6 on fence 0 0 1 0 0   0 0 0 0 0 0 0 0 clueless POINT (-73.974382557804 40.7674812627373)
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)
2635 2635 -73.97638367403421 40.7706121151491 5C-AM-1006-06 05C AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763836740342 40.7706121151491)
2671 2671 -73.97433690682541 40.7675726965985 3F-AM-1006-11 03F AM 10062018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9743369068254 40.7675726965985)
2677 2677 -73.97348276186 40.7656171832911 2H-PM-1006-02 02H PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97348276186 40.7656171832911)
2726 2726 -73.9734206435334 40.7657854684194 2H-PM-1006-01 02H PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9734206435334 40.7657854684194)
2755 2755 -73.9712022111028 40.767250436826295 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9712022111028 40.7672504368263)
2783 2783 -73.97917671562679 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9791767156268 40.7714445258765)
2811 2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)
2814 2814 -73.9551625272308 40.791193071916 34H-PM-1006-06 34H PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE in grass 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9551625272308 40.791193071916)
2847 2847 -73.9568378330302 40.788031780276604 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568378330302 40.7880317802766)
2863 2863 -73.9698246369929 40.7711472794488 9H-AM-1006-04 09H AM 10062018 4 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.9698246369929 40.7711472794488)
2879 2879 -73.9744080700098 40.773151572182606 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile 0 0 0 1 0   0 0 0 0 0 0 0 1 (me) POINT (-73.9744080700098 40.7731515721826)
2895 2895 -73.9747873899653 40.77319452583271 9C-PM-1006-04 09C PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9747873899653 40.7731945258327)
2909 2909 -73.9564478909357 40.79769287754171 40C-PM-1006-04 40C PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9564478909357 40.7976928775417)
2911 2911 -73.9793923984874 40.770847547458295 5A-AM-1006-01 05A AM 10062018 1 Adult Gray   Gray+   Above Ground 10 Oak tree near rock outcropping 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97939239848742 40.7708475474583)
20 20 -73.9706105896967 40.769812482150705 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706105896967 40.7698124821507)
230 230 -73.97314980648721 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9731498064872 40.7659963196581)
352 352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
449 449 -73.9701335162984 40.772205101135704 10G-AM-1006-10 10G AM 10062018 10 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9701335162984 40.7722051011357)
471 471 -73.97072153948871 40.7727508149058 10G-AM-1006-05 10G AM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#6) 1 0 0 0 0 0 0 0   POINT (-73.9707215394887 40.7727508149058)
503 503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.95983407835722 40.7915857030295)
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)
1016 1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691293546408 40.77032190765491)
1172 1172 -73.9706929270645 40.77278411194239 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   0 1 0 0 0 chasing (#5) 1 0 0 0 0 0 0 0   POINT (-73.9706929270645 40.7727841119424)
1201 1201 -73.97828135384209 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.9782813538421 40.7715730368712)
1302 1302 -73.9704024529864 40.772925606388895 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 1 0 0 0 0 0 0 0   POINT (-73.9704024529864 40.7729256063889)
1535 1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
1588 1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
1815 1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
1995 1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603366992925 40.789961288953904)
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)
2298 2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2362 2362 -73.9700263936574 40.769933509858106 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #6 0 0 0 0 0 0 1 0   POINT (-73.9700263936574 40.7699335098581)
2542 2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2796 2796 -73.96310890114121 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9631089011412 40.789191946875)

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