2018_Central_Park_Squirrel_Census

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

28 rows where Age = "Juvenile" and Date = 1012 sorted by Indifferent

View and edit SQL

Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Shift, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Eating, Foraging, Kuks, Tail_flags, Tail_twitches, Indifferent, Runs_from, Latlong

Primary_Fur_Color

Date

  • 1012 · 28

Age

  • Juvenile · 28
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
8 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 1012 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2.0 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)   19 4 19 13
110 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 1012 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5.0   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.7884180156055)   19 4 19 13
771 -73.9626560807032 40.7884633049896 28D-AM-1012-05 28D AM 1012 5 Juvenile Black   Black+   Above Ground 30.0   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9626560807032 40.7884633049896)   19 4 19 13
966 -73.9733222531339 40.764997537154606 1I-PM-1012-01 01I PM 1012 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733222531339 40.7649975371546)   19 4 19 13
1054 -73.96801718943509 40.772464442631296 11I-PM-1012-07 11I PM 1012 7 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying its food into the ground 0 0 0 0 0 0 0 0   POINT (-73.9680171894351 40.7724644426313)   19 4 19 13
1182 -73.9801343393329 40.769151245340204 3A-AM-1012-01 03A AM 1012 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1.0   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9801343393329 40.7691512453402)   19 4 19 13
1350 -73.965215665278 40.7761309082202 15I-PM-1012-02 15I PM 1012 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.965215665278 40.7761309082202)   19 4 19 13
1766 -73.9736873018042 40.76491066771379 1I-PM-1012-02 01I PM 1012 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1.0 tree 0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9736873018042 40.7649106677138)   19 4 19 13
1797 -73.98020792598659 40.7678723471007 1B-AM-1012-10 01B AM 1012 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9802079259866 40.7678723471007)   19 4 19 13
2442 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 1012 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1.0   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9801902133148 40.769557595068)   19 4 19 13
3031 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 1012 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2.0 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)   19 4 19 13
3133 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 1012 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5.0   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.7884180156055)   19 4 19 13
3794 -73.9626560807032 40.7884633049896 28D-AM-1012-05 28D AM 1012 5 Juvenile Black   Black+   Above Ground 30.0   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9626560807032 40.7884633049896)   19 4 19 13
3989 -73.9733222531339 40.764997537154606 1I-PM-1012-01 01I PM 1012 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733222531339 40.7649975371546)   19 4 19 13
4077 -73.96801718943509 40.772464442631296 11I-PM-1012-07 11I PM 1012 7 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying its food into the ground 0 0 0 0 0 0 0 0   POINT (-73.9680171894351 40.7724644426313)   19 4 19 13
4205 -73.9801343393329 40.769151245340204 3A-AM-1012-01 03A AM 1012 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1.0   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9801343393329 40.7691512453402)   19 4 19 13
4373 -73.965215665278 40.7761309082202 15I-PM-1012-02 15I PM 1012 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.965215665278 40.7761309082202)   19 4 19 13
4789 -73.9736873018042 40.76491066771379 1I-PM-1012-02 01I PM 1012 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1.0 tree 0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9736873018042 40.7649106677138)   19 4 19 13
4820 -73.98020792598659 40.7678723471007 1B-AM-1012-10 01B AM 1012 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9802079259866 40.7678723471007)   19 4 19 13
5465 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 1012 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1.0   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9801902133148 40.769557595068)   19 4 19 13
427 -73.95656845779891 40.79360039404129 36F-PM-1012-02 36F PM 1012 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9565684577989 40.7936003940413)   19 4 19 13
1764 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 1012 4 Juvenile Gray White Gray+White   Above Ground 10.0 on tree trunk (descending from height of ~10 ft) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566277721581 40.7966674587803)   19 4 19 13
1944 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 1012 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)   19 4 19 13
2578 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 1012 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)   19 4 19 13
3450 -73.95656845779891 40.79360039404129 36F-PM-1012-02 36F PM 1012 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9565684577989 40.7936003940413)   19 4 19 13
4787 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 1012 4 Juvenile Gray White Gray+White   Above Ground 10.0 on tree trunk (descending from height of ~10 ft) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566277721581 40.7966674587803)   19 4 19 13
4967 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 1012 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)   19 4 19 13
5601 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 1012 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)   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 1399.841ms · Data source: NYC Open Data · About: The Squirrel Census