home / lobbying / lobbying_filings_raw

lobbying_filings_raw: fa09c5ea-4cca-444b-bcfd-b59fa861fcd9

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
fa09c5ea-4cca-444b-bcfd-b59fa861fcd9 Q1 11674 DAVIS & HARMAN LLP 116204 NATIONAL RURAL ELECTRIC COOPERATIVE ASSN 2017 first_quarter 2017-04-17T14:32:58.077000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/fa09c5ea-4cca-444b-bcfd-b59fa861fcd9/", "filing_uuid": "fa09c5ea-4cca-444b-bcfd-b59fa861fcd9", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2017, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/fa09c5ea-4cca-444b-bcfd-b59fa861fcd9/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kent A. Mason", "dt_posted": "2017-04-17T14:32:58.077000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1455 Pennsylvania Avenue, N. W.", "registrant_address_2": "Suite 1200", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 11674, "url": "https://lda.senate.gov/api/v1/registrants/11674/", "house_registrant_id": 31318, "name": "DAVIS & HARMAN LLP", "description": "Law Firm.", "address_1": "1455 Pennsylvania Avenue, N. W.", "address_2": "Suite 1200", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TAYLOR HOWARD", "contact_telephone": "+1 202-662-2282", "dt_updated": "2026-01-30T12:13:03.011579-05:00"}, "client": {"id": 116204, "url": "https://lda.senate.gov/api/v1/clients/116204/", "client_id": 734, "name": "NATIONAL RURAL ELECTRIC COOPERATIVE ASSN", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "VA", "state_display": "Virginia", "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-08-14"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Proposals related to PBGC premiums. Proposals related to plan funding. Proposals to facilitate new growth of pension plans. Proposals to reform the multiple employer plan rules, including H.R. 854, Retirement Security for American Workers Act. Proposals related to nondiscrimination testing of pension plans. H.J. Res. 66, Disapproving the rule submitted by the DOL relating to savings arrangements established by states. H.J. Res. 67, Disapproving the rule submitted by the DOL relating to savings arrangements established by state political subdivisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41060, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": "A", "last_name": "MASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46347, "prefix": "ms", "prefix_display": "MS.", "first_name": "BARBARA", "nickname": null, "middle_name": "A.", "last_name": "PATE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 40969, "prefix": null, "prefix_display": null, "first_name": "RANDOLF", "nickname": null, "middle_name": "HURST", "last_name": "HARDOCK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 40970, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "A", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62920, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": "L", "last_name": "GASTON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Representative Rush Holt", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Proposals related to PBGC premiums. Proposals related to plan funding. Proposals to facilitate new growth of pension plans. Proposals to reform the multiple employer plan rules, including H.R. 854, Retirement Security for American Workers Act. Proposals related to nondiscrimination testing of pension plans. H.J. Res. 66, Disapproving the rule submitted by the DOL relating to savings arrangements established by states. H.J. Res. 67, Disapproving the rule submitted by the DOL relating to savings arrangements established by state political subdivisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41060, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": "A", "last_name": "MASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46347, "prefix": "ms", "prefix_display": "MS.", "first_name": "BARBARA", "nickname": null, "middle_name": "A.", "last_name": "PATE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 40969, "prefix": null, "prefix_display": null, "first_name": "RANDOLF", "nickname": null, "middle_name": "HURST", "last_name": "HARDOCK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 40970, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "A", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62920, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": "L", "last_name": "GASTON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Representative Rush Holt", "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
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 4.246ms