home / lobbying / lobbying_filings_raw

lobbying_filings_raw: fc7798c3-2a7a-4e97-bdd0-77a0fcffd332

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
fc7798c3-2a7a-4e97-bdd0-77a0fcffd332 Q2 401105214 RUTTENKERN POLICY GROUP 203414 RAJEN DAIRY 2020 second_quarter 2020-07-14T10:21:43.270000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/fc7798c3-2a7a-4e97-bdd0-77a0fcffd332/", "filing_uuid": "fc7798c3-2a7a-4e97-bdd0-77a0fcffd332", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2020, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/fc7798c3-2a7a-4e97-bdd0-77a0fcffd332/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Timothy M Rutten", "dt_posted": "2020-07-14T10:21:43.270000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "641 Constitution Ave, NE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 401105214, "url": "https://lda.senate.gov/api/v1/registrants/401105214/", "house_registrant_id": null, "name": "RUTTENKERN POLICY GROUP", "description": "lobbying firm", "address_1": "641 Constitution Ave, NE", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20002", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TIMOTHY M RUTTEN", "contact_telephone": "+1 202-547-5801", "dt_updated": "2026-01-05T16:04:51.465066-05:00"}, "client": {"id": 203414, "url": "https://lda.senate.gov/api/v1/clients/203414/", "client_id": 24, "name": "RAJEN DAIRY", "general_description": "farming", "client_government_entity": false, "client_self_select": null, "state": "NM", "state_display": "New Mexico", "country": "US", "country_display": "United States of America", "ppb_state": "NM", "ppb_state_display": "New Mexico", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2019-03-01"}, "lobbying_activities": [{"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "S 675, the Prompt and Fast Action to Stop Damages Act of 2019 and HR 1567, Prompt and Fast Action to Stop Damages Act of 2019. Monitor legislation\n\nS 4049 and HR 6395, National Defense Authorization Act \n\nFY 2021, Agriculture Appropriations, potential amendments\n\nFY 2021, Defense Appropriations, Potential Amendments\n\nHR 535, the PFAS Action Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70198, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "RUTTEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71393, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": "B.", "last_name": "KERN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 25, "name": "Defense, Dept of (DOD)"}, {"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
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.709ms