home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bbd4e01d-266d-43c7-a80e-a4575f9e841b

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 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
bbd4e01d-266d-43c7-a80e-a4575f9e841b Q2 1615 AMERICAN ASSOCIATION OF LAW LIBRARIES 102635 AMERICAN ASSOCIATION OF LAW LIBRARIES 2017 second_quarter 2017-07-10T10:29:08.453000-04:00 5200.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bbd4e01d-266d-43c7-a80e-a4575f9e841b/", "filing_uuid": "bbd4e01d-266d-43c7-a80e-a4575f9e841b", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bbd4e01d-266d-43c7-a80e-a4575f9e841b/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "5200.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Emily Feltren", "dt_posted": "2017-07-10T10:29:08.453000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "105 W. Adams Street", "registrant_address_2": "Suite 3300", "registrant_different_address": false, "registrant_city": "Chicago", "registrant_state": "IL", "registrant_zip": "60603", "registrant": {"id": 1615, "url": "https://lda.senate.gov/api/v1/registrants/1615/", "house_registrant_id": 31710, "name": "AMERICAN ASSOCIATION OF LAW LIBRARIES", "description": "Professional association interested in information policy.", "address_1": "230 West Monroe Street", "address_2": "Suite 2650", "address_3": null, "address_4": null, "city": "Chicago", "state": "IL", "state_display": "Illinois", "zip": "60606", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "VANI UNGAPEN", "contact_telephone": "+1 312-205-8016", "dt_updated": "2023-08-13T10:25:18.221543-04:00"}, "client": {"id": 102635, "url": "https://lda.senate.gov/api/v1/clients/102635/", "client_id": 12, "name": "AMERICAN ASSOCIATION OF LAW LIBRARIES", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "IL", "state_display": "Illinois", "country": "US", "country_display": "United States of America", "ppb_state": "IL", "ppb_state_display": "Illinois", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-01-28"}, "lobbying_activities": [{"general_issue_code": "INT", "general_issue_code_display": "Intelligence", "description": "H.R. 699, Email Privacy Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40635, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": "J", "last_name": "FELTREN", "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": "TEC", "general_issue_code_display": "Telecommunications", "description": "H.R. 1770, OPEN Government Data Act\nS.J.Res.34 - A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Communications Commission relating to \"Protecting the Privacy of Customers of Broadband and Other Telecommunications Services\"\nIn support of the FCCs Open Internet Order (no specific bill)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40635, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": "J", "last_name": "FELTREN", "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": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "H.R. 890, CODE Act\nH.R. 1695/S. 1010 Register of Copyrights Selection and Accountability Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40635, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": "J", "last_name": "FELTREN", "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": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "H.R. 1815/S.845 Protecting Sensitive Locations Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40635, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": "J", "last_name": "FELTREN", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R.244, Consolidated Appropriations Act 2017 - Legislative Branch appropriations (Government Publishing Office and Library of Congress); Commerce Justice and Science appropriations (Legal Services Corporation); Labor, HHS and Education appropriations (Institute of Museum and Library Services)\nH.J.Res.99 - Making Further Continuing Appropriations for FY2017 and for other purposes -- Legislative Branch appropriations (Government Publishing Office and Library of Congress); Commerce Justice and Science appropriations (Legal Services Corporation); Labor, HHS and Education appropriations (Institute of Museum and Library Services)\nFY 2018 Legislative Branch appropriations (Government Publishing Office and Library of Congress); Commerce Justice and Science appropriations (Legal Services Corporation); Labor, HHS and Education appropriations (Institute of Museum and Library Services)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40635, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": "J", "last_name": "FELTREN", "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": "S. 760/H.R. 1770, OPEN Government Data Act\nH.R.2884: To amend section 2201 of title 44, United States Code, to require the preservation of presidential social media accounts, and for other purposes.\nH.R.2335: To direct the Director of the Government Publishing Office to provide members of the public with Internet access to Congressional Research Service reports, and for other purposes.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40635, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": "J", "last_name": "FELTREN", "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": []} IL US 31710 IL IL US US   0 0 577063   normalized_name_state 0.9

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.073ms