US (United States of America)

Property	Value
A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code	US
Language-specific name. Monolingual name	美国 (zh), Vereinigte Staaten (de), United States of America (en), États-Unis d'Amérique (fr)
Language-specific short name. Monolingual short name	États-Unis (fr), USA (de), USA (en), 美国 (zh)
The offical langauge of a country. Official language	en
Language used in a country, beside the administrative languages. other language	en
Continent a country belongs to. Part of	North America

Regions

Region (controlled vocabulary)	A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code	Language-specific name. Monolingual name
US-AK (Alaska)	US-AK	Alaska (de), Alaska (en), Alaska (fr), 阿拉斯加州 (zh)
US-AL (Alabama)	US-AL	Alabama (de), Alabama (en), Alabama (fr), 亚拉巴马州 (zh)
US-AR (Arkansas)	US-AR	Arkansas (de), Arkansas (en), Arkansas (fr), 阿肯色州 (zh)
US-AS (American Samoa)	US-AS	American Samoa (en)
US-AZ (Arizona)	US-AZ	Arizona (de), Arizona (en), Arizona (fr), 亞利桑那州 (zh)
US-CA (California)	US-CA	California (en), Californie (fr), Kalifornien (de), 加利福尼亚州 (zh)
US-CO (Colorado)	US-CO	Colorado (de), Colorado (en), Colorado (fr), 科羅拉多州 (zh)
US-CT (Connecticut)	US-CT	Connecticut (de), Connecticut (en), Connecticut (fr), 康乃狄克州 (zh)
US-DC (District of Columbia)	US-DC	District of Columbia (de), District of Columbia (en), District of Columbia (fr), 哥伦比亚特区 (zh)
US-DE (Delaware)	US-DE	Delaware (de), Delaware (en), Delaware (fr), 特拉华州 (zh)
US-FL (Florida)	US-FL	Florida (de), Florida (en), Floride (fr), 佛罗里达州 (zh)
US-GA (Georgia)	US-GA	Georgia (de), Georgia (en), Géorgie (fr), 喬治亞州 (zh)
US-GU (Guam)	US-GU	Guam (en)
US-HI (Hawaii)	US-HI	Hawaii (de), Hawaii (en), Hawaï (fr), 夏威夷州 (zh)
US-IA (Iowa)	US-IA	Iowa (de), Iowa (en), Iowa (fr), 艾奥瓦州 (zh)
US-ID (Idaho)	US-ID	Idaho (de), Idaho (en), Idaho (fr), 爱达荷州 (zh)
US-IL (Illinois)	US-IL	Illinois (de), Illinois (en), Illinois (fr), 伊利诺伊州 (zh)
US-IN (Indiana)	US-IN	Indiana (de), Indiana (en), Indiana (fr), 印第安纳州 (zh)
US-KS (Kansas)	US-KS	Kansas (de), Kansas (en), Kansas (fr), 堪薩斯州 (zh)
US-KY (Kentucky)	US-KY	Kentucky (de), Kentucky (en), Kentucky (fr), 肯塔基州 (zh)
US-LA (Louisiana)	US-LA	Louisiana (de), Louisiana (en), Louisiane (fr), 路易斯安那州 (zh)
US-MA (Massachusetts)	US-MA	Massachusetts (de), Massachusetts (en), Massachusetts (fr), 麻薩諸塞州 (zh)
US-MD (Maryland)	US-MD	Maryland (de), Maryland (en), Maryland (fr), 马里兰州 (zh)
US-ME (Maine)	US-ME	Maine (de), Maine (en), Maine (fr), 缅因州 (zh)
US-MI (Michigan)	US-MI	Michigan (de), Michigan (en), Michigan (fr), 密歇根州 (zh)
US-MN (Minnesota)	US-MN	Minnesota (de), Minnesota (en), Minnesota (fr), 明尼蘇達州 (zh)
US-MO (Missouri)	US-MO	Missouri (de), Missouri (en), Missouri (fr), 密蘇里州 (zh)
US-MP (Northern Mariana Islands)	US-MP	Northern Mariana Islands (en)
US-MS (Mississippi)	US-MS	Mississippi (de), Mississippi (en), Mississippi (fr), 密西西比州 (zh)
US-MT (Montana)	US-MT	Montana (de), Montana (en), Montana (fr), 蒙大拿州 (zh)
US-NC (North Carolina)	US-NC	Caroline du Nord (fr), North Carolina (de), North Carolina (en), 北卡罗来纳州 (zh)
US-ND (North Dakota)	US-ND	Dakota du Nord (fr), North Dakota (de), North Dakota (en), 北达科他州 (zh)
US-NE (Nebraska)	US-NE	Nebraska (de), Nebraska (en), Nebraska (fr), 內布拉斯加州 (zh)
US-NH (New Hampshire)	US-NH	New Hampshire (de), New Hampshire (en), New Hampshire (fr), 新罕布什尔州 (zh)
US-NJ (New Jersey)	US-NJ	New Jersey (de), New Jersey (en), New Jersey (fr), 新泽西州 (zh)
US-NM (New Mexico)	US-NM	New Mexico (de), New Mexico (en), Nouveau-Mexique (fr), 新墨西哥州 (zh)
US-NV (Nevada)	US-NV	Nevada (de), Nevada (en), Nevada (fr), 内华达州 (zh)
US-NY (New York)	US-NY	New York (de), New York (en), État de New York (fr), 纽约州 (zh)
US-OH (Ohio)	US-OH	Ohio (de), Ohio (en), Ohio (fr), 俄亥俄州 (zh)
US-OK (Oklahoma)	US-OK	Oklahoma (de), Oklahoma (en), Oklahoma (fr), 奧克拉荷馬州 (zh)
US-OR (Oregon)	US-OR	Oregon (de), Oregon (en), Oregon (fr), 俄勒冈州 (zh)
US-PA (Pennsylvania)	US-PA	Pennsylvania (de), Pennsylvania (en), Pennsylvanie (fr), 宾夕法尼亚州 (zh)
US-PR (Puerto Rico)	US-PR	Puerto Rico (en)
US-RI (Rhode Island)	US-RI	Rhode Island (de), Rhode Island (en), Rhode Island (fr), 羅德島州 (zh)
US-SC (South Carolina)	US-SC	Caroline du Sud (fr), South Carolina (de), South Carolina (en), 南卡罗来纳州 (zh)
US-SD (South Dakota)	US-SD	Dakota du Sud (fr), South Dakota (de), South Dakota (en), 南达科他州 (zh)
US-TN (Tennessee)	US-TN	Tennessee (de), Tennessee (en), Tennessee (fr), 田纳西州 (zh)
US-TX (Texas)	US-TX	Texas (de), Texas (en), Texas (fr), 得克萨斯州 (zh)
US-UM (US Minor Outl. Isl.)	US-UM	US Minor Outl. Isl. (en)
US-UT (Utah)	US-UT	Utah (de), Utah (en), Utah (fr), 猶他州 (zh)
US-VA (Virginia)	US-VA	Virginia (de), Virginia (en), Virginie (fr), 弗吉尼亚州 (zh)
US-VI (Virgin Islands, U.S.)	US-VI	Virgin Islands, U.S. (en)
US-VT (Vermont)	US-VT	Vermont (de), Vermont (en), Vermont (fr), 佛蒙特州 (zh)
US-WA (Washington)	US-WA	Washington (de), Washington (en), Washington (fr), 华盛顿州 (zh)
US-WI (Wisconsin)	US-WI	Wisconsin (de), Wisconsin (en), Wisconsin (fr), 威斯康辛州 (zh)
US-WV (West Virginia)	US-WV	Virginie-Occidentale (fr), West Virginia (de), West Virginia (en), 西維吉尼亞州 (zh)
US-WY (Wyoming)	US-WY	Wyoming (de), Wyoming (en), Wyoming (fr), 怀俄明州 (zh)

