lobbying_filings_raw: 54418279-22c0-4755-bee0-fe4496480386

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence income_amount expense_amount
54418279-22c0-4755-bee0-fe4496480386 Q3 400665998 SIFF & ASSOCIATES PLLC 193952 UNITED BROTHERHOOD OF CARPENTERS AND JOINERS OF AMERICA 2018 third_quarter 2018-10-15T15:12:43.527000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/54418279-22c0-4755-bee0-fe4496480386/", "filing_uuid": "54418279-22c0-4755-bee0-fe4496480386", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2018, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/54418279-22c0-4755-bee0-fe4496480386/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Andrew M. Siff", "dt_posted": "2018-10-15T15:12:43.527000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "3222 N Street, NW", "registrant_address_2": "Suite 340", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20007", "registrant": {"id": 400665998, "url": "https://lda.senate.gov/api/v1/registrants/400665998/", "house_registrant_id": 41451, "name": "SIFF & ASSOCIATES PLLC", "description": "Law firm", "address_1": "3222 N Street, NW", "address_2": "Suite 340", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20007", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ANDREW M. SIFF", "contact_telephone": "+1 202-457-7756", "dt_updated": "2022-04-06T16:06:16.877869-04:00"}, "client": {"id": 193952, "url": "https://lda.senate.gov/api/v1/clients/193952/", "client_id": 51, "name": "UNITED BROTHERHOOD OF CARPENTERS AND JOINERS OF AMERICA", "general_description": "Labor Organization", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "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": "2013-11-19"}, "lobbying_activities": [{"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Implementation of Sec. 1086 of Public Law 114-92, the \"National Defense Authorization Act for Fiscal Year 2016,\" concerning Government Accountability Office study of federal background check, access control, and credentialing standards.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52774, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "GRANBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "S. 3405, the \"Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018,\" legislation to reauthorize the Chemical Facility Anti-Terrorism Standards program; Section 7, Personnel Surety Program. General education regarding federal access control, background check, and credentialing programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52774, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "GRANBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Implementation of Sec. 1050 of Public Law 114-138, the \"National Defense Authorization Act for Fiscal Year 2017,\" concerning the use of Transportation Worker Identification Credentials to gain access at Department of Defense Installations. Implementation of the Identity Management Engine for Security and Analysis system and the ability for employees and contractors to utilize Transportation Worker Identification Credentials for access to Defense Department facilities and installations.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52774, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": null, "last_name": "GRANBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 41451 DC   US US Labor Organization 0 0         20000.0  

Links from other tables