home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a47444d0-a768-4e04-a957-e7cbdbc6a233

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

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
a47444d0-a768-4e04-a957-e7cbdbc6a233 Q4 400665998 SIFF & ASSOCIATES PLLC 193957 SERGEANTS BENEVOLENT ASSOCIATION OF NEW YORK CITY 2019 fourth_quarter 2020-01-10T12:24:41.277000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a47444d0-a768-4e04-a957-e7cbdbc6a233/", "filing_uuid": "a47444d0-a768-4e04-a957-e7cbdbc6a233", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2019, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a47444d0-a768-4e04-a957-e7cbdbc6a233/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Andrew M. Siff", "dt_posted": "2020-01-10T12:24:41.277000-05: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": 193957, "url": "https://lda.senate.gov/api/v1/clients/193957/", "client_id": 24, "name": "SERGEANTS BENEVOLENT ASSOCIATION OF NEW YORK CITY", "general_description": "Law Enforcement Labor Organization", "client_government_entity": false, "client_self_select": false, "state": "NY", "state_display": "New York", "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": "2010-10-01"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 1865, the \"Further Consolidated Appropriations Act, 2020\"; Division K, \"National Law Enforcement Museum Commemorative Coin.\" H.R. 3055, the FY 2020 Commerce-Justice-Science Appropriations Act; S.Amdt. 963, an amendment to establish a \"Bulletproof Vest Partnership Program Type III Body Armor Fund.\"", "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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Application of the Fair Labor Standards Act to police officers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52771, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "SIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "S. 273, the \"Kelsey Smith Act,\" a bill to amend the Communications Act of 1934 to require providers of a covered service to provide location information concerning the telecommunications device of a user of such service to an investigative or law enforcement officer or an employee or other agent of a public safety answering point in an emergency situation involving risk of death or serious physical harm or in order to respond to the user's call for emergency services; entire bill. S. 2878, the \"Facial Recognition Technology Warrant Act of 2019,\" legislation to limit the ability of federal law enforcement agencies to utilize facial recognition technology; entire bill. General education regarding law enforcement's use of facial recognition technology and the potential impact of proposals to impose a ban or moratorium on such use. General education concerning the challenges posed to law enforcement by encryption and other technological barriers on cellular phones and messaging apps.", "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}, {"lobbyist": {"id": 52771, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "SIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71344, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": "P", "last_name": "SIMPSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 5342, the \"Supporting America's First Responders Act of 2019,\" a bill to amend the Internal Revenue Code to allow certain expenses of first responders as an above-the-line deduction; entire bill.", "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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Implementation of Pub. Law 116-32, a law to reauthorize and expand federal support for law enforcement mental health and wellness programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52771, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "SIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "H.R. 2812, the \"Protecting America's First Responders Act,\" legislation to provide for reforms to the delivery of death and disability benefits under the Public Safety Officers' Benefits Program for public safety officers who have died or become disabled in the line of duty; entire bill. S. 1208, the \"Protecting America's First Responders Act,\" legislation to provide for reforms to the delivery of death and disability benefits under the Public Safety Officers' Benefits Program for public safety officers who have died or become disabled in the line of duty; entire bill. S. 1644, the \"Stop Dangerous Sanctuary Cities Act,\" legislation to provide liability protection for local officials who comply with immigration detainers, and to withhold non-law enforcement federal grant funds from sanctuary jurisdictions; entire bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52771, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "SIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S. 2059, the \"Justice for Victims of Sanctuary Cities Act of 2019,\" legislation to provide a civil remedy for individuals harmed by sanctuary jurisdiction policies; entire bill. General education concerning the risks posed to citizens and police officers by state and local policies that prevent police departments from cooperating with Immigration and Customs Enforcement in removing dangerous criminals from communities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52771, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "SIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "H.R. 3735, the \"Law Enforcement Suicide Data Collection Act,\" legislation to require the Director of the FBI to provide information on suicide rates in law enforcement; entire bill. S. 2746, the \"Law Enforcement Suicide Data Collection Act,\" legislation to require the Director of the FBI to provide information on suicide rates in law enforcement; entire bill. H.R. 5395, the \"Back the Blue Act of 2019,\" legislation to revise Title 18, U.S. Code, to enhance protections for federal, state, and local law enforcement officers; entire bill. S. 2323, the \"Screening All Fentanyl-Enhanced (SAFE) Mail Act,\" legislation to require the 100 percent screening of international mail and express cargo inbound into the United States from high-risk countries to detect and prevent the importation of illicit fentanyl and other illicit synthetic opioids; entire bill. Legislative proposal to include a provision in any final year-end government funding package to extend the DEA's temporary scheduling order for fentanyl-related substances. General education concerning the need to ensure that fentanyl analogues continue to be included on the list of prohibited Schedule A opioids when the temporary placement of certain analogues on this list expires.", "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}, {"lobbyist": {"id": 52771, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "SIFF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 41451 NY   US US Law Enforcement Labor Organization 0 0         40000.0  

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.547ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy