Form 345 Data Sets

Contents

1... Overview... 1

2... Scope. 1

3... Organization.. 1

4... File Formats. 2

5... Table Definitions. 2

5.1        SUBMISSION.. 2

5.2         REPORTINGOWNER. 2

5.3         NONDERIV_TRANS. 3

5.4         NONDERIV_HOLDING.. 3

5.5        DERIV_TRANS. 3

5.6        DERIV_HOLDING.. 4

5.7         FOOTNOTES. 5

5.8         OWNER_SIGNATURE. 5

6... Appendix. 5

6.1         Timeliness List. 5

6.2         Trans Code List. 5

6.3         U.S. State/Country Codes and Descriptions. 5

 

1                   Overview

Under Section 16 of the Securities Exchange Act of 1934, senior executives, directors, and large-block shareholders are required to make ongoing filings about their company stock holdings to report any changes. These filings are made on Form 3, Form 4, and Form 5 and submitted to SECs Electronic Data Gathering, Analysis, and Retrieval (EDGAR) system. The EDGAR Forms 3, 4, and 5 provide information from corporate insiders (i.e., company's officers and directors, and any beneficial owners of more than ten percent of a class of the company's equity securities registered under Section 12 of the Securities Exchange Act of 1934) file with the SEC a statement of ownership regarding those securities.  The Form 345 data sets are extracted from EDGAR Ownership XML submissions in a flat file format to assist users in constructing the data for analysis.  The data has been automatically and directly taken from submissions created by the registrants and provided as-filed.  The data will be published quarterly. Data contained in documents filed after 5:30pm EST on the last business day of the quarter will be included in the next quarterly posting.

The following table lists the submission types for EDGAR Ownership Forms 3, 4, and 5 filings which are included in the data sets.

 

DOCUMENT TYPE

DESCRIPTION

Form 3

Initial Statement of Beneficial Ownership of Securities

Form 3/A

Amendment of a previous Form 3

Form 4

Statement of Changes of Beneficial Ownership of Securities

Form 4/A

Amendment of a previous Form 4

Form 5

Annual Statement of Beneficial Ownership of Securities

Form 5/A

Amendment of a previous Form 5

 

DISCLAIMER: The Form 345 data sets contain information derived from structured data filed with the Commission by individual registrants as well as Commission-generated filing identifiers. Because the data is derived from information provided by individual registrants, we cannot guarantee the accuracy of the data. In addition, it is possible inaccuracies or other errors were introduced into the data during the process of extracting the data and compiling. Finally, the data does not reflect all available information, including certain metadata associated with Commission filings. The data is intended to assist the public in analyzing data contained in Commission filings; however, it is not a substitute for such filings. Investors should review the full Commission filings before making any investment decision.

2         Scope

The Form 345 data sets consists of XML data submitted from January 2006 through current period.

Note:  EDGAR Technical Specifications provides information on Ownership XML Technical Specifications Document.

3         Organization

