DataPrep
ID dataprep
etl
DataPrep is an open-source Python library for data preparation from the SFU Database Group. Its clean module standardises and validates the values of a DataFrame column: national identifiers, tax and VAT numbers, company registration numbers, bank account numbers and product, publication and securities codes (most of them checked with python-stdnum), as well as email addresses, phone numbers, URLs, IP addresses, dates, coordinates, countries and addresses.
- Website
- https://github.com/sfu-db/dataprep
- Supported types
- 169
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| aadhaar | Indian Aadhaar number by known name PII | pii, persons | IN | Indian Aadhaar number by known name identifier |
| ad_nrt | Andorran tax registration number (NRT) PII draft | finances | AD | Número de Registre Tributari, the identifier that the Andorran tax administration gives to natural and legal persons. It has eight... |
| address | Address (physical location) PII | common, pii, geo | global | Geographic address, commonly consist of postindex, country, area, town, street and building |
| al_nipt | Albanian taxpayer identification number (NIPT) PII draft | finances | AL | Numri i Identifikimit për Personin e Tatueshëm (NIPT, also NUIS), the tax number that Albania gives to businesses and individuals. It... |
| ar_cbu | Argentine uniform bank account code (CBU) draft | finances | AR | Clave Bancaria Uniforme, the 22-digit code that identifies a customer account at a bank in Argentina. The first block holds a 3-digit... |
| ardni | Argentina DNI (National Identity Document) PII | pii, persons | AR | Documento Nacional de Identidad or DNI (which means National Identity Document) is the main identity document for Argentine citizens, as... |
| at_vat | Austrian VAT identification number (UID) PII draft | finances, companies | AT | Austrian VAT identification number (Umsatzsteuer-Identifikationsnummer, UID). In the EU form it is ATU followed by eight digits. The... |
| at_vnr | Austrian social insurance number (VNR) PII draft | pii, persons | AT | Versicherungsnummer (also SVNR or VSNR), the personal number of the Austrian social insurance. It has ten digits: a 3-digit serial... |
| auabn | Australian Business Number (ABN) | companies | AU | The Australian Business Number (ABN) is a unique 11-digit identifier issued by the Australian Business Register (ABR) which is operated... |
| auacn | Australian Company Number (ACN) | companies | AU | An Australian Company Number (usually shortened to ACN) is a unique identifier required by every company registered under Australia’s... |
| autfn | Australian Tax File Number (TFN) PII | pii, persons | AU | The tax file number (TFN) is a unique identifier issued by the Australian Taxation Office to each taxpaying entity — an individual,... |
| be_iban | Belgian IBAN | finances | BE | International Bank Account Number of a bank account in Belgium. It has 16 characters: BE, two IBAN check digits and the 12 digits of the... |
| be_vat | Belgian enterprise number (KBO/BCE, VAT number) | companies, finances | BE | Ondernemingsnummer (numéro d'entreprise, Unternehmensnummer), the 10-digit number of a company, association, public body or... |
| bg_egn | Bulgarian unified civil number (EGN) PII draft | pii, persons | BG | Единен граждански номер, the 10-digit personal number of Bulgarian citizens. The first six digits encode the date of birth (the month is... |
| bg_pnf | Bulgarian personal number of a foreigner (LNCh) PII draft | pii, persons | BG | Личен номер на чужденец, the 10-digit personal number given to foreigners who live in Bulgaria. The last digit is a weighted check digit. |
| bg_vat | Bulgarian VAT identification number PII draft | finances, companies | BG | Bulgarian VAT identification number (ДДС номер). It is BG followed by 9 digits for legal entities or 10 digits for individuals,... |
| bic | SWIFT/BIC code draft | finances | global | Datatype for 'SWIFT/BIC code' (bic) from rules in context 'finances'. |
| brcpf | CPF number (Cadastro de Pessoas Fisicas) PII | pii, persons | BR | The CPF number (Cadastro de Pessoas Fisicas; Portuguese for Natural Persons Register) is the Brazilian individual taxpayer registry,... |
| bsn | Dutch citizen service number (BSN) PII | pii, persons, finances | NL | Burgerservicenummer (BSN), the personal number of everyone registered in the Dutch population register (BRP). It replaced the sofinummer... |
| by_unp | Belarusian payer account number (UNP) PII draft | finances | BY | Учетный номер плательщика, the 9-character tax number that Belarus gives to organisations and individuals. Organisations have nine... |
| cabn | Canada Business Number | finances | CA | CA datatype for 'Canada Business Number' (cabn) from rules in context 'finances'. |
| casin | Canada social insurance number (SIN) PII | pii, persons | CA | Social insurance number (SIN) is a number issued in Canada to administer various government programs. |
| casrn | CAS Registry Number draft | chemistry | global | Identifier that the Chemical Abstracts Service (CAS) gives to a chemical substance: two to seven digits, a hyphen, two digits, a hyphen... |
| ch_esr | Swiss payment slip reference number (ESR, QR reference) draft | finances | CH | Reference number of Swiss inpayment slips (ESR/ISR, Einzahlungsschein mit Referenznummer), also used as the QR reference of QR-bills. It... |
| chahv | Swiss AHV Number PII | pii, persons | CH | Swiss AHV (Alters- und Hinterlassenenversicherung) social security number |
| chuid | Swiss UID | finances | CH | Swiss UID (Unternehmens-Identifikationsnummer) - Swiss business identification number |
| cif | CIF por nombre de campo PII | finances | ES | ES datatype for 'CIF por nombre de campo' (cif) from rules in context 'finances'. The CIF (Código de Identificación Fiscal) is a Spanish... |
| cl_rut | Chilean tax number (RUT, RUN) PII draft | finances, pii | CL | Rol Único Tributario, the Chilean tax number. For people it is the same as the RUN (Rol Único Nacional), the national identification... |
| cnpj | Brazilian CNPJ (Cadastro Nacional de Pessoa Jurídica) by known name | finances | BR | Brazilian CNPJ (Cadastro Nacional de Pessoa Jurídica) by known name identifier |
| co_nit | Colombian tax identification number (NIT) PII draft | finances | CO | Número de Identificación Tributaria, the tax number of businesses and other taxpayers in Colombia, also called the RUT number (Registro... |
| country | Country code or name | geo | global | A country is a distinct territorial body or political entity. It may be an independent sovereign state or part of a larger state,[2] as... |
| cr_cpf | Costa Rican physical person ID number (cédula de identidad) PII draft | pii, persons | CR | Cédula de Persona Física, also called cédula de identidad, the identity number of people in Costa Rica. It has ten digits in the form... |
| cr_cpj | Costa Rican legal person ID number (cédula jurídica) draft | companies | CR | Cédula de Persona Jurídica, the tax identifier of legal entities in Costa Rica. It has ten digits: a class digit (2 to 5), a 3-digit... |
| cr_cr | Costa Rican foreigner residence ID number (DIMEX) PII draft | pii, persons | CR | Cédula de Residencia, also called DIMEX (Documento de Identificación Migratorio para Extranjeros), the identifier of foreigners in Costa... |
| cu_ni | Cuban identity card number PII draft | pii, persons | CU | Número de identidad, the 11-digit national identifier printed on the identity card of Cuban residents. It begins with the date of birth... |
| cuit | Argentine CUIT (Clave Única de Identificación Tributaria) by known name | finances | AR | Argentine CUIT (Clave Única de Identificación Tributaria) by known name identifier |
| curp | Mexican CURP (Clave Única de Registro de Población) by known name PII | common | MX | Mexican CURP (Clave Única de Registro de Población) by known name identifier |
| currency | Currency | finances | global | A currency in the most specific sense is money in any form when in use or circulation as a medium of exchange, especially circulating... |
| cusip | CUSIP (Committee on Uniform Securities Identification Procedures) | finances, identifiers | US, CA | A CUSIP is a nine-digit numeric (e.g. 037833100 for Apple) or nine-character alphanumeric (e.g. 38259P508 for Google) code that... |
| cy_vat | Cypriot VAT number draft | finances | CY | Αριθμός Εγγραφής Φ.Π.Α., the VAT registration number in Cyprus: eight digits and a check letter. |
| cz_dic | Czech VAT number (DIČ) PII draft | finances | CZ | Daňové identifikační číslo (DIČ), the Czech tax identification number, also used as the VAT (DPH) number. It is CZ followed by a base... |
| cz_rc | Czech birth number (rodné číslo) PII draft | pii, persons | CZ | Rodné číslo, the Czech personal number; Slovakia uses the same scheme. The first six digits are the date of birth as YYMMDD. Women have... |
| date | Date | datetime | global | Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype. |
| datetime | Date and time | datetime | global | Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an... |
| de_stnr | German tax number (Steuernummer) PII draft | finances | DE | Steuernummer (St.-Nr.), the number that a regional German tax office gives to taxable individuals and organisations. The regional form... |
| de_wkn | German securities identification number (WKN) | finances | DE | Wertpapierkennnummer, the 6-character code of digits and capital letters (without I and O) that identifies securities in Germany. It has... |
| deust | German VAT identification number (USt-IdNr.) PII | finances | DE | Umsatzsteuer-Identifikationsnummer (USt-IdNr.), the VAT identification number that the Federal Central Tax Office (BZSt) issues to... |
| dk_cvr | Danish business registration number (CVR) draft | companies, finances | DK | CVR-nummer, the 8-digit number of a business in the Danish Central Business Register. With the DK prefix it is also the VAT number... |
| dkcprnum | CPR-Number, Personal identification number (Denmark) PII | pii, persons | DK | The Danish Personal Identification number is a national identification number, which is part of the personal information stored in the... |
| do_cedula | Dominican Republic identity number (cédula) PII draft | pii, persons | DO | Cédula de identidad y electoral, the 11-digit identification number that the Dominican Republic gives to citizens and residents. It is... |
| do_ncf | Dominican Republic fiscal receipt number (NCF) draft | finances | DO | Número de Comprobante Fiscal, the number of invoices and other tax documents in the Dominican Republic. Current numbers have 11... |
| do_rnc | Dominican Republic taxpayer registration number (RNC) draft | companies, finances | DO | Registro Nacional del Contribuyente, the 9-digit tax number of companies and institutions in the Dominican Republic. It ends with a... |
| ean | European Article Number (EAN-13, EAN-8) | gs1, objectids | global | GS1 barcode number of a trade item, the form of the GTIN printed under EAN-13 and EAN-8 barcodes on retail goods, books, music releases... |
| ec_ci | Ecuadorian identity card number (cédula) PII draft | pii, persons | EC | Cédula de identidad, the 10-digit number that identifies citizens of Ecuador. The first two digits are a province code and the last... |
| ec_ruc | Ecuadorian taxpayer number (RUC) PII draft | finances | EC | Registro Único de Contribuyentes, the 13-digit tax number in Ecuador. The third digit shows the kind of taxpayer: below 6 for natural... |
| ee_ik | Estonian personal identification code (isikukood) PII draft | pii, persons | EE | Isikukood, the 11-digit personal code in Estonia. The first digit gives the sex and the century of birth, the next six the date of birth... |
| ee_kmkr | Estonian VAT number (KMKR) draft | finances | EE | KMKR number (käibemaksukohustuslase registreerimisnumber), the 9-digit VAT registration number in Estonia. The last digit is a check digit. |
| ee_registrikood | Estonian organisation registration code (registrikood) draft | companies | EE | Registrikood, the 8-digit code that the Estonian registers give to organisations. Commercial companies start with 1, state and local... |
| Email address PII | common, internet, pii | global | Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,... | |
| es_ccc | Spanish bank account code (CCC) draft | finances | ES | Código Cuenta Cliente, the 20-digit Spanish bank account number: a 4-digit bank code, a 4-digit office code, two check digits and a... |
| es_cups | Spanish energy supply point code (CUPS) draft | industry | ES | Código Unificado de Punto de Suministro, the identifier of an electricity or piped gas supply point in Spain. It has 20 or 22... |
| es_dni | Spanish national identity document number (DNI) PII draft | pii, persons | ES | Documento Nacional de Identidad, the identity number of Spanish citizens: eight digits and a check letter, which is the number modulo 23... |
| es_iban | Spanish IBAN draft | finances | ES | International Bank Account Number of a bank account in Spain. It has 24 characters: ES, two IBAN check digits and the 20-digit CCC. |
| es_referenciacatastral | Spanish cadastral reference (referencia catastral) draft | realestate | ES | Referencia catastral, the 20-character identifier that the Spanish Directorate General for Cadastre gives to a real estate property. It... |
| esnie | Spanish Foreigner Identity Number (NIE) PII | pii, persons | ES | The NIE is a tax identification number in Spain, known in Spanish as the NIE, or more formally the Numero de identidad de extranjero |
| esnif | Spanish Tax identification number PII | pii, persons | ES | Spanish tax identification number used to identify tax paying individuals |
| eu_at_02 | SEPA creditor identifier (AT-02) draft | finances | EU | Creditor identifier of SEPA direct debits (data element AT-02 of the SEPA rulebooks, Creditor Scheme Identification in ISO 20022). It... |
| eu_banknote | Euro banknote serial number draft | finances | EU | Serial number printed on euro banknotes. Notes of the first series have one letter and eleven digits; notes of the Europa series have... |
| eu_eic | Energy Identification Code (EIC) draft | industry | EU | Energy Identification Code, the 16-character code of the European electricity and gas sector for market participants, areas, metering... |
| eu_nace | NACE code (EU classification of economic activities) draft | industry | EU | Code of NACE, the Statistical Classification of Economic Activities in the European Community and the EU version of the UN ISIC... |
| fi_alv | Finnish VAT number (ALV) draft | finances | FI | Arvonlisäveronumero, the Finnish VAT number: the FI prefix and the 8-digit business ID (Y-tunnus) without its hyphen. The last digit is... |
| fi_associationid | Finnish association register number draft | companies | FI | Number of an association in the Finnish Register of Associations. It has one to six digits, often written with a dot before the last... |
| fi_hetu | Finnish personal identity code (HETU) PII draft | pii, persons | FI | Henkilötunnus, the personal identity code of people registered in Finland. It is the date of birth (DDMMYY), a century sign (+ for the... |
| fi_veronumero | Finnish individual tax number (veronumero) PII draft | pii, persons | FI | Veronumero, the 12-digit tax number given to people who work in the construction industry in Finland. It is separate from the personal... |
| fi_ytunnus | Finnish business ID (Y-tunnus) draft | companies | FI | Y-tunnus (yritys- ja yhteisötunnus, in Swedish FO-nummer), the business identity code of companies and organisations in Finland: seven... |
| figi | Financial Instrument Global Identifier (FIGI) | finances | global | The Financial Instrument Global Identifier (FIGI) (formerly Bloomberg Global Identifier (BBGID)) is an open standard, unique identifier... |
| fr_nif | French tax identification number (numéro fiscal) PII draft | finances, pii | FR | Numéro fiscal de référence, also called NIF or SPI number, the 13-digit number that the French tax administration gives to each person... |
| frnir | French social security number (NIR) PII | pii, persons | FR | French national identification number (numéro d'inscription au répertoire, NIR), known as the social security number. INSEE assigns it... |
| frvat | French VAT number (numéro de TVA intracommunautaire) PII | finances | FR | Numéro de TVA intracommunautaire, the VAT identification number of businesses in France: FR, a 2-character key and the 9-digit SIREN... |
| gb_upn | English unique pupil number (UPN) PII draft | pii, persons, education | GB | Unique Pupil Number, the 13-character code of a pupil in English state schools. It is a check letter, a 3-digit local authority number,... |
| gb_vat | UK VAT registration number draft | finances | GB | VAT registration number of businesses in the United Kingdom and the Isle of Man. The standard form has nine digits with a weighted... |
| geopoint | Geopoint draft | geo | global | Basic geopoint as coordinates |
| gr_amka | Greek social security number (AMKA) PII draft | pii, persons | GR | Αριθμός Μητρώου Κοινωνικής Ασφάλισης, the 11-digit social security registration number in Greece. It begins with the date of birth... |
| gr_vat | Greek tax number (AFM) PII draft | finances | GR | Αριθμός Φορολογικού Μητρώου (ΑΦΜ), the 9-digit tax registration number of individuals and businesses in Greece. With the EL prefix it is... |
| grid_release | Global Release Identifier (GRid) draft | media | global | Global Release Identifier, used to identify releases of digital sound recordings and other music products distributed electronically. It... |
| gt_nit | Guatemalan tax number (NIT) PII draft | finances | GT | Número de Identificación Tributaria, the tax identifier of the Guatemalan tax authority (SAT). It has 2 to 12 characters: digits and a... |
| handelsregisternr | German commercial register number (Handelsregisternummer) | companies, finances | DE | Number of an entry in the German commercial register (Handelsregister), which the local courts (Amtsgerichte) keep. It is the register... |
| hr_oib | Croatian personal identification number (OIB) PII draft | finances, pii | HR | Osobni identifikacijski broj, the 11-digit identification number of persons and legal entities in Croatia. It holds no personal... |
| hu_anum | Hungarian VAT number (ANUM) draft | finances | HU | Közösségi adószám, the Hungarian EU VAT number: the HU prefix and an 8-digit taxpayer number with a weighted check digit. |
| iban | International Bank Account Number | finances | global | The International Bank Account Number (IBAN) is an internationally agreed system of identifying bank accounts across national borders to... |
| idcard | Chinese ID card (身份证) by known name PII | pii, persons | CN | Citizen identification number of the People's Republic of China, printed on the Resident Identity Card (居民身份证). Since 1999 it has 18... |
| idnpwp | Indonesian NPWP | finances | ID | Indonesian taxpayer identification number (NPWP). The older form has 15 digits, written as XX.XXX.XXX.X-XXX.XXX; since 2024 the NPWP has... |
| ie_pps | Irish Personal Public Service number (PPS) PII draft | pii, persons | IE | Personal Public Service Number, the identifier for social welfare, public services and tax in Ireland. It has seven digits and a check... |
| ie_vat | Irish VAT number draft | finances | IE | VAT registration number in Ireland. It has eight or nine characters: seven digits and one or two letters. An older form has a letter or... |
| il_hp | Israeli company number draft | companies | IL | Mispar ḥevra (מספר חברה, short ח.פ.), the 9-digit registration number of a corporation in Israel. Companies start with 5, and the first... |
| il_idnr | Israeli identity number (Mispar Zehut) PII draft | pii, persons | IL | Mispar Zehut (מספר זהות), the 9-digit identity number given to Israeli citizens at birth. The last digit is a Luhn check digit; leading... |
| imei | International Mobile Equipment Identity (IMEI) PII | telecom, pii | global | Number that identifies a mobile device of 3GPP networks (GSM, UMTS, LTE, 5G) and of some satellite networks. It has 15 digits; the... |
| imonumber | IMO ship Number | transport | global | The International Maritime Organization (IMO) number is a unique identifier for ships, registered ship owners and management companies. |
| imsi | International Mobile Subscriber Identity (IMSI) PII | telecom, pii | global | Number stored on a SIM card that identifies a subscription in a mobile network (3GPP TS 23.003, ITU-T E.212). It starts with the 3-digit... |
| ipaddr | IP address (IPv4 or IPv6) PII | internet, pii | global | Address of a network interface in the Internet Protocol: a 32-bit IPv4 address in dotted-decimal form (192.0.2.1) or a 128-bit IPv6... |
| ipv4 | IPv4 address PII | internet, pii | global | 32-bit address of Internet Protocol version 4 (RFC 791), written in dotted-decimal notation as four numbers from 0 to 255, such as... |
| ipv6 | IPv6 address PII | internet, pii | global | 128-bit address of Internet Protocol version 6, written as eight groups of up to four hexadecimal digits separated by colons (RFC 4291,... |
| is_kennitala | Icelandic identity number (kennitala) PII draft | pii, persons | IS | Kennitala, the 10-digit identity code of individuals and organisations in Iceland. It starts with a date (DDMMYY; organisations add 40... |
| is_vsk | Icelandic VAT number (VSK) draft | finances | IS | Virðisaukaskattsnúmer, the VAT number in Iceland: five or six digits, sometimes written with the IS prefix. |
| isan | International Standard Audiovisual Number (ISAN) draft | media | global | ISO 15706 identifier of audiovisual works, such as films and episodes. It is hexadecimal: a 12-digit root and a 4-digit episode or part,... |
| isbn10 | International Standard Book Number 10-digits (ISBN10) | objectids, publishing | global | 10-digit International Standard Book Number, used for books published before 2007. The last character is a check digit (0-9 or X). |
| isbn13 | International Standard Book Number 13-digits (ISBN13) | objectids, publishing | global | 13-digit International Standard Book Number, used since 2007. It starts with the prefix 978 or 979. |
| isil | International Standard Identifier for Libraries (ISIL) draft | publishing | global | ISO 15511 identifier of libraries, archives, museums and related organisations. It has up to 15 characters: a prefix (a 2-letter country... |
| isin | International Securities Identification Number | finances | global | An International Securities Identification Number (ISIN) uniquely identifies a security. Its structure is defined in ISO 6166. The ISIN... |
| ismn | International Standard Music Number (ISMN) draft | publishing, media | global | ISO 10957 identifier of notated (printed) music. The current form has 13 digits starting with 979-0; the older 10-character form starts... |
| issn | International Standard Serial Number (ISSN) | objectids, publishing | global | The International Standard Serial Number (ISSN) is an eight-digit serial number used to uniquely identify a serial publication, such as... |
| it_aic | Italian medicine authorisation code (AIC) draft | medical | IT | Codice AIC (autorizzazione all'immissione in commercio), the code that the Italian Medicines Agency (AIFA) gives to each medicine pack... |
| it_codicefiscale | Italian tax code (codice fiscale) PII draft | pii, persons | IT | Codice fiscale, the tax code of people in Italy, issued by the Agenzia delle Entrate: 16 characters derived from the surname, the first... |
| it_iva | Italian VAT number (partita IVA) draft | finances | IT | Partita IVA, the 11-digit VAT number in Italy: seven digits that identify the taxpayer, a 3-digit tax office code (mostly the province... |
| jp_cn | Japanese corporate number (hōjin bangō) draft | companies | JP | 法人番号 (hōjin bangō), the 13-digit Corporate Number that the National Tax Agency gives to corporations, government bodies and other... |
| krbusinessreg | Korean business registration number by field name | finances | KR | Korean business registration number by field name identifier |
| krrrn | Korean RRN by field name PII | pii, persons | KR | Korean RRN by field name identifier |
| lei | Legal Entity Identifier | companies | global | The Legal Entity Identifier (LEI) is a unique global identifier for legal entities participating in financial transactions. Also known... |
| li_peid | Liechtenstein personal identification number (PEID) PII draft | finances | LI | Personenidentifikationsnummer, a numeric code of up to 12 digits that identifies individuals and entities in Liechtenstein, used as the... |
| lt_asmens | Lithuanian personal code (asmens kodas) PII draft | pii, persons | LT | Asmens kodas, the 11-digit personal code in Lithuania. The first digit gives the sex and the century of birth, the next six the date of... |
| lt_pvm | Lithuanian VAT number (PVM) draft | finances | LT | PVM mokėtojo kodas, the VAT code in Lithuania: nine digits for legal entities or twelve digits for temporarily registered taxpayers,... |
| lu_tva | Luxembourg VAT number draft | finances | LU | Numéro d'identification à la taxe sur la valeur ajoutée, the 8-digit VAT number in Luxembourg. The last two digits are check digits. |
| lv_pvn | Latvian VAT number (PVN) PII draft | finances | LV | PVN reģistrācijas numurs, the 11-digit VAT number in Latvia. For legal entities the first digit is greater than 3; for natural persons... |
| mc_tva | Monaco VAT number draft | finances | MC | VAT number (numéro de TVA) of businesses in Monaco, which belongs to the French VAT territory. It has the French format, FR followed by... |
| md_idno | Moldovan state identification number (IDNO) draft | companies | MD | IDNO (numărul de identificare de stat), the 13-digit identifier of legal entities in Moldova. It holds a registry digit, three digits... |
| me_iban | Montenegrin IBAN draft | finances | ME | International Bank Account Number of a bank account in Montenegro. It has 22 characters: ME, two IBAN check digits, a 3-digit bank code,... |
| meid | Mobile Equipment Identifier (MEID) PII draft | telecom, pii | global | 56-bit identifier of CDMA mobile devices that replaced the 32-bit ESN (esn). It is written as 14 hexadecimal characters or as an... |
| mt_vat | Maltese VAT number draft | finances | MT | VAT registration number in Malta: eight digits, the first not 0, with a weighted check. |
| mu_nid | Mauritian national identity number PII draft | pii, persons | MU | National identity number of people in Mauritius, given at birth and printed on the National Identity Card. It has 14 characters: the... |
| my_nric | Malaysian identity card number (NRIC) PII draft | pii, persons | MY | National Registration Identity Card number (MyKad number) of Malaysian citizens and permanent residents. It has twelve digits: the date... |
| nl_brin | Dutch school identification number (BRIN) | education | NL | BRIN number (Basisregistratie Instellingen), the code of a school or other education institution in the Netherlands, kept by the Dienst... |
| nl_onderwijsnummer | Dutch education number (onderwijsnummer) PII | pii, persons, education | NL | Onderwijsnummer, the 9-digit number that the Dienst Uitvoering Onderwijs (DUO) gives to a pupil or student in government-funded... |
| nl_postcode | Dutch postal code PII | geo | NL | Postcode in the Netherlands: four digits, the first not 0, a space and two capital letters, from 1000 AA upwards. The letter pairs SA,... |
| nlbtw | Dutch VAT identification number (btw-id) PII | finances | NL | Btw-identificatienummer, the VAT identification number of businesses in the Netherlands: NL, nine digits, the letter B and a 2-digit... |
| no_fodselsnummer | Norwegian national identity number (fødselsnummer) PII draft | pii, persons | NO | Fødselsnummer, the 11-digit national identity number in Norway, kept in the National Population Register by the Norwegian Tax... |
| no_iban | Norwegian IBAN draft | finances | NO | International Bank Account Number of a bank account in Norway. It has 15 characters: NO, two IBAN check digits and the 11-digit account... |
| no_kontonr | Norwegian bank account number (kontonummer) draft | finances | NO | Kontonummer, the 11-digit bank account number in Norway: a 4-digit bank code, six digits for the account and a modulo 11 check digit. It... |
| no_mva | Norwegian VAT number (MVA) draft | finances | NO | Merverdiavgift (MVA) number, the VAT number of Norwegian businesses: the 9-digit organisation number followed by MVA. |
| no_orgnr | Norwegian organisation number (organisasjonsnummer) draft | companies | NO | Organisasjonsnummer, the 9-digit number of a legal entity in the Norwegian Central Coordinating Register for Legal Entities... |
| nz_bankaccount | New Zealand bank account number draft | finances | NZ | Bank account number in New Zealand: two digits for the bank, four for the branch, seven for the account base number and two or three for... |
| nz_ird | New Zealand IRD number PII draft | finances | NZ | Inland Revenue Department number (Te Tari Taake), the tax number of individuals and businesses in New Zealand. It has eight or nine... |
| p2pkhaddr | Bitcoin P2PKH address | cryptocurrency | global | Legacy Bitcoin address of the pay-to-public-key-hash (P2PKH) type. It is the Base58Check encoding of the version byte 0 and the 20-byte... |
| p2shaddr | Bitcoin P2SH address | cryptocurrency | global | Bitcoin address of the pay-to-script-hash (P2SH) type, defined by BIP 13 and BIP 16. It is the Base58Check encoding of the version byte... |
| p2wpkhaddr | Bitcoin P2WPKH address (native SegWit, bc1q) | cryptocurrency | global | Native SegWit address of the pay-to-witness-public-key-hash (P2WPKH) type: witness version 0 with a 20-byte public key hash (BIP 141),... |
| p2wshaddr | Bitcoin P2WSH address (native SegWit, bc1q) | cryptocurrency | global | Native SegWit address of the pay-to-witness-script-hash (P2WSH) type: witness version 0 with the 32-byte SHA-256 hash of a witness... |
| pan | Indian PAN (Permanent Account Number) by known name PII | pii, persons | IN | Indian PAN (Permanent Account Number) by known name identifier |
| pe_cui | Peruvian identity number (CUI) PII draft | pii, persons | PE | Cédula Única de Identidad, the 8-digit personal number on the Peruvian national identity document (DNI). It can be followed by a check... |
| pe_ruc | Peruvian taxpayer number (RUC) PII draft | finances | PE | Registro Único de Contribuyentes, the 11-digit tax number of companies and individuals in Peru. The first two digits give the kind of... |
| phone | Phone number PII | pii, common, telecom | global | Telephone number in standard format (RFC3966), without 'tel:' prefix |
| plnip | Polish tax identification number (NIP) PII draft | finances | PL | Numer identyfikacji podatkowej, the 10-digit tax identification number in Poland. Businesses, including sole traders, use it in tax... |
| plpesel | Polish PESEL by field name PII | pii, persons | PL | Polish PESEL by field name identifier |
| plregon | Polish REGON by field name draft | common | PL | Polish REGON by field name identifier |
| pt_nif | Portuguese tax identification number (NIF) PII draft | finances, pii | PT | Número de identificação fiscal, the 9-digit tax number of individuals and legal persons in Portugal (for legal persons also called... |
| py_ruc | Paraguayan taxpayer number (RUC) PII draft | finances | PY | Registro Único del Contribuyente, the tax number of persons and legal entities in Paraguay. Legal entities have eight digits starting... |
| rfc | Mexican RFC (Registro Federal de Contribuyentes) by known name PII | finances | MX | Mexican RFC (Registro Federal de Contribuyentes) by known name identifier |
| ro_cf | Romanian VAT code (CF) PII draft | finances | RO | Cod de înregistrare în scopuri de TVA, the VAT registration code in Romania: the company identifier (CUI) of 2 to 10 digits, usually... |
| ro_cnp | Romanian personal numerical code (CNP) PII draft | pii, persons | RO | Cod numeric personal, the 13-digit personal identifier in Romania. It encodes the sex and century of birth, the date of birth (YYMMDD),... |
| ro_cui | Romanian company identifier (CUI, CIF) draft | companies, finances | RO | Codul unic de înregistrare, also called codul de identificare fiscală (CIF), the fiscal identifier of companies and other entities in... |
| ro_onrc | Romanian trade register number (ONRC) draft | companies | RO | Registration number in the Romanian Trade Register (Oficiul Național al Registrului Comerțului). The old form is a letter for the kind... |
| sedol | SEDOL identifier | finances | GB, IE | SEDOL stands for Stock Exchange Daily Official List, a list of security identifiers used in the United Kingdom and Ireland for clearing purposes. |
| sirencode | SIREN Code | companies | FR | SIREN codes are given to French businesses and nonprofit associations, SIRET codes to their establishments and facilities. SIREN codes... |
| siretcode | SIRET Code | geo | FR | The SIRET code (French: Système d’identification du répertoire des établissements), or SIRET number,[1] is an INSEE code which allows... |
| steuerid | German tax identification number (Steuer-ID, IdNr.) PII | finances, pii | DE | Steuerliche Identifikationsnummer (IdNr., Steuer-ID), the personal tax number that the Federal Central Tax Office (BZSt) assigns once to... |
| swiftcode | Bank SWIFT code (ISO 9362) | finances | global | ISO 9362 defines a standard format of Business Identifier Codes (also known as SWIFT-BIC, BIC, SWIFT ID or SWIFT code) approved by the... |
| taxid | Chinese tax ID (统一社会信用代码) by known name | finances | CN | Chinese tax ID (统一社会信用代码) by known name identifier |
| uknhsnum | UK NHS Number PII | pii, persons, medical | GB | NHS numbers are the unique numbers allocated to registered users of the three public health services in England, Wales and the Isle of... |
| ukutr | Unique Taxpayer Reference (UTR) PII | pii, persons | GB | A UTR (unique taxpayer reference) number is a 10-digit number completely unique to each and every UK taxpayer. |
| url | Uniform Resource Locator (URL) | common, internet | global | Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query... |
| vatin | EU VAT ID | companies | EU | A value-added tax identification number or VAT identification number (VATIN) is an identifier used in many countries, including the... |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/etl/dataprep.yamlon GitHub