2018_Central_Park_Squirrel_Census_-_Squirrel_Data

162 rows where Date = 10102018 and Foraging = 0 sorted by Highlight Fur Color descending

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 62

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
414 414 -73.9721899838568 40.776151904565104 13C-AM-1010-03 13C AM 10102018 3 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9721899838568 40.7761519045651)
417 417 -73.9639888092327 40.791449395909 31A-AM-1010-01 31A AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9639888092327 40.791449395909005)
434 434 -73.96766397404859 40.7745369616499 13H-PM-1010-07 13H PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9676639740486 40.7745369616499)
530 530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9696360756453 40.7786545659072)
535 535 -73.9772396728545 40.7668696411765 2E-AM-1010-02 02E AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0 totally indifferent POINT (-73.9772396728545 40.7668696411765)
585 585 -73.9700148248402 40.778778019335796 16D-PM-1010-04 16D PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9700148248402 40.7787780193358)
609 609 -73.9698762023146 40.778205568811295 16D-PM-1010-09 16D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9698762023146 40.77820556881131)
623 623 -73.9662939630722 40.7878502338031 26B-AM-1010-01 26B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE running across bridle path 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9662939630722 40.7878502338031)
632 632 -73.9767314435027 40.7661199889431 1F-AM-1010-01 01F AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9767314435027 40.7661199889431)
661 661 -73.9700759073973 40.7680560871695 5I-AM-1010-01 05I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9700759073973 40.7680560871695)
671 671 -73.9709244006956 40.7676942639697 5I-AM-1010-02 05I AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9709244006956 40.7676942639697)
676 676 -73.9710207438538 40.7682187144432 5I-AM-1010-05 05I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9710207438538 40.7682187144432)
690 690 -73.9767949141123 40.774454583585 9A-PM-1010-01 09A PM 10102018 1 Adult     +   Ground Plane FALSE by large tree in sectioned off area 0 0 1 0 0 i think it climbed the tree when i first saw it. 0 0 0 0 0 0 1 0   POINT (-73.9767949141123 40.774454583585)
711 711 -73.97679809251241 40.774362775678 9A-PM-1010-02 09A PM 10102018 2 Adult     +   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767980925124 40.774362775678)
822 822 -73.9576559099012 40.7992598626483 41B-AM-1010-09 41B AM 10102018 9 Adult Gray   Gray+   Above Ground 3   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9576559099012 40.7992598626483)
923 923 -73.9578924882613 40.789806297824 32G-AM-1010-02 32G AM 10102018 2 Adult Gray   Gray+   Above Ground 13   0 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9578924882613 40.789806297824)
977 977 -73.9764601882854 40.766070446642 1F-AM-1010-05 01F AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9764601882854 40.766070446642)
988 988 -73.97870401924729 40.767901024728104 2C-AM-1010-06 02C AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 stood still & watched me then jumped on a fence and ran away 0 0 0 0 0 0 1 1   POINT (-73.9787040192473 40.7679010247281)
1038 1038 -73.9563311167069 40.79509015633371 38E-AM-1010-12 38E AM 10102018 12 Adult Cinnamon   Cinnamon+   Ground Plane FALSE running on rocks 0 1 0 0 0   0 0 0 1 0 0 0 0 runs toward something POINT (-73.9563311167069 40.7950901563337)
1084 1084 -73.96988397502491 40.778143307669204 16D-PM-1010-08 16D PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9698839750249 40.7781433076692)
1227 1227 -73.9527924755398 40.79343662605329 37I-AM-1010-04 37I AM 10102018 4 Adult Gray   Gray+   Above Ground 50 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527924755398 40.7934366260533)
1238 1238 -73.97736921314409 40.767977115014894 3D-PM-1010-02 03D PM 10102018 2 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9773692131441 40.7679771150149)
1260 1260 -73.9811585807616 40.768706748732 2A-AM-1010-06 02A AM 10102018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 1 0 0 0 chasing #5 0 0 0 0 0 0 0 0   POINT (-73.9811585807616 40.768706748732)
1357 1357 -73.96313500206341 40.791907210332 32B-PM-1010-01 32B PM 10102018 1 Juvenile Gray   Gray+   Above Ground 25 in tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9631350020634 40.791907210332)
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)
1365 1365 -73.9791648157033 40.767625444347 2C-AM-1010-04 02C AM 10102018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9791648157033 40.767625444347)
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)
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)
1645 1645 -73.9619673317128 40.7924176673037 33B-PM-1010-08 33B PM 10102018 8 Juvenile Gray   Gray+   Above Ground   running up tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9619673317128 40.7924176673037)
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)
1882 1882 -73.9541601469123 40.7907832744689 34I-PM-1010-04 34I PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE across the lawn and climb up a small tree 1 0 1 0 0 grooming 0 0 0 0 0 0 0 0   POINT (-73.9541601469123 40.79078327446891)
1890 1890 -73.97877230828071 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9787723082807 40.7713655754004)
1951 1951 -73.9548431601579 40.7906346271566 34I-PM-1010-02 34I PM 10102018 2 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9548431601579 40.7906346271566)
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)
2076 2076 -73.9712636931964 40.77998098773 17B-AM-1010-03 17B AM 10102018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9712636931964 40.77998098773)
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)
2297 2297 -73.9787771053108 40.769356212275 3B-AM-1010-07 03B AM 10102018 7 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0 together w/ #8 0 0 0 1 0 0 1 0   POINT (-73.9787771053108 40.76935621227501)
2361 2361 -73.9708032298419 40.7784265674544 15C-AM-1010-02 15C AM 10102018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0 nest building 0 0 0 0 0 0 1 0   POINT (-73.9708032298419 40.77842656745441)
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)
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)
2420 2420 -73.95877875927509 40.7981699014259 40A-AM-1010-01 40A AM 10102018 1 Juvenile Gray   Gray+   Above Ground 30 bottom of great hill 0 0 1 0 0   0 0 0 0 0 0 0 0 climbing up a tree POINT (-73.9587787592751 40.7981699014259)
2435 2435 -73.972087127535 40.776237268628 13C-AM-1010-01 13C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.972087127535 40.776237268628)
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)
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)
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)
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9752915601718 40.7739329570033)
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)
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)
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)
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)

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.762ms