home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 2eba7bd0-17fa-4739-832e-e6360dc09ae7

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
2eba7bd0-17fa-4739-832e-e6360dc09ae7 Q2 292994 MARGARET MATHNA 178419 CUYAHOGA COUNTY EXECUTIVE (FORMERLY KNOWN AS CUYAHOGA COUNTY COMMISSIONERS) 2010 second_quarter 2010-07-16T13:01:17.030000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/2eba7bd0-17fa-4739-832e-e6360dc09ae7/", "filing_uuid": "2eba7bd0-17fa-4739-832e-e6360dc09ae7", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2010, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/2eba7bd0-17fa-4739-832e-e6360dc09ae7/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Margaret Mathna", "dt_posted": "2010-07-16T13:01:17.030000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2 Bratenahl Place Suite 3D", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Bratenahl", "registrant_state": "OH", "registrant_zip": "44108", "registrant": {"id": 292994, "url": "https://lda.senate.gov/api/v1/registrants/292994/", "house_registrant_id": 37347, "name": "MARGARET MATHNA", "description": "Government Affairs", "address_1": "2 Bratenahl Place", "address_2": "Suite 3D", "address_3": null, "address_4": null, "city": "Bratenahl", "state": "OH", "state_display": "Ohio", "zip": "44108", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MARGARET MATHNA", "contact_telephone": "+1 216-761-9405", "dt_updated": "2022-04-06T16:07:55.022653-04:00"}, "client": {"id": 178419, "url": "https://lda.senate.gov/api/v1/clients/178419/", "client_id": 1002632, "name": "CUYAHOGA COUNTY EXECUTIVE (FORMERLY KNOWN AS CUYAHOGA COUNTY COMMISSIONERS)", "general_description": "Government Affairs", "client_government_entity": true, "client_self_select": false, "state": "OH", "state_display": "Ohio", "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": "2007-08-04"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "HR3288, the consolidated approps. act, 2010 Div B, Title II and div. D, Tittle II, provisions related to crime prevention and education. HR 3293, The Labor, Health and Human Services, Education ad related Agencies Appropriations Acts, 2010 Provisions related to education. HR 2847, The Commerce, Justice, Science and related Agencies Appropriations Act, 2010 provisions related to crime prevention. The Senate Commerce, Justice, Science & related Agencies Appropriations act, 2010 provisions related to crime prevention. The Senate Commerce, Justice, Science & related Agencies Appropriations Act, 2010 provisions related to crime prevention - HR 3288 The Transportation Housing and Urban Development and related Agencies Appropriations Act, 2010 provisions related to Economic Development ; the House and Senate Transportation Authorization Act provisions related to pedestrian connectors", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26725, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "MATHNA", "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": []}

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 57.513ms