home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bfd14312-fe0c-4b0b-adaa-e09eca4bfc73

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
bfd14312-fe0c-4b0b-adaa-e09eca4bfc73 Q1 79175 STRATEGIES 360 170510 CITY OF BOISE 2014 first_quarter 2014-04-15T15:49:30.543000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bfd14312-fe0c-4b0b-adaa-e09eca4bfc73/", "filing_uuid": "bfd14312-fe0c-4b0b-adaa-e09eca4bfc73", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2014, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bfd14312-fe0c-4b0b-adaa-e09eca4bfc73/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Tylynn Gordon -- Senior Vice President, Federal Relations", "dt_posted": "2014-04-15T15:49:30.543000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "801 Pennsylvania Ave NW", "registrant_address_2": "Suite 715", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 79175, "url": "https://lda.senate.gov/api/v1/registrants/79175/", "house_registrant_id": 37196, "name": "STRATEGIES 360", "description": "Government affairs", "address_1": "2200 6th Avenue", "address_2": "Suite 780", "address_3": null, "address_4": null, "city": "Seattle", "state": "WA", "state_display": "Washington", "zip": "98121", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ALAN CHAFFEE", "contact_telephone": "+1 206-334-0822", "dt_updated": "2026-01-23T11:17:12.690001-05:00"}, "client": {"id": 170510, "url": "https://lda.senate.gov/api/v1/clients/170510/", "client_id": 1003150, "name": "CITY OF BOISE", "general_description": "Municipal government", "client_government_entity": true, "client_self_select": false, "state": "ID", "state_display": "Idaho", "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": "2013-07-16"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Implementation of MAP-21 (P.L. 112-141) including New Starts/Small Starts, Highway Trust Fund financing reform, Metropolitan Planning Organizations (MPOs), TIGER Grant, FY 2014 Appropriations, FY 2014-2015 Budget", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "FY 2014 Appropriations, FY 2014-2015 Budget, COPS Grant Program, Byrne Grant Program, Implementation and funding of emergency communications system", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "FY 2014 Appropriations, FY 2014-2015 Budget, CDBG, HOME Program, McKinney Vento Continuum of Care, S. 1442 Improving the Low Income Housing Tax Credit Rate, HUD Proposed Rule on Affirmatively Furthering Fair Housing (Docket No. FR-5173-P-01), Low-Income Housing Tax Credit Extension", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY 2014 Appropriations, FY2014-FY2015 Budget, FY 2015 Appropriations, Debt Ceiling", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Tax-exemption of municipal bonds, H.R. 684/S. 336 Marketplace Fairness Act, Deduction for Local Sales Tax, Low-Income Housing Tax Credit, New Markets Tax Credit, Federal Gas Tax", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "DoD aircraft training missions, A-10 Thunderbolt II, FY 2015 National Defense Authorization, Air National Guard, Army National Guard, Apache Helicopter", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "Assistance to Firefighters Grant Program, Implementation and funding of emergency communications system", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "FY 2014 Appropriations, FY2014-2015 Budget, Tax-exemption of municipal bonds, H.R. 3080 Water Resources Development Act, S. 601 Water Resources Development Act, H.R. 684 Marketplace Fairness Act, S. 743 Marketplace Fairness Act, Deduction for Local Sales Tax, New Markets Tax Credit", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "FY 2014 Appropriations, DoD training missions, A-10 Thunderbolt II, TRACON, En Route Centers", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "FY 2014 Appropriations, FY 2014-2015 Budget, geothermal programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24687, "prefix": "ms", "prefix_display": "MS.", "first_name": "TYLYNN", "nickname": null, "middle_name": "R", "last_name": "GORDON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59289, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "GOLDROSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 10 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 59.019ms