home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 623bd41f-9e9d-45f0-b75f-d3392cbf64cb

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
623bd41f-9e9d-45f0-b75f-d3392cbf64cb Q3 5222 BALL JANIK LLP 106128 NORTHWEST RIVERPARTNERS 2013 third_quarter 2013-10-09T14:09:21.417000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/623bd41f-9e9d-45f0-b75f-d3392cbf64cb/", "filing_uuid": "623bd41f-9e9d-45f0-b75f-d3392cbf64cb", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2013, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/623bd41f-9e9d-45f0-b75f-d3392cbf64cb/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Irene Ringwood - Partner", "dt_posted": "2013-10-09T14:09:21.417000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "655 Fifteenth Street NW Suite 225", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 5222, "url": "https://lda.senate.gov/api/v1/registrants/5222/", "house_registrant_id": 32404, "name": "BALL JANIK LLP", "description": "Law/lobby firm", "address_1": "655 F Street NW Suite 225", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GEOFFREY URBACH", "contact_telephone": "+1 202-638-3307", "dt_updated": "2022-04-06T16:04:34.518196-04:00"}, "client": {"id": 106128, "url": "https://lda.senate.gov/api/v1/clients/106128/", "client_id": 1002072, "name": "NORTHWEST RIVERPARTNERS", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": null, "state_display": null, "country": "", "country_display": "* Undetermined", "ppb_state": null, "ppb_state_display": null, "ppb_country": "", "ppb_country_display": "* Undetermined", "effective_date": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Participate in the debate regarding endangered fish species in the Columbia/Snake Rivers. Support H.R. 1308, The Endangered Salmon & Fisheries Predation Prevention Act. Support the NOAA revised Biological Opinion on ESA listed salmon and steelhead in the Columbia Basin. Participate in the process of reviewing the US-Canada Columbia River Treaty.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 32544, "prefix": null, "prefix_display": null, "first_name": "IRENE", "nickname": null, "middle_name": null, "last_name": "RINGWOOD", "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": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Support S.545, Hydropower Improvement Act of 2013 and H.R. 267, Hydropower Regulatory Efficiency Act of 2013. Support hydropower, in general. Monitor Bonneville Power Administration Fish and Wildlife issues in general.\nSupport S. 306/H.R. 678, Bureau of Reclamation Small Conduit Hydropower Development and Rural Jobs Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 32544, "prefix": null, "prefix_display": null, "first_name": "IRENE", "nickname": null, "middle_name": null, "last_name": "RINGWOOD", "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

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