Search Results

Keyword: ‘bgg url hack’

lies, damned lies, and statistics; more fun with BGG URLs

June 18, 2011 Leave a comment

Thanks to Pelle Nillson, I now have a Python script that enables me to download BoardGameGeek game data using their XML API. I hope to do a number of posts based on this data in the near future, but I first wanted to correct a post I did recently.

In more BGG stats: fun with numbers, I shared a snapshot of a spreadsheet table listing the fifty games with the highest wanted in trade / offered for trade ratio in the BGG database. I included a caveat:

I didn’t go through the entire BGG database looking for the twenty games with the highest ratio, instead I assumed that they would all be in the top 100 games wanted in trade. And this might well be a bad assumption.

It turns out it was a terrible assumption. If you look at all games in the BGG database, the top twenty come out quite a bit differently:

So now, the top 10 include Julius Caesar, Hive: the Ladybug, Big Boss, Dominion: Cornucopia, K2, Railways of the Western US, Airlines Europe, Santorini, Olympus, and German Railways. And that’s quite a different list.

Sorry ’bout that….

To end this post on a more positive note, however, I’d like to share another little URL hack anyone can use to get at the data on BGG in a slightly nonstandard way.

In fun with BGG URLs, part III, I showed how it was possible to sort the games by number owned. Did you know it’s possible to do the same thing with just games in the family category? Just add “familygames/” before “browse/” in the URL above, and you get: Cool, huh? You can also do this for strategy games, for abstracts, for party games, and for wargames.

And if you don’t want to sort by number owned, you can also sort by other things, too: number wanting (sort=numwanting), number trading (sort=numtrading), number wishing for (sort=numwish), and pageviews (sort=views).

The general principle, here, is that you can add the type of game you’re looking for before “browse/” to limit the results you get.

Now I think that’s pretty neat. :-)


fun with BGG URLs, part III (and an update on El Chupacabra)

June 5, 2011 Leave a comment

First up is a URL that takes you to a bunch of different ways to rank the games on BGG: My favorites here are sorting by number owned, by number wanted in trade, by number that users have put on their wishlist, and by the total number of pageviews. I was hoping to find a way to break down the number of views by year, to get an idea of when games were generating a lot of interest, but multiple attempts at URL hacking went exactly nowhere.

What I’d really like to do is come up with a relational analysis of all the games in, say, the top 200. Analyze the “recommends” data on each game, for example, to find links between games based on common ownership. Or find a way to do it based on “people who play / rate highly game x also play / rate highly game y.” In other words, first find out which games are “connected” to one another, then present this data graphically. If anyone has any ideas or suggestions for how to go about this (without losing what sanity I have), I’d love to hear them. I suspect that BGG’s xml api might be the way to go, but after an initial assessment of its features, I don’t quite see how. Again, though, I’d welcome any and all suggestions — enlighten me!

Since this relational analysis appears to be beyond me (for the moment), I’ll have to content myself with sharing something much more mundane: the ability to search BGG’s database for games of a particular weight, sorted in pretty much any way you want.

This, for example, looks at all the games with a weight between 1.8 and 2.0 (fairly light, includes both Carcassonne and Ticket to Ride) and sorts them by the number of people who rated the game:  And yes, it’s ugly — but the important thing is that it works.

Now for a little URL hacking:  change the 1.8 to 2.0 and the 2.0 to 2.2: This does the same search, only it bumps the weight up a little bit — this list includes Citadels, Alhambra, and 7 Wonders.

If you want to look at slightly heavier games again, then change the 2.0 to 2.2 and the 2.2 to 2.4 (this’ll get you games like Dominion, Pandemic, and Settlers of Catan). While you’re at it, change the “numvoters” to “rank” to sort the resulting games by their BGG ranking: Or change “rank” to “numowned” to sort by the number of BGG users who own the game: Easy, huh?

I’ve always thought it should be easier to get at some of this info, but it’s nothing a little URL hacking can’t take care of. :-)

And, as promised, an update on El Chupacabra. Those who have been following my blog know that the game didn’t work as well with 7 as I had hoped, so I went back to the drawing board to come up with something a little different. I decided that the opportunity to “shoot the moon” offered by the role of El Chupacabra just wasn’t interesting enough to justify its overhead in terms of rules complexity, and I also decided that the mechanism just didn’t fit very well with the push-your-luck gameplay. So I took it out.

I’ve been thinking for some time that it would be fun to design a game that encourages people to cheat, or at the very least encourages people to call one another cheaters. The first step, then, was to check to see if that name had been taken, and sadly, it had: Cheater. I always hate it when a poorly-rated game is taking up a perfectly good name, but what do you do? I mean, aside from turning your copy of Cheater into a perfectly serviceable version of The Bottle Imp.

Naming concerns aside (I can’t decide between Russian Rollette and Cheater’s Dice), I decided to gut the original game, take out all the fussy bits having to do with scoring, and make it a betting and bluffing game pure and simple. Think of it as a dice version of Bullshit (a.k.a. I Doubt It / Cheat) with gambling thrown in. It’ll fall most definitely into the Beer & Pretzels category of gaming….

More anon.

fun with BGG URLs, part I

June 2, 2011 2 comments

Okay, so I was having a bit of fun on BGG today, trying to figure out how to get at some of all their awesome data. I mean, yes, you can pretty easily sort by rank, or the number of voters, etc., but did you know you can sort by number of owners? Or by number of people who have the game on their wishlist? By the number of people who want a game in trade?

