home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dee57ea3-1a3a-484f-86cd-e1ea904a626b

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
dee57ea3-1a3a-484f-86cd-e1ea904a626b Q1 400665998 SIFF & ASSOCIATES PLLC 193957 SERGEANTS BENEVOLENT ASSOCIATION OF NEW YORK CITY 2012 first_quarter 2012-04-12T12:50:31.313000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dee57ea3-1a3a-484f-86cd-e1ea904a626b/", "filing_uuid": "dee57ea3-1a3a-484f-86cd-e1ea904a626b", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/dee57ea3-1a3a-484f-86cd-e1ea904a626b/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Andrew M. Siff, Principal", "dt_posted": "2012-04-12T12:50:31.313000-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": 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": "RET", "general_issue_code_display": "Retirement", "description": "H.R. 3561, the \"Small Business Pension Promotion Act of 2011,\" provisions addressing normal retirement age.", "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": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Implementation of Pub. L. 111-347, the James Zadroga 9/11 Health and Compensation Act, an Act to amend the Public Health Service Act to extend and improve protections and services to individuals directly impacted by the terrorist attack in New York City on September 11, 2001, and provisions regarding determinations with respect to whether certain cancers are World Trade Center-related.", "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": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Implementation of Pub. L. 111-347, the James Zadroga 9/11 Health and Compensation Act, an Act to amend the Public Health Service Act to extend and improve protections and services to individuals directly impacted by the terrorist attack in New York City on September 11, 2001, and provisions regarding determinations with respect to whether certain cancers are World Trade Center-related.", "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": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "H.R. 365, the \"National Blue Alert Act,\" legislation to encourage, enhance, and integrate Blue Alert plans throughout the U.S. in order to disseminate information when a law enforcement officer is seriously injured or killed in the line of duty, entire bill. S. 657, the \"National Blue Alert Act,\" legislation to encourage, enhance, and integrate Blue Alert plans throughout the U.S. in order to disseminate information when a law enforcement officer is seriously injured or killed in the line of duty, 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}, {"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": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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