Metanet Forums

N v1.4 Full Highscore Database

I present to you a MySQL database ready to be imported containing the complete database of highscores from N v1.4. I scraped it a few days ago for archival purposes. It contains every score ever submitted to the highscore boards in the past 16 years, including demos!

I've already cleaned it of hackers, duplicates, etc. I've left cheaters in there, though, again for archival purposes and in case Metanet actually ever needs this copy to restore theirs, since we know their past reticence to remove cheated scores.

Download: https://drive.google.com/file/d/1kst9uL ... vXUSkmqlhF

Please read the included README file for some relevant notes on, for example, how demos are compressed, otherwise you won't be able to use them.

Some figures:

* 365130 scores.
* 22222 players (that's right!).
* 2189 duplicated/triplicated scores.
* 22 scores without a valid demo.
* 9 duplicated players.

As I said those duplicates have been removed.

Some documents:

* Levels sorted by total completions: https://pastebin.com/H3zhsCEa
* Episodes sorted by total completions: https://pastebin.com/vPFWdkXB
* Total level score rankings (top 1000): https://pastebin.com/16MPpKWg
* Total episode score rankings (top 1000): https://pastebin.com/sAYdxbwv

The complete rankings with all +22k players are too big for pastebin, so here you go: If you use the database to come up with other interesting statistics that were not possible before, please post them here. Also, do not hesitate to ask me for any other stat, ranking or document you may want to see.

Bump

Just a suggestion: might be a good idea to have half a dozen mirrors or so.

Good idea, I'll do it, nonetheless, I'll never remove my own local copies either.

Potentially a dumb question, but what exactly is meant by completions? Is it just scores submitted to the server, or is it only including level scores that were a top-20 upon time of submission? My gut tells me it's the latter, otherwise the implication is that some levels had fewer than 200 submissions, which doesn't sound right at all.

It's actually the former, some levels really only have 200 submitted completions, at least, that's what there is on their database. It did seem way too low to me too, golf said the same when we discussed it in the Discord, but that's all there is in Metanet's database.