Master Code List (MCL)
- Rob Whyte (Unlicensed)
- Kelly Evans (Unlicensed)
The Master Code List (MCL) is the list of international dialing codes.
Country_id - An internal identification number used to identify the country.
Name - The name of the country.
Country_code - The International Country dialing code.
Destination - Typically a telecommunications provider servicing the country.
Code - The dialing code assigned to the telecommunications provider.
Initial Increment - This refers to the initial call duration measured in seconds. For rating purposes, all calls are rated the minimum initial increment. For example, a 3-second call with an initial increment of 6 seconds is billed for 6 seconds. A 42-second call with an initial increment of 60 seconds is billed for a 60-second call.
Subsequent Increment - This refers to the subsequent call duration increments beyond the initial duration. For example, a 100-second call with an initial increment and subsequent increment of 6 seconds is billed for 1 initial increment and 16 subsequent increments. A 10 minute and 22-second call with an initial increment and subsequent increment of 60 seconds is billed for 1 initial increment and 10 subsequent increments.
An International MCL
Country_id | Name | Country_code | Destination | Code | Initial Increment | Subsequent Increment |
1 | Afghanistan | 93 | Mobile MTN | 9376 | 1 | 1 |
1 | Afghanistan | 93 | Afghanistan | 93 | 1 | 1 |
1 | Afghanistan | 93 | Mobile MTN | 9377 | 1 | 1 |
1 | Afghanistan | 93 | Mobile Roshan | 9379 | 1 | 1 |
1 | Afghanistan | 93 | Mobile AWCC | 939 | 1 | 1 |
1 | Afghanistan | 93 | Mobile AT | 9375 | 1 | 1 |
1 | Afghanistan | 93 | Mobile AWCC | 9370 | 1 | 1 |
1 | Afghanistan | 93 | Mobile Etisalat | 9378 | 1 | 1 |
2 | Albania | 355 | Mobile AMC | 35568 | 1 | 1 |
2 | Albania | 355 | Albania | 355 | 1 | 1 |
2 | Albania | 355 | Tirana | 355424 | 1 | 1 |
2 | Albania | 355 | Tirana | 355423 | 1 | 1 |
… +19k rows |  |  |  |  |  |  |
224 | Vietnam | 84 | Mobile Viettel | 84163 | 1 | 1 |
225 | Wallis and Futuna | 681 | Wallis and Futuna | 681 | 1 | 1 |
226 | West Bank | 970 | Palestine Mobile | 97056 | 1 | 1 |
226 | West Bank | 970 | West Bank | 970 | 1 | 1 |
226 | West Bank | 970 | Palestine Mobile | 97059 | 1 | 1 |
227 | Yemen | 967 | Yemen | 967 | 1 | 1 |
227 | Yemen | 967 | Mobile Sabafon | 96771 | 1 | 1 |
228 | Zambia | 260 | Mobile Zamtel | 26095 | 1 | 1 |
228 | Zambia | 260 | Zambia | 260 | 1 | 1 |
229 | Zimbabwe | 263 | Mobile NetOne | 26311 | 1 | 1 |
229 | Zimbabwe | 263 | Mobile NetOne | 26371 | 1 | 1 |
229 | Zimbabwe | 263 | Zimbabwe | 263 | 1 | 1 |
Â
An MCL for the US & Canada
country_id | name | country_code | destination | code | initial increment | subsequent increment |
37 | Canada | 1 | 1249 | 1249573 | 1 | 1 |
37 | Canada | 1 | 1249 | 1249702 | 1 | 1 |
37 | Canada | 1 | 1249 | 1249832 | 1 | 1 |
37 | Canada | 1 | 1249 | 1249966 | 1 | 1 |
37 | Canada | 1 | 1249 | 1249219 | 1 | 1 |
37 | Canada | 1 | 1249 | 1249362 | 1 | 1 |
37 | Canada | 1 | 1249 | 1249225 | 1 | 1 |
…. + 42k rows |  |  |  |  |  |  |
218 | United States | 1 | 817 | 1817528 | 1 | 1 |
218 | United States | 1 | 817 | 1817654 | 1 | 1 |
218 | United States | 1 | 817 | 1817781 | 1 | 1 |
218 | United States | 1 | 817 | 1817907 | 1 | 1 |
218 | United States | 1 | 817 | 1817322 | 1 | 1 |
218 | United States | 1 | 817 | 1817449 | 1 | 1 |
218 | United States | 1 | 817 | 1817575 | 1 | 1 |
… + 189k rows |  |  |  |  |  |  |