Recommend
28 
 Thumb up
 Hide
33 Posts
1 , 2  Next »   | 

BoardGameGeek» Forums » Gaming Related » General Gaming

Subject: Historical BGG Rankings rss

Your Tags: Add tags
Popular Tags: [View All]
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
I've been playing around with BGG rating data and came up with the following query for historical rankings, plan on keeping up with this updating it on or about the first of the month.

I've been playing around with loading the historical data via the XML api into a SQL Database, which has gone fairly well, so I can now go back a bit farther into the history, and it's easier to keep things up to date.

June 2014 update complete.

The actual dates of the data collection are...

2014-09 = 2014-09-01
2014-06 = 2014-06-01
2014-01 = 2014-01-01
2013-07 = 2013-07-01
2013-01 = 2013-01-01
2012-07 = 2012-07-01
2012-01 = 2012-01-01
2011-01 = 2011-01-01
2010-01 = 2010-01-01
2009-01 = 2009-01-01
2008-01 = 2008-01-01
2007-01 = 2007-01-01

This didn't seem like a geeklist type of thing, so 'general gaming' seemed to be the best place for this.


Game Name Release GeekRating 2014-09 2014-06 2014-01 2013-07 2013-01 2012-07 2012-01 2011-01 2010-01 2009-01 2008-01 2007-01
------------------------------------ ------- ---------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------
Twilight Struggle 2005 8.218 1 1 1 1 1 1 1 1 4 4 3 10
Through the Ages Story of Civil 2006 8.089 2 2 2 3 3 4 4 4 5 9 37 220
Terra Mystica 2012 8.086 3 6 7 11 136 -- -- -- -- -- -- --
Agricola 2007 8.086 4 3 3 2 2 2 2 3 1 1 10 --
Puerto Rico 2002 8.076 5 4 4 4 4 3 3 2 2 2 1 1
Android: Netrunner 2012 8.067 6 5 5 5 10 -- -- -- -- -- -- --
Caverna: The Cave Farmers 2013 7.996 7 10 157 -- -- -- -- -- -- -- -- --
Eclipse 2011 7.980 8 7 6 6 5 6 22 -- -- -- -- --
Power Grid 2004 7.948 9 8 8 7 6 5 5 5 3 3 2 4
Mage Knight Board Game 2011 7.947 10 9 9 8 8 13 250 -- -- -- -- --
The Castles of Burgundy 2011 7.910 11 12 12 13 21 25 70 -- -- -- -- --
Le Havre 2008 7.903 12 11 10 9 7 7 6 6 7 38 -- --
Robinson Crusoe: Cursed Island 2012 7.899 13 13 25 189 324 -- -- -- -- -- -- --
Brass 2007 7.878 14 14 11 10 9 8 7 9 11 15 132 --
Tzolk'in: The Mayan Calendar 2012 7.839 15 15 13 17 82 -- -- -- -- -- -- --
War of the Ring (second edition) 2012 7.835 16 17 20 26 93 -- -- -- -- -- -- --
Caylus 2005 7.816 17 16 14 12 11 10 10 10 10 8 5 3
7 Wonders 2010 7.810 18 18 15 15 13 12 11 21 -- -- -- --
Dominion: Intrigue 2009 7.783 19 19 16 14 12 9 8 7 -- -- -- --
Dominant Species 2010 7.740 20 21 18 18 18 21 16 78 -- -- -- --
Dominion 2008 7.736 21 20 17 16 14 11 9 8 6 6 -- --
El Grande 1995 7.735 22 23 19 19 17 14 12 11 9 7 6 5
Star Wars: X-Wing Miniatures Game 2012 7.734 23 26 26 29 59 -- -- -- -- -- -- --
Race for the Galaxy 2007 7.732 24 22 21 20 16 15 13 13 12 10 25 --
Battlestar Galactica 2008 7.715 25 25 22 22 23 20 17 17 18 41 -- --
Mage Wars 2012 7.712 26 24 23 37 258 -- -- -- -- -- -- --
Lords of Waterdeep 2012 7.707 27 27 29 30 31 41 -- -- -- -- -- --
The Resistance: Avalon 2012 7.693 28 28 34 76 494 -- -- -- -- -- -- --
Eldritch Horror 2013 7.681 29 41 287 -- -- -- -- -- -- -- -- --
Twilight Imperium (3rd ed) 2005 7.679 30 30 31 27 29 28 27 26 30 29 24 27
Tigris & Euphrates 1997 7.674 31 29 24 23 20 16 14 12 8 5 4 2
War of the Ring (first edition) 2004 7.667 32 31 27 24 22 19 15 15 15 13 12 13
Descent Journeys in the Dark (2nd) 2012 7.660 33 32 32 31 30 -- -- -- -- -- -- --
A Game of Thrones Board Game (2nd) 2011 7.655 34 33 30 25 26 27 423 -- -- -- -- --
Keyflower 2012 7.640 35 37 54 99 308 -- -- -- -- -- -- --
Ora et Labora 2011 7.632 36 34 28 21 19 18 309 -- -- -- -- --
Trajan 2011 7.623 37 36 36 39 48 76 234 -- -- -- -- --
Crokinole 1867 7.617 38 35 37 35 36 34 31 39 39 36 39 36
Commands & Colors: Ancients 2006 7.601 39 38 35 33 28 23 20 16 16 14 15 12
Paths of Glory 1999 7.598 40 39 33 28 24 24 19 19 19 17 19 17
Nations 2013 7.597 41 44 160 -- -- -- -- -- -- -- -- --
Steam 2009 7.577 42 40 38 34 27 22 18 14 13 -- -- --
Pandemic 2008 7.576 43 47 48 47 47 45 37 27 22 22 -- --
Stone Age 2008 7.576 44 42 39 36 33 30 25 25 27 33 -- --
Russian Railroads 2013 7.574 45 54 220 -- -- -- -- -- -- -- -- --
Goa 2004 7.571 46 45 41 40 35 32 28 23 21 23 18 14
Combat Commander: Europe 2006 7.568 47 46 46 43 37 31 24 24 25 28 28 249
Troyes 2010 7.564 48 50 43 42 39 36 34 159 -- -- -- --
Summoner Wars: Master Set 2011 7.564 49 43 40 32 25 37 181 -- -- -- -- --
Railways of the World 2005 7.559 50 51 45 44 40 51 43 31 26 24 20 19
Age of Steam 2002 7.559 51 48 42 38 32 26 21 18 14 12 9 9
The Princes of Florence 2000 7.551 52 52 44 41 34 29 23 20 17 11 7 7
Suburbia 2012 7.550 53 53 77 162 447 -- -- -- -- -- -- --
Chaos in the Old World 2009 7.521 54 55 52 48 45 44 38 37 45 -- -- --
Tichu 1991 7.514 55 57 51 46 44 42 36 36 37 34 35 33
Pathfinder Adventure: Rise Rune Base 2013 7.512 56 49 47 -- -- -- -- -- -- -- -- --
Hannibal: Rome vs. Carthage 1996 7.510 57 56 49 45 38 33 26 22 20 16 17 16
Go -2200 7.507 58 58 53 49 46 43 40 38 35 30 23 21
Runewars 2010 7.499 59 59 50 50 42 39 32 35 -- -- -- --
Ticket to Ride: Europe 2005 7.481 60 61 63 61 65 66 60 51 47 44 40 29


