Master data management ยท features 286-305
๐Ÿ›ข๏ธ SQL Server ยท MasterDataLabDB
๐ŸŒ

305Countries

Countries with ISO 3166 codes, dialling code and currency.

๏ผ‹ New country
Try it

Countries by region

Grouped in Java with Collectors.groupingBy(Country::getRegion)

AFRICA ยท 3

๐Ÿ‡ช๐Ÿ‡ฌ๐Ÿ‡ฐ๐Ÿ‡ช๐Ÿ‡ฟ๐Ÿ‡ฆ

AMERICAS ยท 4

๐Ÿ‡ง๐Ÿ‡ท๐Ÿ‡จ๐Ÿ‡ฆ๐Ÿ‡ฒ๐Ÿ‡ฝ๐Ÿ‡บ๐Ÿ‡ธ

ASIA ยท 15

๐Ÿ‡ฐ๐Ÿ‡ญ๐Ÿ‡จ๐Ÿ‡ณ๐Ÿ‡ญ๐Ÿ‡ฐ๐Ÿ‡ฎ๐Ÿ‡ณ๐Ÿ‡ฎ๐Ÿ‡ฉ๐Ÿ‡ฏ๐Ÿ‡ต๐Ÿ‡ฑ๐Ÿ‡ฆ๐Ÿ‡ฒ๐Ÿ‡พ๐Ÿ‡ฒ๐Ÿ‡ฒ๐Ÿ‡ต๐Ÿ‡ญ๐Ÿ‡ธ๐Ÿ‡ฌ๐Ÿ‡ฐ๐Ÿ‡ท๐Ÿ‡น๐Ÿ‡ญ๐Ÿ‡ฆ๐Ÿ‡ช๐Ÿ‡ป๐Ÿ‡ณ

EUROPE ยท 6

๐Ÿ‡ซ๐Ÿ‡ท๐Ÿ‡ฉ๐Ÿ‡ช๐Ÿ‡ฎ๐Ÿ‡น๐Ÿ‡ณ๐Ÿ‡ฑ๐Ÿ‡จ๐Ÿ‡ญ๐Ÿ‡ฌ๐Ÿ‡ง

OCEANIA ยท 2

๐Ÿ‡ฆ๐Ÿ‡บ๐Ÿ‡ณ๐Ÿ‡ฟ

Who has this dialling code?

# Flag ISO 2 ISO 3 Name Capital Region Phone code Currency Status
25 ๐Ÿ‡ฆ๐Ÿ‡บ AU AUS Australia Canberra Oceania +61 AUD Active โœ๏ธ
23 ๐Ÿ‡ง๐Ÿ‡ท BR BRA Brazil Brasรญlia Americas +55 BRL Active โœ๏ธ
4 ๐Ÿ‡ฐ๐Ÿ‡ญ KH KHM Cambodia Phnom Penh Asia +855 KHR Active โœ๏ธ
22 ๐Ÿ‡จ๐Ÿ‡ฆ CA CAN Canada Ottawa Americas +1 CAD Active โœ๏ธ
10 ๐Ÿ‡จ๐Ÿ‡ณ CN CHN China Beijing Asia +86 CNY Active โœ๏ธ
28 ๐Ÿ‡ช๐Ÿ‡ฌ EG EGY Egypt Cairo Africa +20 EGP Active โœ๏ธ
17 ๐Ÿ‡ซ๐Ÿ‡ท FR FRA France Paris Europe +33 EUR Active โœ๏ธ
16 ๐Ÿ‡ฉ๐Ÿ‡ช DE DEU Germany Berlin Europe +49 EUR Active โœ๏ธ
14 ๐Ÿ‡ญ๐Ÿ‡ฐ HK HKG Hong Kong Hong Kong Asia +852 HKD Active โœ๏ธ
13 ๐Ÿ‡ฎ๐Ÿ‡ณ IN IND India New Delhi Asia +91 INR Active โœ๏ธ
8 ๐Ÿ‡ฎ๐Ÿ‡ฉ ID IDN Indonesia Jakarta Asia +62 IDR Active โœ๏ธ
18 ๐Ÿ‡ฎ๐Ÿ‡น IT ITA Italy Rome Europe +39 EUR Active โœ๏ธ
11 ๐Ÿ‡ฏ๐Ÿ‡ต JP JPN Japan Tokyo Asia +81 JPY Active โœ๏ธ
29 ๐Ÿ‡ฐ๐Ÿ‡ช KE KEN Kenya Nairobi Africa +254 KES Active โœ๏ธ
2 ๐Ÿ‡ฑ๐Ÿ‡ฆ LA LAO Laos Vientiane Asia +856 LAK Active โœ๏ธ
Showing 1โ€“15 of 30
๐ŸŽ“ Learn: how this master is built table country

Key points

  • Emoji flags are Unicode text: NVARCHAR + N'๐Ÿ‡น๐Ÿ‡ญ' in SQL.
  • Bean Validation @Pattern(regexp = "[A-Z]{2}") on Country.iso2.

Code

Entity
domain/Country.java
Repository
repo/CountryRepository.java
Definition
MasterRegistry: "countries"
Page / form
web/MasterController.java
Try-it panel
templates/tools/country-summary.html
REST API
GET /api/masters/countries?q=thai

SQL to try in SSMS (database MasterDataLabDB)

SELECT region, COUNT(*) AS countries FROM country WHERE active = 1 GROUP BY region ORDER BY countries DESC;