home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 6a40b95c-8961-4628-bb82-70ab51dc7ca5

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
6a40b95c-8961-4628-bb82-70ab51dc7ca5 Q1 82658 DAYTON DEVELOPMENT COALITION 171775 DAYTON DEVELOPMENT COALITION 2012 first_quarter 2012-04-18T17:19:33.090000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/6a40b95c-8961-4628-bb82-70ab51dc7ca5/", "filing_uuid": "6a40b95c-8961-4628-bb82-70ab51dc7ca5", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/6a40b95c-8961-4628-bb82-70ab51dc7ca5/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "60000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Michael Gessel, Vice President, Government Relations", "dt_posted": "2012-04-18T17:19:33.090000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2111 WILSON BOULEVARD, #700", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "ARLINGTON", "registrant_state": "VA", "registrant_zip": "22201", "registrant": {"id": 82658, "url": "https://lda.senate.gov/api/v1/registrants/82658/", "house_registrant_id": 36370, "name": "DAYTON DEVELOPMENT COALITION", "description": null, "address_1": "1550 Wilson Boulevard, Suite 700", "address_2": null, "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": "MICHAEL GESSEL", "contact_telephone": "", "dt_updated": "2026-01-26T12:29:19.041347-05:00"}, "client": {"id": 171775, "url": "https://lda.senate.gov/api/v1/clients/171775/", "client_id": 12, "name": "DAYTON DEVELOPMENT COALITION", "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": "2003-01-06"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Funding for economic development of Dayton, Ohio region, including legislation promoting an enduring relationship between the Air Force Research Laboratory (AFRL), Federal Aviation Administration (FAA), and the National Aeronautics and Space Administration (NASA) to perform collaborative research at AFRL on integrating Unmanned Aircraft Systems (UAS) in the National Airspace System (NAS); funding in the Defense Appropriations Bill for research on integrating Unmanned Aircraft Systems (UAS) in the National Airspace System (NAS); funding in the in the Transportation/HUD Appropriations Bill for research on integrating Unmanned Aircraft Systems (UAS) in the National Airspace System (NAS); funding in the Commerce/Justice/Science Appropriations Bill for research on integrating Unmanned Aircraft Systems (UAS) in the National Airspace System (NAS); funding for an Acquisition Management Complex, Phase V and funding for a Foreign Materiel Exploitation Facility in the MILCON-VA Appropriations Bill; legislation that will direct the Secretary of Defense to establish an agreement with the National Research Council to complete a review Defense Department specialized degree-granting graduate programs in engineering, science and management; legislation directing the Secretary of Defense to conduct a study on the benefits of modifying NASICs management structure; legislation to codify Defense Department regulations relative to donating military aircraft to nongovernmental entities; actions to facilitate the Air Force Reserve to locate a proposed assault runway in Ohio; actions to urge the Department of Veterans Affairs to locate its Health Administration national archive on the campus of the Dayton Veterans Affairs Medical Center in West Dayton; actions to increase medical research at the Dayton Veterans Affairs Medical Center; actions to urge the National Park Service to complete a new General Management Plan for the Dayton Aviation Heritage National Historical Park and to complete a Historic Structures Report for a the Wright Factory Company buildings and Hawthorn Hill two sites recently included within the boundaries of the park; H.R.799 and S.858, Colonel Charles Young Home Study Act (all portions); legislation to amend 6 U.S.C. Section 1102(b) to add the National Center for Medical Readiness as a member of the National Domestic Preparedness Consortium and provide funding for the Consortium, effort to increase activities among the Director of National Intelligence, the Department of Defense, and the Advanced Technical Intelligence Center for Human Capital Development (ATIC).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 38574, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "GESSEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 36370 VA VA US US   0 0           60000.0

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.496ms · Privacy