home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 419dcaae-b5a8-4e36-bcc2-e69f5af98b41

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
419dcaae-b5a8-4e36-bcc2-e69f5af98b41 Q3 10478 CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) 114334 CITY OF RIDGEFIELD 2018 third_quarter 2018-10-16T15:12:49.547000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/419dcaae-b5a8-4e36-bcc2-e69f5af98b41/", "filing_uuid": "419dcaae-b5a8-4e36-bcc2-e69f5af98b41", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2018, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/419dcaae-b5a8-4e36-bcc2-e69f5af98b41/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Joel Rubin", "dt_posted": "2018-10-16T15:12:49.547000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "820 1st Street NE", "registrant_address_2": "Suite 710", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 10478, "url": "https://lda.senate.gov/api/v1/registrants/10478/", "house_registrant_id": 30189, "name": "CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK)", "description": "Joint Municipal Water District", "address_1": "1015 15TH ST NW", "address_2": "STE 1125", "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": "JOEL RUBIN", "contact_telephone": "+1 202-347-9171", "dt_updated": "2026-01-29T17:09:14.830153-05:00"}, "client": {"id": 114334, "url": "https://lda.senate.gov/api/v1/clients/114334/", "client_id": 1001927, "name": "CITY OF RIDGEFIELD", "general_description": "Municipal Government", "client_government_entity": true, "client_self_select": null, "state": "WA", "state_display": "Washington", "country": "US", "country_display": "United States of America", "ppb_state": "WA", "ppb_state_display": "Washington", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2016-06-01"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Support transportation enhancement and trails programs and project streamlining; support Pioneer Street extension project.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24056, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "RUBIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64041, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "SKIPPER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66524, "prefix": null, "prefix_display": null, "first_name": "KIRBY", "nickname": null, "middle_name": "JOSEPH", "last_name": "GARRETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "Issues related to local transportation, economic development, public safety and water infrastructure projects. Support funding for Ridgefield Refuge Visitors Center. Support funding for dredging of Lake River. Support BUILD grant application for Ridgefield Junction.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24056, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "RUBIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64041, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "SKIPPER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66524, "prefix": null, "prefix_display": null, "first_name": "KIRBY", "nickname": null, "middle_name": "JOSEPH", "last_name": "GARRETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Support preservation of tax exempt municipal bonds and private activity bonds, expansion of low income housing tax credit and restoration of advanced refunding and state and local tax deduction.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24056, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "RUBIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Making appropriations for Transportation, Housing, Justice, Commerce, Interior & Environment and related agencies for the fiscal year ending September 30, 2019; Specifically advocating for adequate funding for CDBG, Economic Development Administration, COPS, and BUILD grant funding levels.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24056, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "RUBIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64041, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "SKIPPER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66524, "prefix": null, "prefix_display": null, "first_name": "KIRBY", "nickname": null, "middle_name": "JOSEPH", "last_name": "GARRETT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}], "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 3.649ms