lobbying_filings_raw: aa9a405a-dac6-41cd-8ee7-39fc80ac3d58

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
aa9a405a-dac6-41cd-8ee7-39fc80ac3d58 Q1 58795 CANADIAN NATIONAL RAILWAY COMPANY 160725 CANADIAN NATIONAL RAILWAY COMPANY 2022 first_quarter 2022-04-14T09:02:55-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/aa9a405a-dac6-41cd-8ee7-39fc80ac3d58/", "filing_uuid": "aa9a405a-dac6-41cd-8ee7-39fc80ac3d58", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2022, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/aa9a405a-dac6-41cd-8ee7-39fc80ac3d58/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "180000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "David Woodruff", "dt_posted": "2022-04-14T09:02:55-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "Canada", "registrant_address_1": "601 PENNSYLVANIA AVENUE, NW", "registrant_address_2": "Suite 500, North Building", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 58795, "url": "https://lda.senate.gov/api/v1/registrants/58795/", "house_registrant_id": 35303, "name": "CANADIAN NATIONAL RAILWAY COMPANY", "description": null, "address_1": "601 Pennsylvania Avenue, NW", "address_2": "Suite 500", "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": "CA", "ppb_country_display": "Canada", "contact_name": "ANDREA NIETHOLD", "contact_telephone": "+1 202-763-6485", "dt_updated": "2026-01-23T12:17:15.519996-05:00"}, "client": {"id": 160725, "url": "https://lda.senate.gov/api/v1/clients/160725/", "client_id": 12, "name": "CANADIAN NATIONAL RAILWAY COMPANY", "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": "2007-08-08"}, "lobbying_activities": [{"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "Surface transportation reauthorization issues Implementation of CN's acquisition of the major portion of the Elgin, Joliet & Eastern Railway Company Implementation of Positive Train Control technology Expansion of rail passenger services in the United States Safe Transportation by rail of materials, commodities, crude oil and hazardous materials Issues relating to transportation and infrastructure", "foreign_entity_issues": "Canadian National Railway Company is a publicly-traded Canadian corporation, whose core business is freight railroad transportation services in the United States and Canada. The company's interest in railroad issues is the impact of the referenced legislation or regulatory changes on its ability to provide freight rail services to its customers in the U.S.", "lobbyists": [{"lobbyist": {"id": 62997, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68469, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": "MARIE", "last_name": "WALDOCK NIETHOLD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 181, "name": "Surface Transportation Board (STB)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Surface transportation reauthorization issues Implementation of CN's acquisition of the major portion of the Elgin, Joliet & Eastern Railway Company Implementation of Positive Train Control technology Expansion of rail passenger services in the United States Safe transportation by rail of crude oil and other hazardous materials", "foreign_entity_issues": "Canadian National Railway Company is a publicly-traded Canadian corporation whose core business is freight railroad transportation services in the United States and Canada. The company's interest in transportation issues is the impact of the referenced legislation or regulatory changes on its ability to provide freight rail services to its customers in the U.S.", "lobbyists": [{"lobbyist": {"id": 62997, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68469, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": "MARIE", "last_name": "WALDOCK NIETHOLD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 174, "name": "Federal Railroad Administration"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 181, "name": "Surface Transportation Board (STB)"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Surface transportation/railroad homeland security issues Border security and cross-border commerce/U.S.-Canada Beyond the Border Initiative", "foreign_entity_issues": "Canadian National Railway Company is a publicly-traded Canadian corporation whose core business is freight railroad transportation services in the United States and Canada. The company's interest in homeland security issues is the impact of potential legislation or regulatory changes on its ability to provide freight rail services to its customers in the U.S.", "lobbyists": [{"lobbyist": {"id": 62997, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68469, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": "MARIE", "last_name": "WALDOCK NIETHOLD", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Short Line Tax Credit provision 45G Tax reform and rate reduction issues", "foreign_entity_issues": "Canadian National Railway Company is a publicly-traded Canadian corporation, whose core business is freight railroad transportation services in the United States and Canada. The company's interest in tax issues is the impact of the referenced legislation on its ability to provide freight rail services to its customers in the U.S.", "lobbyists": [{"lobbyist": {"id": 62997, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68469, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": "MARIE", "last_name": "WALDOCK NIETHOLD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "NAFTA Cross-border trade issues", "foreign_entity_issues": "Canadian National Railway Company is a publicly-traded Canadian corporation, whose core business is freight railroad transportation services in the United States and Canada. The company's interest in trade issues is the impact of the referenced matters on its ability to provide freight rail services to its customers in the U.S.", "lobbyists": [{"lobbyist": {"id": 62997, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68469, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": "MARIE", "last_name": "WALDOCK NIETHOLD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 35303 DC DC US US   0 0           180000.0

Links from other tables