home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9a78401d-8b3e-44dd-9769-06204748899d

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
9a78401d-8b3e-44dd-9769-06204748899d 1T 6850 BRACY TUCKER BROWN & VALANZANO, INC. 109556 WILLIS NORTH AMERICA INC 2018 first_quarter 2018-02-02T08:55:39.787000-05:00 16000.0 0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/9a78401d-8b3e-44dd-9769-06204748899d/", "filing_uuid": "9a78401d-8b3e-44dd-9769-06204748899d", "filing_type": "1T", "filing_type_display": "1st Quarter - Termination", "filing_year": 2018, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9a78401d-8b3e-44dd-9769-06204748899d/print/", "filing_document_content_type": "text/html", "income": "16000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Deborah Thieme", "dt_posted": "2018-02-02T08:55:39.787000-05:00", "termination_date": "2018-01-31", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1615 L STREET, NW, #520", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 6850, "url": "https://lda.senate.gov/api/v1/registrants/6850/", "house_registrant_id": 31812, "name": "BRACY TUCKER BROWN & VALANZANO, INC.", "description": "Government Affairs, Lobbyist", "address_1": "1050 Connecticut Ave. NW, Ste. 500", "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": "TRACY TUCKER", "contact_telephone": "", "dt_updated": "2026-01-26T16:42:33.387413-05:00"}, "client": {"id": 109556, "url": "https://lda.senate.gov/api/v1/clients/109556/", "client_id": 633, "name": "WILLIS NORTH AMERICA INC", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "NY", "state_display": "New York", "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": "2007-10-11"}, "lobbying_activities": [{"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "Monitor the implementation of the reauthorization of Terrorism Risk Insurance Act (TRIA), specifically regarding data collection and the National Assoc. of Registered Agents and Brokers Reform Act, as included in that Act. Also monitor the activities of the FIO Advisory Committee on Alternative Risk Sharing Mechanisms for TRIA. \nMonitor issues re implementation of health insurance reform, and efforts to repeal and replace the ACA as in the American Health Care and the Graham/Cassidy amendment to the budget reconciliation act (H.R.1628). \nSupport efforts to repeal the Cadillac Tax as in H.R.173, and S.58. \nMonitor tax reform proposals generally and support efforts to preserve the current tax treatment for employer sponsored health plans and other employee benefits. \nSupport efforts to maintain current treatment of self-insured plans. \nMonitor the Small Business Health Insurance Act of 2017 (H.R.1101). \nMonitor efforts to make changes in the Dodd-Frank Act, as they may relate to insurance. \nMonitor the activities of the Federal Insurance Office and the development of insurance modernization proposals. \nMonitor issues related to cyber security and the cyber security insurance market, including the House Small Business Committees hearing on cyber insurance for small businesses. \nSupport the clarification of the Foreign Account Tax Compliance Act to exclude property/casualty insurance as in H.R. 871. \nSupport the reauthorization of the National Flood Insurance Program, particularly the Flood Insurance Market Parity and Modernization Act (S. 563 & H.R. 1422), the Repeatedly Flooded Communities Preparation Act (H.R. 1558), the NFIP Policyholder Protection Act of 2017 (H.R. 2868), the 21st Century Flood Reform Act of 2017 (H.R. 2874), the NFIP Administrative Reform Act of 2017 (H.R. 2875), the Taxpayer Exposure Mitigation Act of 2017 (H.R. 2246), and H.R. 2565 requiring use of replacement cost in determining premium rates. \nMonitor issues related insurance generally.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 13568, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": null, "last_name": "VALANZANO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 8904, "prefix": "mr", "prefix_display": "MR.", "first_name": "TERRENCE", "nickname": null, "middle_name": "L", "last_name": "BRACY", "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": []}

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.923ms