2018_Central_Park_Squirrel_Census_-_Squirrel_Data

170 rows where Highlight Fur Color = "Gray" sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Tail twitches ✖

  • 0 57
  • 1 13
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
1098 1098 -73.96049542761291 40.7965682182001 37A-AM-1012-01 37A AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray Drawing included on tally sheet Ground Plane FALSE   0 0 0 0 1 scanning (drawing included) 0 0 0 0 0 0 0 1   POINT (-73.9604954276129 40.7965682182001)
290 290 -73.95606798644259 40.7947887062326 37E-PM-1006-06 37E PM 10062018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9560679864426 40.7947887062326)
2454 2454 -73.9565151662506 40.794664798744705 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 me POINT (-73.9565151662506 40.7946647987447)
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 moseying 0 0 0 0 1 1 0 0   POINT (-73.957342596188 40.7944359654227)
604 604 -73.9540908513075 40.794201225045 37G-PM-1007-04 37G PM 10072018 4   Cinnamon Gray Cinnamon+Gray gray tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540908513075 40.794201225045)
1253 1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527227282134 40.7935061484064)
1042 1042 -73.9593374341938 40.797258337802 38B-PM-1018-01 38B PM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9593374341938 40.797258337802)
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95744422055 40.7961046528557)
2060 2060 -73.9575798004084 40.795701403548996 38D-PM-1006-04 38D PM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 near drive -runners -cyclists POINT (-73.95757980040841 40.795701403549)
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9533101544112 40.7938634280159)
2608 2608 -73.95226776576591 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9522677657659 40.7934034811368)
2504 2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 0   POINT (-73.9550131837533 40.7958617258176)
2001 2001 -73.9521655419974 40.7948785497717 39H-AM-1007-04 39H AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9521655419974 40.7948785497717)
1276 1276 -73.9798005188704 40.7691868791734 3A-PM-1017-01 03A PM 10172018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97980051887042 40.7691868791734)
651 651 -73.9801661903932 40.7697950141751 3A-PM-1017-03 03A PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9801661903932 40.7697950141751)
557 557 -73.97921538931459 40.7688272492961 3B-AM-1010-01 03B AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9792153893146 40.7688272492961)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2280 2280 -73.97671436441509 40.76847569413211 3D-AM-1006-02 03D AM 10062018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25 tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767143644151 40.7684756941321)
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
493 493 -73.97768547979159 40.768310229566296 3D-AM-1006-04 03D AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (boy on bike) POINT (-73.9776854797916 40.7683102295663)
2245 2245 -73.9774228454023 40.7686399839016 3D-AM-1006-05 03D AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (chased by boy),wary of humans in playground POINT (-73.9774228454023 40.7686399839016)
2462 2462 -73.9768544488742 40.76800695009771 3D-AM-1006-07 03D AM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0 running (with food in mouth) 0 0 0 0 0 0 1 0   POINT (-73.9768544488742 40.7680069500977)
214 214 -73.97725765612441 40.767989509396294 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0 approaches (food stand) POINT (-73.9772576561244 40.7679895093963)
1891 1891 -73.9749641575871 40.767330505627704 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9749641575871 40.7673305056277)
2671 2671 -73.97433690682541 40.7675726965985 3F-AM-1006-11 03F AM 10062018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9743369068254 40.7675726965985)
2467 2467 -73.9755923256429 40.7672967972471 3F-PM-1013-02 03F PM 10132018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.97559232564292 40.7672967972471)
748 748 -73.9756603846107 40.7672531319384 3F-PM-1013-03 03F PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756603846107 40.7672531319384)
2234 2234 -73.9734741818047 40.766328451425 3H-PM-1014-03 03H PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9734741818047 40.766328451425)
1437 1437 -73.97212798086831 40.7661158663901 3I-PM-1013-02 03I PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9721279808683 40.7661158663901)
2752 2752 -73.972069937746 40.765940262783204 3I-PM-1013-04 03I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97206993774601 40.7659402627832)
2493 2493 -73.954767265558 40.7973243644491 40E-PM-1017-03 40E PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954767265558 40.7973243644491)
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)
1050 1050 -73.9562642076935 40.798333876307396 41C-AM-1017-02 41C AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9562642076935 40.7983338763074)
2746 2746 -73.95614328368629 40.798266534723396 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9561432836863 40.7982665347234)
2033 2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0 cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)
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)
1034 1034 -73.95531638295509 40.7988610926249 42D-PM-1013-04 42D PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray Light Cinnamon Ground Plane FALSE   0 0 0 0 0 carrying nut away 0 0 0 0 0 0 1 0   POINT (-73.9553163829551 40.7988610926249)
224 224 -73.9520592496349 40.797507629981105 42G-PM-1014-03 42G PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 on fence 1 0 0 0 0 prancing 0 0 0 0 0 0 0 1   POINT (-73.9520592496349 40.7975076299811)
2244 2244 -73.9509628195532 40.797777567417796 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9509628195532 40.7977775674178)
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)
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)
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)
1448 1448 -73.9772810073685 40.7693577540392 4C-PM-1010-03 04C PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772810073685 40.7693577540392)
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)
2992 2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9746063250438 40.7687654196811)
2521 2521 -73.976869549792 40.770698245472296 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree 0 0 0 0 0 relaxing 0 0 0 1 0 0 1 0   POINT (-73.976869549792 40.7706982454723)
1226 1226 -73.97684509716998 40.7709430375069 5C-PM-1010-07 05C PM 10102018 7 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 13   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97684509717 40.7709430375069)
19 19 -73.9768603630674 40.7702795904962 5C-PM-1010-09 05C PM 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.9768603630674 40.7702795904962)
625 625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.97642353733221 40.770606513989)
377 377 -73.9757001944781 40.769499790547 5E-AM-1008-09 05E AM 10082018 9 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2 went up tree 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9757001944781 40.769499790547)
1505 1505 -73.9733461334967 40.7684314285151 5G-PM-1010-01 05G PM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9733461334967 40.7684314285151)
1215 1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1266 1266 -73.9709897849823 40.768627964006 6H-AM-1008-02 06H AM 10082018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709897849823 40.768627964006)
1296 1296 -73.97055091705421 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9705509170542 40.7689416540228)
1275 1275 -73.9702541471417 40.769858423179706 7H-AM-1006-12 07H AM 10062018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9702541471417 40.7698584231797)
2938 2938 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench 0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9700264128414 40.7692014637698)
2496 2496 -73.96962742914171 40.7691980808067 7I-PM-1013-03 07I PM 10132018 3 Adult Black Gray Black+Gray   Ground Plane FALSE Trash bins 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9696274291417 40.7691980808067)
1636 1636 -73.97014086231209 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass 1 0 0 1 0   0 0 0 1 0 0 0 0   POINT (-73.9701408623121 40.7695511718541)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
1966 1966 -73.97509119964991 40.772244521017896 8C-PM-1013-06 08C PM 10132018 6   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9750911996499 40.7722445210179)
305 305 -73.9750283794865 40.772410192782104 8C-PM-1013-08 08C PM 10132018 8   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9750283794865 40.7724101927821)
1619 1619 -73.9744555348544 40.772849810635705 8D-PM-1007-03 08D PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray         0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9744555348544 40.7728498106357)
1354 1354 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9765269282059 40.7746876635248)
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)
423 423 -73.97567542977471 40.7738518843446 9B-PM-1013-02 09B PM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756754297747 40.7738518843446)
432 432 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9757787135906 40.7737231427345)
399 399 -73.97634332024009 40.773847349068106 9B-PM-1013-10 09B PM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763433202401 40.7738473490681)
937 937 -73.97063234587691 40.7713196034265 9G-PM-1007-03 09G PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706323458769 40.771319603426505)
968 968 -73.9689781843873 40.7709333833783 9I-PM-1010-04 09I PM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9689781843873 40.7709333833783)

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