home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cc704d46-bfbb-46c8-bd10-d23df3867cfc

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
cc704d46-bfbb-46c8-bd10-d23df3867cfc Q2 32021 PPG INDUSTRIES, INC 139582 PPG INDUSTRIES, INC 2013 second_quarter 2013-07-19T11:44:26.217000-04:00 201472.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cc704d46-bfbb-46c8-bd10-d23df3867cfc/", "filing_uuid": "cc704d46-bfbb-46c8-bd10-d23df3867cfc", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2013, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cc704d46-bfbb-46c8-bd10-d23df3867cfc/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "201472.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Bryan N. Iams, VP, Corporate Communications, Marketing and Government and Community Affairs", "dt_posted": "2013-07-19T11:44:26.217000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "ONE PPG PLACE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "PITTSBURGH", "registrant_state": "PA", "registrant_zip": "15272", "registrant": {"id": 32021, "url": "https://lda.senate.gov/api/v1/registrants/32021/", "house_registrant_id": 32106, "name": "PPG INDUSTRIES, INC", "description": "Manufacturing", "address_1": "ONE PPG PLACE", "address_2": null, "address_3": null, "address_4": null, "city": "PITTSBURGH", "state": "PA", "state_display": "Pennsylvania", "zip": "15272", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "EMILY ELIZER", "contact_telephone": "+1 412-434-1717", "dt_updated": "2026-01-29T09:50:11.893296-05:00"}, "client": {"id": 139582, "url": "https://lda.senate.gov/api/v1/clients/139582/", "client_id": 12, "name": "PPG INDUSTRIES, INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "PA", "state_display": "Pennsylvania", "country": "US", "country_display": "United States of America", "ppb_state": "PA", "ppb_state_display": "Pennsylvania", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2020-01-27"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Corporate tax reform, including internationally competitive tax system policies\nWays and Means Committee comprehensive tax reform discussion drafts on international tax reform, financial products, and reducing the burden the tax code imposes on small businesses", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R.1960/S.1197 National Defense Authorization Act for FY2014, R&D issues; Corrosion issues; issues related to defense manufacturing", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S. 744, Border Security, Economic Opportunity and Immigration Modernization Act, including provisions related to H1-B visas", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "IRIS\nNational Ambient Air Quality Standards for Ozone\nS. 332, Climate Protection Act of 2013, including provisions relating to a carbon tax\nEnergy Star Windows criteria", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "S. 1009, Chemical Safety and Improvement Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "S.761/H.R.1616 Energy Savings and Industrial Competitiveness Act of 2013", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 2397/S.0000 Department of Defense Appropriations for FY2014, R&D\nH.2609/S.1245 Energy and Water Appropriations for FY2014, EERE", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Issues related to Miscellaneous Tariff bills, including provisions related to Agilon 400 and Melamine Resin", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42042, "prefix": null, "prefix_display": null, "first_name": "MEGHAN", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} PA US 32106 PA PA US US   0 0 339   normalized_name_state 0.9

Links from other tables

  • 8 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 1.277ms