home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 8770f0e1-fed3-4c0b-866b-e57790dec0ed

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
8770f0e1-fed3-4c0b-866b-e57790dec0ed Q3 401103568 ROCK CREEK COUNSEL 199607 NATIONAL EDUCATION ASSOCIATION 2023 third_quarter 2023-10-12T10:56:31-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/8770f0e1-fed3-4c0b-866b-e57790dec0ed/", "filing_uuid": "8770f0e1-fed3-4c0b-866b-e57790dec0ed", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2023, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/8770f0e1-fed3-4c0b-866b-e57790dec0ed/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "James Dennis", "dt_posted": "2023-10-12T10:56:31-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "7648 Burford Drive", "registrant_address_2": null, "registrant_different_address": true, "registrant_city": "McLean", "registrant_state": "VA", "registrant_zip": "22102", "registrant": {"id": 401103568, "url": "https://lda.senate.gov/api/v1/registrants/401103568/", "house_registrant_id": null, "name": "ROCK CREEK COUNSEL", "description": "Lobbying firm", "address_1": "7648 Burford Drive", "address_2": null, "address_3": null, "address_4": null, "city": "McLean", "state": "VA", "state_display": "Virginia", "zip": "22102", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JAMES DENNIS", "contact_telephone": "+1 202-309-0829", "dt_updated": "2026-01-31T11:51:16.381521-05:00"}, "client": {"id": 199607, "url": "https://lda.senate.gov/api/v1/clients/199607/", "client_id": 36, "name": "NATIONAL EDUCATION ASSOCIATION", "general_description": "Professional employee organization advancing the cause of public education", "client_government_entity": false, "client_self_select": null, "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": "2015-02-01"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Federal tax issues related to the tax treatment of IRC Section 529 plans, bonds for school construction, voucher tax credits, state and local deduction limitations, tax incentives for educators and public schools and Social Security issues impacting educators (WEP and GPO).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61655, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "DENNIS", "suffix": null, "suffix_display": null}, "covered_position": "Counsel to Sen. Jeff Bingaman", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Retirement issues involving qualified plans and Social Security as it impacts educators.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61655, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "DENNIS", "suffix": null, "suffix_display": null}, "covered_position": "Counsel for Senator Jeff Bingaman", "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 3.234ms