1 Millionth Beer

Talk Discussion in 'BeerAdvocate Talk' started by cyclonece09, Jan 2, 2026.

  1. cyclonece09

    cyclonece09 Grand Pooh-Bah (3,559) Aug 5, 2008 Wisconsin
    BA4LYFE Society Pooh-Bah

    Ok, so a bit of nerdy talk. I have added a couple of beers today, and noticed that it seems that the beer number in the URL seems to just go up by 1 as beers are added. If my observation is correct (@Todd will have to confirm this), we are currently at 775,000+ beers in the data base. My question is based on number of beers being added per year, when is a good projection when that will hit 1 million. 26, 27, 28??? Just nerdy thought on when this might happen. And when we get close, what beer will put us over the top.
     
    skivtjerry, jjamadorphd, DCH and 35 others like this.
  2. BillAfromSoCal

    BillAfromSoCal Pooh-Bah (2,415) Aug 24, 2020 California
    Society Pooh-Bah

    Oh crud… I have only reviewed about 540 of those. I better get busy…
     
  3. heymikew

    heymikew Pooh-Bah (2,685) Mar 18, 2011 California
    BA4LYFE Society Pooh-Bah

    There should be a prize for whomever adds the millionth.
     
  4. REVZEB

    REVZEB Grand High Pooh-Bah (7,686) Mar 28, 2013 Illinois
    BA4LYFE Society Pooh-Bah Trader

    Countdown clock?
     
  5. chrisjws

    chrisjws Grand Pooh-Bah (3,302) Dec 3, 2014 California
    Pooh-Bah Trader

    New brewery just opened near me. Guess I'm gonna go add theirs to do my part?
     
  6. PapaGoose03

    PapaGoose03 Grand High Pooh-Bah (6,057) May 30, 2005 Michigan
    BA4LYFE Society Pooh-Bah

    Somebody has to do the rough math and arrive at a projection, so it might as well be me.

    This site has been around since 1996 so it just finished the 29th year. If we're at 775,000 beers now, that means 26,724 have been added on average per year.

    To reach 1,000,000 we need another 225,000 so dividing that by the 26,724 means that we'd reach that 1,000,000 goal in 8.4 years. Adding that to 2025 gets us to sometime around April, 2033. (All that math assumes that the new beer additions would continue to occur at an average rate of 26,724 beers per year.)

    The math is done. :slight_smile:
     
  7. sulldaddy

    sulldaddy Grand Pooh-Bah (5,716) Apr 6, 2003 Connecticut
    Mod Team BA4LYFE Society Pooh-Bah Trader

    Honestly this is the key to keeping the DB up to date.
    "Adopt" your local brewery and check in with them for new beers. Add em into BA and we can increase the rate of growth .

    A countdown clock would be cool , but I feel like it makes more sense when the site is closer to the 1,000,000. Maybe 25,000 away?

    Fun geeking out with the math @PapaGoose03 . I do wonder if more beers are being added per year in recent past due to places creating so many beers in shorter time periods (ie Tree House, etc)
     
    Bitburger, bambiere, Amendm and 15 others like this.
  8. MrOH

    MrOH Grand Pooh-Bah (3,995) Jul 5, 2010 Virginia
    BA4LYFE Society Pooh-Bah

    Yes, but there has been parabolic growth in the number of new beers released per year over that time.
     
    Amendm, Whyteboar, zac16125 and 11 others like this.
  9. PapaGoose03

    PapaGoose03 Grand High Pooh-Bah (6,057) May 30, 2005 Michigan
    BA4LYFE Society Pooh-Bah

    Yeah, that's why I added the 'assumes' statement. With only a tiny membership and the smaller number of breweries in 1996 it's easy to see it was likely a slow start creating the database, and the huge increase in both factors since then means it's likely that the current annual pace exceeds the 26,724. An average number of submissions for the last 2-3 years would be a better number to use for the projection. We'll likely reach the 1,000,000th beer a couple years before 2033.
     
    Amendm, Whyteboar, ChicagoJ and 11 others like this.
  10. sulldaddy

    sulldaddy Grand Pooh-Bah (5,716) Apr 6, 2003 Connecticut
    Mod Team BA4LYFE Society Pooh-Bah Trader

    Im willing to bet @Todd has a good sense of the number of new beers added per year. :grin:
     
  11. dcotom

    dcotom Grand High Pooh-Bah (6,637) Aug 4, 2014 Iowa
    BA4LYFE Society Pooh-Bah Trader

    One hundred percent. According to the latest Forum Statistics, we have almost 800,000 members. If everyone added just one beer to the database, we're there.

    And I'll bet the One Millionth Beer will be a Mexican lager.
     
    Amendm, Whyteboar, ChicagoJ and 10 others like this.
  12. BBThunderbolt

    BBThunderbolt Grand High Pooh-Bah (7,846) Sep 24, 2007 Kiribati
    Pooh-Bah Trader

    It'll be some hot, new, trend we don't yet see coming.
     
  13. BBThunderbolt

    BBThunderbolt Grand High Pooh-Bah (7,846) Sep 24, 2007 Kiribati
    Pooh-Bah Trader

    I wonder how much of a difference it would make if we all just added all the beers that are currently on tap in our towns? Since I stopped ticking, I don't think I've added a beer. I'm sure I could add 50ish just from the breweries in my county, and maybe more.
     
  14. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    Great post, @cyclonece09! And yes, @sulldaddy, I have the numbers.

    After weeding out deleted entries, the actual number of beers in the database is 741,889 as of this post. If we group entries by year, starting when we introduced user accounts, we get the following:
    • 2000 = 124
    • 2001 = 1193
    • 2002 = 4236
    • 2003 = 5833
    • 2004 = 5074
    • 2005 = 8278
    • 2006 = 6078
    • 2007 = 5050
    • 2008 = 6027
    • 2009 = 7352
    • 2010 = 9051
    • 2011 = 11398
    • 2012 = 11286
    • 2013 = 20328
    • 2014 = 40486
    • 2015 = 52898
    • 2016 = 51419
    • 2017 = 55530
    • 2018 = 67541
    • 2019 = 64124
    • 2020 = 66429
    • 2021 = 54922
    • 2022 = 50093
    • 2023 = 48229
    • 2024 = 42607
    • 2025 = 45846
    • 2026 = 238 (so far)
    So we need roughly 258,111 new beers added to reach 1 million, which will take us roughly 5,7 years at our current entry rate (under 1,000 a week) assuming that goes unchanged. If we do nothing, that number will probably drop, however, there's an opportunity here to encourage users to not only add new beers to help us reach 1 million, but to rate some of them too.

    LFG! :beers::heavymetal::fire:
     
  15. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    I think even just highlighting it as a stat on the main Beers page would be a good start. We used to do this, but I pulled it for performance reasons. That said, one of my many goals this year is to track some high-level daily stats for beers and places that are essentially cached, which would allow me to bring this back.
     
  16. PapaGoose03

    PapaGoose03 Grand High Pooh-Bah (6,057) May 30, 2005 Michigan
    BA4LYFE Society Pooh-Bah

    This kind of sounds like a challenge to the membership to me. We can publicize an 'Add a Beer Today' day for a couple weeks so that everyone has an opportunity to read about the challenge and has time to decide which beer(s) to purchase or target for addition. It would be interesting to see how many we can add in one day. @Todd likely can develop the stats for the number of beers and the number of participants in the challenge.
     
    Shanex, Amendm, ChicagoJ and 13 others like this.
  17. HouseofWortship

    HouseofWortship Pooh-Bah (2,735) May 3, 2016 Illinois
    Pooh-Bah Trader

    How many breweries in US and how many new beers do we think each brewery averages per year?
     
    Shanex, Amendm, ChicagoJ and 5 others like this.
  18. wmeckley44

    wmeckley44 Savant (1,114) Nov 1, 2023 Tennessee
    Trader

    I could probably add a good chunk to the database assuming I get a few flights around Nashville at the breweries I've avoided. I've been meaning to try to get Stoke Haus in the database which doesn't have much but don't have photos.

    Most Nashville breweries also don't repeat beers (at least the ones I go to a lot) so I've been adding probably half of all the beers I drink to the database.
     
    Amendm, ChicagoJ, UWDAWG and 5 others like this.
  19. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    We list over 9,000 breweries in the US alone, but it's a big beer world out there. And how many beers per year really depends on the brewery. Talking under a dozen to hundreds per year.
     
    Shanex, Amendm, Bitterbill and 11 others like this.
  20. KP7

    KP7 Pooh-Bah (1,605) Feb 8, 2021 Massachusetts
    Society Pooh-Bah

    I just added 11 the past two days, so we'll be to 1 million in no time...

    But seriously, I've seen many express implicitly that you need to have the beer to add it to the BA DB. Not so! Add the beer with the details from the brewery website or menu. By doing so, you help keep the DB up to date and make it more likely that casual users will rate and review the beer. As @sulldaddy suggested, keep tabs on your locals and periodically add their new beers to the DB.