home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a25f2ddc-3fee-4824-bd8f-e46ad71a2eb8

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
a25f2ddc-3fee-4824-bd8f-e46ad71a2eb8 Q2 22883 FBB FEDERAL RELATIONS 129730 GREEN HILLS SOFTWARE 2012 second_quarter 2012-07-13T11:18:30.827000-04:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a25f2ddc-3fee-4824-bd8f-e46ad71a2eb8/", "filing_uuid": "a25f2ddc-3fee-4824-bd8f-e46ad71a2eb8", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2012, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a25f2ddc-3fee-4824-bd8f-e46ad71a2eb8/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Peter Friedmann, Of Counsel", "dt_posted": "2012-07-13T11:18:30.827000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1120 G STREET, NW", "registrant_address_2": "SUITE 1020", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 22883, "url": "https://lda.senate.gov/api/v1/registrants/22883/", "house_registrant_id": 32752, "name": "FBB FEDERAL RELATIONS", "description": "Lobbying Services", "address_1": "801 Pennsylvania Ave. NW", "address_2": "Apt. PH20", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "PETER FRIEDMANN", "contact_telephone": "+1 202-783-3333", "dt_updated": "2025-08-19T14:34:40.623595-04:00"}, "client": {"id": 129730, "url": "https://lda.senate.gov/api/v1/clients/129730/", "client_id": 176, "name": "GREEN HILLS SOFTWARE", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Pursue policies that support utilization of the most secure real time operating systems in military and civilian applications, and for funding for specific projects that will utilize secure operating system in government application.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 30928, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "FRIEDMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1517, "prefix": null, "prefix_display": null, "first_name": "RAY", "nickname": null, "middle_name": null, "last_name": "BUCHEGER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"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.811ms