home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 2f686dfd-8277-4ac1-ade9-2cfd6de36d2d

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
2f686dfd-8277-4ac1-ade9-2cfd6de36d2d YY 47198 WHEAT GOVERNMENT RELATIONS 154682 GLAXOSMITHKLINE 2006 year_end 2007-02-13T19:25:57-05:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/2f686dfd-8277-4ac1-ade9-2cfd6de36d2d/", "filing_uuid": "2f686dfd-8277-4ac1-ade9-2cfd6de36d2d", "filing_type": "YY", "filing_type_display": "Year-End Report", "filing_year": 2006, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/2f686dfd-8277-4ac1-ade9-2cfd6de36d2d/print/", "filing_document_content_type": "application/pdf", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-02-13T19:25:57-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 47198, "url": "https://lda.senate.gov/api/v1/registrants/47198/", "house_registrant_id": 34397, "name": "WHEAT GOVERNMENT RELATIONS", "description": "Government Relations Firm", "address_1": "8627 Burdette Rd", "address_2": null, "address_3": null, "address_4": null, "city": "Bethesda", "state": "MD", "state_display": "Maryland", "zip": "20817", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MR. ALAN WHEAT", "contact_telephone": "+1 202-494-4977", "dt_updated": "2022-04-06T16:08:14.241535-04:00"}, "client": {"id": 154682, "url": "https://lda.senate.gov/api/v1/clients/154682/", "client_id": 428, "name": "GLAXOSMITHKLINE", "general_description": "Worldwide research-based pharmaceutical and healthcare company", "client_government_entity": null, "client_self_select": false, "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-09"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "\r\nS. 2823, H.R. 6143 Ryan White HIV/AIDS Treatment Modernization Act- A bill to provide life-saving care for those with HIV/AIDS", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7559, "prefix": null, "prefix_display": null, "first_name": "MARYANNE", "nickname": null, "middle_name": null, "last_name": "SAPIO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 24441, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38424, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "\r\nHR 5337 Reform of National Security Reviews of Foreign Direct Investments Act", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7559, "prefix": null, "prefix_display": null, "first_name": "MARYANNE", "nickname": null, "middle_name": null, "last_name": "SAPIO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 24441, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38424, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "\r\nS. 3778 An original bill to reauthorize and improve the Small Business Act of 1958, and for other purposes.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7559, "prefix": null, "prefix_display": null, "first_name": "MARYANNE", "nickname": null, "middle_name": null, "last_name": "SAPIO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 24441, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38424, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "\r\nS 3708 An original bill making appropriations for the Departments of Labor, Health and Human Services, and Education, and related agencies for the fiscal year ending September 30, 2007, and for other purposes.\n\nHR 5441 FY 2007 Homeland Security Appropriations\n\nHR 4939 Emergency Supplemental Appropriations Act for Defense the Global War on Terror, and Hurricane Recovery, 2006\r\nHR 5647 Making appropriations for the Departments of Labor, Health and Human Services, and Education, and related agencies for the fiscal year ending September 30, 2007, and for other purposes.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7559, "prefix": null, "prefix_display": null, "first_name": "MARYANNE", "nickname": null, "middle_name": null, "last_name": "SAPIO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 24441, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38424, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "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 89.937ms