2018_Central_Park_Squirrel_Census_-_Squirrel_Data

127 rows where Eating = 0, Hectare Squirrel Number = 2 and Running = 1 sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Chasing ✖

  • 0 23
  • 1 4

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
1781 1781 -73.96005650463 40.793404850298295 34C-PM-1012-02 34C PM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96005650463 40.7934048502983)
2881 2881 -73.9541629063295 40.7934259301577 37G-AM-1014-02 37G AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0 ran away & disappeared 0 0 0 0 0 0 0 0   POINT (-73.9541629063295 40.7934259301577)
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)
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)
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)
859 859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 1 0 1   POINT (-73.9600964585868 40.7952339524416)
2639 2639 -73.9543832609857 40.795355063970106 39F-AM-1014-02 39F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 rocks 1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9543832609857 40.7953550639701)
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)
819 819 -73.9603620122205 40.7955965755851 36B-AM-1013-02 36B AM 10132018 2   Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 didn't see me POINT (-73.9603620122205 40.7955965755851)
1515 1515 -73.9530326577312 40.7956922386395 39G-PM-1013-02 39G PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9530326577312 40.795692238639504)
442 442 -73.9502466289084 40.795922877988296 41I-AM-1018-02 41I AM 10182018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0 runs off POINT (-73.9502466289084 40.7959228779883)
525 525 -73.952526164386 40.796375924050395 40G-AM-1007-02 40G AM 10072018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.952526164386 40.7963759240504)
2320 2320 -73.9576897478787 40.796469532845705 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9576897478787 40.7964695328457)
1652 1652 -73.94984217462209 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9498421746221 40.7969397424182)
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
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)
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)
883 883 -73.95655337834991 40.7974368491287 40D-PM-1013-02 40D PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565533783499 40.7974368491287)
2632 2632 -73.95082755733499 40.797579073666 42H-PM-1014-02 42H PM 10142018 2 Adult Gray White Gray+White   Above Ground   Running along stone ledge 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.950827557335 40.797579073666)
438 438 -73.95257475169142 40.7977257435263 42F-PM-1017-02 42F PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.95257475169142 40.7977257435263)
1719 1719 -73.955429970986 40.797816862987496 40D-AM-1013-02 40D AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.955429970986 40.7978168629875)
1635 1635 -73.95607317386771 40.798033601855394 41D-PM-1014-02 41D PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9560731738677 40.7980336018554)
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.958535640774 40.7982737896998)
1064 1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)
2829 2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
1908 1908 -73.95883455468791 40.7991830272008 40A-PM-1014-02 40A PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from base of tree into bushes) POINT (-73.9588345546879 40.7991830272008)
2968 2968 -73.9587236619579 40.799185018043396 40A-AM-1010-02 40A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park at 108th West 1 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9587236619579 40.7991850180434)

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