The data is for your own private use only.
It is available here for more complicated analysis of the data.
Pick a world...
Lancelot1 (English)
Kay2 (English)
Bors3 (Deutsch)
Bedivere4 (Español)
Galahad5 (Français)
Gawain6 (Italiano)
Percival7 (English)
Ector8 (English)
Gareth9 (English)
Hengist10 (English)
Horsa11 (English)
Merlin12 (English)
Mordred13 (English)
Pellinore14 (Français)
Tristan15 (Italiano)
Pendragon16 (English)
Vortigern17 (English)
Guinevere18 (English)
Morgana19 (Deutsch)
Lancelot20 (Español)
Kay21 (English)
Bors22 (English)
Bedivere23 (English)
Galahad24 (English)
Gawain25 (English)
Percival26 (English)
Ector27 (Turkish)
Gareth28 (Swedish)
Hengist29 (Dutch)
Horsa30 (Danish)
Merlin31 (Russian)
Mordred32 (Polish)
Pellinore33 (Br. Portuguese)
Tristan34 (Français)
Pendragon35 (Italiano)
Vortigern36 (English)
Guinevere37 (English)
Morgana38 (English)
Lancelot39 (English)
Kay40 (English)
Bors41 (Español)
Bedivere42 (Deutsch)
Galahad43 (English)
Gawain44 (English)
Percival45 (English)
Ector46 (English)
Gareth47 (English)
Hengist48 (English)
Horsa49 (Hardcore)
Merlin50 (English)
Mordred51 (English)
Pellinore52 (English)
Tristan53 (English)
Pendragon54 (English)
Vortigern55 (Español)
Guinevere56 (Deutsch)
Morgana57 (Br. Portuguese)
Lancelot58 (Russian)
Kay59 (English)
Bors60 (English)
Bedivere61 (Turkish)
Galahad62 (Dutch)
Gawain63 (Russian)
Percival64 (Français)
Ector65 (Italiano)
Gareth66 (English)
Hengist67 (English)
Horsa68 (English)
Merlin69 (English)
Mordred70 (English)
Pellinore71 (English)
Tristan72 (English)
Pendragon73 (Español)
Vortigern74 (Deutsch)
Guinevere75 (Br. Portuguese)
Morgana76 (English)
Lancelot77 (English)
Howell78 (English)
Kay79 (Turkish)
Bors80 (English)
Bedivere81 (English)
Galahad82 (English)
Gawain83 (Français)
Percival84 (Français)
Ector85 (Deutsch)
Gareth86 (Deutsch)
Hengist87 (English)
兰斯洛特1 (Chinese Simplified)
蘭斯洛特1 (Chinese Traditional)
랜슬롯90 (Korean)
ランスロット91 (Janpanese)
凯伊2 (Chinese Simplified)
凱伊2 (Chinese Traditional)
Lancelot94
Kay95
博尔3 (Chinese Simplified)
Lancelot97 (English)
Kay98 (English)
Bors99 (Español)
Easter 2020 Hardcore
Gawain102 (English)
Percival103 (English)
Ector104 (Français)
Gareth105 (Italiano)
Hengist106 (Deutsch)
Horsa107 (Español)
Merlin108 (Turkish)
Mordred109 (Russian)
Pellinore110 (Danish)
Tristan111 (Swedish)
Avalon (Hardcore)
Stormlands (Hardcore)
Camlann (English)
Morgana115 (English)
Lancelot116 (English)
Kay117 (English)
Lohengrin118 (English)
Lohengrin119 (English)
Avalon (English)
Gawain121 (English)
Bors122
Ector123 (Dutch)
Nordic/Polski124 (Polish)
Hengist125 (English)
Horsa126 (English)
Merlin127 (English)
Mordred128 (English)
Pellinore129 (English)
Tristan130 (English)
Pendragon131 (English)
Vortigern132 (English)
Guinevere133 (English)
Morgana134 (Deutsch)
Lancelot135 (Français)
Lancelot136 (Español)
Kay137 (Italiano)
AvalonPvP138 (Hardcore)
Bedivere139 (Turkish)
贝德维尔4 (Chinese Simplified)
Gawain141 (Br. Portuguese)
Percival142 (Russian)
Ector143
Gareth144 (English)
145
Horsa146



Info about the numbers in the downloads.
Gender column is the family...
0 Corleone
1 Tattaglia
2 Stracci
3 Barzini
4 Cuneo



To load With command line...
  1. To load: mysql -u root -p mysql <....sql
  2. To dump back into csv: mysqldump -T /tmp/ -u root -p mysql mapbyid_?? users alliances
Change "root" + "mysql" to whatever the user name/database name is.
And is whatever the MapId number is.


With GUI in windows...
  1. Download mysql (for windows, click on the "development" tab and use >=v5.5 the older versions have problems with too many opened files.)
  2. For windows: Download HeidiSql
  3. Make a new session, you only need to set the password on this screen if mysql was installed on the same computer.
  4. In HeidiSQL click:
    1. Select a database on the left, "mysql" is usually there.
    2. Import -> Load sql data -> pick the .sql file that you had extracted
    3. Tools -> Preferences -> export -> change "fields separated by" to , (comma). Change "Limit Copy as CSV Copy" to 50MB
    4. Tools -> Preferences -> data -> change "Number of rows displayed in data tab" to "1000000"
    5. Click the "Refresh" icon, then select the table in the database, which is either users,alliances,map,mapbyid_???
    6. Go to the "data" tab, press ctrl-end to load all the data into the grid.
    7. Export -> export grid

Foreign characters
To get the foreign characters to appear correctly for some games. Before running any queries, use...
set character_set_connection = 'latin1';
set character_set_client = 'latin1';
set character_set_results = 'latin1';

Video instructions here