2018_Central_Park_Squirrel_Census_-_Squirrel_Data

143 rows where Hectare Squirrel Number = 2 and Running = 1 sorted by Shift

✎ View and edit SQL

This data as json, CSV (advanced)

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
1186 1186 -73.96740331258341 40.7769132902037 15G-PM-1019-02 15G PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674033125834 40.7769132902037)
1202 1202 -73.9694979297007 40.769466740872105 7I-PM-1013-02 07I PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE Construction materials 1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9694979297007 40.7694667408721)
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9735655529245 40.7716072681474)
1370 1370 -73.9681627331154 40.7785099665602 17E-PM-1018-02 17E PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE On the rock 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9681627331154 40.7785099665602)
1426 1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664986446294 40.778308334318)
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)
1539 1539 -73.9681874036914 40.7817948690964 20C-PM-1018-02 20C PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9681874036914 40.7817948690964)
1570 1570 -73.96628648847891 40.7891062338302 28A-PM-1007-02 28A PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0 running from #3 0 0 0 0 0 0 1 0   POINT (-73.9662864884789 40.7891062338302)
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)
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)
1706 1706 -73.965215665278 40.7761309082202 15I-PM-1012-02 15I PM 10122018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.965215665278 40.7761309082202)
1731 1731 -73.9692846326638 40.7841049008492 22A-PM-1017-02 22A PM 10172018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692846326638 40.7841049008492)
1741 1741 -73.9736995552241 40.77227125186371 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9736995552241 40.7722712518637)
1749 1749 -73.97568253382991 40.7755542506699 11A-PM-1013-02 11A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756825338299 40.7755542506699)
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)
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733898487296 40.7666975131518)
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)
1909 1909 -73.9772070122251 40.7694343352509 4C-PM-1010-02 04C PM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97720701222511 40.7694343352509)
1954 1954 -73.9794840520702 40.7709595369804 4A-PM-1007-02 04A PM 10072018 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.9794840520702 40.770959536980406)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
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)
1960 1960 -73.97301589136609 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 1 0 0 0 chasing #2 0 0 0 0 0 0 0 0   POINT (-73.9730158913661 40.7701310707272)
1984 1984 -73.9739249209875 40.7768528386853 13B-PM-1008-02 13B PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9739249209875 40.7768528386853)
2029 2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687213827744 40.7843586374648)
2112 2112 -73.9655206571055 40.7764851568746 16H-PM-1014-02 16H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9655206571055 40.7764851568746)
2307 2307 -73.9736997033862 40.778497952406 14A-PM-1014-02 14A PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9736997033862 40.778497952406)
2391 2391 -73.9721497679014 40.771616019938605 8F-PM-1012-02 08F PM 10122018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9721497679014 40.7716160199386)
2394 2394 -73.97858295460459 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785829546046 40.7719652299132)
2444 2444 -73.966590487009 40.780246905289104 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.96659048700901 40.7802469052891)
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)
2557 2557 -73.97124542516791 40.7674262749891 5I-PM-1008-02 05I PM 10082018 2 Adult Black   Black+   Ground Plane FALSE crossing pavement in front of arsenal 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9712454251679 40.7674262749891)
2564 2564 -73.970996228532 40.7715540712285 9G-PM-1007-02 09G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.970996228532 40.7715540712285)
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)
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)
2688 2688 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)
2705 2705 -73.9748962681637 40.76787782717 4F-PM-1013-02 04F PM 10132018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9748962681637 40.76787782717)
2727 2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.974596903918 40.7765498215674)
2785 2785 -73.9729105002306 40.7672758037086 4H-PM-1006-02 04H PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9729105002306 40.7672758037086)
2803 2803 -73.9576652087316 40.787545797780105 29H-PM-1006-02 29H PM 10062018 2 Adult Gray   Gray+   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9576652087316 40.7875457977801)
2818 2818 -73.9681664642028 40.77246696819579 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 0 1 runs away from the ball POINT (-73.9681664642028 40.7724669681958)
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)
2904 2904 -73.97203897567171 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9720389756717 40.7763524091989)
2947 2947 -73.96012151981141 40.7909769801241 32D-PM-1006-02 32D PM 10062018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9601215198114 40.7909769801241)

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