home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa

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 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
51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY 28093 REPUBLICAN JEWISH COALITION 134489 REPUBLICAN JEWISH COALITION 2004 year_end 2005-02-10T00:00:00-05:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa/", "filing_uuid": "51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa", "filing_type": "YY", "filing_type_display": "Year-End Report", "filing_year": 2004, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "40000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2005-02-10T00:00:00-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": 28093, "url": "https://lda.senate.gov/api/v1/registrants/28093/", "house_registrant_id": 32870, "name": "REPUBLICAN JEWISH COALITION", "description": null, "address_1": "50 F STREET, NW", "address_2": "SUITE 100", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "NOAH SILVERMAN", "contact_telephone": "", "dt_updated": "2026-01-22T16:23:26.035617-05:00"}, "client": {"id": 134489, "url": "https://lda.senate.gov/api/v1/clients/134489/", "client_id": 12, "name": "REPUBLICAN JEWISH COALITION", "general_description": null, "client_government_entity": false, "client_self_select": true, "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": "1996-02-14"}, "lobbying_activities": [{"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "H.R. 3077, International Studies in Higher Education Act, Title VI provisions.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "WEL", "general_issue_code_display": "Welfare", "description": "H.R. 4, Welfare Reform Extension", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "H.R. 401, S. 684, Koby Mandell Act\r\nH.R. 4818, Omnibus FY 2005 Appropriations, Koby Mandell provisions", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 6, Energy Policy Act of 2003", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R. 4613, Defense Appropriations for FY 2005, Middle East provisions", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "H.R. 4818, Omnibus Appropriations for FY 2005, Mideast provisions\r\nH.R. 4214, S. 2292, Global Anti-Semitism Review Act\r\nH.R. 4284, S. 2389, Investigating UN Oil for Food Program\r\nH.Con.Res. 311, S.Res. 325, Jewish Refugees\r\nH.Res. 615, Israel and UN WEOG\r\nH.Res. 617, Israel and OECD\r\nH.Con.Res. 425, S.Con.Res. 110, OSCE Combatting Anti-Semitism\r\nH.Res. 713, S.Res. 408, UN ICJ and Israel's Security Barrier\r\nH.Con.Res. 398, S.Con.Res. 81, Iran's nuclear weapons program\r\nH.R. 5193, S. 2681, Iran Freedom Support Act\r\nH.Con.Res. 469, S.Con.Res. 126, Bombing AMIA Jewish Center in Argentina\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "REL", "general_issue_code_display": "Religion", "description": "S. 893, Workplace Religious Freedom Act", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 2202, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "KASSIDAY", "suffix": null, "suffix_display": null}, "covered_position": "CHIEF OF STAFF, U.S. REP. ELTON GALLEGY (THROUGH 10/18/02)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32870 DC DC US US   0 0 975802   normalized_name_state 0.9

Links from other tables

  • 7 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 23.349ms