home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dd9564c0-0422-45c9-b97c-413928927f3f

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
dd9564c0-0422-45c9-b97c-413928927f3f Q1 20287 EXELIS INC. (FORMERLY ITT CORPORATION) 126485 EXELIS INC. (FORMERLY ITT CORPORATION) 2015 first_quarter 2015-04-15T15:29:43.767000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dd9564c0-0422-45c9-b97c-413928927f3f/", "filing_uuid": "dd9564c0-0422-45c9-b97c-413928927f3f", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2015, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/dd9564c0-0422-45c9-b97c-413928927f3f/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "330000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "William Syers", "dt_posted": "2015-04-15T15:29:43.767000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1650 TYSONS BOULEVARD, #1700", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "MCLEAN", "registrant_state": "VA", "registrant_zip": "22102", "registrant": {"id": 20287, "url": "https://lda.senate.gov/api/v1/registrants/20287/", "house_registrant_id": 30754, "name": "EXELIS INC. (FORMERLY ITT CORPORATION)", "description": "Provides Mission Critical Technologies for Defense, Aerospace, & Aviation applications", "address_1": "1650 TYSONS BOULEVARD, #1700", "address_2": null, "address_3": null, "address_4": null, "city": "MCLEAN", "state": "VA", "state_display": "Virginia", "zip": "22102-4827", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "WILLIAM A. SYERS", "contact_telephone": "+1 703-790-6338", "dt_updated": "2022-04-06T16:07:02.706691-04:00"}, "client": {"id": 126485, "url": "https://lda.senate.gov/api/v1/clients/126485/", "client_id": 12, "name": "EXELIS INC. (FORMERLY ITT CORPORATION)", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-11-01"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "House and Senate versions of the FY 16 defense authorization and appropriations bills as they pertain to Overseas Contingency Operations, procurement, R&D, and O&M accounts.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56502, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "SUZANNE", "nickname": null, "middle_name": "C", "last_name": "STERNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "AER", "general_issue_code_display": "Aerospace", "description": "House and Senate versions of the FY 16 appropriations and authorization bills as they pertain to civilian space and weather programs including interests in weather satellites, earth science, space telescopes and air traffic surveillance at the FAA, NASA, & NOAA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56502, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "SUZANNE", "nickname": null, "middle_name": "C", "last_name": "STERNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61803, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "SCHRAMEK", "suffix": null, "suffix_display": null}, "covered_position": "None", "new": true}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "House and Senate bills as they pertain to tax credit extenders, the corporate tax rate, changes in the tax treatment of single payer defined benefit pension plans and Pension Benefit Guaranty Corporation premium increases.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56502, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "SUZANNE", "nickname": null, "middle_name": "C", "last_name": "STERNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Legislative actions of the House Foreign Affairs and Senate Foreign Relations Committees as they pertain to notice and potential approval of foreign military sales of US products, services and technologies to countries such as Egypt and Taiwan.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56502, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "SUZANNE", "nickname": null, "middle_name": "C", "last_name": "STERNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61803, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "SCHRAMEK", "suffix": null, "suffix_display": null}, "covered_position": "None", "new": true}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "House and Senate versions of the FY 16 budget resolutions and companion appropriations bills as they pertain to Budget Control ACT discretionary caps, funding for defense programs, FAA NextGen programs, weather satellites, earth science, space telescopes and Homeland Security Tethered Aerostat border protection programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56502, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "SUZANNE", "nickname": null, "middle_name": "C", "last_name": "STERNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61803, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "SCHRAMEK", "suffix": null, "suffix_display": null}, "covered_position": "None", "new": true}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "House and Senate versions of the transportation appropriations and FAA reauthorization bills as they pertain to FAA NextGen air traffic control programs and restructuring of the air traffic control organization within the FAA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "House and Senate versions of the FY 16 Homeland security authorization and appropriations bills as they pertain to tethered aerostats for border security and cyber security programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}, {"general_issue_code": "INT", "general_issue_code_display": "Intelligence", "description": "House and Senate versions of the FY 15 and 16 intelligence authorization and defense appropriations bills as they pertain to sensors, payloads, and industrial base issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19251, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": "DOC", "middle_name": null, "last_name": "SYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56502, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "SUZANNE", "nickname": null, "middle_name": "C", "last_name": "STERNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61803, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "SCHRAMEK", "suffix": null, "suffix_display": null}, "covered_position": "None", "new": true}], "government_entities": [{"id": 131, "name": "Administration for Children & Families (ACF)"}, {"id": 29, "name": "Air Force, Dept of"}, {"id": 30, "name": "Army, Dept of (Other)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 231, "name": "Defense Security Cooperation Agency (DSCA)"}, {"id": 215, "name": "Director of National Intelligence (ODNI)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 126, "name": "Natl Geospatial Intelligence Agency"}, {"id": 242, "name": "Natl Guard"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 210, "name": "U.S. Marines"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 30754 VA VA US US   0 0           330000.0

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.649ms · Privacy