home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 7cbd037b-8fca-4d98-b248-bcfe6ee2f3ee

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
7cbd037b-8fca-4d98-b248-bcfe6ee2f3ee Q4 91774 CAPITOL HILL STRATEGIES, LLC 174778 PRINCIPAL FINANCIAL GROUP 2017 fourth_quarter 2018-01-16T14:37:09.637000-05:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7cbd037b-8fca-4d98-b248-bcfe6ee2f3ee/", "filing_uuid": "7cbd037b-8fca-4d98-b248-bcfe6ee2f3ee", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2017, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7cbd037b-8fca-4d98-b248-bcfe6ee2f3ee/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "A.J. Wojciak", "dt_posted": "2018-01-16T14:37:09.637000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "660 Pennsylvania Avenue, SE Suite 202", "registrant_address_2": null, "registrant_different_address": true, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 91774, "url": "https://lda.senate.gov/api/v1/registrants/91774/", "house_registrant_id": 36809, "name": "CAPITOL HILL STRATEGIES, LLC", "description": "consultant lobbying", "address_1": "660 Pennsylvania Avenue, SE Suite 202", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHARLES M. BRAIN", "contact_telephone": "+1 202-589-0002", "dt_updated": "2022-04-06T16:08:08.041856-04:00"}, "client": {"id": 174778, "url": "https://lda.senate.gov/api/v1/clients/174778/", "client_id": 1004672, "name": "PRINCIPAL FINANCIAL GROUP", "general_description": "Investment manager and provider of financial products and services", "client_government_entity": false, "client_self_select": false, "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": "2013-04-01"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "H.R. 4173/Public Law 111-203, Dodd-Frank Wall Street Reform and Consumer Protection Act, implementation and regulatory reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 13073, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "M", "last_name": "BRAIN", "suffix": null, "suffix_display": null}, "covered_position": "Asst. to the President, Dp.Chief Staff W&M Cmte", "new": false}, {"lobbyist": {"id": 46305, "prefix": "mr", "prefix_display": "MR.", "first_name": "A.", "nickname": null, "middle_name": "J.", "last_name": "WOJCIAK", "suffix": null, "suffix_display": null}, "covered_position": "Senior Legislative Asst., Cong. Earl Pomeroy", "new": false}, {"lobbyist": {"id": 61804, "prefix": null, "prefix_display": null, "first_name": "BEAU`", "nickname": null, "middle_name": null, "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": "LD-CongTanner, LD-CongMcIntyre,SA-CongRose", "new": false}, {"lobbyist": {"id": 59342, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "MCHUGH", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Sen. Chuck Schumer", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 1, An Act to provide for reconciliation pursuant to titles II and V of the concurrent resolution on the budget for fiscal year 2018; comprehensive tax reform legislation, generally\nand specifically, tax treatment of and implication for retirement and life insurance products", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 13073, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "M", "last_name": "BRAIN", "suffix": null, "suffix_display": null}, "covered_position": "Asst. to the President, Dp.Chief Staff W&M Cmte", "new": false}, {"lobbyist": {"id": 46305, "prefix": "mr", "prefix_display": "MR.", "first_name": "A.", "nickname": null, "middle_name": "J.", "last_name": "WOJCIAK", "suffix": null, "suffix_display": null}, "covered_position": "Senior Legislative Asst., Cong. Earl Pomeroy", "new": false}, {"lobbyist": {"id": 61804, "prefix": null, "prefix_display": null, "first_name": "BEAU`", "nickname": null, "middle_name": null, "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": "LD-CongTanner, LD-CongMcIntyre,SA-CongRose", "new": false}, {"lobbyist": {"id": 59342, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "MCHUGH", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Sen. Chuck Schumer", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Issues related to proposed Department of Labor regulations on investment advice (Fiduciary Rule)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 13073, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "M", "last_name": "BRAIN", "suffix": null, "suffix_display": null}, "covered_position": "Asst. to the President, Dp.Chief Staff W&M Cmte", "new": false}, {"lobbyist": {"id": 46305, "prefix": "mr", "prefix_display": "MR.", "first_name": "A.", "nickname": null, "middle_name": "J.", "last_name": "WOJCIAK", "suffix": null, "suffix_display": null}, "covered_position": "Senior Legislative Asst., Cong. Earl Pomeroy", "new": false}, {"lobbyist": {"id": 61804, "prefix": null, "prefix_display": null, "first_name": "BEAU`", "nickname": null, "middle_name": null, "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": "LD-CongTanner, LD-CongMcIntyre,SA-CongRose", "new": false}, {"lobbyist": {"id": 59342, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "MCHUGH", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Sen. Chuck Schumer", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R. 1628, American Health Care Act of 2017, reconciliation legislation repealing significant portions of the Patient Protection and Affordable Care Act, potential provisions relating to legislatively extending Cost Sharing Reduction payments to insurers", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46305, "prefix": "mr", "prefix_display": "MR.", "first_name": "A.", "nickname": null, "middle_name": "J.", "last_name": "WOJCIAK", "suffix": null, "suffix_display": null}, "covered_position": "Senior Legislative Aide to Rep. Earl Pomeroy", "new": false}, {"lobbyist": {"id": 13073, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "M", "last_name": "BRAIN", "suffix": null, "suffix_display": null}, "covered_position": "Assistant to the President, Deputy COS House Ways and Means Committee", "new": false}, {"lobbyist": {"id": 61804, "prefix": null, "prefix_display": null, "first_name": "BEAU`", "nickname": null, "middle_name": null, "last_name": "SCHUYLER", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director Rep. John Tanner", "new": false}, {"lobbyist": {"id": 59342, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "MCHUGH", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director Sen. Chuck Schumer", "new": false}], "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
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 54.337ms