Anyway, I got to playing around a bit with their stats, specifically the number of plays each game has. And I found something interesting: ignoring the number of plays (since this data can be easily corrupted), you can sort by the number of unique users who played the game. Here’s a link that lists all the games in their database, sorted by the number of unique users who have played the game: Pretty cool, huh? Who knew that Carcassonne would have the most unique players, followed by Dominion, Agricola, Puerto Rico, and The Settlers of Catan?

Here’s where it gets really interesting, though: you can limit the time-frame you’re looking at, so you get just the number of unique users who played the game, say, in the year 2000.

You can tell where I’m going with this, can’t you?

First, a link or two: if you want to see how many unique users played Settlers of Catan in, say, 2000, just click here. And you can obviously do a little url hacking to change the year from 2000 to 2001 (that’s easier than picking a new range of dates with their chooser and then choosing to sort by number of unique users, though you can do it that way, too).

And you can go through and do this for 2000, 2001, 2002, all the way up to 2010. What do you get when you do all that?

You get a bunch of web pages, that’s what. But if you look at the top ten games of each year, some interesting trends emerge. And if you look at every game that hits the top ten in that period (there are 34), tracking it until it no longer cracks the top 100, you get a rather interesting little graph. But one that’s very hard to read:

A couple things to note: first, each game is just stacked on top of the next. Second, this looks an awfully lot like exponential growth, at least up until 2010. This might represent the growth of the hobby, but more likely it’s just the growth in BGG users / users who record their plays. Third, I’m not sure why things tail off for 2010 — probably it’s just that fewer players recorded their plays that year (for whatever reason).

Playing with it a little, you can “normalize” the graph by converting all the numbers to percents. Here all that dramatic growth goes away, replaced by an easier-to-read graph where each game gets a slice of 100%:

A caveat: of course there are a number of things that are suspect with this data. First, the number of users on BGG has been increasing a lot. Second, not all users record their plays. Third, there are an unknown but possibly large number of shill accounts. And so on.

Still, I think this is fairly interesting. It gives a pretty good idea as to what the big (popular) names in gaming are, and it does so in an easy-to-read way.

I’d upload the spreadsheet I made so other people can play with the data, too, but WordPress appears to be unwilling to allow me to post an ODS file. ODT, yes, but not ODS. Anyway, I can try to figure something out if folks are interested. Just let me know.

cult of the new?

September 26, 2012 Leave a comment

So I got to thinking the other day about the “cult of the new,” and I began to wonder if there was any way to see if there really was an effect along those lines at BGG.

How did I decide to go about it?  Using two sets of numbers:  first, a breakdown of the number of games in the top 250 ranked games by year, and second, a breakdown of the number of games in the top 250 most popular games by year (as measured by the number of players who have ranked the game).

Is this a perfect way to do it?  No, there are obviously any number of factors that would tend to skew the data in one direction or another.  But it isn’t bad, and all I was looking for was a back-of-the-envelope kind of calculation, anyway.

How did I get the data?  With a little URL hacking, that’s how.

For the number of games in the top 250 ranked games that were published in 1995, for example, I entered the following URL:[yearpublished][min]=1995&range[yearpublished][max]=1995&range[rank][min]=1&range[rank][max]=250&B1=Submit&sort=rank&sortdir=asc.  If you follow the link, you will see that there were four.

For the number of games in the top 250 most popular games that were published in 1995, on the other hand, I entered:[yearpublished][min]=1995&range[yearpublished][max]=1995&range[numvoters][min]=3362&range[numvoters][max]=250000&B1=Submit&sort=numvoters&sortdir=desc.  The number?  Seven.

(How did I come up with 3362 as the minimum number of voters for the 250 most popular games?  Look at all the games in the database, sort by the number of voters, and see how many votes the 250th game received.  Simple.)

On to the visuals.  In the graph below, blue shows the number of games in the top 250 highest ranked games, broken down by year; yellow shows the number of games in the top 250 most popular games, broken down by year.  Red and green show these same numbers while looking at only the top 100 games in their respective categories.

So what, if anything, does this graph tell us?  Both the yellow and green lines (tracking the most popular games, as measured by the number of voters) peak in 2004 and then drop off.  Both the blue and the red lines (tracking the highest ranked games), however, peak in 2009.

While certainly not definitive, this does suggest that (a) games take a while to be widely adopted by the BGG community, and (b) our ratings of these games do tend to fall over time.  We tend to rank games more highly, in other words, when they’re still relatively bright and shiny, and we tend lower our ratings when games begin to show their age.

If I were on Mythbusters, I’d have to conclude that the myth was confirmed.  What do you think?


top games of 2010, 2011

December 14, 2011 3 comments

Okay, so I got curious — what are the most popular games (on BGG, of course) from 2010 and 2011?  Mainly I was interested in seeing if I missed anything that looked promising.  I don’t tend to be an “early adopter,” and I don’t keep track of all the latest games as they come out, so it’s easy for good games to get by me.

Here’s a link to the most popular games on BGG that were published in 2010 and 2011.  For those who keep up better than I do, here’s the most popular games on BGG from 2011 only.

Most popular is fine, but what about highest ranked?  Here are the highest-ranked games published in 2010 and 2011.  And here are the highest-ranked games from 2011 only.

Of course a little URL hacking can get you the highest-ranked (or the most popular) games from 2009, 2008, &c.

Scanning down these lists, I really ought to read more about A Few Acres of SnowLetters from Whitechapel, Airlines Europe, and Strasbourg (all from 2011).  Also, from 2010, I should probably take another look at Sid Meier’s Civilization: The Board Game, Troyes, and Merchants & Marauders.  And finally, I really need to get around to trying my friend’s copies of Kingdom Builder and Panic Station.