2018_Central_Park_Squirrel_Census_-_Squirrel_Data

149 rows where Hectare Squirrel Number = 1 and Running = 1 sorted by longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Eating ✖

  • 0 41
  • 1 8

Running ✖

Hectare Squirrel Number ✖

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
1051 1051 -73.96137470327021 40.7920483852431 33C-PM-1007-01 33C PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9613747032702 40.792048385243106)
1441 1441 -73.961335649743 40.7818876867842 23H-PM-1019-01 23H PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.961335649743 40.7818876867842)
1298 1298 -73.9612900553755 40.791291739186704 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9612900553755 40.7912917391867)
1590 1590 -73.9610388059192 40.793952935840004 34B-PM-1007-01 34B PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610388059192 40.79395293584)
2629 2629 -73.9604576237503 40.7818120101394 23I-PM-1019-01 23I PM 10192018 1 Adult Gray   Gray+   Above Ground 35   1 0 0 0 0 running (across branches) 0 0 0 0 0 0 0 0   POINT (-73.9604576237503 40.7818120101394)
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)
2469 2469 -73.9600963639087 40.7934962325313 34C-AM-1007-01 34C AM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1 dog POINT (-73.9600963639087 40.7934962325313)
2466 2466 -73.95994199262991 40.797277472881106 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599419926299 40.7972774728811)
403 403 -73.9597470659927 40.797321593541604 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9597470659927 40.7973215935416)
170 170 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)
2621 2621 -73.9596904740342 40.7897200025671 31E-AM-1014-01 31E AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9596904740342 40.7897200025671)
2609 2609 -73.95968653180941 40.7893787188526 31F-AM-1013-01 31F AM 10132018 1 Adult Gray Black Gray+Black   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9596865318094 40.7893787188526)
2143 2143 -73.9596232170232 40.7959550843229 37B-PM-1013-01 37B PM 10132018 1 Adult Gray   Gray+ Sighting was far away Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9596232170232 40.795955084322905)
1412 1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9594676326588 40.7984457363388)
746 746 -73.9591407691 40.796084690312206 37B-AM-1018-01 37B AM 10182018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9591407691 40.7960846903122)
2743 2743 -73.9587179613803 40.7992119571657 41A-PM-1007-01 41A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9587179613803 40.7992119571657)
802 802 -73.958494212554 40.7995008636057 41A-AM-1013-01 41A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 ran across a path 0 0 0 0 0 0 1 0   POINT (-73.958494212554 40.7995008636057)
2118 2118 -73.958369699409 40.79024566683321 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.958369699409 40.7902456668332)
2436 2436 -73.95827701417 40.785661023889105 28I-PM-1007-01 28I PM 10072018 1 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.95827701417 40.7856610238891)
45 45 -73.9579645940414 40.7918613498407 34F-AM-1007-01 34F AM 10072018 1 Adult Gray White Gray+White   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9579645940414 40.7918613498407)
2316 2316 -73.957697363244 40.7997576909042 42A-PM-1014-01 42A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 up on hind legs looking around 0 0 0 0 0 0 0 0 came to about 10' away then ran off POINT (-73.957697363244 40.7997576909042)
365 365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)
1171 1171 -73.9573477643797 40.797173406050895 39C-AM-1017-01 39C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9573477643797 40.7971734060509)
1284 1284 -73.95708916967759 40.793544880224104 36E-PM-1012-01 36E PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9570891696776 40.7935448802241)
706 706 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)
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)
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)
1096 1096 -73.95683008997729 40.793585574335395 36E-AM-1013-01 36E AM 10132018 1 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran into treebrush) POINT (-73.9568300899773 40.7935855743354)
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)
118 118 -73.9566346046453 40.7973923396512 40D-PM-1013-01 40D PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9566346046453 40.7973923396512)
1307 1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9565197137317 40.7986011403785)
2691 2691 -73.9564599077179 40.7965185098695 39D-PM-1012-01 39D PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9564599077179 40.7965185098695)
2678 2678 -73.95629468736941 40.7938593012595 36F-AM-1017-01 36F AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9562946873694 40.7938593012595)
2530 2530 -73.95610768244549 40.7981145780509 40D-AM-1013-01 40D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561076824455 40.7981145780509)
1308 1308 -73.95603964408441 40.7945080361909 37E-AM-1013-01 37E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9560396440844 40.7945080361909)
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)
386 386 -73.95503513809571 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550351380957 40.7974681522214)
953 953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   1 0 1 0 1   1 1 0 0 0 0 1 0   POINT (-73.9547959269955 40.7925162926273)
1689 1689 -73.9547031549299 40.797886753932204 41E-PM-1013-01 41E PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9547031549299 40.7978867539322)
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)
2758 2758 -73.95420748142959 40.79543222400039 39F-AM-1014-01 39F AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9542074814296 40.7954322240004)
193 193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9537691298752 40.7941272599797)
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9531953594918 40.7960413520131)
1945 1945 -73.9530257401736 40.795139740737 39G-PM-1013-01 39G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9530257401736 40.79513974073701)
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)
2460 2460 -73.9526681107152 40.7977012009146 42F-PM-1017-01 42F PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9526681107152 40.7977012009146)
1877 1877 -73.9524490779105 40.7936003219524 38I-AM-1019-01 38I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9524490779105 40.7936003219524)
120 120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1 begging 0 0 0 0 0 0 0 0   POINT (-73.9511118711108 40.7950813345902)
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)

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.811ms