home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 0e59edc7-e0f2-4a0c-8a4d-559f74a481e7

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
0e59edc7-e0f2-4a0c-8a4d-559f74a481e7 Q2 400382761 RED MAPLE CONSULTING, LLC 189800 CHICKASAW NATION 2016 second_quarter 2016-07-13T20:06:31.057000-04:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0e59edc7-e0f2-4a0c-8a4d-559f74a481e7/", "filing_uuid": "0e59edc7-e0f2-4a0c-8a4d-559f74a481e7", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2016, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0e59edc7-e0f2-4a0c-8a4d-559f74a481e7/print/", "filing_document_content_type": "text/html", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Pete Kirkham", "dt_posted": "2016-07-13T20:06:31.057000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "6929 Conservation Drive", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Springfield", "registrant_state": "VA", "registrant_zip": "22153", "registrant": {"id": 400382761, "url": "https://lda.senate.gov/api/v1/registrants/400382761/", "house_registrant_id": null, "name": "RED MAPLE CONSULTING, LLC", "description": "Government affairs consulting", "address_1": "PO Box 133", "address_2": null, "address_3": null, "address_4": null, "city": "Yorktown", "state": "VA", "state_display": "Virginia", "zip": "23690", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "PETE KIRKHAM", "contact_telephone": "+1 571-286-6482", "dt_updated": "2026-01-05T17:55:52.424812-05:00"}, "client": {"id": 189800, "url": "https://lda.senate.gov/api/v1/clients/189800/", "client_id": 12, "name": "CHICKASAW NATION", "general_description": "Native American tribe", "client_government_entity": false, "client_self_select": false, "state": "OK", "state_display": "Oklahoma", "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": "2009-01-05"}, "lobbying_activities": [{"general_issue_code": "GAM", "general_issue_code_display": "Gaming/Gambling/Casino", "description": "Monitor gaming legislation, regulations and National Indian Gaming Commission\nH.R. 707, S. 1668, Restoration of America's Wire Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "SMB", "general_issue_code_display": "Small Business", "description": "Monitor legislation and regulations on 8(a) programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "FY17 Interior appropriations--BIA and IHS funding, HR 5538 and S 3068\nFY17 Labor HHS appropriations--tribal labor sovereignty, draft HR--- and S 3040", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "TRA", "general_issue_code_display": "Transportation", "description": "Monitor highway reauthorization, specifically Tribal Transportation Program\nHR 22, Fixing America's Surface Transportation Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "EDU", "general_issue_code_display": "Education", "description": "Draft legislation affecting the Johnson-O'Malley Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 511, S. 248, Tribal Labor Sovereignty Act\nMonitor NLRB legislation and regulations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Tax reform generally as it relates to Indian tribes\nTribal eligibility for alternative fuels-related tax incentives\nMonitor legislation and regulation on taxation of tribal election campaign assets\nImplementation of the Tribal General Welfare Exclusion Act of 2013\nTribal allocations of the New Markets Tax Credit\nBonds, pensions and essential governmental function rule", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "HOU", "general_issue_code_display": "Housing", "description": "H.R. 360, Native American Housing Assistance and Self-Determination Reauthorization Act of 2015", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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": "NAT", "general_issue_code_display": "Natural Resources", "description": "Monitor water rights issues involving Sardis Lake in Oklahoma\nMonitor issues involving Chickasaw National Recreation Area\nMonitor issues involving management and disposition of tribal trust assets--timber lands\nMonitor H.R. 2684 and S. 1457, Alabama-Coushatta Tribe of Texas Equal and Fair Opportunity Settlement Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46175, "prefix": null, "prefix_display": null, "first_name": "PETE", "nickname": null, "middle_name": null, "last_name": "KIRKHAM", "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

  • 9 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 36.879ms