Legal forms

Legal form	ELF code	Name	Main abbreviation
US_0444 (CDQ)	US_0444	Domestic Profit (en)	DOMP (en)
US_0917 (CDQ)	US_0917	Domestic Non-Profit (en)	DOMPN (en)
US_0921 (CDQ)	US_0921	Foreign Profit (en)	FORP (en)
US_0966 (CDQ)	US_0966	Foreign Non-Profit (en)	FORNP (en)
US_0969 (CDQ)	US_0969	Domestic Limited Partnership (en)	DOMLP (en)
US_0971 (CDQ)	US_0971	Foreign Limited Partnership (en)	FORLP (en)
US_0976 (CDQ)	US_0976	Florida Limited Liability Co (en)	FLAL (en)
US_0977 (CDQ)	US_0977	Foreign Limited Liability Co (en)	FORL (en)
US_0983 (CDQ)	US_0983	Non-Profit, Registration (en)	NPREG (en)
US_0995 (CDQ)	US_0995	Declaration of Trust (en)	TRUST (en)
US_0999 (CDQ)	US_0999	Designation of Registered Agent (en)	AGENT (en)
US_1151 (CDQ)	US_1151	Company (en)	Co. (en)
US_1579 (CDQ)	US_1579	Limited Liability Partnership (en)	LLP (en)
US_3548 (CDQ)	US_3548	General partnership (en)	GP (en)
US_3911 (CDQ)	US_3911	Incorporated (en)	Inc (en)
US_4039 (CDQ)	US_4039	Sole proprietorship (en)	SP (en)
US_6584 (CDQ)	US_6584	Limited Liability Company (en)	LLC (en)
US_6941 (CDQ)	US_6941	Corporation (en)	Corp (en)
US_8454 (CDQ)	US_8454	Limited partnership (en)	LP (en)

