Data Dictionary

Our data is aggregated, enhanced, and presented in a fashion that makes data analysis easier for advanced analytics and reporting.

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.

Springstreet summarizes & identifies key stakeholders related to each Initial Financing

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

initial_financing_id	string	Unique identifier for the initial financing record.
initial_financing_date_time	timestamp	Date and time when the initial financing was filed.
initial_financing_estimated_lapse_date	string	Estimated expiration date of the financing.
initial_financing_lien_status	string	Status of the financing (e.g., active, terminated).
composite_key_state_initial_financing_id	string	Composite key for unique identification across United States.
source_database_state_origin	string	State the financing was filed in.
source_database_state_url	string	URL of the State's Secretary of State website.

---

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.

Springstreet provides a historical chain of events, helping identify key amendment activity.

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.

Springstreet add additional data to Debtor information for a deeper understanding of the debtor and their attributes.

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.

Springstreet add additional data to Secured Party information for a deeper understanding of the Secured Party and their attributes.

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.