# Data Dictionary

## Initial Financings (a.k.a "UCC Financing Statements")

This table contains data about initial financing statements, which are the foundational records in UCC filings. These records describe the secured transaction, including its collateral, lien status, and related parties.

{% hint style="info" %}
Springstreet summarizes & identifies key stakeholders related to each Initial Financing
{% endhint %}

For each state, each Initial Financing is a Unique ID.

<table data-header-hidden><thead><tr><th width="249">Field Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td><code>initial_financing_id</code> </td><td><code>string</code></td><td>Unique identifier for the initial financing record.</td></tr><tr><td><code>initial_financing_date_time</code></td><td><code>timestamp</code></td><td>Date and time when the initial financing was filed.</td></tr><tr><td><code>initial_financing_estimated_lapse_date</code></td><td><code>string</code></td><td>Estimated expiration date of the financing.</td></tr><tr><td><code>initial_financing_lien_status</code></td><td><code>string</code></td><td>Status of the financing (e.g., active, terminated).</td></tr><tr><td><code>composite_key_state_initial_financing_id</code></td><td><code>string</code></td><td>Composite key for unique identification across United States.</td></tr><tr><td><code>source_database_state_origin</code></td><td><code>string</code></td><td>State the financing was filed in.</td></tr><tr><td><code>source_database_state_url</code></td><td><code>string</code></td><td>URL of the State's Secretary of State website.</td></tr></tbody></table>

***

## Amendments

This table contains data about amendments made to initial financing statements. Amendments update or correct the details of an existing initial financing record, such as changes in debtor names, secured party names, or collateral descriptions. Amendments can also highlight terminations of UCC Financing records, indicating a debtor has repaid the financing.

{% hint style="info" %}
Springstreet provides a historical chain of events, helping identify key amendment activity.
{% endhint %}

Each amendment is associated with a specific initial financing record.

| `amendment_financing_id`                     | `string`    | Unique identifier for the amendment record.                             |
| -------------------------------------------- | ----------- | ----------------------------------------------------------------------- |
| `amendment_financing_date_time`              | `timestamp` | Date and time when the amendment was filed.                             |
| `amendment_financing_type_description`       | `string`    | Description of amendment type (e.g., "Initial Filing", "Continuation"). |
| `composite_key_state_amendment_financing_id` | `string`    | Composite key for unique identification across the United States.       |
| `amendment_financing_estimated_lapse_date`   | `string`    | Estimated expiration date of the amendment.                             |
| `amendment_financing_type_code`              | `string`    | Code representing the amendment type.                                   |
| `amendment_financing_collateral_codes`       | `string`    | Codes representing the collateral type.                                 |
| `amendment_financing_collateral_description` | `string`    | Text description of the collateral involved.                            |

***

## Debtors

This table stores information about debtor/borrowing parties involved in initial financings and amendments. Information about debtors can include first name, last name, entity name, addresses, and more. Debtors are pledging their collateral to Secured Parties.

{% hint style="info" %}
Springstreet add additional data to Debtor information for a deeper understanding of the debtor and their attributes.
{% endhint %}

A debtor may be associated with many initial financings and amendments.

| `debtor_party_id`                | `string` | Unique internal identifier for the debtor party. |
| -------------------------------- | -------- | ------------------------------------------------ |
| `debtor_party_type`              | `string` | Type of debtor (e.g., Individual, Organization). |
| `debtor_party_category`          | `string` | Category of debtor business/activity.            |
| `debtor_party_entity_name`       | `string` | Legal entity name (if applicable).               |
| `debtor_party_first_name`        | `string` | First name (if individual).                      |
| `debtor_party_last_name`         | `string` | Last name (if individual).                       |
| `debtor_party_name_concat`       | `string` | Full concatenated name of the debtor.            |
| `debtor_party_street_address1`   | `string` | Primary address line.                            |
| `debtor_party_street_address2`   | `string` | Secondary address line.                          |
| `debtor_party_city`              | `string` | City.                                            |
| `debtor_party_state`             | `string` | State.                                           |
| `debtor_party_postal_code`       | `string` | Postal/Zip code.                                 |
| `debtor_party_country`           | `string` | Country.                                         |
| `debtor_party_google_map_detail` | `string` | Google Maps link for the address.                |
| `debtor_party_sos_detail`        | `string` | Secretary of State detail link.                  |

***

## Secured Parties

This table stores information about secured parties involved in initial financings and amendments. A secured party is the creditor in the secured transaction and has a claim on the debtor(s) collateral.

{% hint style="info" %}
Springstreet add additional data to Secured Party information for a deeper understanding of the Secured Party and their attributes.
{% endhint %}

A Secured Party may be associated with many initial financings and amendments.

| **Field Name**                    | **Data Type** | **Description**                                   |
| --------------------------------- | ------------- | ------------------------------------------------- |
| `secured_party_id`                | `string`      | Unique internal identifier for the secured party. |
| `secured_party_type`              | `string`      | Type of secured party.                            |
| `secured_party_category`          | `string`      | Category of secured party (e.g., Bank).           |
| `secured_party_entity_name`       | `string`      | Legal entity name.                                |
| `secured_party_first_name`        | `string`      | First name.                                       |
| `secured_party_last_name`         | `string`      | Last name.                                        |
| `secured_party_name_concat`       | `string`      | Full concatenated name.                           |
| `secured_party_street_address1`   | `string`      | Primary address line.                             |
| `secured_party_street_address2`   | `string`      | Secondary address line.                           |
| `secured_party_city`              | `string`      | City.                                             |
| `secured_party_state`             | `string`      | State.                                            |
| `secured_party_postal_code`       | `string`      | Postal/Zip code.                                  |
| `secured_party_country`           | `string`      | Country.                                          |
| `secured_party_google_map_detail` | `string`      | Google Maps link for the address.                 |
| `secured_party_sos_detail`        | `string`      | Secretary of State detail link.                   |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://springstreet.gitbook.io/springstreet.io/api/getting-started/publish-your-docs.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.