lobbying_filings_raw: 492aad8f-e65c-4516-b46c-e893bf8ae431

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid	filing_type	registrant_id	registrant_name	client_id	client_name	filing_year	filing_period	received_date	amount_reported	is_amendment	is_no_activity	is_termination	raw_json	registrant_state	registrant_country	registrant_house_id	client_state	client_ppb_state	client_country	client_ppb_country	client_general_description	client_government_entity	affiliated_org_count	client_entity_id	client_government_unit_id	client_match_method	client_match_confidence
492aad8f-e65c-4516-b46c-e893bf8ae431	Q4	86196	FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC)	173149	DUPONT SPECIALTY PRODUCTS(PREVIOUSLY REPORTED AS E.I. DU PONT DE NEMOURS AND CO)	2018	fourth_quarter	2019-01-17T10:01:11.593000-05:00	50000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/492aad8f-e65c-4516-b46c-e893bf8ae431/", "filing_uuid": "492aad8f-e65c-4516-b46c-e893bf8ae431", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2018, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/492aad8f-e65c-4516-b46c-e893bf8ae431/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Nicole Dade", "dt_posted": "2019-01-17T10:01:11.593000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1025 F Street NW", "registrant_address_2": "9th Floor", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 86196, "url": "https://lda.senate.gov/api/v1/registrants/86196/", "house_registrant_id": 36548, "name": "FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC)", "description": "Legislative and public affairs firm.", "address_1": "1299 Pennsylvania Ave. NW", "address_2": "12th Floor", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "NICOLE DADE", "contact_telephone": "+1 202-337-0808", "dt_updated": "2026-01-26T13:27:22.673713-05:00"}, "client": {"id": 173149, "url": "https://lda.senate.gov/api/v1/clients/173149/", "client_id": 1006257, "name": "DUPONT SPECIALTY PRODUCTS(PREVIOUSLY REPORTED AS E.I. DU PONT DE NEMOURS AND CO)", "general_description": "DePont is a science-based products and services company.", "client_government_entity": false, "client_self_select": null, "state": "DE", "state_display": "Delaware", "country": "US", "country_display": "United States of America", "ppb_state": "DE", "ppb_state_display": "Delaware", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2017-10-01"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Government relations support for the Specialty Products Division's product delivery and work related to food and nutrition, efficient cars, new sources of energy, smarter homes, and protections for workers and the environment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50099, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "KRUMHOLTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52269, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "GRANT", "nickname": null, "middle_name": "LESLIE", "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67742, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": "T", "last_name": "LEFTWICH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Government relations support for the Specialty Products Division's product delivery and work related to food and nutrition, efficient cars, new sources of energy, smarter homes, and protections for workers and the environment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50099, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "KRUMHOLTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52269, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "GRANT", "nickname": null, "middle_name": "LESLIE", "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67742, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": "T", "last_name": "LEFTWICH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Government relations support for the Specialty Products Division's product delivery and work related to food and nutrition, efficient cars, new sources of energy, smarter homes, and protections for workers and the environment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50099, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "KRUMHOLTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52269, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "GRANT", "nickname": null, "middle_name": "LESLIE", "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67742, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": "T", "last_name": "LEFTWICH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Government relations support for the Specialty Products Division's product delivery and work related to food and nutrition, efficient cars, new sources of energy, smarter homes, and protections for workers and the environment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50099, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "KRUMHOLTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52269, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "GRANT", "nickname": null, "middle_name": "LESLIE", "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67742, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": "T", "last_name": "LEFTWICH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Government relations support for the Specialty Products Division's product delivery and work related to food and nutrition, efficient cars, new sources of energy, smarter homes, and protections for workers and the environment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50099, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "KRUMHOLTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52269, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "GRANT", "nickname": null, "middle_name": "LESLIE", "last_name": "MITCHELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67742, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": "T", "last_name": "LEFTWICH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	36548	DE	DE	US	US	DePont is a science-based products and services company.	0	0

Links from other tables

5 rows from filing_uuid in lobbying_activities
3 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs