home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 078b86d5-b102-406a-84c2-d70ea4b4d503

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
078b86d5-b102-406a-84c2-d70ea4b4d503 Q4 11982 DELTA AIR LINES, INC. 116564 DELTA AIR LINES INC 2016 fourth_quarter 2017-01-17T15:23:41-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/078b86d5-b102-406a-84c2-d70ea4b4d503/", "filing_uuid": "078b86d5-b102-406a-84c2-d70ea4b4d503", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2016, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/078b86d5-b102-406a-84c2-d70ea4b4d503/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "677834.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Will Kinzel", "dt_posted": "2017-01-17T15:23:41-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1212 New York Ave, NW Suite 200", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 11982, "url": "https://lda.senate.gov/api/v1/registrants/11982/", "house_registrant_id": 31867, "name": "DELTA AIR LINES, INC.", "description": null, "address_1": "601 Pennsylvania Avenue, NW", "address_2": "Suite 700", "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": "HEATHER WINGATE", "contact_telephone": "+1 202-216-0700", "dt_updated": "2026-01-30T11:16:01.476255-05:00"}, "client": {"id": 116564, "url": "https://lda.senate.gov/api/v1/clients/116564/", "client_id": 12, "name": "DELTA AIR LINES INC", "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": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "H.R. 4891 - Technical Corrections Act of 2016 \nH.R. 5180 - The Food and Fuel Consumer Protection Act\nS. 2775 - Technical Corrections Act of 2016\n\n\nOTHER CONGRESSIONAL/REGULATORY MATTERS:\nRenewable Fuel Standards/RINs\nEnergy Tax Issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "OTHER CONGRESSIONAL/REGULATORY MATTERS:\nTransportation Security Administration (TSA) Aviation Security Taxes and Fees\nCustoms & Border Protection Taxes\nVarious federal income and excise tax matters\nVarious pension and retirement matters\nIssues related to aviation fuel taxes", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "H.R. TBD - Department of State, Foreign Operations, and Related Programs Appropriations Act, 2017\nS. 3117 - Department of State, Foreign Operations, and Related Programs Appropriations Act, 2017\n\n\nOTHER CONGRESSIONAL/REGULATORY MATTERS:\nInternational Air Service Rights Issues (U.S. Government Bilateral Negotiations)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "OTHER CONGRESSIONAL/REGULATORY MATTERS:\nAviation Industry Financial Issues\nRIN Markets", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 5394 - Transportation, Housing and Urban Development and Related Agencies Appropriations Act, 2017\nS. 2844 - Transportation, Housing and Urban Development and Related Agencies Appropriations Act, 2017\nH.R. TBD - Department of State, Foreign Operations, and Related Programs Appropriations Act, 2017\nS. 3117 - Department of State, Foreign Operations, and Related Programs Appropriations Act, 2017\nS. 3001 - Department of Homeland Security Appropriations Act, 2017\nH.R. 5634 - Department of Homeland Security Appropriations Act, 2017\nH.R. 5485 - Financial Services and General Government Appropriations Act, 2017\nS. 3067 - Financial Services and General Government Appropriations Act, 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "H.R. 5394 - FY2017 Transportation, Housing and Urban Development, and Related Agencies Appropriations Act\nS. 2844 - FY2017 Transportation, Housing and Urban Development, and Related Agencies Appropriations Act\nS. 3117 - Department of State, Foreign Operations, and Related Programs Appropriations Act, 2017\nH.R. TBD - Department of State, Foreign Operations, and Related Programs Appropriations Act, 2017\nS. 1972 - Airlines Access to Emergency Epinephrine Act of 2015\nH.R. 4171 - Silent Skies Act of 2015\n\nOTHER CONGRESSIONAL/REGULATORY MATTERS:\nAir Traffic Control Reform\nPassenger Facility Charge Tax\nUnmanned Aerial Systems\nFAA Flight and Duty Time regulations\nLithium Battery regulations\nAirline Alliance Antitrust Immunity Issues\nAirlines Service Quality Issues (domestic and international)\nAviation Industry Financial Issues\nAircraft Noise and Emissions Issues\nAlternative Aviation Fuels\nDepartment of Transportation Passenger Protection Regulations Rule III\nDepartment of Transportation Full Fare Advertising Rule\nDepartment of Transportation Ancillary Revenue Reporting Rule\nInternational Air Service Rights Issues (US Government Bilateral Negotiations)\nFAA NextGen Initiative\nIssues Related to Global Distribution Systems and online travel sites\nFY2016 DHS budget proposals, including proposals to increase the TSA passenger security fee, customers user fee, and immigrations user fee\nHaneda Airport Liberalization\nFair Competition Issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "OTHER CONGRESSIONAL/REGULATORY MATTERS:\nImmigration User Fee\nImplementation of Biometric Entry and Exit Systems\nImmigration Line Waits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "S. 3001 - Department of Homeland Security Appropriations Act, 2017\nH.R. 5634 - Department of Homeland Security Appropriations Act, 2017\nH.R. 3584 - Transportation Security Administration Reform and Improvement Act of 2015\n\n\nOTHER CONGRESSIONAL/REGULATORY TRADE MATTERS:\nTransportation Security Administration (TSA) Aviation Security Taxes and Fees\nAirport Security Issues\nAir Cargo Security Issues\nCustoms & Border Protection Fees\nCivil Aviation Security Issues including expansion or trusted traveler/risk-based screening programs, airport checkpoint lane staffing, secondary cockpit barriers, canines and lobby security\nCustoms and Border Protection (CBP) issues, including CBP staffing levels at airports, preclearance issues and proposed CBP user fee increase\nFY 2017 DOT/FAA and DSH budget proposals, including proposals to increase the customer use and immigration user fee\nFY2017 DOT/FAA and DHS Budget proposals, including proposals to increase the TSA passenger security fee, customs user fee, and immigration user fee\nTSA Aviation Security Taxes and Fees", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 49072, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANDREA", "nickname": null, "middle_name": "FISCHER", "last_name": "NEWMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1380, "prefix": null, "prefix_display": null, "first_name": "SAMETTA", "nickname": null, "middle_name": null, "last_name": "BARNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59446, "prefix": null, "prefix_display": null, "first_name": "WILL", "nickname": null, "middle_name": null, "last_name": "KINZEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59448, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "LETTENEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61457, "prefix": null, "prefix_display": null, "first_name": "MIMI", "nickname": null, "middle_name": null, "last_name": "BRANIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64563, "prefix": null, "prefix_display": null, "first_name": "MOLLY", "nickname": null, "middle_name": null, "last_name": "HARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31867 DC DC US US   0 0           677834.0

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 6 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.688ms · Privacy