home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 67be25fb-e6fd-4bc7-9f0c-0cede9fe0dd3

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
67be25fb-e6fd-4bc7-9f0c-0cede9fe0dd3 Q2 26147 THE LAW OFFICES OF JOHN R. BRIMSEK, PC 133768 DELAWARE AND HUDSON RAILWAY D/B/A/ CANADIAN PACIFIC RAILWAY 2012 second_quarter 2012-07-09T08:42:26.693000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/67be25fb-e6fd-4bc7-9f0c-0cede9fe0dd3/", "filing_uuid": "67be25fb-e6fd-4bc7-9f0c-0cede9fe0dd3", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2012, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/67be25fb-e6fd-4bc7-9f0c-0cede9fe0dd3/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "John Brimsek, President", "dt_posted": "2012-07-09T08:42:26.693000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1200 19th Street, NW, Suite 300", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "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": 133768, "url": "https://lda.senate.gov/api/v1/clients/133768/", "client_id": 51, "name": "DELAWARE AND HUDSON RAILWAY D/B/A/ CANADIAN PACIFIC RAILWAY", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "NY", "state_display": "New York", "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": null}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Support the fluid movement of goods between the United States and Canada.", "foreign_entity_issues": "Delaware and Hudson Railway is wholly owned by Canadian Pacific Railway. Legislation which affects the U.S. railroad industry affects Canadian Pacific Railway's U.S. interests.", "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": null, "new": false}], "government_entities": [{"id": 59, "name": "Federal Maritime Commission"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR 4348 Moving Ahead for Progress in the 21st Century (MAP-21). Support extension of short line railroad tax credit.", "foreign_entity_issues": "Delaware and Hudson Railway is wholly owned by Canadian Pacific Railway. Legislation which affects the U.S. railroad industry affects Canadian Pacific Railway's U.S. interests.", "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": null, "new": false}], "government_entities": [{"id": 59, "name": "Federal Maritime Commission"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "S 158 Surface Transportation Board Reauthorization Act. Support balanced economic regulation of the railroad industry. \nS 49 Railroad Antitrust Enforcement Act. Oppose provisions which would repeal the limited railroad antitrust exemptions and which would permit reopenning previously approved railroad transactions. HR 7 American Energy and Infrastructure Jobs Act. Support provisions related to Postive Train Control. \nS 1813 Moving Ahead for Progress in the 21st Century (MAP-21). Monitor provisions related to freight policy, hazardous materials transportation, and freight and passenger rail transportation.", "foreign_entity_issues": "Delaware and Hudson Railway is wholly owned by Canadian Pacific Railway. Legislation which affects the U.S. railroad industry affects Canadian Pacific Railway's U.S. interests.", "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": null, "new": false}], "government_entities": [{"id": 59, "name": "Federal Maritime Commission"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ROD", "general_issue_code_display": "Roads/Highway", "description": "HR 4348 Moving Ahead for Progress in the 21st Century (MAP-21). Oppose expanded operations of longer and heavier trucks. Support authorization and funding of railroad/highway grade crossing program.", "foreign_entity_issues": "Delaware and Hudson Railway is wholly owned by Canadian Pacific Railway. Legislation which affects the U.S. railroad industry affects Canadian Pacific Railway's U.S. interests.", "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": null, "new": false}], "government_entities": [{"id": 59, "name": "Federal Maritime Commission"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "S 2322 and HR 5972, FY 2013 Transportation Appropriations Act. Monitor provisions related to railroad research, highway-railroad grade crossings, Amtrak and other passenger rail, and port and rail security grants. Oppose railroad user fees.", "foreign_entity_issues": "Delaware and Hudson Railway is wholly owned by Canadian Pacific Railway. Legislation which affects the U.S. railroad industry affects Canadian Pacific Railway's U.S. interests.", "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": null, "new": false}], "government_entities": [{"id": 59, "name": "Federal Maritime Commission"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Support legislation to maintain the security and continuity of freight rail services.", "foreign_entity_issues": "Delaware and Hudson Railway is wholly owned by Canadian Pacific Railway. Legislation which affects the U.S. railroad industry affects Canadian Pacific Railway's U.S. interests.", "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": null, "new": false}], "government_entities": [{"id": 59, "name": "Federal Maritime Commission"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 118.903ms