2018_Central_Park_Squirrel_Census

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

32 rows where Hectare_Squirrel_Number = 14 sorted by Highlight_Fur_Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Hectare, Shift, Date, Age, Primary_Fur_Color, Combination_of_Primary_and_Highlight_Color, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Chasing, Climbing, Eating, Foraging, Other_Activities, Kuks, Quaas, Tail_twitches, Approaches, Indifferent, Runs_from, Latlong

Highlight_Fur_Color ✖

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
1214 1214 -73.96919687484821 40.776586299619204 14E-AM-1008-14 14E AM 1008 14 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691968748482 40.7765862996192)   19 4 19 13
2108 2108 -73.9775067398903 40.772656614240105 7B-AM-1008-14 07B AM 1008 14 Adult Gray   Gray+   Above Ground   on fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9775067398903 40.7726566142401)   19 4 19 13
2163 2163 -73.9596413903948 40.790312888902896 32E-PM-1017-14 32E PM 1017 14 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 0 1   POINT (-73.9596413903948 40.7903128889029)   19 4 19 13
2425 2425 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 1007 14 Adult Gray   Gray+   Above Ground 50.0 literally fell to ground from 50 feet up 0 0 0 0 0 falling 0 0 0 0 0 0 0 1   POINT (-73.9602808042376 40.7906130788763)   19 4 19 13
4237 4237 -73.96919687484821 40.776586299619204 14E-AM-1008-14 14E AM 1008 14 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691968748482 40.7765862996192)   19 4 19 13
5131 5131 -73.9775067398903 40.772656614240105 7B-AM-1008-14 07B AM 1008 14 Adult Gray   Gray+   Above Ground   on fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9775067398903 40.7726566142401)   19 4 19 13
5186 5186 -73.9596413903948 40.790312888902896 32E-PM-1017-14 32E PM 1017 14 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 0 1   POINT (-73.9596413903948 40.7903128889029)   19 4 19 13
5448 5448 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 1007 14 Adult Gray   Gray+   Above Ground 50.0 literally fell to ground from 50 feet up 0 0 0 0 0 falling 0 0 0 0 0 0 0 1   POINT (-73.9602808042376 40.7906130788763)   19 4 19 13
401 401 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 1008 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9726090882487 40.7710199108849)   19 4 19 13
871 871 -73.98054238861499 40.768204880479395 1B-AM-1012-14 01B AM 1012 14   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980542388615 40.7682048804794)   19 4 19 13
892 892 -73.97736964550309 40.7687241866704 3D-PM-1010-14 03D PM 1010 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10.0   0 0 0 0 0 crying out 1 1 0 0 0 0 0 0   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
1707 1707 -73.97063044050999 40.77710605948079 14D-PM-1019-14 14D PM 1019 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97063044051 40.7771060594808)   19 4 19 13
3424 3424 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 1008 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9726090882487 40.7710199108849)   19 4 19 13
3894 3894 -73.98054238861499 40.768204880479395 1B-AM-1012-14 01B AM 1012 14   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980542388615 40.7682048804794)   19 4 19 13
3915 3915 -73.97736964550309 40.7687241866704 3D-PM-1010-14 03D PM 1010 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10.0   0 0 0 0 0 crying out 1 1 0 0 0 0 0 0   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
4730 4730 -73.97063044050999 40.77710605948079 14D-PM-1019-14 14D PM 1019 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97063044051 40.7771060594808)   19 4 19 13
202 202 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 1007 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
929 929 -73.97083718064292 40.7764813666684 14D-AM-1014-14 14D AM 1014 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708371806429 40.7764813666684)   19 4 19 13
3225 3225 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 1007 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
3952 3952 -73.97083718064292 40.7764813666684 14D-AM-1014-14 14D AM 1014 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708371806429 40.7764813666684)   19 4 19 13
888 888 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 1018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
1321 1321 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 1006 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
1862 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
3911 3911 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 1018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
4344 4344 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 1006 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
4885 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
1243 1243 -73.97720265726741 40.7691598773017 4D-PM-1008-14 04D PM 1008 14 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.9772026572674 40.7691598773017)   19 4 19 13
4266 4266 -73.97720265726741 40.7691598773017 4D-PM-1008-14 04D PM 1008 14 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.9772026572674 40.7691598773017)   19 4 19 13
1166 1166 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 1006 14 Adult Gray White Gray+White   Above Ground 12.0   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)   19 4 19 13
2064 2064 -73.9646023053207 40.7810680044024 20F-PM-1007-14 20F PM 1007 14 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9646023053207 40.7810680044024)   19 4 19 13
4189 4189 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 1006 14 Adult Gray White Gray+White   Above Ground 12.0   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)   19 4 19 13
5087 5087 -73.9646023053207 40.7810680044024 20F-PM-1007-14 20F PM 1007 14 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9646023053207 40.7810680044024)   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 1031.25ms · Data source: NYC Open Data · About: The Squirrel Census