The downloadable file is provided in a standardized UTF-8 encoded Plain Text (.txt) format, ensuring maximum compatibility across different operating systems and legacy software applications. The document is structured using standard tab-separated values (TSV), which allows automated scripts and database management tools to parse the information cleanly without corrupting special characters or diacritics. Each row represents a single, distinct data record, while individual data fields within that record are divided by uniform horizontal tabs.</

Troubleshooting common import errors

When attempting to parse or ingest the plain text file into your software, the most frequent issue encountered is character encoding corruption, often visible as scrambled text or question mark replacement symbols. This typically occurs when the receiving program defaults to ASCII or Windows-1252 instead of reading the file as UTF-8. To resolve this, ensure that your application’s file-origin setting is explicitly changed to UTF-8 during the import process, which will correctly render all

Data structure and field definitions

Understanding the internal organization of the text file is essential for writing accurate parsing scripts or mapping fields correctly during a database import. Every line in the document acts as a discrete record terminated by a standard newline character, while each record contains five distinct fields arranged in a fixed order. The first column contains a unique numerical identifier that serves as the primary key for the record, formatted strictly as an integer without commas or decimals.

The second field represents the