2018_Central_Park_Squirrel_Census

Data source: NYC Open Data · About: The Squirrel Census

46 rows where Hectare_Squirrel_Number = 13

View and edit SQL

Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Hectare, Shift, Date, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Climbing, Eating, Foraging, Other_Activities, Tail_twitches, Approaches, Indifferent, Latlong

Highlight_Fur_Color

Primary_Fur_Color

Runs_from

  • 0 44
  • 1 2

Age

Hectare_Squirrel_Number

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 Latlong Zip_Codes Community_Districts Borough_Boundaries City_Council_Districts Police_Precincts
74 -73.9703169373939 40.770065882385396 7H-AM-1006-13 07H AM 1006 13 Adult Gray   Gray+   Above Ground 10.0   1 0 0 0 0 running (up tree) 0 0 0 0 0 0 1 0   POINT (-73.9703169373939 40.7700658823854)   19 4 19 13
211 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 1006 13 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9755041276839 40.7678213857557)   19 4 19 13
325 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 1017 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705837974358 40.7758494849673)   19 4 19 13
579 -73.9708225719705 40.7772497804149 14D-PM-1019-13 14D PM 1019 13 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708225719705 40.7772497804149)   19 4 19 13
732 -73.9528682507794 40.792580780830704 36I-PM-1007-13 36I PM 1007 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9528682507794 40.7925807808307)   19 4 19 13
770 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 1007 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700066659086 40.7744028820163)   19 4 19 13
874 -73.9692946938852 40.7767389791452 14E-AM-1008-13 14E AM 1008 13 Adult Gray   Gray+   Above Ground 1.0   0 0 1 1 1   0 0 0 0 0 0 1 0 curious POINT (-73.9692946938852 40.7767389791452)   19 4 19 13
1118 -73.97754454411941 40.7697096533728 4C-PM-1010-13 04C PM 1010 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)   19 4 19 13
1238 -73.95950023395079 40.7903365788694 32E-PM-1017-13 32E PM 1017 13 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9595002339508 40.7903365788694)   19 4 19 13
1332 -73.96501200660741 40.7805932882407 20F-PM-1007-13 20F PM 1007 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10.0   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9650120066074 40.7805932882407)   19 4 19 13
1340 -73.9709407456459 40.776423522087 14D-AM-1014-13 14D AM 1014 13 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709407456459 40.776423522087)   19 4 19 13
1357 -73.9669782832746 40.7841166727168 22C-PM-1006-13 22C PM 1006 13 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669782832746 40.7841166727168)   19 4 19 13
1444 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 1010 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)   19 4 19 13
1488 -73.9702755805141 40.7783547795222 16D-PM-1010-13 16D PM 1010 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)   19 4 19 13
1490 -73.9803895322385 40.7680730789944 1B-AM-1012-13 01B AM 1012 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9803895322385 40.7680730789944)   19 4 19 13
1525 -73.959127912788 40.79211971304029 33E-AM-1014-13 33E AM 1014 13 Adult Black Cinnamon Black+Cinnamon Cinnamon on the tail Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.959127912788 40.7921197130403)   19 4 19 13
1564 -73.9616770335086 40.792164863109605 32C-PM-1013-13 32C PM 1013 13 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 buried nut 0 0 0 0 1 0 0 0   POINT (-73.9616770335086 40.7921648631096)   19 4 19 13
1683 -73.9712256765283 40.776094287248796 13D-PM-1018-13 13D PM 1018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9712256765283 40.7760942872488)   19 4 19 13
1855 -73.9763243383771 40.770540931570295 5C-PM-1010-13 05C PM 1010 13 Adult Gray White Gray+White   Above Ground 20.0 way up a tree! 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9763243383771 40.7705409315703)   19 4 19 13
2110 -73.95959331954091 40.7905847332369 32E-AM-1007-13 32E AM 1007 13 Adult Gray   Gray+   Above Ground 50.0   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9595933195409 40.7905847332369)   19 4 19 13
2241 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 1008 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772691210241 40.7690960712994)   19 4 19 13
2795 -73.97733615807921 40.7729478226715 7B-AM-1008-13 07B AM 1008 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773361580792 40.7729478226715)   19 4 19 13
2932 -73.97294104880208 40.770948496457706 7F-AM-1008-13 07F AM 1008 13 Adult Gray   Gray+   Above Ground 4.0 to tree 1 0 0 1 1 ran up tree 4 feet and ate leaves 0 0 0 0 0 0 1 0   POINT (-73.9729410488021 40.7709484964577)   19 4 19 13
3097 -73.9703169373939 40.770065882385396 7H-AM-1006-13 07H AM 1006 13 Adult Gray   Gray+   Above Ground 10.0   1 0 0 0 0 running (up tree) 0 0 0 0 0 0 1 0   POINT (-73.9703169373939 40.7700658823854)   19 4 19 13
3234 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 1006 13 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9755041276839 40.7678213857557)   19 4 19 13
3348 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 1017 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705837974358 40.7758494849673)   19 4 19 13
3602 -73.9708225719705 40.7772497804149 14D-PM-1019-13 14D PM 1019 13 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708225719705 40.7772497804149)   19 4 19 13
3755 -73.9528682507794 40.792580780830704 36I-PM-1007-13 36I PM 1007 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9528682507794 40.7925807808307)   19 4 19 13
3793 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 1007 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700066659086 40.7744028820163)   19 4 19 13
3897 -73.9692946938852 40.7767389791452 14E-AM-1008-13 14E AM 1008 13 Adult Gray   Gray+   Above Ground 1.0   0 0 1 1 1   0 0 0 0 0 0 1 0 curious POINT (-73.9692946938852 40.7767389791452)   19 4 19 13
4141 -73.97754454411941 40.7697096533728 4C-PM-1010-13 04C PM 1010 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)   19 4 19 13
4261 -73.95950023395079 40.7903365788694 32E-PM-1017-13 32E PM 1017 13 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9595002339508 40.7903365788694)   19 4 19 13
4355 -73.96501200660741 40.7805932882407 20F-PM-1007-13 20F PM 1007 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10.0   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9650120066074 40.7805932882407)   19 4 19 13
4363 -73.9709407456459 40.776423522087 14D-AM-1014-13 14D AM 1014 13 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709407456459 40.776423522087)   19 4 19 13
4380 -73.9669782832746 40.7841166727168 22C-PM-1006-13 22C PM 1006 13 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669782832746 40.7841166727168)   19 4 19 13
4467 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 1010 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)   19 4 19 13
4511 -73.9702755805141 40.7783547795222 16D-PM-1010-13 16D PM 1010 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)   19 4 19 13
4513 -73.9803895322385 40.7680730789944 1B-AM-1012-13 01B AM 1012 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9803895322385 40.7680730789944)   19 4 19 13
4548 -73.959127912788 40.79211971304029 33E-AM-1014-13 33E AM 1014 13 Adult Black Cinnamon Black+Cinnamon Cinnamon on the tail Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.959127912788 40.7921197130403)   19 4 19 13
4587 -73.9616770335086 40.792164863109605 32C-PM-1013-13 32C PM 1013 13 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 buried nut 0 0 0 0 1 0 0 0   POINT (-73.9616770335086 40.7921648631096)   19 4 19 13
4706 -73.9712256765283 40.776094287248796 13D-PM-1018-13 13D PM 1018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9712256765283 40.7760942872488)   19 4 19 13
4878 -73.9763243383771 40.770540931570295 5C-PM-1010-13 05C PM 1010 13 Adult Gray White Gray+White   Above Ground 20.0 way up a tree! 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9763243383771 40.7705409315703)   19 4 19 13
5133 -73.95959331954091 40.7905847332369 32E-AM-1007-13 32E AM 1007 13 Adult Gray   Gray+   Above Ground 50.0   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9595933195409 40.7905847332369)   19 4 19 13
5264 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 1008 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772691210241 40.7690960712994)   19 4 19 13
5818 -73.97733615807921 40.7729478226715 7B-AM-1008-13 07B AM 1008 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773361580792 40.7729478226715)   19 4 19 13
5955 -73.97294104880208 40.770948496457706 7F-AM-1008-13 07F AM 1008 13 Adult Gray   Gray+   Above Ground 4.0 to tree 1 0 0 1 1 ran up tree 4 feet and ate leaves 0 0 0 0 0 0 1 0   POINT (-73.9729410488021 40.7709484964577)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "2018_Central_Park_Squirrel_Census" (
"Longitude" REAL,
  "Latitude" REAL,
  "Unique_Squirrel_ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare_Squirrel_Number" INTEGER,
  "Age" REAL,
  "Primary_Fur_Color" REAL,
  "Highlight_Fur_Color" REAL,
  "Combination_of_Primary_and_Highlight_Color" TEXT,
  "Color_notes" REAL,
  "Location" REAL,
  "Above_Ground_Sighter_Measurement" REAL,
  "Specific_Location" REAL,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other_Activities" REAL,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail_flags" INTEGER,
  "Tail_twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs_from" INTEGER,
  "Other_Interactions" REAL,
  "Latlong" TEXT,
  "Zip_Codes" REAL,
  "Community_Districts" INTEGER,
  "Borough_Boundaries" INTEGER,
  "City_Council_Districts" INTEGER,
  "Police_Precincts" INTEGER
)
Powered by Datasette · Query took 898.941ms · Data source: NYC Open Data · About: The Squirrel Census