2018_Central_Park_Squirrel_Census

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

52 rows where Age = "Juvenile" and Highlight_Fur_Color = "Gray" sorted by Combination_of_Primary_and_Highlight_Color

View and edit SQL

Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Hectare, Shift, Date, Hectare_Squirrel_Number, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Chasing, Climbing, Eating, Foraging, Other_Activities, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Other_Interactions, Latlong

Primary_Fur_Color

Highlight_Fur_Color

  • Gray · 52

Age

  • Juvenile · 52
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
128 -73.97567542977471 40.7738518843446 9B-PM-1013-02 09B PM 1013 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)   19 4 19 13
200 -73.96704295859901 40.778437071937105 17F-AM-1007-05 17F AM 1007 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.967042958599 40.7784370719371)   19 4 19 13
205 -73.96795381633409 40.7837103696906 22C-AM-1013-03 22C AM 1013 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1 eating (mushroom) 0 0 0 0 0 0 0 1   POINT (-73.9679538163341 40.7837103696906)   19 4 19 13
214 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 1007 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3.0   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)   19 4 19 13
276 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 1008 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9658867660358 40.7756523577509)   19 4 19 13
396 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 1006 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)   19 4 19 13
503 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 1013 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)   19 4 19 13
594 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 1007 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9528482858163 40.7922056218325)   19 4 19 13
785 -73.9541500874008 40.7920329989756 35H-AM-1013-02 35H AM 1013 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10.0 Sitting on tree limb 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0 watching me from tree,but calm POINT (-73.9541500874008 40.7920329989756)   19 4 19 13
812 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 1006 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10.0 on tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9675472064204 40.7835947167436)   19 4 19 13
1047 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 1013 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)   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
1346 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 1008 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20.0 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.7745309794155)   19 4 19 13
1457 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 1013 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)   19 4 19 13
1579 -73.97433690682541 40.7675726965985 3F-AM-1006-11 03F AM 1006 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)   19 4 19 13
1862 -73.9775099290913 40.76976090631371 4C-PM-1010-14 04C PM 1010 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)   19 4 19 13
1910 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 1008 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9.0 tree hollow 0 0 0 0 0 in hollow 0 0 0 0 0 0 0 0 curious POINT (-73.9645547556826 40.776877007081)   19 4 19 13
1964 -73.952526164386 40.796375924050395 40G-AM-1007-02 40G AM 1007 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18.0   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.952526164386 40.7963759240504)   19 4 19 13
2057 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 1013 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)   19 4 19 13
2168 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 1006 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.7684035996758)   19 4 19 13
2269 -73.97634332024009 40.773847349068106 9B-PM-1013-10 09B PM 1013 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12.0   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763433202401 40.7738473490681)   19 4 19 13
2558 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 1007 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3.0   0 0 1 0 0   0 0 0 0 0 0 0 1 me! POINT (-73.9527196716568 40.792363826828)   19 4 19 13
2653 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 1018 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)   19 4 19 13
2656 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 1018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9645437409662 40.7811599933331)   19 4 19 13
2731 -73.9678561384348 40.77828773978221 16E-PM-1018-02 16E PM 1018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 0 0 gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
2835 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 1013 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)   19 4 19 13
3151 -73.97567542977471 40.7738518843446 9B-PM-1013-02 09B PM 1013 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)   19 4 19 13
3223 -73.96704295859901 40.778437071937105 17F-AM-1007-05 17F AM 1007 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.967042958599 40.7784370719371)   19 4 19 13
3228 -73.96795381633409 40.7837103696906 22C-AM-1013-03 22C AM 1013 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1 eating (mushroom) 0 0 0 0 0 0 0 1   POINT (-73.9679538163341 40.7837103696906)   19 4 19 13
3237 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 1007 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3.0   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)   19 4 19 13
3299 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 1008 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9658867660358 40.7756523577509)   19 4 19 13
3419 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 1006 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)   19 4 19 13
3526 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 1013 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)   19 4 19 13
3617 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 1007 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9528482858163 40.7922056218325)   19 4 19 13
3808 -73.9541500874008 40.7920329989756 35H-AM-1013-02 35H AM 1013 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10.0 Sitting on tree limb 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0 watching me from tree,but calm POINT (-73.9541500874008 40.7920329989756)   19 4 19 13
3835 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 1006 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10.0 on tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9675472064204 40.7835947167436)   19 4 19 13
4070 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 1013 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)   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
4369 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 1008 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20.0 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.7745309794155)   19 4 19 13
4480 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 1013 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)   19 4 19 13
4602 -73.97433690682541 40.7675726965985 3F-AM-1006-11 03F AM 1006 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)   19 4 19 13
4885 -73.9775099290913 40.76976090631371 4C-PM-1010-14 04C PM 1010 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)   19 4 19 13
4933 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 1008 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9.0 tree hollow 0 0 0 0 0 in hollow 0 0 0 0 0 0 0 0 curious POINT (-73.9645547556826 40.776877007081)   19 4 19 13
4987 -73.952526164386 40.796375924050395 40G-AM-1007-02 40G AM 1007 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18.0   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.952526164386 40.7963759240504)   19 4 19 13
5080 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 1013 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)   19 4 19 13
5191 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 1006 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.7684035996758)   19 4 19 13
5292 -73.97634332024009 40.773847349068106 9B-PM-1013-10 09B PM 1013 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12.0   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763433202401 40.7738473490681)   19 4 19 13
5581 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 1007 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3.0   0 0 1 0 0   0 0 0 0 0 0 0 1 me! POINT (-73.9527196716568 40.792363826828)   19 4 19 13
5676 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 1018 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)   19 4 19 13
5679 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 1018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9645437409662 40.7811599933331)   19 4 19 13
5754 -73.9678561384348 40.77828773978221 16E-PM-1018-02 16E PM 1018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 0 0 gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
5858 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 1013 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)   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 900.232ms · Data source: NYC Open Data · About: The Squirrel Census