2018_Central_Park_Squirrel_Census_-_Squirrel_Data

162 rows where Date = 10102018, Foraging = 0 and Moans = 0 sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

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
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)
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)
729 729 -73.97760445784459 40.7697607308033 4C-PM-1010-15 04C PM 10102018 15 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on tree 0 1 0 0 0 chasing #14 0 0 0 0 0 0 1 0   POINT (-73.9776044578446 40.7697607308033)
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)
860 860 -73.97135191580271 40.7798470142991 17B-AM-1010-01 17B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9713519158027 40.7798470142991)
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)
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)
1129 1129 -73.97449068326779 40.7699948746776 6E-PM-1010-05 06E PM 10102018 5 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE   0 0 0 1 0 could this squirrel be eating a white mushroom? 0 0 0 0 0 0 1 0   POINT (-73.9744906832678 40.76999487467761)
1141 1141 -73.9664669369583 40.7774085361976 16G-AM-1010-05 16G AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9664669369583 40.7774085361976)
1164 1164 -73.97902264006291 40.76989976537921 4B-AM-1010-01 04B AM 10102018 1 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9790226400629 40.7698997653792)
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)
1233 1233 -73.9722281263634 40.770408328801295 7G-AM-1010-06 07G AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722281263634 40.7704083288013)
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)
1282 1282 -73.974451175321 40.770129463526395 6E-PM-1010-04 06E PM 10102018 4 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 #3 0 0 0 0 0 0 1 0   POINT (-73.974451175321 40.7701294635264)
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)
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)
1762 1762 -73.9769106838192 40.7674414870702 2E-AM-1010-05 02E AM 10102018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 33   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9769106838192 40.7674414870702)
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)
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)
1976 1976 -73.9770920860805 40.769469804008295 4C-PM-1010-01 04C PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 0 1 0 0   0 1 0 0 0 0 1 0   POINT (-73.9770920860805 40.7694698040083)
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)
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)
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)
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree 0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.975198284551 40.7740343763399)
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)
2226 2226 -73.9624296435843 40.791320813687 31C-PM-1010-02 31C PM 10102018 2 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9624296435843 40.791320813687)
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)
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)
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)
2404 2404 -73.96653096896159 40.7775271020244 16G-AM-1010-04 16G AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9665309689616 40.7775271020244)
2474 2474 -73.97214488797658 40.7762112840981 13C-AM-1010-02 13C AM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   0 0 1 0 0 burying 0 0 0 0 0 0 1 0   POINT (-73.9721448879766 40.7762112840981)
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)
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9622050752008 40.7886373772305)
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)
2569 2569 -73.9559663734409 40.794582826137706 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9559663734409 40.7945828261377)
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)
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)
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)
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.970595860252 40.7832060751268)
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 8.886ms