lobbying_filings_raw: 3d04fe98-e47e-46b7-8f4d-a84d6e01fe47

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
3d04fe98-e47e-46b7-8f4d-a84d6e01fe47	Q1	12868	DUTKO WORLDWIDE, LLC	118344	ZEACHEM, INC.	2011	first_quarter	2011-04-14T15:37:31.663000-04:00	30000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/3d04fe98-e47e-46b7-8f4d-a84d6e01fe47/", "filing_uuid": "3d04fe98-e47e-46b7-8f4d-a84d6e01fe47", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2011, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3d04fe98-e47e-46b7-8f4d-a84d6e01fe47/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Joshua Ian Rosenstein, Vice President and General Counsel", "dt_posted": "2011-04-14T15:37:31.663000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "412 FIRST STREET SE", "registrant_address_2": "SUITE 100", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 12868, "url": "https://lda.senate.gov/api/v1/registrants/12868/", "house_registrant_id": 32229, "name": "DUTKO WORLDWIDE, LLC", "description": "Government relations firm", "address_1": "80 M STREET SE", "address_2": "SUITE 130", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRIS ANDRESEN", "contact_telephone": "+1 202-851-3618", "dt_updated": "2026-01-26T17:43:32.412214-05:00"}, "client": {"id": 118344, "url": "https://lda.senate.gov/api/v1/clients/118344/", "client_id": 1005534, "name": "ZEACHEM, INC.", "general_description": "Cellulosic ethanol company", "client_government_entity": false, "client_self_select": false, "state": "CO", "state_display": "Colorado", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-04-13"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Investigate and target potential federal funding opportunities. Expand federal outreach efforts regarding the use of advanced biofuels and other advanced biochemical technologies.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8016, "prefix": null, "prefix_display": null, "first_name": "TRACY", "nickname": null, "middle_name": null, "last_name": "HAMMOND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29712, "prefix": null, "prefix_display": null, "first_name": "ARTHUR", "nickname": null, "middle_name": null, "last_name": "SILVERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39758, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "ANDRESEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20210, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": null, "last_name": "BERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Identify and secure support for a production tax credit for biobased chemical producers. Identify and secure support for legislation creating an investment tax credit for advanced biofuels facilities. Pursue loan guarantee opportunities. Promote extension of accelerated depreciation for cellulosic biofuel facilities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8016, "prefix": null, "prefix_display": null, "first_name": "TRACY", "nickname": null, "middle_name": null, "last_name": "HAMMOND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29712, "prefix": null, "prefix_display": null, "first_name": "ARTHUR", "nickname": null, "middle_name": null, "last_name": "SILVERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39758, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "ANDRESEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20210, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": null, "last_name": "BERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Investigate and target potential federal funding opportunities. Expand federal outreach efforts regarding the use of advanced biofuels and other advanced biochemical technologies. Identify and secure support for a production tax credit for biobased chemical producers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8016, "prefix": null, "prefix_display": null, "first_name": "TRACY", "nickname": null, "middle_name": null, "last_name": "HAMMOND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29712, "prefix": null, "prefix_display": null, "first_name": "ARTHUR", "nickname": null, "middle_name": null, "last_name": "SILVERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39758, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "ANDRESEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20210, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": null, "last_name": "BERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "Investigate and target potential federal funding opportunities. Expand federal outreach efforts regarding the use of advanced biofuels and other advanced biochemical technologies. Identify and secure support for a production tax credit for biobased chemical \nproducers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8016, "prefix": null, "prefix_display": null, "first_name": "TRACY", "nickname": null, "middle_name": null, "last_name": "HAMMOND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29712, "prefix": null, "prefix_display": null, "first_name": "ARTHUR", "nickname": null, "middle_name": null, "last_name": "SILVERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39758, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "ANDRESEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20210, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": null, "last_name": "BERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Investigate and target potential federal funding opportunities. Expand federal outreach efforts regarding the use of advanced biofuels and other advanced biochemical technologies. Identify and secure support for a production tax credit for biobased chemical producers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8016, "prefix": null, "prefix_display": null, "first_name": "TRACY", "nickname": null, "middle_name": null, "last_name": "HAMMOND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29712, "prefix": null, "prefix_display": null, "first_name": "ARTHUR", "nickname": null, "middle_name": null, "last_name": "SILVERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39758, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "ANDRESEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 20210, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": null, "last_name": "BERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	32229	CO		US	US	Cellulosic ethanol company	0	0	2341116		normalized_name	0.7

Links from other tables

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