home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 590e52bb-ead0-4d75-aaee-2f656bf462aa

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
590e52bb-ead0-4d75-aaee-2f656bf462aa Q4 3151 AMERICAN PSYCHIATRIC ASSOCIATION 103634 AMERICAN PSYCHIATRIC ASSOCIATION 2019 fourth_quarter 2020-01-15T10:39:43.853000-05:00 216000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/590e52bb-ead0-4d75-aaee-2f656bf462aa/", "filing_uuid": "590e52bb-ead0-4d75-aaee-2f656bf462aa", "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/590e52bb-ead0-4d75-aaee-2f656bf462aa/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "216000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Craig Obey", "dt_posted": "2020-01-15T10:39:43.853000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "800 Maine AVE SW", "registrant_address_2": "Suite 900", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20024", "registrant": {"id": 3151, "url": "https://lda.senate.gov/api/v1/registrants/3151/", "house_registrant_id": 30489, "name": "AMERICAN PSYCHIATRIC ASSOCIATION", "description": null, "address_1": "800 Maine AVE SW", "address_2": "Suite 900", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20024", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ABIGAIL GRIFFIN", "contact_telephone": "+1 585-590-9005", "dt_updated": "2026-01-28T10:49:33.492707-05:00"}, "client": {"id": 103634, "url": "https://lda.senate.gov/api/v1/clients/103634/", "client_id": 12, "name": "AMERICAN PSYCHIATRIC ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "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": "1996-02-14"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "H.R. 1329, the Medicaid Reentry Act\nH.R. 1839, the Medicaid Services Investment and Accountability Act of 2019\nH.R. 3925, the Reducing Barriers to Substance Use Treatment Act\nExecutive Order Protecting and Improving Medicare for our Nations Seniors. (10/3/19)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65099, "prefix": null, "prefix_display": null, "first_name": "KAILEEN", "nickname": null, "middle_name": null, "last_name": "DOUGHERTY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66250, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "STRICKLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H. Res. 480, Acknowledging the racial disparities in diagnosing and treating mental health among youth in communities of color\nH.R. 1109, the Mental Health Services for Students Act of 2019\nH.R. 1554, the Resident Education Deferred Interest Act\nH.R. 1763 / S. 348, the Resident Physician Shortage Reduction Act of 2019\nH.R. 2062 / S. 1012 (42 CFR Part 2)\nH.R. 2279/ S. 2546, the Safe Step Act\nH.R. 2482/ S. 2074, the Mainstreaming Addiction Treatment Act of 2019\nH.R. 2734 / S. 1448, the Safer Prescribing of Controlled Substances Act\nH.R. 2862, the VACCINES Act of 2019\nH.R. 3, Lower Drug Costs Now Act of 2019\nH.R. 3180/ S. 1770, the RISE from Trauma Act\nH.R. 3239/ S. 2135, the Humanitarian Standards for Individuals in Customs and Border Protection Custody Act\nH.R. 3253, the Empowering Beneficiaries, Ensuring Access, and Strengthening Accountability Act\nH.R. 3414/ S. 2892, the Opioid Workforce Act\nH.R. 3417, BETTER Act of 2019\nH.R. 4194, S. 2661, the National Suicide Hotline Designation Act of 2019\nH.R. 4309, the Barriers to Suicide Act\nH.R. 4327, the Enhancing Mental Health and Suicide Prevention Through Campus Planning Act\nH.R. 4861/ S. 3006, the Effective Suicide Screening and Assessment in the Emergency Department Act \nH.R. 4932 / S. 2741, the CONNECT for Health Act \nH.R. 4995, the Maternal Health Quality Improvement Act of 2019\nH.R. 4996, the Helping Medicaid Offer Maternity Services Act of 2019\nH.R. 5, the Equality Act\nH.R. 5201, the Telemental Health Expansion Act of 2019\nH.R. 5473, the Enhance Access to Support Essential Behavioral Health Services Act \nH.R.5469, the Pursuing Equity in Mental Health Act of 2019 \nH.R.5575, the Primary and Behavioral Health Care Access Act of 2020\nOut of network billing legislation\nS. 1227, the Prescription Pricing for the People Act of 2019\nS. 2443, the Investment in Tomorrow's Pediatric Health Care Workforce Act\nS. 824, the Excellence in Mental Health and Addiction Treatment Expansion Act\nS.1659, the Ensuring Childrens Access to Specialty Care Act of 2019\nTitle III Sec. 305 Timely Bills to Patients within the Lower Health Care Costs Act of 2019 (S. 1895)\nCures 2.0\nGuidance related to flavored cigarette products. \nSuggestions related to addressing mental health in rural communities. \nTitle X Family Planning Program Administration Rule \nEfforts related to psychiatric bed shortages.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138415, "prefix": "mr", "prefix_display": "MR.", "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CLEMENT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65099, "prefix": null, "prefix_display": null, "first_name": "KAILEEN", "nickname": null, "middle_name": null, "last_name": "DOUGHERTY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66250, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "STRICKLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "S. 785, the Commander John Scott Hannon Veterans Mental Health Care Improvement Act of 2019\nH.R. 2931, the Securing the Rights our Veterans have Earned Act of 2019 (SERVE Act of 2019)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R. 2767, the Supporting Eating disorders Recovery through Vital Expansion Act (SERVE Act)\nH.R. 2500, the National Defense Authorization Act\nS. 1790, the National Defense Authorization Act for Fiscal Year 2020", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "H.R. 3165 / S. 1737, the Mental Health Parity Compliance Act \nH.R. 2279, the Safe Step Act\nH.R. 3630, the No Surprises Act\nH.R. 2874/ S. 1576, the Behavioral Health Coverage Transparency Act of 2019\nH.R. 3107, the Improving Seniors Timely Access to Care Act \nH. Res. 271, Condemning the Trump Administration's Legal Campaign to Take Away Americans' Health Care\nEfforts to increase compliance with the Mental Health Parity and Addiction Equity Act of 2008.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138415, "prefix": "mr", "prefix_display": "MR.", "first_name": "TIMOTHY", "nickname": null, "middle_name": null, "last_name": "CLEMENT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65099, "prefix": null, "prefix_display": null, "first_name": "KAILEEN", "nickname": null, "middle_name": null, "last_name": "DOUGHERTY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66250, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "STRICKLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "H.R. 1109, Mental Health Services for Students Act\nSTOP School Violence Act FY20 Funding\nS. 1782 Improving Mental Health Access for Students Act\nH.R. 2599/ S. 2492 Suicide Training and awareness nationally delivered for universal prevention act (STAND UP Act)\nH.R. 2431 / S. 2550, the Mental Health Professionals Workforce Shortage Loan Repayment Act of 2019 \nH.R. 3414, the Opioid Workforce Act of 2019", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65099, "prefix": null, "prefix_display": null, "first_name": "KAILEEN", "nickname": null, "middle_name": null, "last_name": "DOUGHERTY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 1865, Further Consolidated Appropriations Act, 2020 \nH.R. 2500 National Defense Authorization Act\nH.R. 2740, FY 2020 Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations bill, including programs and initiatives related to mental health and substance use disorders operated by HHS, NIH, SAMHSA, CDC, HRSA\nH.R. 3164, the Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2020\nFY 2020 MilCon-VA Appropriations Bill \nCDC firearm related morbidity and mortality research funding. \nCrisis intervention and suicide prevention services funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65099, "prefix": null, "prefix_display": null, "first_name": "KAILEEN", "nickname": null, "middle_name": null, "last_name": "DOUGHERTY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Sec. 1557 of the ACA, Efforts to weaken nondiscrimination protections for lesbian, gay, bisexual, transgender, and questioning (LGBTQ) individuals \nHealth and Human Services Grants Regulation Proposed Rule, RIN 0991-AC16", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69630, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "OBEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68253, "prefix": null, "prefix_display": null, "first_name": "MIKAEL", "nickname": null, "middle_name": null, "last_name": "TROUBH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71864, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": null, "last_name": "GREENHALGH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55793, "prefix": "ms", "prefix_display": "MS.", "first_name": "DEANA", "nickname": null, "middle_name": "M", "last_name": "MCRAE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30489 DC DC US US   0 0 986787   normalized_name_state 0.9

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 7 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 2.831ms