2018_Central_Park_Squirrel_Census_-_Squirrel_Data

25 rows where Chasing = 1, Hectare Squirrel Number = 2 and Indifferent = 1 sorted by Shift

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches

Indifferent ✖

Hectare Squirrel Number ✖

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
234 234 -73.9741401377844 40.7758134257881 12B-AM-1007-02 12B AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9741401377844 40.7758134257881)
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615402629655 40.7924082330328)
582 582 -73.9677779408464 40.78674822113489 25A-AM-1013-02 25A AM 10132018 2   Gray   Gray+   Above Ground 15 BIG TREE 0 1 0 0 0 chasing #3 0 0 0 1 0 0 1 0   POINT (-73.9677779408464 40.7867482211349)
603 603 -73.9721592378418 40.776034583573 12C-AM-1013-02 12C AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9721592378418 40.776034583573)
747 747 -73.97714226252741 40.772361415776 7B-AM-1008-02 07B AM 10082018 2 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9771422625274 40.772361415776)
1576 1576 -73.96199851876159 40.79432777435321 34A-AM-1012-02 34A AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619985187616 40.7943277743532)
1613 1613 -73.95992022335359 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599202233536 40.7972599930224)
1955 1955 -73.9606559309874 40.7889527629826 30E-AM-1008-02 30E AM 10082018 2 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9606559309874 40.7889527629826)
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)
2200 2200 -73.96980803283041 40.7842252948542 21A-AM-1019-02 21A AM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE Tree & ground 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9698080328304 40.7842252948542)
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)
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
2490 2490 -73.9693876553956 40.7707232748402 8I-AM-1006-02 08I AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9693876553956 40.7707232748402)
2908 2908 -73.96542881512659 40.7815953970174 21E-AM-1017-02 21E AM 10172018 2 Adult Gray   Gray+   Above Ground 7   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9654288151266 40.7815953970174)
2955 2955 -73.97116665233759 40.776151305703394 13D-AM-1014-02 13D AM 10142018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9711666523376 40.7761513057034)
7 7 -73.9719735582476 40.769304513357795 6G-PM-1020-02 06G PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9719735582476 40.7693045133578)
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)
1396 1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9704677007779 40.7786860108302)
1531 1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9630381400083 40.7807571827321)
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)
1847 1847 -73.9782283921819 40.766793260207706 1D-PM-1007-02 01D PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9782283921819 40.7667932602077)
1959 1959 -73.97077370737709 40.780037346583796 17B-PM-1012-02 17B PM 10122018 2 Adult Black   Black+   Ground Plane FALSE   1 1 0 0 1 2/3 chasing each other 1 1 0 1 1 0 1 0   POINT (-73.9707737073771 40.7800373465838)
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)
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)
2670 2670 -73.95310419064691 40.7919916819219 36I-PM-1007-02 36I PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 1 1 1 0 chased birds (blue jay) POINT (-73.9531041906469 40.7919916819219)

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