home / lobbying / lobbying_filings_raw

lobbying_filings_raw: edd5215c-e79e-4e6b-bdb3-94d48f51baea

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 registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
edd5215c-e79e-4e6b-bdb3-94d48f51baea Q2 81351 OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. 171174 AMERICAN CONCRETE PRESSURE PIPE ASSOCIATION 2010 second_quarter 2010-07-12T09:23:09.660000-04:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/edd5215c-e79e-4e6b-bdb3-94d48f51baea/", "filing_uuid": "edd5215c-e79e-4e6b-bdb3-94d48f51baea", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2010, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/edd5215c-e79e-4e6b-bdb3-94d48f51baea/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Christian A. Klein, Managing Member", "dt_posted": "2010-07-12T09:23:09.660000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "117 NORTH HENRY STREET", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "ALEXANDRIA", "registrant_state": "VA", "registrant_zip": "22314", "registrant": {"id": 81351, "url": "https://lda.senate.gov/api/v1/registrants/81351/", "house_registrant_id": 36309, "name": "OBADAL, FILLER, MACLEOD & KLEIN, P.L.C.", "description": "Firm providing regulatory and legislative counsel to businesses and trade associations.", "address_1": "121 NORTH HENRY STREET", "address_2": null, "address_3": null, "address_4": null, "city": "ALEXANDRIA", "state": "VA", "state_display": "Virginia", "zip": "22314", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRISTIAN A. KLEIN", "contact_telephone": "+1 703-299-0784", "dt_updated": "2026-01-28T12:21:37.145713-05:00"}, "client": {"id": 171174, "url": "https://lda.senate.gov/api/v1/clients/171174/", "client_id": 48, "name": "AMERICAN CONCRETE PRESSURE PIPE ASSOCIATION", "general_description": "Trade association representing manufacturers of concrete pressure pipe.", "client_government_entity": false, "client_self_select": false, "state": "ID", "state_display": "Idaho", "country": "US", "country_display": "United States of America", "ppb_state": "ID", "ppb_state_display": "Idaho", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-01-01"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Advocated in opposition to the Employee Free Choice Act (EFCA or card check\") H.R. 1490/S. 560, which would eliminate the right to secret ballot in union organizing elections, potentially exposing workers to increased intimidation, and undermining the rights of both workers and employers; advocated in opposition to compromise legislation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46398, "prefix": null, "prefix_display": null, "first_name": "CHRISTIAN", "nickname": null, "middle_name": "A", "last_name": "KLEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48491, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": "BRIAN", "last_name": "FISHER", "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": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Supported the Water Infrastructure Financing Act (S. 1005) authorizing $14.7 billion for the Drinking Water SRF, $20 billion for the Clean Water SRF over the next five years, and additional funds for other water quality-related program; supported the Water Quality Investment Act (H.R. 1262) authorizing $19.4 billion over the next five years for wastewater infrastructure and water quality-related programs. Supported the Water Protection and Reinvestment Act of 2009 (H.R. 3202) which would establish a Water Protection and Reinvestment Fund to support investments in clean water and drinking water infrastructure.\n\nUrged Congress to eliminate the state volume cap on private activity bonds (PABs) for water and wastewater infrastructure projects in future jobs legislation (The Sustainable Water Infrastructure Investment Act (H.R. 537/S. 3262)).\n\nAdvocated for reauthorization and increased funding for the Drink Water State Revolving Fund (SRF), including the Assistance, Quality and Affordability (AQUA) Act (H.R. 5320).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46398, "prefix": null, "prefix_display": null, "first_name": "CHRISTIAN", "nickname": null, "middle_name": "A", "last_name": "KLEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48491, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": "BRIAN", "last_name": "FISHER", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Supported reinstatement of the 50 percent depreciation bonus, which expired at the end of 2009.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46398, "prefix": null, "prefix_display": null, "first_name": "CHRISTIAN", "nickname": null, "middle_name": "A", "last_name": "KLEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48491, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": "BRIAN", "last_name": "FISHER", "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": "TRA", "general_issue_code_display": "Transportation", "description": "Urged Congress to enact a new multiyear highway spending bill that significantly increases infrastructure investment and creates new, fiscally responsible revenue streams to ensure the Highway Trust Fund's (HTF) long-term viability.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46398, "prefix": null, "prefix_display": null, "first_name": "CHRISTIAN", "nickname": null, "middle_name": "A", "last_name": "KLEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48491, "prefix": "mr", "prefix_display": "MR.", "first_name": "DANIEL", "nickname": null, "middle_name": "BRIAN", "last_name": "FISHER", "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": []} VA US 36309 ID ID US US Trade association representing manufacturers of concrete pressure pipe. 0 0 575200   normalized_name 0.7

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 4.197ms