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.

Field Name	Data Type	Function
initial_financing_id	STRING	Unique identifier for the initial financing record.
initial_financing_type	STRING	Specifies the type of initial financing.
initial_financing_sub_type	STRING	Additional categorization of the initial financing type.
initial_financing_date_time	DATETIME	The date and time when the initial financing was filed.
initial_financing_lapse_date	DATETIME	The expiration date of the initial financing, if applicable.
initial_financing_collateral_description	STRING	Description of the collateral associated with the financing.
initial_financing_lien_status	STRING	Status of the lien associated with the financing (e.g., active, terminated).
database_state_origin	STRING	Indicates the state of origin for the financing data.
composite_key_state_initial_financing_id	STRING	Composite key for uniquely identifying the initial financing record within a state.
hash_key	STRING	Hash for ensuring data integrity and uniqueness.
date_last_updated	TIMESTAMP	Timestamp of the last update to the financing record.
initial_financing_state_database_url	STRING	URL for accessing the state’s database entry for the financing.

---

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.

Field Name	Data Type	Function
amendment_financing_id	STRING	Unique identifier for the amendment record.
amendment_financing_type	STRING	Specifies the type of amendment (e.g., name change, collateral update).
amendment_financing_sub_type	STRING	Additional categorization of the amendment type.
amendment_financing_date_time	DATETIME	The date and time when the amendment was filed.
amendment_financing_lapse_date	DATETIME	The expiration date of the amendment, if applicable.
amendment_financing_collateral_description	STRING	Description of the collateral associated with the amendment.
database_state_origin	STRING	Indicates the state of origin for the amendment data.
initial_financing_id	STRING	Links the amendment to its corresponding initial financing record.
composite_key_state_initial_financing_id	STRING	Composite key for uniquely identifying the initial financing record within a state.
composite_key_state_amendment_financing_id	STRING	Composite key for uniquely identifying the amendment record within a state.
hash_key	STRING	Hash for ensuring data integrity and uniqueness.
date_last_updated	TIMESTAMP	Timestamp of the last update to the amendment record.
amendment_financing_state_database_url	STRING	URL for accessing the state’s database entry for the amendment.

---

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.

Field Name	Data Type	Function
debtor_party_id	STRING	Unique identifier for the debtor party.
debtor_party_type	STRING	Type of the debtor (e.g., individual, entity).
debtor_party_entity_name	STRING	Entity name of the debtor, if applicable.
debtor_party_first_name	STRING	First name of the debtor, if applicable.
debtor_party_last_name	STRING	Last name of the debtor, if applicable.
debtor_party_street_address1	STRING	Primary address line for the debtor.
debtor_party_street_address2	STRING	Secondary address line for the debtor, if applicable.
debtor_party_city	STRING	City of the debtor's address.
debtor_party_state	STRING	State of the debtor's address.
debtor_party_postal_code	STRING	Postal code of the debtor's address.
debtor_party_country	STRING	Country of the debtor's address.
debtor_party_sub_type	STRING	Additional categorization of the debtor type.
debtor_party_sos_detail	STRING	Details from the state of origin's Secretary of State system.
debtor_party_google_map_detail	STRING	Google Maps details for the debtor's address.
amendment_id	STRING	Links the debtor to a specific amendment.
initial_financing_id	STRING	Links the debtor to a specific initial financing.
database_state_origin	STRING	Indicates the state of origin for the debtor record.
composite_key_state_initial_financing_id	STRING	Composite key for uniquely identifying the initial financing record within a state.
composite_key_state_amendment_id	STRING	Composite key for uniquely identifying the amendment record within a state.
hash_key	STRING	Hash for ensuring data integrity and uniqueness.
date_last_updated	TIMESTAMP	Timestamp of the last update to the debtor record.
debtor_party_name_concat	STRING	Concatenated name of the debtor for easy referencing.

---

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	Function
secured_party_id	STRING	Unique identifier for the secured party.
secured_party_type	STRING	Type of the secured party (e.g., individual, entity).
secured_party_entity_name	STRING	Entity name of the secured party, if applicable.
secured_party_first_name	STRING	First name of the secured party, if applicable.
secured_party_last_name	STRING	Last name of the secured party, if applicable.
secured_party_street_address1	STRING	Primary address line for the secured party.
secured_party_street_address2	STRING	Secondary address line for the secured party, if applicable.
secured_party_city	STRING	City of the secured party's address.
secured_party_state	STRING	State of the secured party's address.
secured_party_postal_code	STRING	Postal code of the secured party's address.
secured_party_country	STRING	Country of the secured party's address.
secured_party_sub_type	STRING	Additional categorization of the secured party type.
secured_party_sos_detail	STRING	Details from the state of origin's Secretary of State system.
secured_party_google_map_detail	STRING	Google Maps details for the secured party's address.
amendment_id	STRING	Links the secured party to a specific amendment.
initial_financing_id	STRING	Links the secured party to a specific initial financing.
database_state_origin	STRING	Indicates the state of origin for the secured party record.
composite_key_state_initial_financing_id	STRING	Composite key for uniquely identifying the initial financing record within a state.
composite_key_state_amendment_id	STRING	Composite key for uniquely identifying the amendment record within a state.
hash_key	STRING	Hash for ensuring data integrity and uniqueness.
date_last_updated	TIMESTAMP	Timestamp of the last update to the secured party record.
secured_party_name_concat	STRING	Concatenated name of the secured party for easy referencing.