lobbying_filings_raw: a0c31ae7-079b-492b-a5ca-e1ec7f37b7ea

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
a0c31ae7-079b-492b-a5ca-e1ec7f37b7ea	Q2	31281	ENERGY MARKETERS OF AMERICA	138160	ENERGY MARKETERS OF AMERICA	2013	second_quarter	2013-07-22T19:39:00.573000-04:00	170000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/a0c31ae7-079b-492b-a5ca-e1ec7f37b7ea/", "filing_uuid": "a0c31ae7-079b-492b-a5ca-e1ec7f37b7ea", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2013, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a0c31ae7-079b-492b-a5ca-e1ec7f37b7ea/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "170000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Robert L. Underwood", "dt_posted": "2013-07-22T19:39:00.573000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1901 NORTH FORT MYER DRIVE, #500", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "ARLINGTON", "registrant_state": "VA", "registrant_zip": "22209", "registrant": {"id": 31281, "url": "https://lda.senate.gov/api/v1/registrants/31281/", "house_registrant_id": 30986, "name": "ENERGY MARKETERS OF AMERICA", "description": "Trade association formerly known as the Petroleum Marketers Association of America", "address_1": "1901 North Fort Myer Drive", "address_2": "Suite 500", "address_3": null, "address_4": null, "city": "Arlington", "state": "VA", "state_display": "Virginia", "zip": "22209", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ROBERT L UNDERWOOD", "contact_telephone": "+1 703-351-8000", "dt_updated": "2026-01-14T10:14:32.707002-05:00"}, "client": {"id": 138160, "url": "https://lda.senate.gov/api/v1/clients/138160/", "client_id": 12, "name": "ENERGY MARKETERS OF AMERICA", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2020-10-09"}, "lobbying_activities": [{"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Rules implementation for the Dodd-Frank Wall Street Reform and Consumer Protection Act (Public Law No: 111-203) regarding interchange fees and derivatives (swaps and Futures market position limits on WTI) overhaul; HR 1838 - A bill to repeal a provision of the Dodd-Frank Wall Street Reform and Consumer Protection Act prohibiting any federal bailout of swap dealers or participants.\nHR 3283 - Swap Jurisdiction Certainty Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "ROD", "general_issue_code_display": "Roads/Highway", "description": "Highway Safety; transporation of hazardous materials; highway funding; gasoline taxes; SAFETEA-LU; Wetlines (cargo tank loading lines) and Interstate rest area commercialization; Surface transportation reauthorization; gasoline and Leaking Underground Storage Tank tax reauthorizations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "CDT", "general_issue_code_display": "Commodities (big ticket)", "description": "Implementation of Title VII of the DoddFrank Wall Street Reform and Consumer Protection Act (Pub.L. 111-203); H.R. 992, Swaps Regulatory Improvement Act,\" H.R. 1256, the Swaps Jurisdiction Certainty Act,\" H.R.634, the Business Risk Mitigation and Price Stabilization Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "As referenced under highway issues, the transportation and distribution of petroleum products and hazardous materials; hours of service; driver registration; hazardous materials fees;Wetlines (cargo tank loading lines)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "Because the sequence of events following a natural disaster are often similar in terms of access to fuel supplies, PMAA organized a task force that is examining the bottle necks and making recommendations to federal and state governments to streamline the process. Hours of service, boutique fuel waivers,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Repealing menu-labeling provisions mandating c-stores conform to national, uniform nutrition disclosure standards. Repealing a food Stamp provision in the 2012 House and Senate farm bill reauthorizations which states that c-stores no longer can receive food stamps if 45 percent or more of a c-store's sales come from alcohol, tobacco and hot food products. Menu Labeling: Commonsense Nutrition Disclosure Act (H.R. 1249); Obamacare repeal and delaying the employer mandate", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Appropriations measure as they apply to the Department of Energy, the Environmental Protections Agency, CFTC, the Department of the Interior, the Department of Health and Human Services, Department of Transportation and Agriculture. continuing resolution for 2013", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Environmental issues as they relate to petroleum storage, distribution and customer delivery including: EPA's Underground storage proposed rule; superfund cleanup; ethanol \"blendwall\" issues -- EPA RFS II; Domestic Fuels Protection Act of 2013; biodiesel Renewable Identification Numbers (RINs) fraud, EPA's RINs Quality Assurance PlanStage II vapor controls, Tier 3 gasoline, E15 proposed rules at EPA", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "CR for FY 2013 and FY 2014 budgets on -- Low Income Home Energy Assistance Program, Northeast Home Heating Oil Reserve; grants to reduce emissions from diesel engines; weatherization grants; EPA's proposed underground storage tank proposed rule, National Oilheat Research Alliance Reauthorization (S. 949, H.R. 1985); Domestic Fuels Protection Act, (H.R. 1214)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "All issues related to the motor fuels industry which affects supply, disruption, transportation and sales of the product Ultra Low Sulfur Diesel implementation; Renewable Identification Numbers; Federal Trade Commission, filed comments on agency's proposed biodiesel labeling rule; Refined Product Petroleum Reserve/ Natural Gas Act/ gas to liquids technology, Keystone XL Pipeline, Northern Route Approval Act; ULSD corrosion studies", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Fuel emissions standards (tier 3 gasoline/ozone proposed rules) Leaking Underground Storage Tank fund issues \"Energy Independence and Security Act\" (Public Law No: 110-140); Underground storage tank reauthorization tax issues; Energy Tax Prevention Act of 2011 (S. 482, H.R. 910); bills that would limit EPA's ability to enforce climate change regulations, EPA's new UST proposed Rules, biodiesel content labeling, Ethanol blendwall (RVP) requirements, RFS reform bills,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "IND", "general_issue_code_display": "Indian/Native American Affairs", "description": "Sales of tobacco to non-tribe members; taxation issues between states and tribal governments;", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 11430, "prefix": null, "prefix_display": null, "first_name": "BRANDON", "nickname": null, "middle_name": null, "last_name": "WRIGHT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Estate tax; gasoline taxes; remittance of state sales taxes; Biodiesel tax credit and production tax credit opposition; ethanol/biodiesel tax credit; refueling infrastructure tax credits, blender pumps; Leaking underground storage tank tax, oilheat efficiency tax credits in section 25(c); tobacco taxes included in President's FY 2014 budget", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44850, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "S", "last_name": "MORGAN", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TOB", "general_issue_code_display": "Tobacco", "description": "\"Family Smoking Prevention and Tobacco Control Act (P.L. 111-31);\" Roll your own tobacco provisions within Highway bill, tobacco taxes included in President's FY 2014 budget", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59206, "prefix": null, "prefix_display": null, "first_name": "DAN", "nickname": null, "middle_name": null, "last_name": "GILLIGAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1336, "prefix": null, "prefix_display": null, "first_name": "SHERRI", "nickname": null, "middle_name": null, "last_name": "STONE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 6319, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "UNDERWOOD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 218, "name": "Federal Motor Carrier Safety Administration"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	VA	US	30986	VA	VA	US	US		0	0	971260		normalized_name	0.7

Links from other tables

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