2018_Central_Park_Squirrel_Census_-_Squirrel_Data

162 rows where Date = 10102018 and Foraging = 0 sorted by Climbing descending

✎ View and edit SQL

This data as json, CSV (advanced)

Foraging ✖

Date ✖

  • 10102018 · 62 ✖
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
1333 1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0 laying on tree branch 0 0 0 1 1 0 0 0   POINT (-73.9754527701832 40.7656088463928)
1361 1361 -73.961934398055 40.79247895485221 33B-PM-1010-07 33B PM 10102018 7 Adult     +   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.961934398055 40.7924789548522)
1406 1406 -73.97462048022209 40.769929484073295 6E-PM-1010-01 06E PM 10102018 1 Juvenile     +   Ground Plane FALSE along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail 0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9746204802221 40.7699294840733)
1414 1414 -73.9580513096783 40.79909641532 41B-AM-1010-02 41B AM 10102018 2 Adult Gray White Gray+White   Above Ground 16   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9580513096783 40.79909641532)
1436 1436 -73.97667795856859 40.7669673778105 2E-AM-1010-04 02E AM 10102018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   1 0 0 0 0 0 1 0   POINT (-73.9766779585686 40.7669673778105)
1511 1511 -73.9721642509914 40.7701179390078 7G-AM-1010-01 07G AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9721642509914 40.7701179390078)
1548 1548 -73.9790044506465 40.7689469479245 3B-AM-1010-03 03B AM 10102018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0 chasing #2 0 0 0 0 0 0 0 1   POINT (-73.9790044506465 40.7689469479245)
1643 1643 -73.95305356247809 40.7929809144271 37I-AM-1010-02 37I AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9530535624781 40.7929809144271)
1662 1662 -73.95616002372842 40.7953143196705 38E-AM-1010-10 38E AM 10102018 10 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 over a log across stream 0 0 0 0 0 chillin' 0 0 0 0 0 0 0 1 runs from leaf blower POINT (-73.9561600237284 40.7953143196705)
1734 1734 -73.9524132295658 40.7933777553406 37I-AM-1010-05 37I AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.95241322956582 40.7933777553406)
1740 1740 -73.95777581255179 40.799384716477 41B-AM-1010-10 41B AM 10102018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9577758125518 40.799384716477)
1768 1768 -73.97736964550309 40.7687241866704 3D-PM-1010-14 03D PM 10102018 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 crying out 1 1 0 0 0 0 0 0   POINT (-73.9773696455031 40.7687241866704)
1773 1773 -73.9611126813593 40.7943113021522 35B-AM-1010-03 35B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611126813593 40.7943113021522)
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 1 0 0 0 chasing squirrel #6 1 1 0 0 1 0 0 0   POINT (-73.978844141973 40.7696046074378)
1814 1814 -73.97223594012421 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9722359401242 40.7702891474555)
1822 1822 -73.9775099290913 40.76976090631371 4C-PM-1010-14 04C PM 10102018 14 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 1 0 0 0 chasing #15 0 0 0 0 0 0 0 0   POINT (-73.9775099290913 40.7697609063137)
1824 1824 -73.9617250054003 40.7925390432044 33B-PM-1010-03 33B PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9617250054003 40.7925390432044)
1829 1829 -73.9746965894947 40.766435172430896 2G-AM-1010-03 02G AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9746965894947 40.7664351724309)
1881 1881 -73.9674984567017 40.7745938268705 13H-PM-1010-04 13H PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9674984567017 40.7745938268705)
2007 2007 -73.9684834138222 40.772428912021105 11H-AM-1010-06 11H AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9684834138222 40.7724289120211)
2025 2025 -73.97665418790059 40.7674077265375 2E-AM-1010-06 02E AM 10102018 6 Adult Cinnamon   Cinnamon+   Above Ground 35   0 0 0 0 0 leaping branch to branch 0 0 0 0 0 0 1 0   POINT (-73.9766541879006 40.7674077265375)
2038 2038 -73.98035621370491 40.7685780990634 2B-AM-1010-02 02B AM 10102018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9803562137049 40.7685780990634)
2062 2062 -73.9618173092433 40.7925800181543 33B-PM-1010-04 33B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618173092433 40.7925800181543)
2107 2107 -73.9772624834791 40.769282191854295 4C-PM-1010-05 04C PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9772624834791 40.7692821918543)
2136 2136 -73.97218979152109 40.7660434203132 3I-AM-1010-02 03I AM 10102018 2 Adult Gray   Gray+   Above Ground 40   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9721897915211 40.76604342031321)
2172 2172 -73.9642900903774 40.791701716884205 31A-AM-1010-03 31A AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9642900903774 40.7917017168842)
2219 2219 -73.9709242364673 40.7684217215595 5I-AM-1010-04 05I AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9709242364673 40.7684217215595)
2229 2229 -73.9620719414292 40.788637452988 29D-PM-1010-02 29D PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9620719414292 40.788637452988)
2235 2235 -73.9748522796455 40.771958662100296 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9748522796455 40.7719586621003)
2247 2247 -73.95595201371721 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #7 0 0 0 0 1 0 1 0   POINT (-73.95595201371721 40.7950536287174)
2256 2256 -73.9720050204318 40.769941909416794 7G-AM-1010-03 07G AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9720050204318 40.7699419094168)
2319 2319 -73.97568707891871 40.773364678267896 9B-AM-1010-09 09B AM 10102018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 food in mouth 0 0 0 0 0 0 0 0   POINT (-73.9756870789187 40.7733646782679)
2379 2379 -73.97118651343641 40.7785039981892 15C-AM-1010-03 15C AM 10102018 3 Adult Gray   Gray+   Above Ground 6   0 0 0 1 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9711865134364 40.7785039981892)
2385 2385 -73.9787552947847 40.7690779628762 3B-AM-1010-06 03B AM 10102018 6 Adult Gray   Gray+   Above Ground 20   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9787552947847 40.7690779628762)
2386 2386 -73.95657388959721 40.7900160952624 32H-AM-1010-01 32H AM 10102018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 not sure; walking-stop-walking-stop 0 0 0 0 0 0 1 0 did seem to observe me for a moment POINT (-73.9565738895972 40.7900160952624)
2392 2392 -73.9578981223015 40.798996775435796 41B-AM-1010-03 41B AM 10102018 3 Adult     +   Above Ground 60   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9578981223015 40.7989967754358)
2426 2426 -73.9790203973636 40.768883711483205 3B-AM-1010-02 03B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 together w/ #3 0 0 0 0 0 0 0 1   POINT (-73.9790203973636 40.7688837114832)
2476 2476 -73.9710843362124 40.7679739601336 5I-AM-1010-03 05I AM 10102018 3 Adult Gray   Gray+   Above Ground 3   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710843362124 40.7679739601336)
2533 2533 -73.9766195697096 40.766190726154704 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9766195697096 40.7661907261547)
2570 2570 -73.9721064150173 40.7667053821991 3I-AM-1010-01 03I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9721064150173 40.7667053821991)
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9810149147578 40.7683925377714)
2575 2575 -73.97357533521291 40.7687061447032 5G-PM-1010-04 05G PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9735753352129 40.7687061447032)
2578 2578 -73.97653869653709 40.766371971272996 1F-AM-1010-02 01F AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765386965371 40.766371971273)
2614 2614 -73.9765877920583 40.7660946071574 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765877920583 40.7660946071574)
2620 2620 -73.97718000981308 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9771800098131 40.7708863131336)
2628 2628 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 10102018 13 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9770439076963 40.7685720141731)
2640 2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   1 0 0 0 0 running from squirrel #5 0 0 0 0 0 0 0 0   POINT (-73.9788304714091 40.7696373635315)
2735 2735 -73.97680969536471 40.7708185213129 5C-PM-1010-08 05C PM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9768096953647 40.7708185213129)
2739 2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9681960138614 40.7726867422002)
2780 2780 -73.9700634278 40.778422372245295 16D-PM-1010-07 16D PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9700634278 40.7784223722453)
2781 2781 -73.9752673884392 40.7662642413761 2G-AM-1010-04 02G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9752673884392 40.7662642413761)
2797 2797 -73.95769134926691 40.7994216061391 41B-AM-1010-11 41B AM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 1 0 eating a mushroom! 0 0 0 0 0 0 1 0   POINT (-73.9576913492669 40.7994216061391)
2799 2799 -73.96826273820729 40.773076674345205 11H-AM-1010-09 11H AM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9682627382073 40.7730766743452)
2807 2807 -73.9618213644671 40.792764881973795 33B-AM-1010-02 33B AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.96182136446711 40.7927648819738)
2889 2889 -73.9771646835311 40.769304916508396 4C-PM-1010-05 04C PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9771646835311 40.7693049165084)
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
2914 2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9722053355548 40.7662094993614)
2939 2939 -73.9680204438195 40.774388232265395 13H-PM-1010-08 13H PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9680204438195 40.77438823226541)
2946 2946 -73.974515099169 40.770065079988605 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.974515099169 40.770065079988605)
2970 2970 -73.9619019299709 40.7924476439693 33B-PM-1010-05 33B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619019299709 40.7924476439693)
3006 3006 -73.97443902173859 40.7663168362582 2G-AM-1010-02 02G AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9744390217386 40.7663168362582)
3022 3022 -73.9639941227864 40.7899152327912 29B-PM-1010-02 29B PM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9639941227864 40.7899152327912)

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