home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c52ba9d7-db2e-4e0b-bdee-b51c7bc87ef5

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
c52ba9d7-db2e-4e0b-bdee-b51c7bc87ef5 Q2 314911 POLSINELLI PC 185213 AMERICAN ASSOCIATION OF COLLEGES OF NURSING 2018 second_quarter 2018-07-13T16:03:31.693000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c52ba9d7-db2e-4e0b-bdee-b51c7bc87ef5/", "filing_uuid": "c52ba9d7-db2e-4e0b-bdee-b51c7bc87ef5", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2018, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c52ba9d7-db2e-4e0b-bdee-b51c7bc87ef5/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "KAREN BLITZ", "dt_posted": "2018-07-13T16:03:31.693000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1401 Eye Street, NW", "registrant_address_2": "Suite 800", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 314911, "url": "https://lda.senate.gov/api/v1/registrants/314911/", "house_registrant_id": 39171, "name": "POLSINELLI PC", "description": "Law Firm", "address_1": "1401 Eye Street, NW", "address_2": "Suite 800", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "KAREN BLITZ", "contact_telephone": "+1 202-783-3300", "dt_updated": "2026-01-21T11:12:57.976894-05:00"}, "client": {"id": 185213, "url": "https://lda.senate.gov/api/v1/clients/185213/", "client_id": 1004164, "name": "AMERICAN ASSOCIATION OF COLLEGES OF NURSING", "general_description": "Promote public support for professional nursing education, research, and practice", "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2014-01-01"}, "lobbying_activities": [{"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S.1615/H.R. 3440 - Dream Act of 2017\nChildrens Health", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59931, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": "former member of congress from Missouri", "new": false}, {"lobbyist": {"id": 59516, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66028, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CASEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65583, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "DALEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59645, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": null, "last_name": "STEVENSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68921, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "FOSTER", "last_name": "FLEISCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "H.R.4508 - Promoting Real Opportunity, Success, and Prosperity through Education Reform (PROSPER) Act \nHigher Education Act Reauthorization\nPublic Service Loan Forgiveness Program\nS.1808/H.R. 2482 - Federal Perkins Loan Program Extension Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59931, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59516, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59645, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": null, "last_name": "STEVENSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65583, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "DALEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66028, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CASEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 68921, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "FOSTER", "last_name": "FLEISCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.Con.Res.71- Establishing the congressional budget for the United States Government for fiscal year 2018 and setting forth the appropriate budgetary levels for fiscal years 2019 through 2027.\nS. 3158 - Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2019\nNursing Workforce Development Programs (Title VIII, Public Health Service Act), NIH, NINR, HRSA, Health Professions Programs (PHSA), CDC, AHRQ for FY18 and FY19\nPell Grants\nPrevention and Public Health Fund\nVA Nursing Partnerships and Programs\nNational Health Service Corps", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59931, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59516, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59645, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": null, "last_name": "STEVENSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65583, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "DALEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66028, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CASEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 68921, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "FOSTER", "last_name": "FLEISCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "S.1109/H.R.959 - Title VIII Nursing Workforce Reauthorization Act of 2017\nS. 445/ H.R.1825 - Home Health Care Planning Improvement Act of 2017\nH.R. 6 - SUPPORT for Patients and Communities Act \nS.2524/H.R. 5102 - Substance Use Disorder Workforce Loan Repayment Act of 2018\nH.R. 3692 - Addiction Treatment Access Improvement Act of 2017\nS. 2317 - Addiction Treatment Access Improvement Act of 2018\nS. 2456/H.R. 5311- CARA 2.0 Act of 2018\nH.R.1478 - Gun Violence Research Act\nPublic Law No: 115-119 (S.1028/H.R. 3759) RAISE Family Caregivers Act\nPriorities for health care reform\nOpioid Abuse Epidemic\nS.2680 - Opioid Crisis Response Act of 2018\nS. 2891 - Fighting the Opioid Epidemic with Sunshine Act of 2018", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59931, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59516, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59645, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": null, "last_name": "STEVENSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65583, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "DALEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66028, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CASEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 68921, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "FOSTER", "last_name": "FLEISCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R.795 - Employer Participation in Student Loan Assistance Act\nS.796 - Employer Participation in Repayment Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59931, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": null, "last_name": "WHEAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59516, "prefix": "ms", "prefix_display": "MS.", "first_name": "JULIE", "nickname": null, "middle_name": "E", "last_name": "SHROYER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66028, "prefix": null, "prefix_display": null, "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CASEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59645, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": null, "last_name": "STEVENSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65583, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "DALEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68921, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "FOSTER", "last_name": "FLEISCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"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

  • 5 rows from filing_uuid in lobbying_activities
  • 6 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 2.589ms