home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9d13f31c-0e2c-4e5e-9348-9db5cab2ef32

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
9d13f31c-0e2c-4e5e-9348-9db5cab2ef32 Q2 79211 O'DONOGHUE & O'DONOGHUE LLP 170542 UNITED ASSN OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY 2011 second_quarter 2011-07-19T14:28:18.597000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9d13f31c-0e2c-4e5e-9348-9db5cab2ef32/", "filing_uuid": "9d13f31c-0e2c-4e5e-9348-9db5cab2ef32", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2011, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9d13f31c-0e2c-4e5e-9348-9db5cab2ef32/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Scott M. Seedorf, Associate", "dt_posted": "2011-07-19T14:28:18.597000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "4748 Wisconsin Ave., NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20016", "registrant": {"id": 79211, "url": "https://lda.senate.gov/api/v1/registrants/79211/", "house_registrant_id": 36228, "name": "O'DONOGHUE & O'DONOGHUE LLP", "description": "Law firm", "address_1": "4748 Wisconsin Ave., NW", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20016", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "SCOTT M. SEEDORF", "contact_telephone": "+1 202-362-0041", "dt_updated": "2022-04-06T16:06:19.453231-04:00"}, "client": {"id": 170542, "url": "https://lda.senate.gov/api/v1/clients/170542/", "client_id": 12, "name": "UNITED ASSN OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY", "general_description": null, "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": "2013-07-12"}, "lobbying_activities": [{"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "- Hiring Heroes Act of 2011, H.R. 1941 and S. 951, provisions relating to training.\n- National Defense Authorization Act for Fiscal Year 2012, H.R. 1540, proposed amendment in Armed Services Committee Military Personnel Subcommittee Markup regarding apprenticeship training for military personnel prior to discharge. - Consideration of contractor participation in employment and job training programs for U.S. veterans, including United Association's Veterans in Piping (VIP) Program, in federal procurement process generally, and specifically in relation to Veterans Affairs Hospital project in Colorado.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9916, "prefix": null, "prefix_display": null, "first_name": "GERARD", "nickname": null, "middle_name": "M", "last_name": "WAITES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "- Review of TransCanadas Keystone XL Project for Presidential Permit, including environmental review of Project under National Environmental Policy Act (NEPA).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9916, "prefix": null, "prefix_display": null, "first_name": "GERARD", "nickname": null, "middle_name": "M", "last_name": "WAITES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "- Possible revisions to U.S. Department of Transportation regulations regarding pipeline safety.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9916, "prefix": null, "prefix_display": null, "first_name": "GERARD", "nickname": null, "middle_name": "M", "last_name": "WAITES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "- The Energy Tax Prevention Act of 2011, H.R. 910 and S. 482, all provisions. \n- Air permits for exploratory drilling programs in Alaskas Outer Continental Shelf.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9916, "prefix": null, "prefix_display": null, "first_name": "GERARD", "nickname": null, "middle_name": "M", "last_name": "WAITES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "- Proposed rule by U.S. Department of Labor overhauling H-2B visa program. \n- Abuses and enforcement of E-2 and H-2B visa programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9916, "prefix": null, "prefix_display": null, "first_name": "GERARD", "nickname": null, "middle_name": "M", "last_name": "WAITES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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