lobbying_filings_raw: bb3b2419-cd73-4587-afbf-e443302b9e2b

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
bb3b2419-cd73-4587-afbf-e443302b9e2b	Q1	19230	INDEPENDENT PETROLEUM ASSOCIATION OF AMERICA	126314	INDEPENDENT PETROLEUM ASSOCIATION OF AMERICA	2020	first_quarter	2020-04-18T23:24:27.897000-04:00	238560.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/bb3b2419-cd73-4587-afbf-e443302b9e2b/", "filing_uuid": "bb3b2419-cd73-4587-afbf-e443302b9e2b", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2020, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bb3b2419-cd73-4587-afbf-e443302b9e2b/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "238560.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Ryan Ullman", "dt_posted": "2020-04-18T23:24:27.897000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1201 15TH STREET, NW", "registrant_address_2": "SUITE 300", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 19230, "url": "https://lda.senate.gov/api/v1/registrants/19230/", "house_registrant_id": 31120, "name": "INDEPENDENT PETROLEUM ASSOCIATION OF AMERICA", "description": null, "address_1": "1201 15TH STREET, NW", "address_2": "SUITE 450", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RYAN ULLMAN", "contact_telephone": "+1 202-857-4727", "dt_updated": "2026-01-29T14:13:13.558198-05:00"}, "client": {"id": 126314, "url": "https://lda.senate.gov/api/v1/clients/126314/", "client_id": 12, "name": "INDEPENDENT PETROLEUM ASSOCIATION OF AMERICA", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "H. R. 1391 - To provide regulatory relief for conventional marginally producing oil and gas wells from the Environmental Protection Agencys Methane Rule.\nH. R. 585 - To amend the Clean Air Act to eliminate the exemption for aggregation of emissions from oil and gas sources, and for other purposes\nS. 940 - To cap the emissions of greenhouse gases through a requirement to purchase carbon permits, to distribute the proceeds of such purchases to eligible individuals, and for other purposes.\nS. 383 - USE IT Act\nHR 1166 - USE IT Act\nS 1790 - National Defense Authorization Act\nHR 4014 - Fracturing Responsibility and Awareness of Chemicals Act of 2019\nHR 436 - Fracking Disclosure and Safety Act\nHR 4007 - Focused Reduction of Effluence and Stormwater runoff through Hydrofracking Environmental Regulation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "United Nations International Maritime Organization regulation to requiring low-sulfur diesel for international shipping", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "HR 4007 - Focused Reduction of Effluence and Stormwater runoff through Hydrofracking Environmental Regulation\nH. R. 1391 - To provide regulatory relief for conventional marginally producing oil and gas wells from the Environmental Protection Agencys Methane Rule.\nH. R. 585 - To amend the Clean Air Act to eliminate the exemption for aggregation of emissions from oil and gas sources, and for other purposes\nS. 940 - To cap the emissions of greenhouse gases through a requirement to purchase carbon permits, to distribute the proceeds of such purchases to eligible individuals, and for other purposes.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "S.180 - A bill to streamline the oil and gas permitting process and to recognize fee ownership for certain oil and gas drilling or spacing units, and for other purposes\nH. R. 310 - To amend the Outer Continental Shelf Lands Act to permanently prohibit the conduct of offshore drilling on the outer Continental Shelf off the coast of California, Oregon, and Washington.\nH. R. 309 - To prohibit drilling in the Arctic Ocean.\nH. R. 341 - To amend the Outer Continental Shelf Lands Act to permanently prohibit the conduct of offshore drilling on the outer Continental Shelf in the Mid-Atlantic, South Atlantic, North Atlantic, Straits of Florida, and Eastern Gulf of Mexico planning areas.\nH. R. 279 - To permanently prohibit oil and gas leasing off the coast of the State of California, and for other purposes.\nH. R. 1836 - To amend the Natural Gas Act to expedite approval of exports of small volumes of natural gas, and for other purposes.\nS. 816 - To amend the Natural Gas Act to expedite approval of exports of small volumes of natural gas, and for other purposes.\nH. R. 286 - To amend the Outer Continental Shelf Lands Act to prohibit oil and gas preleasing, leasing, and related activities in certain areas of the Outer Continental Shelf off the coast of Florida, and for other purposes.\nH. R. 1333 - To amend the Mineral Leasing Act to create a buffer in between oil and gas drilling operations and homes, businesses, schools, and other buildings that require special protection, and for other purposes.\nS. 13 - To include the State of Florida in the Gulf of Mexico outer Continental Shelf revenue sharing program, to extend the moratorium on oil and gas leasing in certain areas of the Gulf of Mexico, and for other purposes.\nH. R. 291 - To amend the Outer Continental Shelf Lands Act to place a ten-year moratorium on oil and gas preleasing, leasing, and related activities on the Outer Continental Shelf in the North Atlantic, Mid-Atlantic, South Atlantic, and Straits of Florida planning areas and in the Eastern Gulf of Mexico.\nH. R. 1391 - To provide regulatory relief for conventional marginally producing oil and gas wells from the Environmental Protection Agencys Methane Rule.\nS. 218 - To empower States to manage the development and production of oil and gas on available Federal land, and for other purposes\nH. R. 1650 - To clarify that the Bureau of Land Management shall not require permits for oil and gas activities conducted on non-Federal surface estate to access subsurface mineral estate that is less than 50 percent federally owned, and for other purposes\nH. R. 585 - To amend the Clean Air Act to eliminate the exemption for aggregation of emissions from oil and gas sources, and for other purposes\nH Res 109 - Recognizing the duty of the Federal Government to create a Green New Deal\nS. RES. 59 - Recognizing the duty of the Federal Government to create a Green New Deal.\nS. J. RES. 8 - Recognizing the duty of the Federal Government to create a Green New Deal.\nH.Amdt.432 - amendment prohibiting DOI spending on pre-leasing & leasing activities in North, Mid, and South Atlantic planning areas\nH.Amdt.450 - amendment prohibiting DOI spending on Atlantic seismic permitting activities\nH.Amdt.452 - amendment prohibiting DOI spending on pre-leasing & leasing activities in all Pacific planning areas\nHR 2181 - Chaco Cultural Heritage Area Protection Act of 2019\nS 1079 - Chaco Cultural Heritage Area Protection Act of 2019\nHR 6289 - Prohibits the Department of the Interior from suspending, waiving, or reducing rents or royalties that the government receives for the production of certain mineral resources\nHR 748 - CARES Act\nS 3548 - CARES Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "H.R.5430 - United States-Mexico-Canada Agreement Implementation Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H. R. 880 - To amend the Internal Revenue Code of 1986 to repeal loopholes for major integrated oil companies, and for other purposes.\nS. 940 - To cap the emissions of greenhouse gases through a requirement to purchase carbon permits, to distribute the proceeds of such purchases to eligible individuals, and for other purposes.\nImplementation of Tax Cuts and Jobs Act\nGeneral tax issues impacting domestic oil and natural gas producers\nHR 748 - CARES Act\nS 3548 - CARES Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "HR 748 - CARES Act\nS 3548 - CARES Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Education and advocacy related to potential impact on oil and natural gas producers with respect to tariffs and/or quotas imposed on imported steel tubular goods.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21777, "prefix": null, "prefix_display": null, "first_name": "BARRY", "nickname": null, "middle_name": null, "last_name": "RUSSELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 13286, "prefix": null, "prefix_display": null, "first_name": "LEE", "nickname": null, "middle_name": null, "last_name": "FULLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12703, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "NAATZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57709, "prefix": null, "prefix_display": null, "first_name": "MALLORI", "nickname": null, "middle_name": null, "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34962, "prefix": null, "prefix_display": null, "first_name": "RYAN", "nickname": null, "middle_name": null, "last_name": "ULLMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 148, "name": "Bureau of Land Management (BLM)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	31120	DC	DC	US	US		0	0	1180679		normalized_name_state	0.9

Links from other tables

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