home / lobbying / lobbying_filings_raw

lobbying_filings_raw: d0747b76-0ce3-4e97-9ea1-fb8d97bc3d36

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
d0747b76-0ce3-4e97-9ea1-fb8d97bc3d36 YY 26147 THE LAW OFFICES OF JOHN R. BRIMSEK, PC 133779 SOO LINE RAILROAD D/B/A CANADIAN PACIFIC RAILWAY 2002 year_end 2003-01-02T00:00:00-05:00 80000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/d0747b76-0ce3-4e97-9ea1-fb8d97bc3d36/", "filing_uuid": "d0747b76-0ce3-4e97-9ea1-fb8d97bc3d36", "filing_type": "YY", "filing_type_display": "Year-End Report", "filing_year": 2002, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/d0747b76-0ce3-4e97-9ea1-fb8d97bc3d36/print/", "filing_document_content_type": "application/pdf", "income": "80000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2003-01-02T00:00:00-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 26147, "url": "https://lda.senate.gov/api/v1/registrants/26147/", "house_registrant_id": 30665, "name": "THE LAW OFFICES OF JOHN R. BRIMSEK, PC", "description": "Law Firm", "address_1": "1629 K Street, NW, Suite 300", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MR. JOHN R. BRIMSEK", "contact_telephone": "+1 202-827-9979", "dt_updated": "2022-04-06T16:08:06.033746-04:00"}, "client": {"id": 133779, "url": "https://lda.senate.gov/api/v1/clients/133779/", "client_id": 113, "name": "SOO LINE RAILROAD D/B/A CANADIAN PACIFIC RAILWAY", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": null, "state_display": null, "country": "CA", "country_display": "Canada", "ppb_state": null, "ppb_state_display": null, "ppb_country": "CA", "ppb_country_display": "Canada", "effective_date": null}, "lobbying_activities": [{"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 4, Energy Policy Act. Provisions related to funding clean coal technology and locomotive fuel and emissions. Provisions reauthorizing the Price-Anderson Act concerning nuclear waste transportation liability.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 43204, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "R", "last_name": "BRIMSEK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "S. 1550, Rail Security Act. Provisions related to freight rail security.\r\n\r\nS. 2245, Railroad Competition, Arbitration and Service Act, S. 1103, Railroad Competition Act, and H.R. 141, Surface Transportation Board Reform Act . Provisions dealing with regulation of the railroad industry.\r\n\r\nH.R. 2654, Transit Rail Accommodation Improvement and Needs Act for the 21st Century. Provisions granting transit authorities enhanced access to freight rail lines.\r\n\r\nS. 1991, National Defense Rail Act, S. 1958, Rail Passenger Service Improvement Act, H.R. 4545, Amtrak Reauthorization Act, and H.R. 2950, Rail Infrastructure Development and Expansion Act for the 21st Century. Provisions related to funding intercity and high speed rail and the Railroad Rehabilitation and Improvement Financing program.\r\n\r\nS. 1669, Hazardous Material Transportation Safety Reauthorization Act, and H.R. 4761, Railroad Safety Reform Act. Provisions relating to railroad operations. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 43204, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "R", "last_name": "BRIMSEK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ROD", "general_issue_code_display": "Roads/Highway", "description": "Upcoming reauthorization of TEA-21, provisions dealing with funding Tradeway Truck Tunnel.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 43204, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "R", "last_name": "BRIMSEK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 4, Energy Policy Act and other bills to eliminate deficit reduction fuel tax applied to railroads.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 43204, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "R", "last_name": "BRIMSEK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 5559 and S.2808, Department of Transportation and Related Agencies Appropriations Act, 2003. Provisions related to railroad user fees to fund the Federal Railroad Administration and Surface Transportation Board. Provisions related to funding highway-railroad grade crossing programs and rail research.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 43204, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "R", "last_name": "BRIMSEK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "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 2.303ms