2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Chasing = 1 and Date = 10132018 sorted by Moans

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 19

Date ✖

  • 10132018 · 19 ✖

Chasing ✖

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
1143 1143 -73.9628349778362 40.793887005205995 34A-PM-1013-03 34A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9628349778362 40.793887005206)
1167 1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593244415072 40.794964729747)
1264 1264 -73.97853537753821 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785353775382 40.7674923683184)
1267 1267 -73.9701010964667 40.768891931450796 6I-PM-1013-02 06I PM 10132018 2 Adult Black   Black+   Ground Plane FALSE Bushes 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701010964667 40.76889193145081)
1601 1601 -73.9544278270221 40.7987827316512 42D-PM-1013-02 42D PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail, Cinnamon feet Ground Plane FALSE   0 1 0 0 1 chasing (chased by #1),found a nut,buried it 0 0 0 0 0 0 1 0   POINT (-73.9544278270221 40.7987827316512)
1623 1623 -73.97701191330229 40.773294909000505 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence 1 1 0 1 1 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770119133023 40.7732949090005)
1656 1656 -73.9557399927792 40.7971563708988 40D-PM-1013-07 40D PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9557399927792 40.7971563708988)
1705 1705 -73.97654172820009 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765417282001 40.7740994735325)
1797 1797 -73.96971780962751 40.769703669630104 7I-PM-1013-07 07I PM 10132018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Under the tree 0 1 0 0 0 playing,interacting with #6 0 0 0 0 1 0 0 0   POINT (-73.9697178096275 40.769703669630104)
1872 1872 -73.9613998967903 40.7912437235667 32C-PM-1013-02 32C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9613998967903 40.7912437235667)
1971 1971 -73.9591880400132 40.795007125283604 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   1 1 0 0 1 0 1 0   POINT (-73.95918804001322 40.7950071252836)
2085 2085 -73.9690551477139 40.782368566319604 20B-PM-1013-07 20B PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9690551477139 40.7823685663196)
2225 2225 -73.95623234556741 40.7946180656349 37E-AM-1013-02 37E AM 10132018 2   Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9562323455674 40.79461806563491)
2249 2249 -73.9785709201168 40.7674391934208 2C-PM-1013-02 02C PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785709201168 40.7674391934208)
2812 2812 -73.963209639301 40.7926138443715 32A-PM-1013-07 32A PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.963209639301 40.7926138443715)
2845 2845 -73.9765016413674 40.77406728629529 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765016413674 40.7740672862953)
2855 2855 -73.9690832219322 40.782343340985996 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.96908322193221 40.782343340986)
2919 2919 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 10132018 12 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE foot of tree 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9768563402344 40.7744487310786)
2982 2982 -73.9513477815203 40.7945259614138 39I-PM-1013-02 39I PM 10132018 2 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 1 1 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9513477815203 40.7945259614138)

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