home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 7d8d224e-ebea-41b9-b45f-208bf95d937c

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
7d8d224e-ebea-41b9-b45f-208bf95d937c 2A 40009067 BEECHCRAFT CORPORATION 187593 BEECHCRAFT CORPORATION 2011 second_quarter 2011-07-12T18:37:35.840000-04:00 60000.0 1 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7d8d224e-ebea-41b9-b45f-208bf95d937c/", "filing_uuid": "7d8d224e-ebea-41b9-b45f-208bf95d937c", "filing_type": "2A", "filing_type_display": "2nd Quarter - Amendment", "filing_year": 2011, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7d8d224e-ebea-41b9-b45f-208bf95d937c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "60000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Douglas R. Scott, Director Congressional Affairs & Strategic Planning", "dt_posted": "2011-07-12T18:37:35.840000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "9709 E. Central", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Wichita", "registrant_state": "KS", "registrant_zip": "67201", "registrant": {"id": 40009067, "url": "https://lda.senate.gov/api/v1/registrants/40009067/", "house_registrant_id": 39742, "name": "BEECHCRAFT CORPORATION", "description": "Manufacturer of business and general aviation and military trainer/light attack aircraft", "address_1": "10511 E. Central Ave.", "address_2": null, "address_3": null, "address_4": null, "city": "Wichita", "state": "KS", "state_display": "Kansas", "zip": "67206-2557", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DOUGLAS R. SCOTT", "contact_telephone": "+1 316-676-5031", "dt_updated": "2022-04-06T16:06:23.062843-04:00"}, "client": {"id": 187593, "url": "https://lda.senate.gov/api/v1/clients/187593/", "client_id": 48, "name": "BEECHCRAFT CORPORATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "KS", "state_display": "Kansas", "country": "US", "country_display": "United States of America", "ppb_state": "KS", "ppb_state_display": "Kansas", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2013-04-22"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Export-Import Bank of the US reauthorization.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43184, "prefix": "mr", "prefix_display": "MR.", "first_name": "DOUGLAS", "nickname": null, "middle_name": "R", "last_name": "SCOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54258, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "PAUL", "last_name": "BLOUIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "4G Long Term Evolution (LTE) wireless broadband communication network impact on General Aviation aircraft that use GPS navigation. Continuance of the Block Aircraft Registration Request (BARR) program. Federal Aviation Administration Reauthorization and Reform Act of 2011.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43184, "prefix": "mr", "prefix_display": "MR.", "first_name": "DOUGLAS", "nickname": null, "middle_name": "R", "last_name": "SCOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54258, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "PAUL", "last_name": "BLOUIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "FY12 authorizations and appropriations for Custom & Border Protection (CBP) Multi-role Enforcement Aircraft (MEA).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38990, "prefix": null, "prefix_display": null, "first_name": "LYNDON", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "FY12 Senate and House authorizations and appropriations for: Joint Primary Aircraft Training System (JPATS), Light Attack Armed Reconnaissance (LAAR), US Army Enhanced Medium Altitude Reconnaissance Surveillance System (EMARSS), USMC UC-12W aircraft and various US armed service requests for King Air and T-6 aircraft. Advocacy for the USAF Light Air Support (LAS) program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43184, "prefix": "mr", "prefix_display": "MR.", "first_name": "DOUGLAS", "nickname": null, "middle_name": "R", "last_name": "SCOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38990, "prefix": null, "prefix_display": null, "first_name": "LYNDON", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 210, "name": "U.S. Marines"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 3.251ms