home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c804b8ea-e0c2-49f9-ac0e-d2ec6b508b1b

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
c804b8ea-e0c2-49f9-ac0e-d2ec6b508b1b YY 18570 PALMETTO GROUP 125738 CITADEL INVESTMENT GROUP L L C 2007 year_end 2008-01-10T14:15:16.327000-05:00 150000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c804b8ea-e0c2-49f9-ac0e-d2ec6b508b1b/", "filing_uuid": "c804b8ea-e0c2-49f9-ac0e-d2ec6b508b1b", "filing_type": "YY", "filing_type_display": "Year-End Report", "filing_year": 2007, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c804b8ea-e0c2-49f9-ac0e-d2ec6b508b1b/print/", "filing_document_content_type": "application/pdf", "income": "150000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2008-01-10T14:15:16.327000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 18570, "url": "https://lda.senate.gov/api/v1/registrants/18570/", "house_registrant_id": 30874, "name": "PALMETTO GROUP", "description": "Legislative Consulting", "address_1": "One Massachusetts Avenue NW", "address_2": "Suite 850", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRISTY MISTR", "contact_telephone": "+1 202-580-6511", "dt_updated": "2022-04-06T16:06:31.775300-04:00"}, "client": {"id": 125738, "url": "https://lda.senate.gov/api/v1/clients/125738/", "client_id": 1004208, "name": "CITADEL INVESTMENT GROUP L L C", "general_description": "Diverse financial institution including hedge funds", "client_government_entity": false, "client_self_select": false, "state": null, "state_display": null, "country": "", "country_display": "* Undetermined", "ppb_state": null, "ppb_state_display": null, "ppb_country": "", "ppb_country_display": "* Undetermined", "effective_date": "2007-09-21"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 2834 To amend the Internal Revenue Code of 1986 to treat income received by partners for performing investment management services as ordinary income received for the performance of services. H.R. 2785 & S.1624 To amend the Internal Revenue Code of 1986 to provide that the exception from the treatment of publicly traded partnerships as corporations for partnerships with passive-type income.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 35943, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "PRUCKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 36419, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "RUDD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45824, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "GLAZE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45849, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "WINBURN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45855, "prefix": null, "prefix_display": null, "first_name": "ED", "nickname": null, "middle_name": null, "last_name": "JENKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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