home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 28908918-16ac-459a-9685-b45e5ae24ce3

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
28908918-16ac-459a-9685-b45e5ae24ce3 Q1 23496 MAGAZINE PUBLISHERS OF AMERICA 130222 MAGAZINE PUBLISHERS OF AMERICA 2022 first_quarter 2022-04-08T17:25:27-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/28908918-16ac-459a-9685-b45e5ae24ce3/", "filing_uuid": "28908918-16ac-459a-9685-b45e5ae24ce3", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2022, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/28908918-16ac-459a-9685-b45e5ae24ce3/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "91814.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Brigitte Schmidt Gwyn", "dt_posted": "2022-04-08T17:25:27-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1211 CONNECTICUT AVENUE, NW, #610", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 23496, "url": "https://lda.senate.gov/api/v1/registrants/23496/", "house_registrant_id": 30195, "name": "MAGAZINE PUBLISHERS OF AMERICA", "description": null, "address_1": "1211 CONNECTICUT AVENUE, NW, #610", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RITA COHEN", "contact_telephone": "+1 202-369-1237", "dt_updated": "2023-06-06T16:25:13.833354-04:00"}, "client": {"id": 130222, "url": "https://lda.senate.gov/api/v1/clients/130222/", "client_id": 12, "name": "MAGAZINE PUBLISHERS OF AMERICA", "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-13"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 1319 \"American Rescue Plan Act of 2021\"; H.R.1962, S. 784 \"Jobs for Economic Recovery Act of 2021\"; S. 41 \"End Taxpayer Subsidies for Drug Ads Act\"; Fiscal Year 2022 Budget", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "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": "POS", "general_issue_code_display": "Postal", "description": "H.R. 1319 \"American Rescue Plan Act of 2021\"; White House proposal \"American Jobs Plan\"; S.1 \"For the People Act of 2021\"; H.R. 1 \"For the People Act of 2021\"; H.R. 695 \"USPS Fairness Act\"; H.R. 1307 \"Vote by Mail Tracking Act\"; H.R. 1582 \"An act to clarify and increase the restrictions on political activities that are applicable to the members of the Postal Service Board of Governors, including the Postmaster General and the Deputy Postmaster General, and for other purposes\"; S.1720, H.R.3077 \"Postal Service Improvement Act\"; H.R. 3076 \"Postal Reform Act of 2021\"; S,1720 \"Postal Reform Act of 2021\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "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": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Matters related to data privacy, including: S. 1 and H.R. 1, the For the People Act; S. 113 \"BROWSER Act of 2021\"; H.R. 474 Protecting Consumer Information Act of 2021; H.R. 1816 Information Transparency & Personal Data Control Act\"; S. 919 \"Data Care Act of 2021\"; S. 1423 Clean Slate for Kids Online Act of 2021; S. 1444 Mind Your Own Business Act of 2021; S. 1494 Consumer Data Privacy and Security Act of 2021; S. 1628 Children and Teens Online Privacy Protection Act; S. 1630 Safe Social Media Act; S. 1667 Social Media Privacy Protection and Consumer Rights Act of 2021; S. 2134 Data Protection Act of 2021; and H.R. 2154 Protecting Americans from Dangerous Algorithms Act; S. 3195 \"Consumer Online Priacy Rights Act\" Matters related to competition, including: H.R. 3451 Social Media DATA Act; H.R. 3460 State Antitrust Enforcement Venue Act of 2021; H.R. 3611, S. 1896 Algorithmic Justice and Online Platform Transparency Act; H.R. 3816 American Choice and Innovation Online Act; H.R. 3825 Ending Platform Monopolies Act; H.R. 3826 Platform Competition and Opportunity Act of 2021; H.R. 3843 The Merger Filing Fee Modernization Act of 2021; S. 797 \"Platform Accountability and Consumer Transparency Act\"; and H.R. 3849 Augmenting Compatibility and Competition by Enabling Service Switching Act of 2021 or the ACCESS Act of 2021 Matters related to consumer protection, including: S. 936 Shop Safe / Inform Act; H.R. 2683, S. 2072 Unsubscribe Act of 2021; and H.R. 2668 Consumer Protection and Recovery Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Discussion draft of modernizing the Digital Copyright Act (DCA) Federal Register, \"Copyright Office, \"Publishers Protection Study\"; S.3880 \"SMART Act\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 207, "name": "U.S. Copyright Office"}]}, {"general_issue_code": "ADV", "general_issue_code_display": "Advertising", "description": "S. 1 and H.R. 1, the For the People Act, the omnibus bill that contains the Honest Ads Act; S. 41 \"End Taxpayer Subsidies for Drug Ads Act\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 1319 \"American Rescue Plan Act of 2021\"; White House proposal \"American Jobs Plan\"; Fiscal Year 2022 Budget; H.R.5376 \"Build Back Better Act\"; H.R.3684 \"Infrastructure Investment and Jobs Act\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "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": "MIA", "general_issue_code_display": "Media (information/publishing)", "description": "H.R. 4330 An act to maintain the free flow of information to the public by establishing appropriate limits on the federally compelled disclosure of information obtained as part of engaging in journalism, and for other purposes; discussion draft of H.R. 4857, S. 2528 \"The Journalist Protection Act\"; H.R. 1735, S.673 \"The Journalism Competition and Preservation Act\"; H.R. 7185 \"Federal Contracting for Peace and Security Act\"; S.2992, H.R. 3816 \"American Innovation and Choice Online Act\"; S.2710 \"Open App Markets Act\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70870, "prefix": null, "prefix_display": null, "first_name": "BRIGITTE", "nickname": null, "middle_name": "SCHMIDT", "last_name": "GWYN", "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": []} DC US 30195 DC DC US US   0 0           91814.0

Links from other tables

  • 7 rows 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.529ms · Privacy