Live data from Hacker News

Show HN: Groundhog-day.com – structured groundhog data

groundhog-day.com

11–20 of 57 posts

Re: Show HN: Groundhog-day.com – structured groundhog data

#14

One groundhog won't be reporting in - https://www.cbc.ca/news/canada/montreal/fred-la-marmotte-die...

When Chekhov saw the long winter, he saw a winter bleak and dark and bereft of hope. Yet we know that winter is just another step in the cycle of life.

RIP Fred la marmotte

Re: Show HN: Groundhog-day.com – structured groundhog data

#16

Does groundhogs not exists outside of North America (or more specifically, Canada and the US) or is the data just harder to gather?

Not naturally no, according to Wikipedia. Plenty of other marmots though (like Murmeltiere in the European Alps), although I don't think those can predict the seasons.

Re: Show HN: Groundhog-day.com – structured groundhog data

#17

Really nice! I'm confused though. The placard says 'early spring' for 2023, but clicking on it, the split is 26/29 early spring vs long winter. Am I reading this wrong or is the placard wrong?

You, sir, have identified a bug. Just pushed an update to fix this.

If you look at the past 3 years, they have all been "early spring": https://groundhog-day.com/predictions

So the logic that was there didn't actually work properly, but I never noticed it before.

Re: Show HN: Groundhog-day.com – structured groundhog data

#19
post #10

Remarkable how in the 1910s and 1920s we had uninterrupted stretches of extra winters decades in a row, but now early spring dominates. Clear evidence of global warming.

That's a huge insight to take away. Nevertheless, we still have climate-denier groundhogs consistently predicting winter and being wrong about it (cough Phil cough).

Hopefully, this site helps shine a light on these unscientific groundhogs.

Re: Show HN: Groundhog-day.com – structured groundhog data

#20
Made my own map:

    brew install datasette sqlite-utils

    curl 'https://groundhog-day.com/api/v1/predictions?year=2023' | \
      jq .predictions | \
      sqlite-utils insert day.db groundhogs - --flatten

    sqlite-utils convert day.db groundhogs \
      groundhog_coordinates --multi 'return {
      "latitude": value.split(",")[0],
      "longitude": value.split(",")[1]
    }'

    datasette install datasette-cluster-map
    datasette day.db
Screenshot of the map here: https://fedi.simonwillison.net/@simon/109796889732947452

sqlite-utils docs here: https://sqlite-utils.datasette.io/en/stable/cli.html

Post reply on HN