Tools

Auto-Type

ID autotype

detector

Auto-Type is a research system from Microsoft Research, published at SIGMOD 2018, that builds type-detection functions for rich semantic types. Given a type name and a few example values, it searches open-source code on GitHub for functions that parse or validate the type and synthesizes a detector from them. Its benchmark covers 112 types in 142 test cases. The registry maps the test cases in mappings.autotype, and this list contains the records that have such a mapping.

Website
https://github.com/congy/AutoType
Supported types
83

Supported semantic types

IDNameCategoriesCountriesDescription
abaroutingnum American Banking Association (ABA) routing number finances US In the United States, an ABA routing transit number (ABA RTN) is a nine-digit code printed on the bottom of checks to identify the...
address Address (physical location) PII common, pii, geo global Geographic address, commonly consist of postindex, country, area, town, street and building
asin Amazon Standard Identification Number (ASIN) draft ecommerce global Ten-character code of uppercase letters and digits that Amazon and its partners assign to a product in the Amazon catalog. For a book...
bankcard Bank card (credit/debit card) PII pii, finances global A bank card is typically a plastic card issued by a bank to its clients that performs one or more of a number of services that relate to...
bibcode Bibcode (ADS bibliographic code) draft science, publishing global Nineteen-character identifier of a publication in the NASA Astrophysics Data System (ADS) and other astronomy databases. Its fixed...
ca_fsa Canadian forward sortation area (FSA) draft geo CA First three characters of a Canadian postal code (ca_postcode): letter, digit, letter, for example K1A. A forward sortation area is the...
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...
countrycode_alpha2 ISO 3166-1 Alpha2 country code pattern geo global ISO 3166-1 alpha-2 codes are two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the...
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...
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...
dbsnp_id dbSNP Reference SNP number (rsID) draft science, medical global Identifier of a reference SNP record (RefSNP) in dbSNP, the database of short genetic variations kept by the US National Center for...
doi Digital Object Identifier (DOI) science, identifiers global A digital object identifier (DOI) is a persistent identifier or handle used to identify objects uniquely, standardized by the...
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...
edifact_message_type UN/EDIFACT message type draft ecommerce global Six-letter code that names a standard message of UN/EDIFACT, the United Nations rules for electronic data interchange in trade,...
email 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,...
ensembl_id Ensembl stable ID (gene, transcript or protein) draft science global Stable identifier that the Ensembl genome database gives to a gene, transcript or protein of a vertebrate genome. It is ENS, a...
geopoint Geopoint draft geo global Basic geopoint as coordinates
gln Global Location Number (GLN) geo, gs1 global The Global Location Number (GLN, sometimes also referred to as International Location Number or ILN) of the respective organization,...
gtin Global Trade Item Number 14 industry, objectids, gs1 global Global Trade Item Number (GTIN-14) written as a GS1 element string with Application Identifier (01): '01' followed by the 14 digits of...
hexcolor sRGB color hex triplet (hex color) pattern common global Color written as a hexadecimal sRGB triplet, for example #1F5FBF.
hslcolor HSL color pattern draft common global Color written as hue, saturation and lightness: a hue angle from 0 to 360 degrees and two percentages from 0% to 100%, separated by...
http_status_code HTTP status code draft internet global Three-digit code with which an HTTP server reports the result of a request. The first digit gives the class: 1xx informational, 2xx...
iataairportcode IATA Airport code pattern transport global An IATA airport code, also known as an IATA location identifier, IATA station code, or simply a location identifier, is a three-letter...
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...
icd10 Identifier in the ICD catalogue codes for diseases - Version 10 (ICD-10) medical global ICD-10 is the 10th revision of the International Statistical Classification of Diseases and Related Health Problems (ICD), a medical...
icd9 ICD-9 code draft medical global Code of the Ninth Revision of the International Classification of Diseases (ICD-9) of the World Health Organization, which ICD-10 later...
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...
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.
inchl International Chemical Identifier (InChl) chemistry global International Chemical Identifier (InChI): a textual identifier for chemical substances defined by IUPAC. It starts with 'InChI='.
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,...
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).
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...
iso4217curcode ISO 4217 Currency code pattern draft finances global ISO 4217 Currency code
isrc International Standard Recording Code (ISRC) objectids, publishing, media global ISO 3901 code of one sound recording or music video recording, not of the composition (iswc): every recording, edit and remix of a song...
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...
iswc International Standard Musical Work Code (ISWC) draft objectids, publishing, media global ISO 15707 identifier of a musical work as a composition, apart from its recordings (which have ISRC codes) and editions. It is the...
lcc Library of Congress Classification (LCC) number draft publishing global Class number or call number in the Library of Congress Classification, the subject classification of the US Library of Congress, which...
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...
mac_address MAC address (Media Access Control) PII internet, identifiers, pii global 48-bit hardware address (EUI-48) of a network interface in Ethernet, Wi-Fi, Bluetooth and other IEEE 802 networks, used to deliver...
md5hash MD5 hash cryptography, software global Digest of the MD5 hash function (128 bits), often used as a checksum of a file or as a record fingerprint. MD5 is not...
medication_generic_name Medication generic name draft medical global Non-proprietary (generic) name of a medicine or its active ingredient, such as an International Nonproprietary Name (INN).
mgrs Military Grid Reference System (MGRS) coordinate draft geo global Position written in the Military Grid Reference System of NATO, which is based on UTM. It is a grid zone designator (a UTM zone number...
molformula Molecular Formula chemistry global Molecular formulae indicate the simple numbers of each type of atom in a molecule of a molecular substance.
money Money amount draft values, common global Amount of money as numeric value
monthday Month and day datetime global Defines a part of a date - the month and day. Example (MM-DD).
msisdn Mobile Subscriber ISDN Number (MSISDN) PII telecom, pii global Telephone number of a mobile subscription, which the network links to the IMSI of the SIM card (3GPP TS 23.003). It is an ITU-T E.164...
nanpphone North American phone number (NANP) PII pattern draft pii, common, telecom US, CA Ten-digit telephone number of the North American Numbering Plan (NANP), the shared numbering plan of country code 1 used by the United...
orcid Open Researcher and Contributor ID (ORCID) science, persons global The ORCID, Open Researcher and Contributor ID) is a nonproprietary alphanumeric code to uniquely identify authors and contributors of...
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...
person_fullname Person fullname PII draft persons, pii global Full name of the person as combination of last, first, and sometimes middle name
phone Phone number PII pii, common, telecom global Telephone number in standard format (RFC3966), without 'tel:' prefix
rgbcolor RGB color triplet pattern draft common global Color written as its red, green and blue components: three integers from 0 to 255 separated by commas, either bare (220,220,220) or in...
roman_numeral Roman numeral draft values global Number from 1 to 3999 written in Roman numerals, with the letters I, V, X, L, C, D and M in the standard subtractive form, where IV is 4...
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.
sha1hash SHA-1 hash cryptography, software global Digest of the SHA-1 hash function (160 bits), used for example as a Git object id or a file checksum. SHA-1 is no longer considered...
sha256hash SHA-256 hash cryptography, software global Digest of the SHA-256 hash function (SHA-2 family, 256 bits), widely used for file checksums, content addressing and digital signatures....
smiles SMILES chemical notation draft chemistry, science global Simplified Molecular-Input Line-Entry System (SMILES): a line notation that writes the structure of a molecule as a short ASCII string....
street_address Street address line PII draft geo, pii global First line of a postal address: the house or building number and the street name, such as 10 Downing Street or Unter den Linden 77. The...
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...
tickersymbol Stock ticker symbol finances global Ticker symbol or stock symbol is an abbreviation used to uniquely identify publicly traded shares of a particular stock on a particular...
time Time draft datetime global Time of the day, like 12:00 or 10PM or 11:05 or 18:01:27
uic_wagon_number UIC wagon number (European Vehicle Number) draft transport global Twelve-digit number of a railway vehicle, such as a freight wagon, coach or locomotive, in the numbering system of the International...
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...
ukpostalcode UK Postal code PII pattern geo GB Postal codes used in the United Kingdom, British Overseas Territories and Crown dependencies are known as postcodes (originally, postal codes).
uniprot_id UniProtKB accession number draft science global Stable identifier of a protein entry in the UniProt Knowledgebase (UniProtKB), the protein sequence and function database of the UniProt...
unixtime Digital timestamp (Unix time, Epoch time, Posix time) datetime global Digital timestamp defined as Unix Time. It is a system for describing a point in time. It is the number of seconds that have elapsed...
upc Universal Product Code (UPC) by field name draft gs1 global Universal Product Code (UPC) by field name code
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...
usdeanumber USA DEA Registration (cerficicate) Number PII pii, persons, medical US A DEA number (DEA Registration Number) is an identifier assigned to a health care provider (such as a physician, physician assistant,...
usein US EIN (Employer Identification Number) PII pii, persons US An Employer Identification Number (EIN) is also known as a Federal Tax Identification Number, and is used to identify a business entity....
user_agent HTTP User-Agent string draft internet global Value of the User-Agent header that a browser, crawler, library or other HTTP client sends to describe itself. RFC 9110 defines it as...
usnpi US National Provider Identifier (NPI) PII pii, persons US A National Provider Identifier (NPI) is a unique 10-digit identification number issued to health care providers in the United States by...
usssn US Social Security Number PII pii, persons US In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary...
usstate US State draft geo US Name or code of US State
uszipcode US Postal code PII pattern geo US A ZIP Code is a postal code used by the United States Postal Service (USPS). Introduced in 1963, the basic format consisted of five...
uuid Universally unique identifier (UUID) identifiers global 128-bit identifier that systems generate without a central registry, defined by RFC 9562 (2024), which replaced RFC 4122. Microsoft...
vin Vehicle Identification Number by field name draft transport global Vehicle Identification Number by field name number
yearmonth Year and month datetime global Defines a part of a date - the year and month. Example YYYY-MM.

Use this record