8 ms·
Show HN: Groundhog-day.com – structured groundhog data
Over the last year, I've worked on aggregating Groundhog data, including predictions, location, and a cute photo.
Welcome to GROUNDHOG-DAY.com: The clean and breathable, machine-readable, all-regional data source for Groundhog Day forecasts. Find your fave groundhog, peruse past predictions, or trek the continent-wide Groundhog Map.
Includes enterprise-grade API for corporate use cases.
- marymkearney 4y agoNow this is a happy thing to find. The internet just got incrementally better. There's hope for us all. :) Thank you! Having a viewport issue with the tables. "Groundhogs" runs over the right margin on desk and mobile. I can zoom it out to see the whole thing on desktop, but not mobile (zooms in but not out). My browser fonts are set to "large." Desktop, Macbook 2017, 1280px wide: https://paste.pics/2756a626c59b8c309e43fa4b7b67d16c https://paste.pics/2756a626c59b8c309e43fa4b7b67d16c Mobile, Pixel 4XL, 412px wide: https://paste.pics/e58e17c7c05b9d404f74367d3fbb6c48 https://paste.pics/e58e17c7c05b9d404f74367d3fbb6c48 Perhaps the left menu bar could be narrower (lot of horiz whitespace there)? Or the column widths could be narrower? "Predictions" table looks good on desktop, but cuts off last 2 columns on mobile. Everything else looks great. I love the map.
- jay-barronville 4y agoThis topic isn’t something I care about, but I did want to say, great work on the design — I have a thing for minimalist designs like this.
- pcraig3 4y agoThanks! It was a fun project for sure: no ads and nobody trying to get me to make it look more conventional.
- beardog 4y agoSeems long winters being the norm died in the 80s
- pcraig3 4y agoI have a pet theory on this. I think, as a local councillor/politician, you show up to a Groundhog Day event and there are like 50 people there hoping you say it's gonna be spring soon, and so you just tell them that it will be. However, it doesn't seem to be holding for this year, where most have said longer winter so far: https://groundhog-day.com/predictions/2023 https://groundhog-day.com/predictions/2023
- w-ll 4y agoI didn't know there were multiple groundhogs. Very eclectic idea.
- leipert 4y agoGreat work: I think this is missing some data crunching on past predictions. Were the predictions correct or not?
- pcraig3 4y agoAccuracy data is basically impossible to get. You have to get weather data year by year for different regions of the country and then compare them to historical ranges. It will basically mean 10x the work I've done already. It's open-source though, so it could be that someone wants to collaborate with me in future :D
- johnfn 4y agoRemarkable 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.
- pcraig3 4y agoThat'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.
- jedberg 4y agoIf I'm not mistaken, Phil's "predictions" are just written down ahead of time, while other groundhogs have to actually move towards a sign that says "early spring" or "long winter". I wonder if there is an easy way to tell which groundhog uses which method and if the groundhogs are more accurate about climate change than the humans.
- MarcScott 4y agoOne groundhog won't be reporting in - https://www.cbc.ca/news/canada/montreal/fred-la-marmotte-dies-1.6734368 https://www.cbc.ca/news/canada/montreal/fred-la-marmotte-die...
- binarymax 4y agoWhen 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
- dfxm12 4y agoThis happened last year in NJ: https://www.nj.com/news/2022/01/njs-weather-predicting-groundhog-milltown-mel-dies-before-his-big-day.html https://www.nj.com/news/2022/01/njs-weather-predicting-groun... The organizers claimed they had a replacement lined up for today, but blame an unnamed state statue for not actually being able to use them: https://www.nj.com/news/2023/01/groundhog-day-to-be-without-njs-milltown-mel-again-due-to-unforeseen-snag.html https://www.nj.com/news/2023/01/groundhog-day-to-be-without-...
- avarun 4y agonote for others confused by "statue", the organizers are blaming an unspecified state _statute_ for not being able to use their new groundhog
- deleted 4y ago[deleted]
- capableweb 4y agoDoes groundhogs not exists outside of North America (or more specifically, Canada and the US) or is the data just harder to gather?
- binarymax 4y agoReally 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?
- pcraig3 4y agoYou, 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 https://groundhog-day.com/predictions So the logic that was there didn't actually work properly, but I never noticed it before.
- simonw 4y agoMade 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 https://fedi.simonwillison.net/@simon/109796889732947452 sqlite-utils docs here: https://sqlite-utils.datasette.io/en/stable/cli.html https://sqlite-utils.datasette.io/en/stable/cli.html
- deleted 4y ago[deleted]
- eigenrick 4y agoI'm going to need to see success rating for each groundhog. How often do they correctly predict the weather? Also how often did their right or wrong predictions contradict the majority?
- pcraig3 4y ago> How often do they correctly predict the weather? I mentioned this in another comment, but accuracy data is basically impossible to get. You have to get weather data year by year for different regions of the country and then compare them to historical ranges. Means a pretty huge amount of trawling through data, not a lot of payoff. > Also how often did their right or wrong predictions contradict the majority? This one, you can get a little more easily. Check out the predictions page to see them grouped by year: https://groundhog-day.com/predictions https://groundhog-day.com/predictions If you are looking up a specific groundhog, you can see how often they align/differ from the plurality.
- willis936 4y agoNOAA's already done it. https://www.noaa.gov/stories/everyones-favorite-groundhog-predicts-6-more-weeks-of-winter https://www.noaa.gov/stories/everyones-favorite-groundhog-pr... 40% accurate, so you're better off inverting Phil's prediction, but not by much.
- well_actulily 4y agoThis is great, but I wish I could filter out all the plush animals.
- pcraig3 4y agoInteresting point, I've got a page up that is the reverse of that here: https://groundhog-day.com/alternative-groundhogs https://groundhog-day.com/alternative-groundhogs On the other hand, there is an API as well, so you can build a custom groundhog dashboard if you like.
- passwordoops 4y agoReally nice! Next level would be to see correctness of the prediction. I guess something like onset of 5 or 7-day moving average temperature above freezing for each locale
- ankaAr 4y agoWell well well, that is what I call a service. There is an API for this extremely useful data?
- pcraig3 4y agoAbsolutely: https://groundhog-day.com/api https://groundhog-day.com/api
- jedberg 4y agoIt's interesting how few groundhogs there are west of the Mississippi. I guess here out west the weather doesn't matter as much.
- camdenreslink 4y agoI live in Buffalo and I’ve never even heard of Buffalo Bert (I live 5 minutes from him apparently). Great job!
- mbo 4y agoCongratulations on the launch! I noticed however that all the image responses from the API appear to navigate to 404ing URLs :( Otherwise love the project!
- pcraig3 4y agoFixed! Thanks for pointing it out. Bath pathname.
- qwerty456127 4y agoCurious fact: In St. Petersburg, Russia, the groundhogs just died shortly before the day this year.
- Jill_the_Pill 4y agoUh-oh, so did Quebec's Fred la Marmotte. https://www.cbc.ca/news/canada/montreal/fred-la-marmotte-dies-1.6734368 https://www.cbc.ca/news/canada/montreal/fred-la-marmotte-die...
- Sakos 4y agoShould I be worried?
- qwerty456127 4y agoBoth the tragedies seem a very bad omen, don't they? I generally am not prone to superstitions but this (also given the whole mess taking place in the world during the recent years, cold gloomy weather and excess of stress this week) really feels spooky.
- Jill_the_Pill 4y agoThe good news, if you can call it that, is that both critters were presumably found dead just before Groundhog's Day, having died quietly at some time earlier in their hibernation.
- wishowee 4y agoCan you reactivate the Google form to add a groundhog? I had a pet woodchuck (Winnie the Woodchuck) who would like to contribute :) https://groundhog-day.com/add-groundhog https://groundhog-day.com/add-groundhog
- pcraig3 4y agoYes sir. Not sure how it ended up there.
- codetrotter 4y agoWait, Groundhog Day is today for real? Or is it like in the T. Hanks movie and every day is Groundhog Day?
- imbnwa 4y agoBill Murray movie, but possibly
- FearNotDaniel 4y agoInterestingly I just watched the German-dubbed version last night and my gf (native German speaker, hence the weird viewing choice) pointed out that Bill Murray actually speaks with Tom Hanks' voice (same dubbing actor).
- actionfromafar 4y agoA new DB: actor2germanvoiceactor.com "Tom Hanks and Bill Murray are the same person" was an interesting finding :-)
- pcraig3 4y agoGroundhog Day is on Feb 2nd! Depends on your timezone when the site rolls over though.
- codetrotter 4y agoWeird, when I visited the site it was already Feb 3rd in my time zone (Europe/Oslo), and the local time in my time zone was 6:15 am, but it said that it was Groundhog Day. When I visited the site again now, a few hours later but still Feb 3rd in my time zone, with the current time being 12:12 pm (middle of the day), now it says instead when the next Groundhog Day is (“364 DAYS UNTIL GROUNDHOG DAY 2024”). Not sure if it is intended exactly like that in terms of time zones or not. Regardless, cool site and it was interesting to learn a bit more about Groundhog Day. Thank you :)
- dmbche 4y agoWeird omen : Fred la marmotte, Quebec's groundhog for groundhog day, was found dead thursday morning and could not make his prediction.
- Sakos 4y agoFinally, somebody found a good use for the internet. Love the idea. Edit: The only thing I'm missing is some pictures of real groundhogs. > Includes enterprise-grade API for corporate use cases. Lmao, brilliant.
- actionfromafar 4y agoIt's good, but I kinda hoped it would be findings from the movie Groundhog Day. :-) You know, with ever more details, upper bound, lower bounds of days, confidence levels, statistical modelling, comparisons against world events that day and psychological profiles of all participants.
- pcraig3 4y agoThe pictures of real groundhogs are all there in the individual profiles, it just turns out that half of them are stuffed.