home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4e9f409c-e22c-459d-9b97-ecb2765206f8

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
4e9f409c-e22c-459d-9b97-ecb2765206f8 Q1 68296 ROCKWELL COLLINS, INC 164081 ROCKWELL COLLINS, INC 2016 first_quarter 2016-04-13T09:12:07.997000-04:00 280819.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4e9f409c-e22c-459d-9b97-ecb2765206f8/", "filing_uuid": "4e9f409c-e22c-459d-9b97-ecb2765206f8", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2016, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4e9f409c-e22c-459d-9b97-ecb2765206f8/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "280819.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Timothy A. Peterson, Senior Director of Government Relations, Rockwell Collins.", "dt_posted": "2016-04-13T09:12:07.997000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "400 COLLINS ROAD, NE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "CEDAR RAPIDS", "registrant_state": "IA", "registrant_zip": "52498", "registrant": {"id": 68296, "url": "https://lda.senate.gov/api/v1/registrants/68296/", "house_registrant_id": 35671, "name": "ROCKWELL COLLINS, INC", "description": "Airborne Avionics and Communications Corporation", "address_1": "400 COLLINS ROAD, NE", "address_2": null, "address_3": null, "address_4": null, "city": "CEDAR RAPIDS", "state": "IA", "state_display": "Iowa", "zip": "52498", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TIMOTHY A. PETERSON", "contact_telephone": "+1 703-516-8200", "dt_updated": "2022-04-06T16:07:55.875878-04:00"}, "client": {"id": 164081, "url": "https://lda.senate.gov/api/v1/clients/164081/", "client_id": 12, "name": "ROCKWELL COLLINS, INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "IA", "state_display": "Iowa", "country": "US", "country_display": "United States of America", "ppb_state": "IA", "ppb_state_display": "Iowa", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-04-28"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Lobbied in favor of Senate nomination hearing and confirmation for an Ex-Im Bank Board Member to ensure quorum and fully reopen Bank.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57534, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "RAE", "last_name": "ROSIA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 51, "name": "Export-Import Bank of the United States (EXIM Bank)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "--Lobbied to strengthen commercial item procurement for DoD acquisition policy in the National Defense Authorization Act (NDAA), H.R. 1735 and S. 1376 (P.L. 114-92).\n\n--Lobbied against the proposed DFAR's rule \"Industry Price Reasonableness for Commercial Items\"\n\n--Lobbied for language and full funding in the FY 17 NDAA and Defense Appropriations bills for:\n(1) Handheld Manpack Small Form Fit (HMS) acquisition strategy for continued LRIP extention and FRP;\n(2) The Air Force's F-35 to include funding for the Helmet Mounted Display System (HMDS);\n(3) The Navy's Tactical Combat Training System (TCTs) to use a Common Range Integrated Instruction System (CRIIS) as a solution;\n(4) The Navy's CH-53K program;\n(5) Increase funding for the Defense Production Act Title III;\n(6) The Army's UH-60M procurement accounts to increase funding and Authorization for the UH-60M for the Active Army and ARNG.\n\n--Lobbied for inclusion of commercial item purchasing policies and intellectual property rights in the FY17 NDAA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37268, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": "A", "last_name": "PETERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 50253, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": "A", "last_name": "STURGELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 51, "name": "Export-Import Bank of the United States (EXIM Bank)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "AER", "general_issue_code_display": "Aerospace", "description": "--Lobbied against enacting industry specific privacy laws for commercial UAS operations in the national airspace (H.R. 4441, S. 2658).\n\n--Advocated for continuing to streamline the FAA's certification activities and use its ODA program effectively (H.R. 4441, S. 2658).\n\n--Lobbied for timely long-term reauthorization of FAA (H.R. 4441, S. 2658).\n\n--Lobbied for publication and successful implementation of FAA UAS roadmap, with periodic review and comment by stakeholders (H.R. 4441, S. 2658).\n\n--Lobbied to support design, certification and operations standards for UAS integration into the NAS(H.R. 4441, S. 2658).\n\n--Lobbied to maximize UAS market growth through appropriate policies (H.R. 4441, S. 2658).\n\n--Lobbied for cockpit display study (H.R. 4441, S. 2658).\n\n--Lobbied in favor of test sites for UAS tracking technology (H.R. 4441, S. 2658).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50253, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": "A", "last_name": "STURGELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59684, "prefix": null, "prefix_display": null, "first_name": "LAURIE", "nickname": null, "middle_name": "M", "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57534, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "RAE", "last_name": "ROSIA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 37268, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": "A", "last_name": "PETERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 51, "name": "Export-Import Bank of the United States (EXIM Bank)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "--Lobbied to maintain \"traditional\" R&D Tax Credit formula extended in Consolidated Appropriations Act of 2016, and maintain permanent extension. (P.L. 114-113)\n\n--Lobbied in favor of long term corporate tax reform; lobbied for reduced corporate tax obligations through lower rate and/or expanded offsets.\n\n--Lobbied in favor of territorial tax system adoption/freer abiltity to move foreign accumulate cash/earnings at no or reduced tax from current regime.\n\n--Lobbied in favor of an \"innovation box\" with a lower tax on certain types of income from intellectual property.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 50253, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": "A", "last_name": "STURGELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57534, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "RAE", "last_name": "ROSIA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 51, "name": "Export-Import Bank of the United States (EXIM Bank)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "--Department of Defense Appropriations (base budget and OCO) at the FY 17 President budget request.\n\n--Lobbied for increased funding in DoD's procurement accounts for:\n\n(1) The Air Force's F-35 appropriations to include funding for the Helmet Mounted Display and System (HMDS).\n\n(2) The Navy's Tactical Combat Training System (TCTs).\n\n(3) The Navy's CH-53K appropriations.\n\n(4) Increased appropriations for the Defense Production Act Title III program line.\n\n(5) The Army's UH-60M procurement accounts to increase funding for the UH-60M for the active Army and the ARNG.\n\n(6) Lobbied to maintain FAA Appropriations at the FY17 President budget request.\n\n(7) Lobbied for FY17 Appropriations to include resources for FAA certification activities, acceleration of UAS and NextGen Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37268, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": "A", "last_name": "PETERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 50253, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": "A", "last_name": "STURGELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57534, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "RAE", "last_name": "ROSIA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 51, "name": "Export-Import Bank of the United States (EXIM Bank)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "--Lobbied for reauthorization of the Perkins Act, P.L. 109-270:\n(1) align CTE programs to the needs of regional, state, and local labor markets;\n(2) support effective collaboration between secondary and postsecondary institutions and employers; \n(3) increase student participation in experimental learning opportunities such as internships, apprenticeships and mentorships; and\n(4) promote the use of industry-recognized credentials.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57534, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "RAE", "last_name": "ROSIA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 51, "name": "Export-Import Bank of the United States (EXIM Bank)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 14.616ms