Note that the data sets include information "as filed" in EDGAR document submissions including amendments of prior submissions.  Data in this submitted form may contain redundancies, inconsistencies, and discrepancies relative to prior submissions and other publication formats.  There are up to eight (8) data files.  Each quarterly data set is accompanied by a metadata file conforming to the W3C specification for tabular data (https://www.w3.org/TR/2015/REC-tabular-data-model-20151217/) that encodes the following information about the data files and their relationships to each other.

1.       SUBMISSION identifies the XML submissions, filer and issuer information, with each row having the primary key ACCESSION_NUMBER.

2.       REPORTINGOWNER provides details of the reporting owner(s) with each row having ACCESSION_NUMBER and RPTOWNERCIK as the keys.

3.       NONDERIV_TRANS contains the non-derivative transaction information reported in Table I with each row having ACCESSION_NUMBER and NONDERIV_TRANS_SK as the keys.

4.       NONDERIV_HOLDING provides the non-derivative holding information reported in Table I with each row having ACCESSION_NUMBER and NONDERIV_HOLDING_SK as the keys.

5.       DERIV_TRANS contains the derivative transaction information reported in Table II with each row having ACCESSION_NUMBER and DERIV_TRANS_SK as the keys.

6.       DERIV_HOLDING provides the derivative holding information reported in Table II with each row having ACCESSION_NUMBER and DERIV_HOLDING_SK as the keys.

7.       FOOTNOTES provides the footnotes details for a field with each row having ACCESSION_NUMBER and FOOTNOTE_ID as the keys.

8.       OWNER_SIGNATURE data contains the signature information with each row having ACCESSION_NUMBER and OWNERSIGNATURENAME as the keys.

4             File Formats

Each of the eight (8) data files provide text format, tab delimited, UTF-8 encoding.

5             Table Definitions

The fields in the tables below provide the following information: field name, description, data format, maximum field size, an indication of whether or not the field may be NULL (yes or no), and key. 

The Key field indicates whether the field is part of a unique index on the data.  There are two possible values for this field:

·         "*"   Indicates the field is part of the unique key for the row.  

·         Empty (nothing in field) means the field is not part of the unique compound key.

 

5.1         SUBMISSION

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

FILING_DATE

Filing date with the Commission; sourced from EDGAR in (DD-MON-YYYY) format.

DATE

No

 

PERIOD_OF_REPORT

Date of event requiring statement in (DD-MON-YYYY) format.

DATE

No

 

DATE_OF_ORIG_SUB

If the original form is amended, this field corresponds to the date of original filing in (DD-MON-YYYY) format.

DATE

Yes

 

NO_SECURITIES_OWNED

Derived value on Form 3 based on the number of entries in <nonDerativeTable> and <DerativeTable> sections of document.  True (1) for no securities are beneficially owned; otherwise false (0).

VARCHAR (1)

Yes

 

NOT_SUBJECT_SEC16

In a Form 4 or Form 5, true (1) for a reporting person not subject to Section 16 and no transaction or holdings reporting in <nonDerativeTable> and <DerativeTable> sections of document.

VARCHAR (1)

Yes

 

FORM3_HOLDING_REPORTED

EDGAR derived value on Form 5 based on the number of <nonDerivativeHolding> and <derivativeHolding> elements with a <transactionFormType> value of “3.” If at least one “3” holding is being reported, EDGAR will set this element to true (1). Otherwise, it will be set to false (0).

VARCHAR (1)

Yes

 

FORM4_TRANS_REPORTED

EDGAR derived value on Form 5 based on the number of <nonDerivativeTransaction> and <derivativeTransaction> elements with a <transactionFormType> value of “4.” If at least one “4” transaction is being reported, EDGAR will set this element to true (1). Otherwise, it will be set to false (0).

VARCHAR(1)

Yes

 

DOCUMENT_TYPE

Submission type is either an initial filing Form 3, 4, 5 or an amendment of either 3/A, 4/A or 5/A.

VARCHAR (20)

No

 

ISSUERCIK

Central Index Key of issuer.

VARCHAR2 (10)

No

 

ISSUERNAME

Name of the issuer.

VARCHAR2 (150)

No

 

ISSUERTRADINGSYMBOL

Issuer trading symbol.

VARCHAR2 (10)

No

 

REMARKS

Remarks from reporting owner.

VARCHAR2 (2000)

Yes

 

 

5.2         REPORTINGOWNER

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

RPTOWNERCIK

Central Index Key of reporting owner.

VARCHAR2 (10)

No

*

RPTOWNERNAME

Reporting owner name.

VARCHAR2 (150)

No

RPTOWNER_RELATIONSHIP

Reporting owner relationship OFFICER, DIRECTOR, TENPERCENTOWNER, OTHER.

VARCHAR2 (100)

No

RPTOWNER_TITLE

Reporting owner title; required if relationship is ‘DIRECTOR’.

VARCHAR2 (150)

Yes

RPTOWNER_TXT

Additional details for reporting owner relationship 'OTHER'.

VARCHAR2 (50)

Yes

RPTOWNER_STREET1

Reporting owner street address first line.

VARCHAR2 (150)

No

RPTOWNER_STREET2

Reporting owner street address second line.

VARCHAR2 (150)

Yes

RPTOWNER_CITY

Reporting owner city.

VARCHAR2 (150)

No

RPTOWNER_STATE

Reporting owner state or country code.

VARCHAR2 (2)

No

RPTOWNER_ZIPCODE

Reporting owner address zip code.

VARCHAR2 (10)

No

RPTOWNER_STATE_DESC

Description of reporting owner state.

VARCHAR2 (150)

Yes

FILE_NUMBER

File number assigned by the Commission; sourced from EDGAR.

VARCHAR2 (30)

Yes

 

 

5.3        NONDERIV_TRANS

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

NONDERIV_TRANS_SK

Non-derivative transaction surrogate key.

NUMBER(38)

No

*

SECURITY_TITLE

Security title

VARCHAR2 (60)

No

 

SECURITY_TITLE_FN

Security title footnote id.

VARCHAR (150)

Yes

 

TRANS_DATE

Transaction date in (DD-MON-YYYY) format.

DATE

No

 

TRANS_DATE_FN

Transaction date footnote id.

VARCHAR (150)

Yes

 

DEEMED_EXECUTION_DATE

Deemed execution date in (DD-MON-YYYY) format.

DATE

Yes

 

DEEMED_EXECUTION_DATE_FN

Deemed execution date footnote id.

VARCHAR (150)

Yes

 

TRANS_FORM_TYPE

Transaction form type.

VARCHAR2 (1)

Yes

 

TRANS_CODE

Transaction code (values and descriptions are listed in the Appendix section 6.2 Trans Code List).

VARCHAR2 (1)

Yes

 

EQUITY_SWAP_INVOLVED

Indicator to show if the transaction involves an equity swap.

CHAR(1)

Yes

 

EQUITY_SWAP_TRANS_CD_FN

Transaction involving equity swap footnote id.

VARCHAR (150)

Yes

 

TRANS_TIMELINESS

Transaction timeliness (values and meanings are listed in the Appendix section 6.1 Trans Timeliness).

VARCHAR2 (1)

Yes

 

TRANS_TIMELINESS_FN

Transaction timeliness footnote id.

VARCHAR (150)

Yes

 

TRANS_SHARES

Transaction shares reported when Securities Acquired (A) or Disposed of (D).

NUMBER(16,2)

Yes

 

TRANS_SHARES_FN

Transaction shares reported when Securities Acquired (A) or Disposed of (D) footnote id.

VARCHAR (150)

Yes

 

TRANS_PRICEPERSHARE

Price of non-Derivative Transaction Security.

NUMBER(16,2)

Yes

 

TRANS_PRICEPERSHARE_FN

Price of non-Derivative Transaction Security footnote id.

VARCHAR (150)

Yes

 

TRANS_ACQUIRED_DISP_CD

Transaction code reported when Securities Acquired (A) or Disposed of (D).

VARCHAR2 (1)

No

 

TRANS_ACQUIRED_DISP_CD_FN

Transaction code reported when Securities Acquired (A) or Disposed of (D) footnote id.

VARCHAR (150)

Yes

 

SHRS_OWND_FOLWNG_TRANS

Shares owned following reported transaction(s).

NUMBER(16,2)

Yes

 

SHRS_OWND_FOLWNG_TRANS_FN

Shares owned following reported transaction(s) footnote id.

VARCHAR (150)

Yes

 

VALU_OWND_FOLWNG_TRANS

Value owned following reported transaction(s).

NUMBER(16,2)

Yes

 

VALU_OWND_FOLWNG_TRANS_FN

Value owned following reported transaction(s) footnote id.

VARCHAR (150)

Yes

 

DIRECT_INDIRECT_OWNERSHIP

Direct or Indirect ownership.

VARCHAR(5)

No

 

DIRECT_INDIRECT_OWNERSHIP_FN

Direct or Indirect ownership footnote id.

VARCHAR (150)

Yes

 

NATURE_OF_OWNERSHIP

Nature of ownership.

VARCHAR2 (100)

Yes

 

NATURE_OF_OWNERSHIP_FN

Nature of ownership footnote id.

VARCHAR (150)

Yes

 

 

5.4        NONDERIV_HOLDING

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

NONDERIV_HOLDING_SK

Non-derivative holding surrogate key.

NUMBER(38)

No

*

SECURITY_TITLE

Security title.

VARCHAR2 (60)

No

 

SECURITY_TITLE_FN

Security title footnote id.

VARCHAR (150)

Yes

 

TRANS_FORM_TYPE

Transaction form type.

VARCHAR2 (1)

Yes

 

TRANS_FORM_TYPE_FN

Transaction form type footnote id.

VARCHAR (150)

Yes

 

SHRS_OWND_FOLWNG_TRANS

Shares owned following reported transaction(s).

NUMBER(16,2)

Yes

 

SHRS_OWND_FOLWNG_TRANS_FN

Shares owned following transaction(s) footnote id.

VARCHAR (150)

Yes

 

VALU_OWND_FOLWNG_TRANS

Value owned following reported transaction(s) footnote id.

NUMBER(16,2)

Yes

 

VALU_OWND_FOLWNG_TRANS_FN

Value owned following transaction(s) footnote id.

VARCHAR (150)

Yes

 

DIRECT_INDIRECT_OWNERSHIP

Direct or indirect ownership.

VARCHAR2 (5)

No

 

DIRECT_INDIRECT_OWNERSHIP_FN

Direct or indirect ownership footnote id.

VARCHAR (150)

Yes

 

NATURE_OF_OWNERSHIP

Nature of indirect beneficial ownership.

VARCHAR2 (100)

Yes

 

NATURE_OF_OWNERSHIP_FN

Nature of indirect beneficial ownership footnote id.

VARCHAR (150)

Yes

 

 

5.5          DERIV_TRANS

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

DERIV_TRANS_SK

Derivative transaction surrogate key.

NUMBER(38)

No

*

SECURITY_TITLE

Title of derivative security.

VARCHAR2 (60)

No

 

SECURITY_TITLE_FN

Title of derivative security footnote id.

VARCHAR (150)

Yes

 

CONV_EXERCISE_PRICE

Conversion or exercise price.

NUMBER(16,2)

Yes

 

CONV_EXERCISE_PRICE_FN

Conversion or exercise price footnote id.

VARCHAR (150)

Yes

 

TRANS_DATE

Transaction date in (DD-MON-YYYY) format.

DATE

No

 

TRANS_DATE_FN

Transaction date footnote id.

VARCHAR (150)

Yes

 

DEEMED_EXECUTION_DATE

Deemed execution date in (DD-MON-YYYY) format.

DATE

Yes

 

DEEMED_EXECUTION_DATE_FN

Deemed execution date footnote id.

VARCHAR (150)

Yes

 

TRANS_FORM_TYPE

Transaction form type.

VARCHAR2 (1)

Yes

 

TRANS_CODE

Transaction code (values and descriptions are listed in the Appendix section 6.2 Trans Code List).

VARCHAR2 (1)

Yes

 

EQUITY_SWAP_INVOLVED

Indicator to show if the transaction involves an equity swap.

CHAR(1)

Yes

 

EQUITY_SWAP_TRANS_CD_FN

Transaction involving equity swap footnote id.

VARCHAR (150)

Yes

 

TRANS_TIMELINESS

Transaction timeliness (values and meanings are listed in the Appendix section 6.1 Trans Timeliness).

VARCHAR2 (1)

Yes

 

TRANS_TIMELINESS_FN

Transaction timeliness footnote id.

VARCHAR (150)

Yes

 

TRANS_SHARES

Transaction shares reported when Securities Acquired (A) or Disposed of (D).

NUMBER(16,2)

Yes

 

TRANS_SHARES_FN

Transaction shares reported when Securities Acquired (A) or Disposed of (D) footnote id.

VARCHAR (150)

Yes

 

TRANS_TOTAL_VALUE

Transaction total value reported when Securities Acquired (A) or Disposed of (D).

NUMBER(16,2)

Yes

 

TRANS_TOTAL_VALUE_FN

Transaction total value reported when Securities Acquired (A) or Disposed of (D) footnote id.

VARCHAR (150)

Yes

 

TRANS_PRICEPERSHARE

Price of Derivative Security.

NUMBER(16,2)

Yes

 

TRANS_PRICEPERSHARE_FN

Price of Derivative Security footnote id.

VARCHAR (150)

Yes

 

TRANS_ACQUIRED_DISP_CD

Transaction code reported when Securities Acquired (A) or Disposed of (D).

VARCHAR2 (1)

No

 

TRANS_ACQUIRED_DISP_CD_FN

Transaction code reported when Securities Acquired (A) or Disposed of (D) footnote id.

VARCHAR (150)

Yes

 

EXCERCISE_DATE

Date exercisable in (DD-MON-YYYY) format.

DATE

Yes

 

EXCERCISE_DATE_FN

Date exercisable footnote id.

VARCHAR (150)

Yes

 

EXPIRATION_DATE

Expiration date in (DD-MON-YYYY) format.

DATE

Yes

 

EXPIRATION_DATE_FN

Expiration date footnote id

VARCHAR (150)

Yes

 

UNDLYNG_SEC_TITLE

Title of underlying securities.

VARCHAR2 (50)

No

 

UNDLYNG_SEC_TITLE_FN

Title of underlying securities footnote id.

VARCHAR (150)

Yes

 

UNDLYNG_SEC_SHARES

Number of shares owned of underlying securities.

NUMBER(16,2)

No

 

UNDLYNG_SEC_SHARES_FN

Number of shares owned of underlying securities footnote id.

VARCHAR (150)

Yes

 

UNDLYNG_SEC_VALUE

Value of underlying securities.

NUMBER(16,2)

Yes

 

UNDLYNG_SEC_VALUE_FN

Value of underlying securities footnote id.

VARCHAR (150)

Yes

 

SHRS_OWND_FOLWNG_TRANS

Shares owned following reported transaction(s).

NUMBER(16,2)

Yes

 

SHRS_OWND_FOLWNG_TRANS_FN

Shares owned following reported transaction(s) footnote id.

VARCHAR (150)

Yes

 

VALU_OWND_FOLWNG_TRANS

Value owned following reported transaction(s).

NUMBER(16,2)

Yes

 

VALU_OWND_FOLWNG_TRANS_FN

Value owned following reported transaction(s) footnote id.

VARCHAR (150)

Yes

 

DIRECT_INDIRECT_OWNERSHIP

Direct or indirect ownership.

VARCHAR2 (5)

No

 

DIRECT_INDIRECT_OWNERSHIP_FN

Direct or indirect ownership footnote id.

VARCHAR (150)

Yes

 

NATURE_OF_OWNERSHIP

Nature of ownership.

VARCHAR2 (100)

Yes

 

NATURE_OF_OWNERSHIP_FN

Nature of ownership footnote id.

VARCHAR (150)

Yes

 

 

5.6         DERIV_HOLDING

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

DERIV_HOLDING_SK

Derivative holding surrogate key.

NUMBER(38)

No

*

SECURITY_TITLE

Title of derivative security.

VARCHAR2 (60)

No

 

SECURITY_TITLE_FN

Title of derivative security footnote id.

VARCHAR (150)

Yes

 

CONV_EXERCISE_PRICE

Conversion or exercise price.

NUMBER(16,2)

Yes

 

CONV_EXERCISE_PRICE_FN

Conversion or exercise price footnote id.

VARCHAR (150)

Yes

 

TRANS_FORM_TYPE

Transaction form type.

VARCHAR2 (1)

Yes

 

TRANS_FORM_TYPE_FN

Transaction form type footnote id.

VARCHAR (150)

Yes

 

EXERCISE_DATE

Date exercisable in (DD-MON-YYYY) format.

DATE

Yes

 

EXERCISE_DATE_FN

Date exercisable footnote id.

VARCHAR (150)

Yes

 

EXPIRATION_DATE

Expiration date in (DD-MON-YYYY) format.

DATE

Yes

 

EXPIRATION_DATE_FN

Expiration date footnote id.

VARCHAR (150)

Yes

 

UNDLYNG_SEC_TITLE

Title of underlying securities.

VARCHAR2 (20)

No

 

UNDLYNG_SEC_TITLE_FN

Title of underlying securities footnote id.

VARCHAR (150)

Yes

 

UNDLYNG_SEC_SHARES

Number of shares reported of underlying securities.

NUMBER(16,2)

Yes

 

UNDLYNG_SEC_SHARES_FN

Number of shares reported of underlying securities footnote id.

VARCHAR (150)

Yes

 

UNDLYNG_SEC_VALUE

Amount of underlying securities value.

NUMBER(16,2)

Yes

 

UNDLYNG_SEC_VALUE_FN

Amount of underlying securities value footnote id.

VARCHAR (150)

Yes

 

SHRS_OWND_FOLWNG_TRANS

Shares owned following reported transaction(s).

NUMBER(16,2)

Yes

 

SHRS_OWND_FOLWNG_TRANS_FN

Shares owned following reported transaction(s) footnote id.

VARCHAR (150)

Yes

 

VALU_OWND_FOLWNG_TRANS

Value owned following reported transaction(s).

NUMBER(16,2)

Yes

 

VALU_OWND_FOLWNG_TRANS_FN

Value owned following reported transaction(s) footnote id.

VARCHAR (150)

Yes

 

DIRECT_INDIRECT_OWNERSHIP

Ownership Form: Direct or Indirect

VARCHAR2 (5)

No

 

DIRECT_INDIRECT_OWNERSHIP_FN

Ownership Form: Direct or Indirect  footnote id

VARCHAR (150)

Yes

 

NATURE_OF_OWNERSHIP

Nature of ownership.

VARCHAR2 (100)

Yes

 

NATURE_OF_OWNERSHIP_FN

Nature of ownership footnote id.

VARCHAR (150)

Yes

 

 

5.7         FOOTNOTES

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission.

VARCHAR2 (25)

No

*

FOOTNOTE_ID

Footnote identifier.

VARCHAR2 (10)

No

*

FOOTNOTE_TXT

Footnote text.

VARCHAR2 (2000)

No

 

 

5.8        OWNER_SIGNATURE

Field Name

Description

Data Type

Nullable

Key

ACCESSION_NUMBER

Unique identifier assigned by the SEC to each EDGAR submission

VARCHAR2 (25)

No

*

OWNERSIGNATURENAME

Reporting owner signature name

VARCHAR2 (255)

No

*

OWNERSIGNATUREDATE

Reporting owner signature date in (DD-MON-YYYY) format

DATE

No

 

 

6             Appendix

6.1       Timeliness List

 

Value

Meaning

E

Early

L

Late

Empty

On-time

 

6.2        Trans Code List

 

Value

Meaning

A

Grant, award or other acquisition pursuant to Rule 16b-3(d)

C

Conversion of derivative security

D

Disposition to the issuer of issuer equity securities pursuant to Rule 16b-3(e)

E

Expiration of short derivative position

F

Payment of exercise price or tax liability by delivering or withholding securities incident to the receipt, exercise or vesting of a security issued in accordance with Rule 16b-3

G

Bona fide gift

H

Expiration (or cancellation) of long derivative position with value received

I

Discretionary transaction in accordance with Rule 16b-3(f) resulting in acquisition or disposition of issuer securities

J

Other acquisition or disposition (describe transaction)

L

Small acquisition under Rule 16a-6

M

Exercise or conversion of derivative security exempted pursuant to Rule 16b-3

O

Exercise of out-of-the-money derivative security

P

Open market or private purchase of non-derivative or derivative security

S

Open market or private sale of non-derivative or derivative security

U

Disposition pursuant to a tender of shares in a change of control transaction

W

Acquisition or disposition by will or the laws of descent and distribution

X

Exercise of in-the-money or at-the-money derivative security

Z

Deposit into or withdrawal from voting trust

 

6.3       U.S. State/Country Codes and Descriptions

 

AL        ALABAMA

AK        ALASKA

AZ        ARIZONA

AR        ARKANSAS

CA        CALIFORNIA

CO        COLORADO

CT        CONNECTICUT

DE        DELAWARE

DC        DISTRICT OF COLUMBIA

FL         FLORIDA

GA        GEORGIA

GU        GUAM

HI         HAWAII

ID        IDAHO

IL         ILLINOIS

IN         INDIANA

IA         IOWA

KS        KANSAS

KY        KENTUCKY

LA        LOUISIANA

ME        MAINE

MD       MARYLAND

MA       MASSACHUSETTS

MI        MICHIGAN

MN       MINNESOTA

MS       MISSISSIPPI

MO       MISSOURI

MT        MONTANA

NE        NEBRASKA

NV        NEVADA

NH        NEW HAMPSHIRE

NJ        NEW JERSEY

NM       NEW MEXICO

NY        NEW YORK

NC        NORTH CAROLINA

ND        NORTH DAKOTA

OH       OHIO

OK        OKLAHOMA

OR        OREGON

PA        PENNSYLVANIA

RI         RHODE ISLAND

SC        SOUTH CAROLINA

SD        SOUTH DAKOTA

TN        TENNESSEE

TX        TEXAS

UT        UTAH

VT        VERMONT

VA        VIRGINIA

WA       WASHINGTON

WV       WEST VIRGINIA

WI        WISCONSIN

WY       WYOMING

PR        PUERTO RICO

VI         VIRGIN ISLANDS, U.S.

A0        ALBERTA, CANADA

A1        BRITISH COLUMBIA, CANADA

Z4        CANADA (FEDERAL LEVEL)

A2        MANITOBA, CANADA

A3        NEW BRUNSWICK, CANADA

A4        NEWFOUNDLAND, CANADA

A5        NOVA SCOTIA, CANADA

A6        ONTARIO, CANADA

A7        PRINCE EDWARD ISLAND, CANADA

A8        QUEBEC, CANADA

A9        SASKATCHEWAN, CANADA

B0        YUKON, CANADA

B2        AFGHANISTAN

Y6        ALAND ISLANDS

B3        ALBANIA

B4        ALGERIA

B5        AMERICAN SAMOA

B6        ANDORRA

B7        ANGOLA

1A        ANGUILLA

B8        ANTARCTICA

B9        ANTIGUA AND BARBUDA

C1        ARGENTINA

1B        ARMENIA

1C        ARUBA

C3        AUSTRALIA

C4        AUSTRIA

1D        AZERBAIJAN

C5        BAHAMAS

C6        BAHRAIN

C7        BANGLADESH

C8        BARBADOS

1F        BELARUS

C9        BELGIUM

D1        BELIZE

G6        BENIN

D0        BERMUDA

D2        BHUTAN

D3        BOLIVIA

1E        BOSNIA AND HERZEGOVINA

B1        BOTSWANA

D4        BOUVET ISLAND

D5        BRAZIL

D6        BRITISH INDIAN OCEAN TERRITORY

D9        BRUNEI DARUSSALAM

E0        BULGARIA

X2        BURKINA FASO

E2        BURUNDI

E3        CAMBODIA

E4        CAMEROON

E8        CAPE VERDE

E9        CAYMAN ISLANDS

F0        CENTRAL AFRICAN REPUBLIC

F2        CHAD

F3        CHILE

F4        CHINA

F6        CHRISTMAS ISLAND

F7        COCOS (KEELING) ISLANDS

F8        COLOMBIA

F9        COMOROS

G0        CONGO

Y3        CONGO, THE DEMOCRATIC REPUBLIC OF THE

G1        COOK ISLANDS

G2        COSTA RICA

L7         COTE D'IVOIRE

1M        CROATIA

G3        CUBA

G4        CYPRUS

2N        CZECH REPUBLIC

G7        DENMARK

1G        DJIBOUTI

G9        DOMINICA

G8        DOMINICAN REPUBLIC

H1        ECUADOR

H2        EGYPT

H3        EL SALVADOR

H4        EQUATORIAL GUINEA

1J         ERITREA

1H        ESTONIA

H5        ETHIOPIA

H7        FALKLAND ISLANDS (MALVINAS)

H6        FAROE ISLANDS

H8        FIJI

H9        FINLAND

I0         FRANCE

I3         FRENCH GUIANA

I4         FRENCH POLYNESIA

2C        FRENCH SOUTHERN TERRITORIES

I5         GABON

I6         GAMBIA

2Q        GEORGIA

2M        GERMANY

J0         GHANA

J1         GIBRALTAR

J3         GREECE

J4         GREENLAND

J5         GRENADA

J6         GUADELOUPE

J8         GUATEMALA

Y7        GUERNSEY

J9         GUINEA

S0        GUINEA-BISSAU

K0        GUYANA

K1        HAITI

K4        HEARD ISLAND AND MCDONALD ISLANDS

X4        HOLY SEE (VATICAN CITY STATE)

K2        HONDURAS

K3        HONG KONG

K5        HUNGARY

K6        ICELAND

K7        INDIA