home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 877352d3-c2ce-4e12-aa8b-4e903b93dca1

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
877352d3-c2ce-4e12-aa8b-4e903b93dca1 Q3 25328 DENNY MILLER ASSOCIATES 133102 AMERICAN AIRLINES 2011 third_quarter 2011-10-18T10:17:01.673000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/877352d3-c2ce-4e12-aa8b-4e903b93dca1/", "filing_uuid": "877352d3-c2ce-4e12-aa8b-4e903b93dca1", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2011, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/877352d3-c2ce-4e12-aa8b-4e903b93dca1/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Denny Miller, President", "dt_posted": "2011-10-18T10:17:01.673000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "400 N Capitol St, Ste 363", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 25328, "url": "https://lda.senate.gov/api/v1/registrants/25328/", "house_registrant_id": 30761, "name": "DENNY MILLER ASSOCIATES", "description": "Lobbying, consulting and government relations", "address_1": "400 N Capitol St, Ste 363", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MELISSA BROWN", "contact_telephone": "+1 202-783-0280", "dt_updated": "2022-04-06T16:06:34.952708-04:00"}, "client": {"id": 133102, "url": "https://lda.senate.gov/api/v1/clients/133102/", "client_id": 1421, "name": "AMERICAN AIRLINES", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "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": "2007-07-30"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "S 1596 Transportation, Housing and Urban Development and Related Agencies Appropriations Act, FY 2012. HR 658 FAA Air Transportation Modernization and Safety Improvement Act of 2012. HR 2279 Airport and Airway Extension Act of 2011, Part III. HR 2253 Airport and Airway Extension Act of 2011, Part IV. S 1387 Airport and Airway Extension Act of 2011, Part IV. HR 2017 Department of Homeland Security Appropriations Act of 2012, issues related to global distribution systems and equipage. General issues and other issues relating to aviation fees.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21146, "prefix": null, "prefix_display": null, "first_name": "WALLY", "nickname": null, "middle_name": null, "last_name": "BURNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "S 1596 Transportation, Housing and Urban Development and Related Agencies Appropriations Act, FY 2012. HR 658 FAA Air Transportation Modernization and Safety Improvement Act of 2012. HR 2279 Airport and Airway Extension Act of 2011, Part III. HR 2253 Airport and Airway Extension Act of 2011, Part IV. S 1387 Airport and Airway Extension Act of 2011, Part IV. HR 2017 Department of Homeland Security Appropriations Act of 2012, issues related to global distribution systems and equipage. General issues and other issues relating to aviation fees.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21146, "prefix": null, "prefix_display": null, "first_name": "WALLY", "nickname": null, "middle_name": null, "last_name": "BURNETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 28.024ms