home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3ec3f15b-e7ea-4ec6-8c5a-8d86b051a154

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
3ec3f15b-e7ea-4ec6-8c5a-8d86b051a154 Q3 79211 O'DONOGHUE & O'DONOGHUE LLP 170542 UNITED ASSN OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY 2011 third_quarter 2011-10-18T09:09:22.877000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3ec3f15b-e7ea-4ec6-8c5a-8d86b051a154/", "filing_uuid": "3ec3f15b-e7ea-4ec6-8c5a-8d86b051a154", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2011, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3ec3f15b-e7ea-4ec6-8c5a-8d86b051a154/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Scott M. Seedorf, Associate", "dt_posted": "2011-10-18T09:09:22.877000-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": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "- Proposed free trade agreements with South Korea, Colombia and Panama.\n- President Obamas Export Control Reform Initiative (no bill).", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "- General outreach regarding the United Association Veterans in Piping (VIP) Programs success in providing veterans with career training in pipe trades and in easing the transition back to civilian life.", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "- Proposed rule by National Labor Relations Board regarding union election procedures.\n- Proposed rule by U.S. Department of Labor regarding \"advice exemption\" to required disclosures of agreements with labor relations consultants under the Labor-Management Reporting and Disclosure Act. \n- Final rule by U.S. Department of Labor regarding wage rate methodology for H-2B workers. - General outreach regarding use of Project Labor Agreements on federal construction projects.", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "- Federal assistance for water infrastructure and pipeline construction projects (no bill).", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "- Presidential Permit for TransCanadas Keystone XL pipeline project.\n- Federal policy relating to onshore and offshore drilling in and around the Arctic National Wildlife Refuge (ANWR).", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "- Abuses and enforcement of H-2B visas in the U.S. construction industry.", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "- American Jobs Act of 2011, H.R. 12 and S. 1549, all provisions.\n- Fix Americas Schools Act, H.R. 2948 and S. 1597, all provisions.", "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": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 36228 DC DC US US   0 0        

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.68ms