Want to keep up with the Geeklists I've created? Subscribe to ConnerCP's Data Geeklist List and Announcement Thread.
20 
 Thumb up
0.50
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
Re: Historical Rankings
for more data fun, check out Good Years and Bad Years For Board Games and 2112 Game Tracking.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Judy Krauss
United States
Pittsburgh
Pennsylvania
flag msg tools
but I'm not the only one
badge
My hands are small, I know, but they're not yours, they are my own
Avatar
mbmbmbmbmb
Re: Historical Rankings
I thought this was going to be a thread about ranking wargames for their perceived historical accuracy!
3 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
Hmm, was probably a bit too generic of a title, eh? Probably still is (:
1 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
...sure...
Netherlands
Rijen
Noord Brabant
flag msg tools
badge
Avatar
mbmbmbmbmb
JonMichael Rasmus does this as well. Every Tuesday there's this thread: http://www.boardgamegeek.com/thread/774831/top-100-analysis-...

Also see Tom Verdonck's monthly GeekList: http://www.boardgamegeek.com/geeklist/137253/bgg-top-50-stat...

I love all these stats, don't get me wrong, but maybe there's some overlap with this.
2 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
I was wanting to present the data in one 'chart', which I wasn't seeing elsewhere. I poked around the links you provided, and didn't see a good summary of the data presented. Am I just overlooking it?

Thanks for the links!
3 
 Thumb up
0.02
 tip
 Hide
  • [+] Dice rolls
John Farrell
Australia
Rozelle
New South Wales
flag msg tools
Averagely Inadequate
badge
Buster Keaton from 'Go West'
Avatar
mbmbmbmbmb
I like LordT's chart:

http://www.boardgamegeek.com/geeklist/137253/item/2049148#it...
3 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
ah, now that is pretty (:
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
April Update- Castles of Burgundy is moving up the charts nicely - going from 50 to 42. I personally enjoy the game. A Few Acres of Snow is moving the opposite direction, from 42 to 49 - I'm guessing this is because the strong feeling by many people that the game is 'broken'. I would mention Puerto Rico LE moving from 45 to 26, but it's not really a different game from the original, is it? (: Eclipse has settled into the #6 spot, I can't see it moving up any farther. Mage Knight Board Game and Ora et Labora are two other 2011 releases that are still moving up the top 60.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
May Update, Ora et Labora has continued to move up, now in the top 20 at #17.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
June Update - Eclipse and Le Havre flipped briefly earlier this week, but Eclipse starts June back at #6. Lords of Waterdeep enters the top 60, coming in at #51.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
July Update - Eclipse has moved ahead of Power Grid for #5. I didn't think that would happen, but it so far Eclipse is holding onto its average rating while gaining more votes with the 2nd printing.

Lords of Waterdeep has moved into #40.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
August Update - Through The Ages and Puerto Rico flip flopped 3rd and 4th, Dominion fell 2 spots from 11 to 13, while Mage Knight is up to #12, meaning 2011 has 3 games in the top 20 (not counting the Puerto Rico LE), Eclipse at #5, Mage Knight at #12 and Ora et Labora at #17. 2007 has 3 as well, Agricola at #2, Brass at #8 and Race For The Galaxy at #16.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
September Update: Top 10 stays exactly the same, Mage Knight moves from #11 to #12.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
October Update: Mage Knight moves into the top 10.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
for more data fun, check out Good Years and Bad Years For Board Games and 2012 Game Tracking.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
November Update: Andriod Netrunner jumps into the top 25.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
been a while since the last update. Android is now #6, passing Power Grid :: sniff :: Tzolk'in is knockin' on the top 25 door.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
2013-04-01 update complete. Tzolk'in in now in the top 25.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Franz Kafka
United States
St. Charles
Missouri
flag msg tools
badge
Avatar
mbmbmbmbmb
ConnerCP wrote:


I'm disappointed by that typo. I thought I was going to see a Rush-related geeklist.
3 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
heh, I fixed it before your post! Freaky!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
2013-11-01 update complete meeple
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
2013-12-01 update complete
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Josh Arnold
United States
Olathe
Kansas
flag msg tools
badge
Avatar
mbmbmbmbmb
Thanks for creating this and keeping it current-- it's great!!

Edit: I created this reddit post so everyone can see your cool content.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Todd Snyder
United States
Oregon City
Oregon
flag msg tools
badge
Avatar
mbmbmbmbmb
squashfactory wrote:
Thanks for creating this and keeping it current-- it's great!!

Edit: I created [http://www.reddit.com/r/boardgames/comments/2dvxe1/bgg_top_6... this reddit post] so everyone can see your cool content.


thanks for the shout out - I maintain some other data related lists, you can see links to my stuff here. The main ones I'm currently focusing on are the 2014 game rating tracking and the monthly list I create to track year over year ownership changes.

I'll probably update this list the first of next month (:
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
1 , 2  Next »   | 
Front Page | Welcome | Contact | Privacy Policy | Terms of Service | Advertise | Support BGG | Feeds RSS
Geekdo, BoardGameGeek, the Geekdo logo, and the BoardGameGeek logo are trademarks of BoardGameGeek, LLC.