> ## Documentation Index
> Fetch the complete documentation index at: https://docs.govfiles.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Schema

> The GovFiles US business-entity dataset, delivered as relational tables

GovFiles is a normalized dataset of US business-entity records, sourced directly from each state's Secretary of State registry. A bulk delivery gives you 75M+ entities across all 50 states as a set of relational tables. It covers corporations, LLCs, partnerships, nonprofits, and trade names, both active and dissolved, and maps every state to one schema, so the same query works for a Delaware LLC or a California corporation.

## Delivery

Bulk data ships as Parquet over S3 or as warehouse-native shares for Snowflake, BigQuery, and Databricks. Each delivery is a full monthly snapshot that replaces the previous month. The `as_of` column on each entity gives the date that row was retrieved, so you can tell how fresh a record is.

## How the data is structured

Every table joins on `(jurisdiction_code, entity_number)`. That pair identifies an entity across the dataset.

Coverage reflects what each registry publishes. A field a state does not release is null, so completeness varies by state and by field.

You can spot-check any record against the source at any time. Each entity carries an `entity_url` linking to its page on the state registry, with `search_url` as a fallback when no direct link exists.

The tables below document the schema. The same records are available one at a time through the REST API.

## CORP.COMPANIES

One row per registered legal entity.

| FIELD              | DESCRIPTION                                                                           | TYPE                                                  | SOURCE               |
| ------------------ | ------------------------------------------------------------------------------------- | ----------------------------------------------------- | -------------------- |
| ENTITY\_NUMBER     | Registry-assigned entity number                                                       | <span className="type-pill type-string">String</span> | Provided by state    |
| JURISDICTION\_CODE | ISO 3166-2 style code, e.g. us\_de                                                    | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| LEGAL\_NAME        | Legal name as registered                                                              | <span className="type-pill type-string">String</span> | Provided by state    |
| STATUS             | Normalized status: active, inactive, dissolved, suspended, merged, withdrawn, unknown | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| STATUS\_RAW        | Verbatim status string from the registry                                              | <span className="type-pill type-string">String</span> | Provided by state    |
| LEGAL\_FORM        | Normalized entity type: llc, corporation, nonprofit, and others                       | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| LEGAL\_FORM\_RAW   | Verbatim company-type string from the registry                                        | <span className="type-pill type-string">String</span> | Provided by state    |
| DOMICILE           | domestic, foreign, or unknown                                                         | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| FORMED\_ON         | Incorporation / formation date                                                        | <span className="type-pill type-date">Date</span>     | Provided by state    |
| DISSOLVED\_ON      | Dissolution date, if dissolved                                                        | <span className="type-pill type-date">Date</span>     | Provided by state    |
| WEBSITES           | Associated websites                                                                   | <span className="type-pill type-array">Array</span>   | Provided by state    |
| PHONE              | Phone number                                                                          | <span className="type-pill type-string">String</span> | Provided by state    |
| FAX                | Fax number                                                                            | <span className="type-pill type-string">String</span> | Provided by state    |
| ENTITY\_URL        | Direct link to this entity on the registry                                            | <span className="type-pill type-string">String</span> | Provided by state    |
| SEARCH\_URL        | State entity-search page; fallback when no direct link exists                         | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| AS\_OF             | Date this record was retrieved from the source                                        | <span className="type-pill type-date">Date</span>     | Created by GovFiles  |

## CORP.COMPANY\_ADDRESSES

Entity addresses, one row per address slot.

| FIELD              | DESCRIPTION                                              | TYPE                                                  | SOURCE               |
| ------------------ | -------------------------------------------------------- | ----------------------------------------------------- | -------------------- |
| JURISDICTION\_CODE | Join key                                                 | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| ENTITY\_NUMBER     | Join key                                                 | <span className="type-pill type-string">String</span> | Provided by state    |
| ADDRESS\_KIND      | registered, headquarters, or mailing                     | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| RAW                | Verbatim address string when the source was unstructured | <span className="type-pill type-string">String</span> | Provided by state    |
| STREET\_ADDRESS    | Street address                                           | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| LOCALITY           | City or town                                             | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| REGION             | State / province                                         | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| POSTAL\_CODE       | Postal code                                              | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| COUNTRY            | Country                                                  | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| COUNTRY\_CODE      | Country code                                             | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |

## CORP.COMPANY\_PARTIES

People and companies related to an entity, one row per party-role. A party with no known role appears once with a null `role_kind`. This is the table for officers, directors, registered agents, members, and owners.

| FIELD                  | DESCRIPTION                                                                                                     | TYPE                                                  | SOURCE               |
| ---------------------- | --------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------- | -------------------- |
| JURISDICTION\_CODE     | Join key                                                                                                        | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| ENTITY\_NUMBER         | Join key                                                                                                        | <span className="type-pill type-string">String</span> | Provided by state    |
| PARTY\_NAME            | Name of the person or company                                                                                   | <span className="type-pill type-string">String</span> | Provided by state    |
| PARTY\_TYPE            | company, person, or unknown                                                                                     | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ROLE\_KIND             | Normalized role: registered\_agent, officer, manager, member, governor, owner, incorporator, shareholder, other | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ROLE\_TITLE            | Verbatim position string from the registry                                                                      | <span className="type-pill type-string">String</span> | Provided by state    |
| OWNERSHIP\_PERCENTAGE  | Percentage owned, for ownership roles                                                                           | <span className="type-pill type-float">Float</span>   | Provided by state    |
| STARTED\_ON            | Date the role started                                                                                           | <span className="type-pill type-date">Date</span>     | Provided by state    |
| ENDED\_ON              | Date the role ended                                                                                             | <span className="type-pill type-date">Date</span>     | Provided by state    |
| ADDRESS\_RAW           | Verbatim party address                                                                                          | <span className="type-pill type-string">String</span> | Provided by state    |
| ADDRESS\_STREET        | Street address                                                                                                  | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ADDRESS\_LOCALITY      | City or town                                                                                                    | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ADDRESS\_REGION        | State / province                                                                                                | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ADDRESS\_POSTAL\_CODE  | Postal code                                                                                                     | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ADDRESS\_COUNTRY       | Country                                                                                                         | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| ADDRESS\_COUNTRY\_CODE | Country code                                                                                                    | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |

