Show HN: Groundhog-day.com – structured groundhog data
11–20 of 57 posts
Re: Show HN: Groundhog-day.com – structured groundhog data
#12Re: Show HN: Groundhog-day.com – structured groundhog data
#13I'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?
Re: Show HN: Groundhog-day.com – structured groundhog data
#14One groundhog won't be reporting in - https://www.cbc.ca/news/canada/montreal/fred-la-marmotte-die...
RIP Fred la marmotte
Re: Show HN: Groundhog-day.com – structured groundhog data
#15I didn't know there were multiple groundhogs. Very eclectic idea.
Re: Show HN: Groundhog-day.com – structured groundhog data
#16Does groundhogs not exists outside of North America (or more specifically, Canada and the US) or is the data just harder to gather?
Re: Show HN: Groundhog-day.com – structured groundhog data
#17Really 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?
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
#18Does groundhogs not exists outside of North America (or more specifically, Canada and the US) or is the data just harder to gather?
Re: Show HN: Groundhog-day.com – structured groundhog data
#19Remarkable 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.
Hopefully, this site helps shine a light on these unscientific groundhogs.
Re: Show HN: Groundhog-day.com – structured groundhog data
#20 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/109796889732947452sqlite-utils docs here: https://sqlite-utils.datasette.io/en/stable/cli.html