home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 78e55ae6-313c-488e-bcd4-e6b9f28fb01e

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
78e55ae6-313c-488e-bcd4-e6b9f28fb01e Q4 400426039 CAPITOLINE CONSULTING, LLC 190607 PPG INDUSTRIES 2012 fourth_quarter 2013-01-19T17:02:44.940000-05:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/78e55ae6-313c-488e-bcd4-e6b9f28fb01e/", "filing_uuid": "78e55ae6-313c-488e-bcd4-e6b9f28fb01e", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2012, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/78e55ae6-313c-488e-bcd4-e6b9f28fb01e/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Liz Roberts, Principal", "dt_posted": "2013-01-19T17:02:44.940000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "P.O. Box 1609", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Alexandria", "registrant_state": "VA", "registrant_zip": "22313", "registrant": {"id": 400426039, "url": "https://lda.senate.gov/api/v1/registrants/400426039/", "house_registrant_id": null, "name": "CAPITOLINE CONSULTING, LLC", "description": "â\u20ac\u2039 Government relations consulting", "address_1": "P.O. Box 1609", "address_2": null, "address_3": null, "address_4": null, "city": "Alexandria", "state": "VA", "state_display": "Virginia", "zip": "22313", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LIZ ROBERTS", "contact_telephone": "+1 571-243-4807", "dt_updated": "2026-01-29T20:35:14.445405-05:00"}, "client": {"id": 190607, "url": "https://lda.senate.gov/api/v1/clients/190607/", "client_id": 188, "name": "PPG INDUSTRIES", "general_description": "Manufacturer of Coatings, Glass, and Chemical Products", "client_government_entity": false, "client_self_select": false, "state": "PA", "state_display": "Pennsylvania", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-06-01"}, "lobbying_activities": [{"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Wind production tax credit", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "R&D issues related to aircraft/aviation safety", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "H.R. 2250/S.1392, the EPA Regulatory Relief Act, provisions relating to Boiler MACT; \nBoiler MACT and Area Source Rule; \nIRIS", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R.4310/S.3254 National Defense Authorization Act for FY2013, R&D; Corrosion issues; issues related to research and development; issues related to defense manufacturing; sequestration issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 3307, the American Renewable Energy Production Tax Credit Extention Act, provisions relating to the wind production tax credit's expiration;\nTax extenders/R&D tax credit H.R. 0000, Ways and Means Discussion Draft Provisions to Establish a Participation Exemption System for the Taxation of Foreign Income, including on repatriation\n\nS. 3521, the Family and Business Tax Credit Cut Certainty Act, including provisions relating to the wind production tax credit\n\nIssues related to international reform and the Joint Committee on Deficit Reduction\n\nTax Reform, including territorial tax system policies\n\nH.R. 8, the American Taxpayers Relief Act of 2012, including provisions relating to the R&D tax credit and the wind production tax credit", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R.5856/S.0000 Department of Defense Appropriations for FY2013, R&D\nH.5325/S.2465 Energy and Water Appropriations for FY2013, EERE\nH.J.RES.117 Continuing Appropriations Resolution, 2013 (Public Law No: 112-175); Sequestration issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "S. 847, the Safe Chemicals Act, including provisions relating to confidential business informtion\nTSCA reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Issues related to Miscellaneous Tariff Bills\nS. 2661/H.R. 4915, including provisions related to Agelon 400\nS. 2660/H.R. 4916, including provisions related to brine electrolizers\nS. 2663/H.R. 5455, including provisions related to pigment violet 23 S. 2662/H.R. 5457, including provisions related to titanium dioxide\nS. 2659/H.R. 5456, including provisions related to melanine resin\nH.R. 6727, the US Jobs Creation and Manufacturing Competitiveness Act, including provisions relating to tariff relief", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48932, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "ROBERTS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47508, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "ZINK", "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": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US   PA   US US Manufacturer of Coatings, Glass, and Chemical Products 0 0 339   normalized_name_state 0.9

Links from other tables

  • 8 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.951ms