Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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_id

...

name

...

country_code

...

destination

...

code

...

increment

...

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

...

country_id

name

country_code

destination

code

initial increment

durationsubsequent 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