## CORP.COMPANY\_FILINGS

Statutory filings: annual reports, amendments, certificates, etc.

| FIELD              | DESCRIPTION                   | TYPE                                                  | SOURCE              |
| ------------------ | ----------------------------- | ----------------------------------------------------- | ------------------- |
| JURISDICTION\_CODE | Join key                      | <span className="type-pill type-string">String</span> | Created by GovFiles |
| ENTITY\_NUMBER     | Join key                      | <span className="type-pill type-string">String</span> | Provided by state   |
| FILING\_ID         | Registry filing / document id | <span className="type-pill type-string">String</span> | Provided by state   |
| TITLE              | Filing title                  | <span className="type-pill type-string">String</span> | Provided by state   |
| FILED\_ON          | Date filed                    | <span className="type-pill type-date">Date</span>     | Provided by state   |
| FILING\_TYPE\_CODE | Filing type code              | <span className="type-pill type-string">String</span> | Provided by state   |
| FILING\_TYPE\_NAME | Filing type name              | <span className="type-pill type-string">String</span> | Provided by state   |
| URL                | Link to the filing            | <span className="type-pill type-string">String</span> | Provided by state   |
| DESCRIPTION        | Filing description            | <span className="type-pill type-string">String</span> | Provided by state   |

## CORP.COMPANY\_IDENTIFIERS

External identifiers (tax numbers, registry ids, etc.).

| FIELD              | DESCRIPTION                                         | TYPE                                                  | SOURCE               |
| ------------------ | --------------------------------------------------- | ----------------------------------------------------- | -------------------- |
| JURISDICTION\_CODE | Join key                                            | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| ENTITY\_NUMBER     | Join key                                            | <span className="type-pill type-string">String</span> | Provided by state    |
| SCHEME             | Identifier scheme, e.g. us\_fein, us\_sec\_cik, lei | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| VALUE              | The identifier value                                | <span className="type-pill type-string">String</span> | Provided by state    |

## CORP.COMPANY\_NAMES

Non-current names: former legal names and DBAs / trade names. The entity's current legal name lives in `corp.companies.legal_name`.

| FIELD              | DESCRIPTION                                                               | TYPE                                                  | SOURCE               |
| ------------------ | ------------------------------------------------------------------------- | ----------------------------------------------------- | -------------------- |
| JURISDICTION\_CODE | Join key                                                                  | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| ENTITY\_NUMBER     | Join key                                                                  | <span className="type-pill type-string">String</span> | Provided by state    |
| NAME               | The name                                                                  | <span className="type-pill type-string">String</span> | Provided by state    |
| NAME\_KIND         | previous\_legal (former legal name), trading (DBA / trade name), or alias | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| STARTED\_ON        | Date the name took effect                                                 | <span className="type-pill type-date">Date</span>     | Provided by state    |
| ENDED\_ON          | Date the name ended                                                       | <span className="type-pill type-date">Date</span>     | Provided by state    |

## CORP.COMPANY\_RELATIONSHIPS

Entity-to-entity links: mergers, foreign-home entity, re-registrations.

| FIELD                       | DESCRIPTION                                                                   | TYPE                                                  | SOURCE               |
| --------------------------- | ----------------------------------------------------------------------------- | ----------------------------------------------------- | -------------------- |
| JURISDICTION\_CODE          | Join key                                                                      | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| ENTITY\_NUMBER              | Join key                                                                      | <span className="type-pill type-string">String</span> | Provided by state    |
| RELATIONSHIP\_KIND          | merged\_into, home\_entity, subsequent\_registration, alternate\_registration | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| RELATED\_NAME               | Name of the related entity                                                    | <span className="type-pill type-string">String</span> | Provided by state    |
| RELATED\_JURISDICTION\_CODE | Jurisdiction of the related entity, when known                                | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| RELATED\_ENTITY\_NUMBER     | Entity number of the related entity, when known                               | <span className="type-pill type-string">String</span> | Provided by state    |
| EFFECTIVE\_DATE             | Effective date                                                                | <span className="type-pill type-date">Date</span>     | Provided by state    |

## CORP.COMPANY\_INDUSTRY\_CODES

Company industry classifications.

| FIELD              | DESCRIPTION                                      | TYPE                                                  | SOURCE               |
| ------------------ | ------------------------------------------------ | ----------------------------------------------------- | -------------------- |
| JURISDICTION\_CODE | Join key                                         | <span className="type-pill type-string">String</span> | Created by GovFiles  |
| ENTITY\_NUMBER     | Join key                                         | <span className="type-pill type-string">String</span> | Provided by state    |
| CODE               | The classification code                          | <span className="type-pill type-string">String</span> | Provided by state    |
| SCHEME             | Code scheme, e.g. us\_naics\_2017, us\_sic\_1987 | <span className="type-pill type-string">String</span> | Enhanced by GovFiles |
| DESCRIPTION        | Classification description                       | <span className="type-pill type-string">String</span> | Provided by state    |