home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e541dc56-e459-43a3-bb0b-347edf9237de

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
e541dc56-e459-43a3-bb0b-347edf9237de 2T 12868 DUTKO WORLDWIDE, LLC 118397 GRAYLING CONNECTING POINT, LLC 2011 second_quarter 2011-07-08T14:13:29.477000-04:00   0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/e541dc56-e459-43a3-bb0b-347edf9237de/", "filing_uuid": "e541dc56-e459-43a3-bb0b-347edf9237de", "filing_type": "2T", "filing_type_display": "2nd Quarter - Termination", "filing_year": 2011, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e541dc56-e459-43a3-bb0b-347edf9237de/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Joshua Ian Rosenstein, Vice President and General Counsel", "dt_posted": "2011-07-08T14:13:29.477000-04:00", "termination_date": "2011-04-01", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "412 FIRST STREET SE", "registrant_address_2": "SUITE 100", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 12868, "url": "https://lda.senate.gov/api/v1/registrants/12868/", "house_registrant_id": 32229, "name": "DUTKO WORLDWIDE, LLC", "description": "Government relations firm", "address_1": "80 M STREET SE", "address_2": "SUITE 130", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRIS ANDRESEN", "contact_telephone": "+1 202-851-3618", "dt_updated": "2026-01-26T17:43:32.412214-05:00"}, "client": {"id": 118397, "url": "https://lda.senate.gov/api/v1/clients/118397/", "client_id": 1006055, "name": "GRAYLING CONNECTING POINT, LLC", "general_description": "High-tech public relations", "client_government_entity": false, "client_self_select": false, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2010-11-18"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Work on behalf of Grayling's client, New Market Impressions LLC (which provides laser etching on eggs to enable consumers, growers and producers to trace eggs and their production place and date), on food safety legislation, FDA and USDA appropriations issues, including implementation of P.L. 111-353, The FDA Food Safety Modernization Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48584, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "P", "last_name": "HALL", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "Work on behalf of Grayling's client, New Market Impressions LLC (which provides laser etching on eggs to enable consumers, growers and producers to trace eggs and their production place and date), on food safety legislation, FDA and USDA appropriations issues, including implementation of P.L. 111-353, The FDA Food Safety Modernization Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 48584, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "P", "last_name": "HALL", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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