home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 80cd6946-083f-4e91-aa92-ebe66943f5a8

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
80cd6946-083f-4e91-aa92-ebe66943f5a8 Q3 400382761 RED MAPLE CONSULTING, LLC 189800 CHICKASAW NATION 2017 third_quarter 2017-10-20T07:38:07.120000-04:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/80cd6946-083f-4e91-aa92-ebe66943f5a8/", "filing_uuid": "80cd6946-083f-4e91-aa92-ebe66943f5a8", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2017, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/80cd6946-083f-4e91-aa92-ebe66943f5a8/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": "2017-10-20T07:38:07.120000-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": "TRA", "general_issue_code_display": "Transportation", "description": "Monitor infrastructure enhancement legislation, including Tribal Transportation Program", "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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Monitor issues involving Chickasaw National Recreation Area\nMonitor draft HR ____ and S ___, Alabama-Coushatta Tribe of Texas Equal and Fair Opportunity Settlement Act\nMonitor status of land-into-trust applications, including Shawnee application near Guymon, OK", "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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"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\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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 986, S. 63, 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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "Reauthorization of Native American Housing Assistance and Self-Determination Reauthorization 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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY17 and FY18 Interior appropriations--BIA and IHS funding\nFY17 and FY18 Labor HHS appropriations--tribal labor sovereignty,", "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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GAM", "general_issue_code_display": "Gaming/Gambling/Casino", "description": "Monitor gaming legislation, regulations and National Indian Gaming Commission\nDraft HR ____ 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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Monitor impact of Affordable Care Act reform efforts on tribal health care\nVA reimbursement of IHS facilities for third party referrals", "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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Draft legislation affecting the Johnson-O'Malley Act\nTribes and charter schools", "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": 146, "name": "Bureau of Indian Affairs (BIA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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