MeridianMERIDIAN

US Employer Identification Number

identity.government.ein

9-digit number assigned by the IRS to business entities for tax identification. Format: XX-XXXXXXX (2 digits, hyphen, 7 digits).

Casts to
VARCHAR
Scope
Locale-specific
Locales
EN_US

Shape

Pattern
^\d{2}-\d{7}$
ValueLengthShape
12-345678910matches
91-123456710matches
20-567890110matches
47-890123410matches
12-3456789rejected: one character short

Background

Origin

An Employer Identification Number (EIN) is a nine-digit number that the IRS assigns in the format XX-XXXXXXX.[1] The IRS describes the EIN as a federal tax ID number for businesses, tax-exempt organisations and other entities.[2] The IRS uses the number to identify taxpayers that are required to file various business tax returns.[1] The EIN system was created by the IRS in 1974 by Treasury Decision 7306.[3] The provision behind it was first enacted as part of the revision of the Tax Code in 1954.[3]

Use

EINs are used by employers, sole proprietors, corporations, partnerships, non-profit associations, trusts, estates of decedents, government agencies, certain individuals and other business entities.[1] The IRS says you need an EIN if you have employees.[2] For employee plans, a letter (for example P) or the plan number (for example 003) may follow the EIN.[1] If a business does not yet have its EIN when a return is due, the IRS tells it to write Applied For and the date it applied in the space for the number.[1] Expect the literal text Applied For, and suffixed plan identifiers, in an EIN column taken from filings, and handle them before you validate. (Meridian's view)

An EIN is usually written in the form 00-0000000, while a Social Security number is usually written as 000-00-0000.[3] In some cases, such as a sole proprietorship, an SSN may be used as a business tax ID.[3] Once an EIN has been issued to an entity, it will never be reissued.[3] Strip or add the hyphen consistently before joining two sources, since one may write 01-0548657 and the other 010548657. (Meridian's view)

Where you'll meet it

The IRS's Exempt Organizations Business Master File Extract is published as CSV files whose records are sorted by Employer Identification Number.[4]

Sources

  1. [1]Publication 1635 (Rev. 2-2014)documentation
  2. [2]Employer identification number | Internal Revenue Servicedocumentation
  3. [3]Employer Identification Numbersecondary source
  4. [4]Exempt Organizations Business Master File Extract (EO BMF)dataset

Detection notes

IRS-assigned. First two digits are the campus/service center code. Required for business tax filings, hiring, and bank accounts.

Use it

CLI · DuckDB
$ finetype infer -i "12-3456789" --mode column
→ identity.government.ein

SELECT ft_infer('12-3456789');
-- → 'identity.government.ein'
Cast expression
CAST({col} AS VARCHAR)

Schema

https://meridian.online/schemas/identity.government.ein · Frictionless type string

finetype taxonomy identity.government.ein -o json-schema

Aliases

employer_idtax_id

Type Registry