lobbying_filings_raw: f1f5fd62-4081-4c23-95fa-4e8a0b7dfb4e

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
f1f5fd62-4081-4c23-95fa-4e8a0b7dfb4e 4T 400656969 BATES CAPITOL GROUP, INC. 193892 ALTRIA CLIENT SERVICES, INC. 2012 fourth_quarter 2013-01-18T15:33:08.267000-05:00 40000.0 0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/f1f5fd62-4081-4c23-95fa-4e8a0b7dfb4e/", "filing_uuid": "f1f5fd62-4081-4c23-95fa-4e8a0b7dfb4e", "filing_type": "4T", "filing_type_display": "4th Quarter - Termination", "filing_year": 2012, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f1f5fd62-4081-4c23-95fa-4e8a0b7dfb4e/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Hunter Bates", "dt_posted": "2013-01-18T15:33:08.267000-05:00", "termination_date": "2012-12-31", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "12918 Crestmoor Circle", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Prospect", "registrant_state": "KY", "registrant_zip": "40059", "registrant": {"id": 400656969, "url": "https://lda.senate.gov/api/v1/registrants/400656969/", "house_registrant_id": null, "name": "BATES CAPITOL GROUP, INC.", "description": "Government Affairs Consulting", "address_1": "PO Box 205", "address_2": null, "address_3": null, "address_4": null, "city": "Harrods Creek", "state": "KY", "state_display": "Kentucky", "zip": "40027", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "HUNTER BATES", "contact_telephone": "+1 502-773-4236", "dt_updated": "2022-04-06T16:08:14.586364-04:00"}, "client": {"id": 193892, "url": "https://lda.senate.gov/api/v1/clients/193892/", "client_id": 315, "name": "ALTRIA CLIENT SERVICES, INC.", "general_description": "Client services for parent company of manufacturers of tobacco products and premium wines", "client_government_entity": false, "client_self_select": null, "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": "2012-09-01"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Center for Disease Control's implementation of health care funding provisions of P.L. 111-148, the Patient Protection and Affordable Care Act. Center for Disease Control's implementation of stimulus funding provisions of P.L. 111-5,American Recovery and Reinvestment Act. Department of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2012. Sec. 503, provision relating to use of appropriated fund for lobbying.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52788, "prefix": null, "prefix_display": null, "first_name": "G", "nickname": null, "middle_name": "HUNTER", "last_name": "BATES", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Center for Disease Control's implementation of stimulus funding provisions of P.L. 111-5, American Recovery and Reinvestment Act. Department of Labor, Health and Human Services,and Education, and Related Agencies Appropriations Act, 2012. Sec. 503, provision relating to use of appropriated fund for lobbying. Monitor fiscal cliff tax and budget negotiations.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52788, "prefix": null, "prefix_display": null, "first_name": "G", "nickname": null, "middle_name": "HUNTER", "last_name": "BATES", "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": "TOB", "general_issue_code_display": "Tobacco", "description": "Monitor H.R.1639 regarding FDA regulations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52788, "prefix": null, "prefix_display": null, "first_name": "G", "nickname": null, "middle_name": "HUNTER", "last_name": "BATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables