home / lobbying / lobbying_filings_raw

lobbying_filings_raw: abecbaa6-4fdd-4826-998d-b84eec626dc9

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
abecbaa6-4fdd-4826-998d-b84eec626dc9 Q4 314738 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS 185030 THERMO FISHER SCIENTIFIC INC 2011 fourth_quarter 2011-01-18T13:53:02.273000-05:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/abecbaa6-4fdd-4826-998d-b84eec626dc9/", "filing_uuid": "abecbaa6-4fdd-4826-998d-b84eec626dc9", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2011, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/abecbaa6-4fdd-4826-998d-b84eec626dc9/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Tim Schellberg, President", "dt_posted": "2011-01-18T13:53:02.273000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "203 Maryland Ave., NE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 314738, "url": "https://lda.senate.gov/api/v1/registrants/314738/", "house_registrant_id": 39172, "name": "GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS", "description": "lobbying firm", "address_1": "1323 Clifton Street NW", "address_2": "Unit 1", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20009", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "HALLEE CROCE", "contact_telephone": "+1 253-620-6639", "dt_updated": "2026-02-03T16:48:08.539668-05:00"}, "client": {"id": 185030, "url": "https://lda.senate.gov/api/v1/clients/185030/", "client_id": 36, "name": "THERMO FISHER SCIENTIFIC INC", "general_description": "Thermo Fisher Scientific is an American provisioner of scientific instrumentation, reagent", "client_government_entity": false, "client_self_select": null, "state": "MA", "state_display": "Massachusetts", "country": "US", "country_display": "United States of America", "ppb_state": "MA", "ppb_state_display": "Massachusetts", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-02-06"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "S.3636 Commerce Justice Science and related ageny appropriations Act 2011\nOmnibus Appropriations bill dealing with DNA", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19476, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "SCHELLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38517, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "HURST", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "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. 4614 Katie Sepich Enhances DNA Collection Act of 2010, H.R. 2736 Justice for Survivors of Sexual Assault Act of 2009, S.4114 Justice for Survivors of Sexual Assault Act of 2009, S. 3805 Katie Sepich Enhances DNA Collection Act of 2010, S.3842 Justice for all Reauthorization Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19476, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "SCHELLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 38517, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "HURST", "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

  • 2 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.815ms