Identifiers

Identifier	Name	Registration authority
BAN_US_SF (San Francisco Business Account Number)	San Francisco Business Account Number (en)	San Francisco Treasurer-Tax Collector
BI_US_AK (State business identifier)	State business identifier (en)
BI_US_CO (State business identifier)	State business identifier (en)
BI_US_CT (State business identifier)	State business identifier (en)
CDN_US_FL (State business identifier)	State business identifier (en)	Florida Department of State's Division of Corporation
CID_NY_US (State business identifier)	State business identifier (en)	Corporation and Business Entity Database (Division of Corporations, State Records and UCC, Department of State)
CIK_US (Central Index Key)	Central Index Key (en)
CN_US_IA (State business identifier)	State business identifier (en)	Business Services Division, Iowa Secretary of State
CUSIP_9 (Committee on Uniform Security Identification Procedures 9-Digit)	Committee on Uniform Security Identification Procedures 9-Digit (en)
EID_US_VA (State entity identifier)	State entity identifier (en)
EN_US_CA (Entity number)	Entity number (en)
FID_US_WY (State business identifier)	State business identifier (en)
IPEDS_ID (Integrated Postsecondary Education Data System ID)	Integrated Postsecondary Education Data System ID (en)	National Center for Education Statistics
LID_US_CH (Chicago Business License ID)	Chicago Business License ID (en)
LIN_US_LA (Los Angeles's Business Location Identification Number)	Los Angeles's Business Location Identification Number (en)	Los Angeles Office of the Treasurer & Tax Collector
LIN_US_SF (San Francisco's Business Location Identification Number)	San Francisco's Business Location Identification Number (en)	Treasurer & Tax Collector, Business Locations, City and County of San Francisco
RN_US_OR (State business identifier)	State business identifier (en)
UBI_US_WS (Unified Business Identifier Number)	Unified Business Identifier Number (en)	Washington State Business License Services
UI_US_SF (San Francisco's Business Unique Identifier)	San Francisco's Business Unique Identifier (en)	Treasurer & Tax Collector, City and County of San Francisco
US_BRN (Business Registration Number)	Business Registration Number (en)	Incorporation Registry, Division of Corporation, Department of State, Florida
US_DEA (DEA Registration Number)	DEA Registration Number (en)	United States Drug Enforcement Administration
US_EMPL_ID (Employer identification number)	Employer identification number (en)	International Revenue Service
US_FTIN (Federal Taxpayer Identification Number)	Federal Taxpayer Identification Number (en)	Internal Revenue Service
US_NPI (National Provider Identifier)	National Provider Identifier (en)	Centers for Medicare and Medicaid Services
US_SAM_ID (Unique Entity ID)	Unique Entity ID (en)
US_SEC_ID (Social security number)	Social security number (en)	Social Security Administration
WR_CUSIP (Committee on Uniform Security Identification Procedures)	Committee on Uniform Security Identification Procedures (en)

Data quality rules

Data quality rule	Description	Criticality
Dummy post code detected (US)	Regular expression/Not available post code Regular expression/One digit multiplied several times post code Regular expression/Ordinal sequence of numbers Regular expression/Single digit post code Regular expression/Very long digits post code. This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for US (United States of America) are the following: Regular expression/Mononumerical post code with delimeter	ERROR
Identifier checkdigit invalid (DEA Registration Number (United States))	This rule checks the checkdigit of DEA Registration Number (United States) according to the following the logic: DEA number without checkdigit: AL455178 To find the checkdigit the following steps are required: Add the first, third, and fifth digits 4 + 5 + 7 = 16 Add the second, fourth, and sixth digits – then multiply x 2 5 + 1 + 8 = 14 x 2 = 28 Add these two totals together 16 + 28 = 44 The second digit of this total number is the check digit, here 4 Any difference results in a violation of this rule	ERROR
Identifier checkdigit invalid (National Provider Identifier (United States))	This rule checks the checkdigit of National Provider Identifier (United States) according to the following the logic: Step 1 - Starting at the right most digit, which should be the check digit. Double the value of every second digit. Step 2 - Take the sum of all the individual digits. Step 2a - If a doubled value is 2-digits (i.e. 8 was doubled to 16), you add the two digits together (i.e. the doubled value of 16 would be: 1 + 6) Step 3 - Add 24 to the value Step 4 - Take the units digit (i.e. if the number was 67, you would take 7). Step 5 - Subtract the units digit from 10. (Do this step only if the units digit isn't zero) Step 6 - The resulting number is the check digit. Any difference results in a violation of this rule	ERROR
Identifier format inaccurate (EIN (United States))	This rule checks the syntax, i.e. format of the Employer identification number (United States) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation. The EIN (USA) consists of exactly 9 numerical digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots then the rule is violated.	INFO
Identifier format inaccurate (Unified Business Identifier Number (United States - Washington))	This rule checks the syntax, i.e. format of the Unified Business Identifier Number (United States - Washington) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation. Unified Business Identifier Number (United States - Washington) consists of 9 digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots then the rule is violated.	INFO
Identifier format invalid (DEA Registration Number (United States))	A DEA number (DEA Registration Number) is an identifier assigned to a health care provider (such as a physician, physician assistant, nurse practitioner, optometrist, podiatrist, dentist, or veterinarian) by the United States Drug Enforcement Administration. DEA numbers consist of two letters, six numbers, and one check digit.	INFO
Identifier format invalid (Employer identification number (United States))	The Employer identification number consists of exactly 9 digits. Prior to 2001, the first two digits of an EIN (the EIN Prefix) indicated the business was located in a particular geographic area. The prefixes as provided here [1] are allowed.	ERROR
Identifier format invalid (National Provider Identifier (United States))	The National Provider Identifier (NPI) is a unique 10-digit identification number. The rule checks for exactly 10 digits!	INFO
Identifier format invalid (Unified Business Identifier Number (United States - Washington))	A UBI number is a 9-digit number that registers you with several state agencies and allows doing business in Washington State. This rule checks presence of exactly 9 digits and prefix without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digits characters then the rule is violated.	INFO
Identifier missing (Employer identification number (United States))	Checks whether there is an Employer identification number maintained for this partner, if not then the rule is violated.	INFO
Identifier missing (Social security number (United States))	...	INFO
Legal form invalid (United States)	Each record should have legal form appropriate for the country.	INFO
Mandatory administrative area missing (United States)	The administrative area is required (i.e. mandatory) for a complete physical touchpoint (usually a street address) in United States of America.	INFO
Mandatory identifier not maintained (United States)	A business partner in US should have at least a Employer identification number (United States) or a state business register ID. If none of these two is available the record is invalid.	ERROR
Mandatory locality missing (United States)	The locality is mandatory for street addresses in United States of America.	ERROR
Mandatory post code missing (United States)	The post code is mandatory for street addresses in United States of America.	ERROR
Mandatory thoroughfare missing (United States)	The thoroughfare is mandatory for street addresses in United States of America.	INFO
Post code format inaccurate (United States)	The US post code can contain a block of 5 digits or, for more accurate delivery, 9 digits in this format: NNNNN-NNNN. This is known as ZIP + 4. In case if the post code still has 5 or 9 digits but in other format then NNNNN-NNNN (a space instead of a hypthen, 9 digits without any delimiter etc.) then the rule is broken.	INFO
Post code format invalid (United States)	This rule checks the post code format of United States. Known as the ZIP code (Zone Improvement Program code), this can contain a block of 5 digits or, for more accurate delivery, 9 digits in this format: NNNNN-NNNN. This is known as ZIP + 4. The rule allows the following formats NNNNN, NNNNN-NNNN, NNNNNNNNN, NNNNN NNNN. Though many companies use the ZIP code as a locational indicator (for example, when assigning local state taxes for mail-ordered items), there are a small number of communities on state borders which have the same ZIP code as a neighbouring community in another state. There is currently legislation in the American senate to give these communities their own ZIP codes. The first three digits of the postal code indicate the routing zone or processing and delivery centre. The next two indicate the post office or delivery section. The first two digits of the code after the hyphen indicate a sector, the final two a segment.	ERROR
Social Security Number identified as Employer Identification Number	The Employer identification number consists of exactly 9 digits likewise the Social security number. As both numbers are usually maintained in the identical SAP field a wrong mapping might easily happen. This rule identifies whether an Employer identification number in the input has a wrong EIN format, and then checks whether it is possible if the number is a social security number purely based on the format of the given value	INFO
Unallowed pattern in name detected (US)	Regular expression/Aggregated payments Regular expression/No new orders Regular expression/Do not use duplicates note Regular expression/Reference to other record Regular expression/No use note Regular expression/Reference to new record Regular expression/Reference the former name Regular expression/Long number in name Regular expression/Duplicate record note Regular expression/Deletion note Regular expression/Dummy record note Regular expression/Sequence of digits Regular expression/Unsorted keywords Regular expression/Length of name . This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for US (United States of America) are the following: Regular expression/One time vendor	ERROR

Data sources

Data quality rule	Name	Content
IRS (data source)	Internal Revenue Service (en) Internal Revenue Service (de)	BUSINESS_PARTNER
US-AK.BER (data source)	Alaska Business Entity Register (en)	BUSINESS_PARTNER
US-CA.BER (data source)	California - Secretary of State (en)	BUSINESS_PARTNER
US-CH.BER (data source)	City of Chicago Business Registry (en)	BUSINESS_PARTNER
US-CO.BER (data source)	Colorado Business Entity Register (en)	BUSINESS_PARTNER
US-CT.BER (data source)	Connecticut Business Registry - Business Master (en)	BUSINESS_PARTNER
US-DC.BER (data source)	City of Washington, District of Columbia Business Registry (en)	BUSINESS_PARTNER
US-DE.BER (data source)	Delaware Business Licenses (United States of America) (en)	BUSINESS_PARTNER
US-FL.BER (data source)	Florida Business Entity Register (en)	BUSINESS_PARTNER
US-IO.BER (data source)	Iowa Business Entity Register (en)	BUSINESS_PARTNER
US-LA.BER (data source)	Listing of Active Businesses - Los Angeles (en)	BUSINESS_PARTNER
US-NY.BER (data source)	New York Business Entity Register (en)	BUSINESS_PARTNER
US-OR.BER (data source)	Oregon Business Entity Register (en)	BUSINESS_PARTNER
US-PA.BER (data source)	Registered Businesses in Pennsylvania (United States of America) (en)	BUSINESS_PARTNER
US-SF.BER (data source)	Registered Business Locations - San Francisco (en)	BUSINESS_PARTNER
US-VA.BER (data source)	Business Entities registered in state of Virginia (United States of America) (en)	BUSINESS_PARTNER
US-WA.BER (data source)	Washington Business Entity Register (en)	BUSINESS_PARTNER
US-WY.BER (data source)	Wyoming Business Entity Register (en)	BUSINESS_PARTNER
US.CHIC.ADDR (data source)	US Chicago addresses (United States) (en)	ADDRESS
US.DETR.ADDR (data source)	US Detroit addresses (United States) (en)	ADDRESS
US.EDU (data source)	Homeland Infrastructure Foundation-Level Data (HIFLD) for Colleges and Universities (en) US Colleges and Universities (de)	BUSINESS_PARTNER
US.HI.EDU (data source)	Homeland Infrastructure Foundation Level Data (en) Homeland Infrastructure Educational Institutions (United States) (en)
US.HI.HOSP (data source)	Homeland Infrastructure Foundation Level Data (en) Homeland Infrastructure Hospitals (United States) (en)
US.HI.SC (data source)	Homeland Infrastructure Foundation Level Data (en) Homeland Infrastructure Supplemental Colleges (United States) (en)
US.HI.SC.PRIV (data source)	Homeland Infrastructure Private Schools (United States) (en)
US.HI.SC.PUB (data source)	Homeland Infrastructure Foundation Level Data (en) Homeland Infrastructure Public Schools (United States) (en)
US.HIPAAS (data source)	HIPAASpace (en)	ADDRESS
US.NPPES (data source)	National Plan & Provider Enumeration System (en)	BUSINESS_PARTNER
US.SEC (data source)	US Securities and Exchange Commission EDGAR Company Filings (en)	BUSINESS_PARTNER
USPS (data source)	United States Postal Service (en)	ADDRESS

Banking metadata

Property	Value
Full metadata	Bank accounts in United States of America
Local name of the national bank ID. Bank ID name	ABA Code
The provider (national authorities in most cases) of the national bank ID. Bank ID provider	Accuity
Currency code for accounting in the given country. Currency code	USD