WCA results export

On this page we offer the WCA results for download in several formats so you can use/analyze them at large. We will usually update after each competition weekend when the results are finalized. The files are numbered and dated so you can see whether you have the newest version already.

SQL: WCA_export003_20181022.sql.zip (84.8 MB) (permalink)
SQL statements, for import into SQL databases.
TSV: WCA_export003_20181022.tsv.zip (79.5 MB) (permalink)
Tab-separated values, for spreadsheets in OpenOffice.org, Excel, etc.

The included README.txt contains the terms of use and a general description:

Export of the World Cube Association results database

Date:     October 22, 2018
Remarks:  none
Contact:  WCA Results Team results@worldcubeassociation.org
Website:  https://www.worldcubeassociation.org/results

  This file contains public information on all official WCA competitions,
  WCA members and WCA competition results.

  Goal of this file is for members of our community to do analysis on the
  information for statistical and personal purposes.

Allowed use: Information and parts of it may be published online,
but only under the following conditions:
  - A clearly visible link to World Cube Association website is added
    (https://www.worldcubeassociation.org) with the notification that
    World Cube Association is the source and owner of the information.
  - A clearly visible notification is added that the published information
    is not actual information.
  - A clearly visible link to https://www.worldcubeassociation.org/results is
    added with the notification that the actual information can be found via
    that link.
  - A clearly visible notification which date is taken for the source of the data.
  - The style and format of the information must be clearly distinguishable
    from the official WCA website

Software created by:
  Clément Gallet    France
  Stefan Pochmann   Germany
  Josef Jelinek     Czech Republic
  Ron van Bruchem   Netherlands

The export consists of these tables:
  Persons                                    WCA competitors
  Competitions                               WCA competitions
  Events                                     WCA events (3x3x3 Cube, Megaminx, etc)
  Results                                    WCA results per competition+event+round+person
  RanksSingle                                Best single result per competitor+event and ranks
  RanksAverage                               Best average result per competitor+event and ranks
  Rounds                                     The round types (first, final, etc)
  Formats                                    The round formats (best of 3, average of 5, etc)
  Countries                                  Countries
  Continents                                 Continents
  Scrambles                                  Scrambles
  championships                              Championship competitions
  eligible_country_iso2s_for_championship    See explanation below

Most of the tables should be self-explanatory, but several things merit further

Countries stores include those from the Wikipedia list of countries at
http://en.wikipedia.org/wiki/List_of_countries, and may include some countries
that no longer exist.  The ISO2 column should reflect ISO 3166-1 alpha-2
country codes, for countries that have them.  Custom codes may used in some

eligible_country_iso2s_for_championship stores information about which citizenships are eligible
to win special cross-country championship types. For example, "greater_china" is a special
championship type which contains 4 iso2: CN, HK, MC and TW. This means competitors from China,
Hong Kong, Macau, and Taiwan are eligible to win a competition with championship type "greater_china".

Scrambles stores all scrambles. For 333mbf, an attempt is comprised of multiple, newline separated
scrambles. Unfortunately, newlines don't work so well in TSV, so we use "|" as a scramble delimiter

Result values of the Results table can be interpreted as follows:
- The result values are in fields value1-value5, best and average.
- Value -1 means DNF
- Value -2 means DNS
- Value 0 means "nothing", for example a best-of-3 has value4=value5=average=0
- Positive values depend on the event, see column "format" in Events.
  - Most events have format "time", where the value represents centiseconds.
    For example, 8653 means 1 minute and 26.53 seconds.
  - Format "number" means the value is a raw number, currently only used
    by "fewest moves" for number of moves.
    - Fewest moves averages are stored as 100 times the average, rounded.
  - Format "multi" is for old and new multi-blind, encoding not only the time
    but also the number of attempted and solved cubes. Writing the value in
    decimal it is interpreted ("decoded") using the following method:
      old: 1SSAATTTTT
             solved        = 99 - SS
             attempted     = AA
             timeInSeconds = TTTTT (99999 means unknown)
      new: 0DDTTTTTMM
             difference    = 99 - DD
             timeInSeconds = TTTTT (99999 means unknown)
             missed        = MM
             solved        = difference + missed
             attempted     = solved + missed
    In order to encode data, the following procedure should be followed:
             solved    = # cubes solved
             attempted = # cubes attempted
             missed    = # cubes missed = attempted - solved
             DD        = 99 - (solved - missed)
             TTTTT     = solve time in seconds
             MM        = missed
    Note that this is designed so that a smaller value means a better result.
    This format does not allow for more than 99 attempted cubes, or for times
    greater than 99999 seconds (about 27.7 hours).