home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 6d8c6b01-ca50-4a49-aab8-02fa47fa1a53

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
6d8c6b01-ca50-4a49-aab8-02fa47fa1a53 Q1 400382761 RED MAPLE CONSULTING, LLC 189803 INDIAN GAMING ASSOCIATION (FKA NATIONAL INDIAN GAMING ASSOCIATION) 2019 first_quarter 2019-04-08T12:17:00.543000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/6d8c6b01-ca50-4a49-aab8-02fa47fa1a53/", "filing_uuid": "6d8c6b01-ca50-4a49-aab8-02fa47fa1a53", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2019, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/6d8c6b01-ca50-4a49-aab8-02fa47fa1a53/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Pete Kirkham", "dt_posted": "2019-04-08T12:17:00.543000-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": 189803, "url": "https://lda.senate.gov/api/v1/clients/189803/", "client_id": 48, "name": "INDIAN GAMING ASSOCIATION (FKA NATIONAL INDIAN GAMING ASSOCIATION)", "general_description": "Trade association", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "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": "2012-11-13"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Monitor implementation of 2017 tax reform specifically tribal lands and opportunity zones\nAdvocate for (1) repeal of essential governmental function and (2) eligibility of tribal court adoptions for adoption tax credit", "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": "GAM", "general_issue_code_display": "Gaming/Gambling/Casino", "description": "Monitor legislation and regulations related to gaming", "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": "HR 779 and S226, Tribal Labor Sovereignty Act of 2019\nMonitor legislation and regulations relating to tribes and labor/workplace issues", "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": []} VA US   DC   US US Trade association 0 0         20000.0  

Links from other tables

  • 3 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 0.444ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API