2018_Central_Park_Squirrel_Census_-_Squirrel_Data

72 rows where Date = 10102018, Foraging = 1, Shift = "PM" and Tail twitches = 0 sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, 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, Eating, Kuks, Quaas, Approaches, Indifferent, Runs from

Climbing ✖

  • 0 69
  • 1 3

Tail twitches ✖

Shift ✖

Moans ✖

  • 0 72

Foraging ✖

Date ✖

  • 10102018 · 72 ✖
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
46 46 -73.9673253417305 40.7749505252981 13H-PM-1010-02 13H PM 10102018 2 Adult Gray   Gray+   Above Ground 5 tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9673253417305 40.7749505252981)
59 59 -73.9684910712272 40.776881164002106 15F-PM-1010-05 15F PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684910712272 40.7768811640021)
89 89 -73.968052057989 40.777338666528 15F-PM-1010-06 15F PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.968052057989 40.777338666528)
208 208 -73.9677646187171 40.7746492806333 13H-PM-1010-05 13H PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9677646187171 40.7746492806333)
211 211 -73.9702755805141 40.7783547795222 16D-PM-1010-13 16D PM 10102018 13 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9702755805141 40.7783547795222)
297 297 -73.9685604013735 40.7773439909065 15F-PM-1010-03 15F PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685604013735 40.7773439909065)
355 355 -73.9639635134738 40.7900337598704 29B-PM-1010-05 29B PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9639635134738 40.7900337598704)
429 429 -73.96947840566179 40.7787735291442 16D-PM-1010-01 16D PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694784056618 40.7787735291442)
514 514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 1 0 0 1   0 1 0 0 0 0 0 0   POINT (-73.9768357173861 40.7683813358343)
554 554 -73.97335194581801 40.768814796037 5G-PM-1010-03 05G PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.973351945818 40.768814796037)
563 563 -73.97003307121192 40.778291392572704 16D-PM-1010-06 16D PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 walking 0 0 0 0 0 0 0 0 checking me out POINT (-73.9700330712119 40.7782913925727)
611 611 -73.9679399097382 40.774281314995704 13H-PM-1010-09 13H PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96793990973822 40.7742813149957)
692 692 -73.9594529310985 40.7840492606552 26I-PM-1010-04 26I PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.95945293109851 40.7840492606552)
705 705 -73.9779228287629 40.7681019683859 3D-PM-1010-01 03D PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9779228287629 40.7681019683859)
739 739 -73.9620597449066 40.7922465876813 33B-PM-1010-10 33B PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 0 0 0 0   POINT (-73.9620597449066 40.7922465876813)
785 785 -73.9619417432685 40.7930365939865 33B-PM-1010-12 33B PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9619417432685 40.7930365939865)
807 807 -73.97772590224409 40.76820599079029 3D-PM-1010-10 03D PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9777259022441 40.7682059907903)
828 828 -73.9545101041865 40.790382361678205 34I-PM-1010-03 34I PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in the playground. 1 0 0 0 1 with some nuts in the mouth 0 0 0 0 0 0 0 0   POINT (-73.9545101041865 40.7903823616782)
933 933 -73.96162045695479 40.7926188605509 33B-PM-1010-01 33B PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9616204569548 40.7926188605509)
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)
990 990 -73.96296155944091 40.792417642582706 32B-PM-1010-06 32B PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9629615594409 40.7924176425827)
1127 1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9776445567926 40.768119107973)
1156 1156 -73.9688929282726 40.7768899536946 15F-PM-1010-01 15F PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9688929282726 40.7768899536946)
1158 1158 -73.97638947595429 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9763894759543 40.7705523372364)
1181 1181 -73.9690395363594 40.771128205027 9I-PM-1010-01 09I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690395363594 40.771128205027)
1277 1277 -73.9619609976132 40.7922824443528 33B-PM-1010-09 33B PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9619609976132 40.7922824443528)
1293 1293 -73.9775465365348 40.768194370787604 3D-PM-1010-09 03D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9775465365348 40.7681943707876)
1336 1336 -73.97338200536791 40.76873304735621 5G-PM-1010-05 05G PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9733820053679 40.7687330473562)
1362 1362 -73.9629184712372 40.7921410511633 32B-PM-1010-04 32B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9629184712372 40.7921410511633)
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)
1468 1468 -73.96405889194459 40.790044098464 29B-PM-1010-04 29B PM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9640588919446 40.790044098464)
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)
1532 1532 -73.97792631145721 40.7682681855369 3D-PM-1010-08 03D PM 10102018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9779263114572 40.7682681855369)
1536 1536 -73.9746128451271 40.770095704670894 6E-PM-1010-02 06E PM 10102018 2 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9746128451271 40.7700957046709)
1550 1550 -73.9698642668906 40.7784669316504 16D-PM-1010-10 16D PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9698642668906 40.7784669316504)
1567 1567 -73.97744073625871 40.7698056129554 4C-PM-1010-12 04C PM 10102018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9774407362587 40.7698056129554)
1580 1580 -73.9775079672882 40.7691500357424 4C-PM-1010-07 04C PM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775079672882 40.7691500357424)
1606 1606 -73.96289327978859 40.7923116396365 32B-PM-1010-05 32B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9628932797886 40.7923116396365)
1670 1670 -73.9682688752331 40.7711934835539 9I-PM-1010-06 09I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682688752331 40.7711934835539)
1672 1672 -73.9640989602986 40.789929543926505 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9640989602986 40.7899295439265)
1718 1718 -73.96826762377029 40.7772653590224 15F-PM-1010-04 15F PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE on path 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682676237703 40.7772653590224)
1763 1763 -73.9768286349595 40.7687012827059 3D-PM-1010-05 03D PM 10102018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9768286349595 40.7687012827059)
1827 1827 -73.97797608743551 40.769823093658296 4C-PM-1010-16 04C PM 10102018 16 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9779760874355 40.7698230936583)
1838 1838 -73.9686622009739 40.776729438050204 15F-PM-1010-02 15F PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9686622009739 40.7767294380502)
1902 1902 -73.9703314162405 40.778584776139 16D-PM-1010-12 16D PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9703314162405 40.778584776139)
1903 1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701379806066 40.7785234812393)
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)
1913 1913 -73.97746308218541 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9774630821854 40.76806266740861)
1934 1934 -73.969756965598 40.7786455091699 16D-PM-1010-02 16D PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.969756965598 40.7786455091699)
1996 1996 -73.977641787698 40.769583026578395 4C-PM-1010-10 04C PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.977641787698 40.7695830265784)
2080 2080 -73.954530253849 40.7910247489879 34I-PM-1010-07 34I PM 10102018 7 Adult Gray   Gray+         1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.954530253849 40.7910247489879)
2097 2097 -73.9773486521595 40.77084549021129 5C-PM-1010-02 05C PM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9773486521595 40.7708454902113)
2152 2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9686925781295 40.7705688673142)
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697787673802 40.7781746195436)
2315 2315 -73.9767849679735 40.768566516928 3D-PM-1010-04 03D PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767849679735 40.768566516928)
2451 2451 -73.9775865217038 40.7704928300008 5C-PM-1010-01 05C PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9775865217038 40.7704928300008)
2459 2459 -73.9679156307975 40.77452693602589 13H-PM-1010-06 13H PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9679156307975 40.7745269360259)
2468 2468 -73.9674603784345 40.7749493803168 13H-PM-1010-01 13H PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9674603784345 40.774949380316805)
2500 2500 -73.9689703880705 40.7712025611298 9I-PM-1010-02 09I PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96897038807052 40.7712025611298)
2501 2501 -73.96169441957758 40.7927250423024 33B-PM-1010-02 33B PM 10102018 2 Adult     +   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616944195776 40.7927250423024)
2523 2523 -73.9619016393127 40.792516012692104 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9619016393127 40.7925160126921)
2615 2615 -73.97346051766459 40.7686218881386 5G-PM-1010-02 05G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9734605176646 40.7686218881386)
2631 2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9690080105286 40.7710230515054)
2633 2633 -73.9776151109912 40.7694681558386 4C-PM-1010-09 04C PM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9776151109912 40.7694681558386)
2644 2644 -73.97754454411941 40.7697096533728 4C-PM-1010-13 04C PM 10102018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9775445441194 40.7697096533728)
2674 2674 -73.97710090245809 40.7688793288864 3D-PM-1010-06 03D PM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9771009024581 40.7688793288864)
2717 2717 -73.9632238528617 40.7920328991252 32B-PM-1010-02 32B PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9632238528617 40.7920328991252)
2769 2769 -73.9769885189342 40.7708936173356 5C-PM-1010-06 05C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9769885189342 40.7708936173356)
2957 2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)
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)
908 908 -73.9594120573719 40.78419457505979 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9594120573719 40.7841945750598)
1331 1331 -73.9588809150045 40.7847231576181 26I-PM-1010-01 26I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9588809150045 40.7847231576181)

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