home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f66d8c6b-b00f-459e-935d-e9d3a34c84fc

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
f66d8c6b-b00f-459e-935d-e9d3a34c84fc Q2 20072 INTERNATIONAL UNION OF BRICKLAYERS & ALLIED CRAFTWORKERS 126474 INTERNATIONAL UNION OF BRICKLAYERS & ALLIED CRAFTWORKERS 2008 second_quarter 2008-07-18T11:05:43-04:00 39000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f66d8c6b-b00f-459e-935d-e9d3a34c84fc/", "filing_uuid": "f66d8c6b-b00f-459e-935d-e9d3a34c84fc", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2008, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f66d8c6b-b00f-459e-935d-e9d3a34c84fc/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "39000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Kevin P Flynn Assistant to the President for Government Relations", "dt_posted": "2008-07-18T11:05:43-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "620 F. Street, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 20072, "url": "https://lda.senate.gov/api/v1/registrants/20072/", "house_registrant_id": 32898, "name": "INTERNATIONAL UNION OF BRICKLAYERS & ALLIED CRAFTWORKERS", "description": "Labor Organization", "address_1": "620 F. Street, NW", "address_2": null, "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": "JEAN-PAUL ITZ", "contact_telephone": "+1 202-383-3149", "dt_updated": "2026-01-23T11:45:13.546765-05:00"}, "client": {"id": 126474, "url": "https://lda.senate.gov/api/v1/clients/126474/", "client_id": 12, "name": "INTERNATIONAL UNION OF BRICKLAYERS & ALLIED CRAFTWORKERS", "general_description": null, "client_government_entity": false, "client_self_select": true, "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-01-01"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR 2470 Rebuild America's Schools Act of 2007. Creates tax credits to assist school districts in securing funding for school repairs and new construction.\nS 912 America's Better Classroom Act of 2007. Creates tax credits to assist school districts in securing funding for school repairs and new construction.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "RET", "general_issue_code_display": "Retirement", "description": "No specific bill but an attempt to make technical corrections to the 2006 Pension Reform bill for multi-employer pension plans.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "Multi-employer healthcare concerns-no specific bills.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Support of S 3036 the Senator Boxer-Liebermann-Warner Climate Security Act of 2008.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "EDU", "general_issue_code_display": "Education", "description": "Increase in school construction and repair budgets with Davis-Bacon prevailing wage language and coverage.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "IMM", "general_issue_code_display": "Immigration", "description": "No specific bill but an effort to inform members of congress about the importance of including the current guestworker wage language guaranteeing Davis-Bacon/Service Contract minimums and reformed labor standards within the H2B guestworkers visas. Opposition to increasing the H2B visa cap without H2B visa labor reforms.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Misclassification of workers as independent contractors. Support of Senator Obama's bill S 2044 Independent Contractor proper Classification Act of 2007. Support of Congressman Andrews & Congresswoman Woolsey's HR 6111 Employee Misclassification Prevention Act of 2008", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "IND", "general_issue_code_display": "Indian/Native American Affairs", "description": "Support of Indian land swap bill HR 2176, necessary for the construction of 2 Indian Casinos in Michigan.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": "No specific bill but informing members of Congress about Davis-Bacon prevailing wage language in reauthorization of future water construction projects.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43978, "prefix": "mr", "prefix_display": "MR.", "first_name": "KEVIN", "nickname": null, "middle_name": "PATRICK", "last_name": "FLYNN", "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": []} DC US 32898 DC DC US US   0 0 992615   normalized_name_state 0.9

Links from other tables

  • 9 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 12.022ms