home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 2c8d3b8f-2341-4043-bb46-e64632507db3

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 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
2c8d3b8f-2341-4043-bb46-e64632507db3 Q2 77798 SODEXO, INC. 170113 SODEXO, INC. 2018 second_quarter 2018-07-20T13:04:20.630000-04:00 98750.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/2c8d3b8f-2341-4043-bb46-e64632507db3/", "filing_uuid": "2c8d3b8f-2341-4043-bb46-e64632507db3", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2018, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/2c8d3b8f-2341-4043-bb46-e64632507db3/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "98750.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Jessica Montoya", "dt_posted": "2018-07-20T13:04:20.630000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "France", "registrant_address_1": "9801 Washingtonian Blvd.", "registrant_address_2": "Suite 1238", "registrant_different_address": false, "registrant_city": "Gaithersburg", "registrant_state": "MD", "registrant_zip": "20878", "registrant": {"id": 77798, "url": "https://lda.senate.gov/api/v1/registrants/77798/", "house_registrant_id": 36155, "name": "SODEXO, INC.", "description": "Food Services and Facilities Management", "address_1": "9801 Washingtonian Blvd.", "address_2": "Suite 1238", "address_3": null, "address_4": null, "city": "Gaithersburg", "state": "MD", "state_display": "Maryland", "zip": "20878", "country": "US", "country_display": "United States of America", "ppb_country": "FR", "ppb_country_display": "France", "contact_name": "NANCY A. BUKAR", "contact_telephone": "+1 301-987-4983", "dt_updated": "2022-04-06T16:08:01.149169-04:00"}, "client": {"id": 170113, "url": "https://lda.senate.gov/api/v1/clients/170113/", "client_id": 12, "name": "SODEXO, INC.", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "MD", "state_display": "Maryland", "country": "US", "country_display": "United States of America", "ppb_state": "MD", "ppb_state_display": "Maryland", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-12-22"}, "lobbying_activities": [{"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Outreach on effects of Tarrifs and trade policy as ordered by Executive orders from Office of the President.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51227, "prefix": null, "prefix_display": null, "first_name": "JESSICA", "nickname": null, "middle_name": null, "last_name": "MONTOYA", "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": "General outreach and education to members of Congress on quality of life services to federal government and military.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51227, "prefix": null, "prefix_display": null, "first_name": "JESSICA", "nickname": null, "middle_name": null, "last_name": "MONTOYA", "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": "RET", "general_issue_code_display": "Retirement", "description": "Monitoring of Proposals relating to multiemployer pension plans, including S. 2147, the Butch Lewis Act of 2018 and H.R. 4444, the Rehabilitation for Multiemployer Pensions Act, and additional proposals to modernize the multiemployer pension plan system.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51227, "prefix": null, "prefix_display": null, "first_name": "JESSICA", "nickname": null, "middle_name": null, "last_name": "MONTOYA", "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": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "This issue was not lobbied in this quarter.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51227, "prefix": null, "prefix_display": null, "first_name": "JESSICA", "nickname": null, "middle_name": null, "last_name": "MONTOYA", "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": "AGR", "general_issue_code_display": "Agriculture", "description": "Policies and provisions in various bills with respect to child nutrition and food policy and safety.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51227, "prefix": null, "prefix_display": null, "first_name": "JESSICA", "nickname": null, "middle_name": null, "last_name": "MONTOYA", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Monitoring of US Labor Department policies and memoranda regarding labor regulatons like overtime pay and review of proposed job growth programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51227, "prefix": null, "prefix_display": null, "first_name": "JESSICA", "nickname": null, "middle_name": null, "last_name": "MONTOYA", "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": []} MD US 36155 MD MD US US   0 0 2241230   normalized_name 0.7

Links from other tables

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