home / lobbying / lobbying_filings_raw

lobbying_filings_raw: d1a9a1f7-e663-49ce-99ec-a765897ba2d2

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
d1a9a1f7-e663-49ce-99ec-a765897ba2d2 Q4 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 103635 AMERICAN PSYCHOLOGICAL ASSOCIATION 2017 fourth_quarter 2018-01-12T15:08:36.900000-05:00 150000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/d1a9a1f7-e663-49ce-99ec-a765897ba2d2/", "filing_uuid": "d1a9a1f7-e663-49ce-99ec-a765897ba2d2", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2017, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/d1a9a1f7-e663-49ce-99ec-a765897ba2d2/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "150000.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Ellen G. Garrison, PhD, Senior Policy Advisor", "dt_posted": "2018-01-12T15:08:36.900000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "750 FIRST STREET, NE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 3162, "url": "https://lda.senate.gov/api/v1/registrants/3162/", "house_registrant_id": 30849, "name": "AMERICAN PSYCHOLOGICAL ASSOCIATION", "description": null, "address_1": "750 FIRST STREET, NE", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20002", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ELLEN GARRISON", "contact_telephone": "+1 202-336-6066", "dt_updated": "2023-06-06T16:25:13.702027-04:00"}, "client": {"id": 103635, "url": "https://lda.senate.gov/api/v1/clients/103635/", "client_id": 12, "name": "AMERICAN PSYCHOLOGICAL 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": "2007-08-01"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "FY2018 Appropriations for DoD - funding for psychological research and mental health programs\nMental and behavioral health of service members and their families\nS. 1519/H.R. 2810 Defense Authorization Bills\nS. 1820 A bill to provide for the retention and service of transgender members of the Armed Forces\nH.R. 3219 Senate Appropriations Bill for Department of Defense", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59287, "prefix": "ms", "prefix_display": "MS.", "first_name": "HEATHER", "nickname": null, "middle_name": "ANNE", "last_name": "O'BEIRNE KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "S. 1006/H.R. 2282 Equality Act\nH.R. 620 ADA Education and Reform Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51616, "prefix": null, "prefix_display": null, "first_name": "BEN", "nickname": null, "middle_name": null, "last_name": "VONACHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51140, "prefix": null, "prefix_display": null, "first_name": "LEO", "nickname": null, "middle_name": null, "last_name": "RENNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "S. 1276 Cannabidiol Research Expansion Act\nS. 1519/H.R. 2810 FY2018 Defense Authorization Act\nS. 1557/H.R. 2998 FY2018 Military Construction/VA Appropriations\nS. 1803 Marijuana Effective Drug Studies (MEDS) Act\nS. 1973 BASIC Research Act - peer review regulation\nH.R. 3391 Medical Marijuana Research Act\nFY2018 Department of Defense Appropriations Bills - funding for psychological research\nFY2018 Commerce/Justice/Science Appropriations Bills - funding for psychological research\nFY2018 Department of Veterans Affairs Appropriations Bills - funding for psychological research", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59287, "prefix": "ms", "prefix_display": "MS.", "first_name": "HEATHER", "nickname": null, "middle_name": "ANNE", "last_name": "O'BEIRNE KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21064, "prefix": null, "prefix_display": null, "first_name": "GEOFFREY", "nickname": null, "middle_name": null, "last_name": "MUMFORD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41226, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "KOBOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "S. 329/H.R. 901 MERCY Act\nDraft legislation on pregnant incarcerated women\n\nDraft House Legislation: Pregnancy in Correctional Institutions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4571, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICAH", "nickname": null, "middle_name": "ANDREW", "last_name": "HASKELL-HOEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66884, "prefix": null, "prefix_display": null, "first_name": "AMALIA", "nickname": null, "middle_name": null, "last_name": "CORBY-EDWARDS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "S. 1112 Maternal Health Accountability Act\nS. 1519/H.R. 2810 Defense Authorization Bills\nS. 1527 Protecting Access to Care for Veterans Act\nS. 1557/H.R. 2998 FY2018 Military Construction/VA Appropriations: Veterans Mental Health\nS. 1827/H.R. 3921 KIDS Act\nS. 1881 Veterans Choice Legislation\nH.R. 1 Tax Cuts and Jobs Act\nH.R. 918 Veterans Urgent Access to Mental Healthcare\nH.R. 3728 Educating Medical Professionals and Optimizing Workforce Efficiency and Readiness (EMPOWER) Act of 2017\nH.R. 3922 CHAMPIONING Healthy Kids Act\nH.R. 5475 Health Equity and Accountability Act\nFY2018 Defense Appropriations\nChildrens Health Insurance Program (CHIP) reauthorization\nVeterans Defense Equal Access to Mental Healthcare Act\nBipartisan Health Care Stabilization Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59287, "prefix": "ms", "prefix_display": "MS.", "first_name": "HEATHER", "nickname": null, "middle_name": "ANNE", "last_name": "O'BEIRNE KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66884, "prefix": null, "prefix_display": null, "first_name": "AMALIA", "nickname": null, "middle_name": null, "last_name": "CORBY-EDWARDS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34313, "prefix": "ms", "prefix_display": "MS.", "first_name": "KAREN", "nickname": null, "middle_name": "ALISON", "last_name": "STUDWELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51616, "prefix": null, "prefix_display": null, "first_name": "BEN", "nickname": null, "middle_name": null, "last_name": "VONACHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63307, "prefix": null, "prefix_display": null, "first_name": "SERENA", "nickname": null, "middle_name": null, "last_name": "DAVILA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63940, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61857, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "BARSTOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4571, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICAH", "nickname": null, "middle_name": "ANDREW", "last_name": "HASKELL-HOEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51140, "prefix": null, "prefix_display": null, "first_name": "LEO", "nickname": null, "middle_name": null, "last_name": "RENNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21064, "prefix": null, "prefix_display": null, "first_name": "GEOFFREY", "nickname": null, "middle_name": null, "last_name": "MUMFORD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43351, "prefix": "ms", "prefix_display": "MS.", "first_name": "ELLEN", "nickname": null, "middle_name": "GREENBERG", "last_name": "GARRISON", "suffix": "phd", "suffix_display": "PHD"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "S. 114 VA Choice and Quality Employment Act\nS. 946/H.R. 2147 Veterans Treatment Court Improvement Act\nS. 1527 Protecting Access to Care for Veterans Act\nS. 1881 Prioritizing Veterans Access to Mental Health Care Act\nH.R. 918 Veteran Urgent Access to Mental Healthcare Act\nFY2018 VA Appropriations bill - funding for mental health services and medical research and infrastructure accounts\nFY2018 House Military Construction/VA Appropriations Bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59287, "prefix": "ms", "prefix_display": "MS.", "first_name": "HEATHER", "nickname": null, "middle_name": "ANNE", "last_name": "O'BEIRNE KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "S. 448/H.R. 1173 Medicare Mental Health Access Act\nS. 1905/H.R. 3931 Excellence in Mental Health and Addiction Treatment Expansion Act\nS. 1169/H.R. 2687 Medicaid Coverage for Addiction Recovery Expansion Act\nS. 1732/H.R. 3331 To amend title XI of the Social Security Act to promote testing of incentive payments for behavioral health providers for adoption and use of certified electronic health record technology\nH.R. 2337: To amend title XIX of the Social Security Act to provide for a State Medicaid option to enhance administrative matching funds to support statewide behavioral health access program activities for children under 21 years of age, and for other purposes\nH.R. 2509 Medicare Mental Health Inpatient Inequity Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61857, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "BARSTOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H. Con. Res. 71 FY2018 for Budget \nFY2018 Appropriations for DoD - funding for psychological research and mental health programs\nFY2018 Appropriations for VA - funding for psychological research and mental health programs\nFY2018 LHHS - funding for opioid abuse research\nFY2018 FDA/CDC Appropriations re. tobacco\nS. 1771/H.R. 3358 FY2018 Appropriations for Labor-Health & Human Services-Education - funding for health and education programs, and psychological research\nS. 2254/H.R. 1 Tax Cuts and Jobs Act\nH.R. 1370 Further Continuing Appropriations for FY2018 (through Jan. 19)\nH.R. 3354 Interior Appropriations Act, 2018", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59287, "prefix": "ms", "prefix_display": "MS.", "first_name": "HEATHER", "nickname": null, "middle_name": "ANNE", "last_name": "O'BEIRNE KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41226, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "KOBOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21064, "prefix": null, "prefix_display": null, "first_name": "GEOFFREY", "nickname": null, "middle_name": null, "last_name": "MUMFORD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34313, "prefix": "ms", "prefix_display": "MS.", "first_name": "KAREN", "nickname": null, "middle_name": "ALISON", "last_name": "STUDWELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60105, "prefix": "ms", "prefix_display": "MS.", "first_name": "ALEXANDRA", "nickname": null, "middle_name": "MARGAUX", "last_name": "GINSBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51140, "prefix": null, "prefix_display": null, "first_name": "LEO", "nickname": null, "middle_name": null, "last_name": "RENNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66884, "prefix": null, "prefix_display": null, "first_name": "AMALIA", "nickname": null, "middle_name": null, "last_name": "CORBY-EDWARDS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63940, "prefix": null, "prefix_display": null, "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "FISHER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 1575, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "SMULSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4571, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICAH", "nickname": null, "middle_name": "ANDREW", "last_name": "HASKELL-HOEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51616, "prefix": null, "prefix_display": null, "first_name": "BEN", "nickname": null, "middle_name": null, "last_name": "VONACHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63307, "prefix": null, "prefix_display": null, "first_name": "SERENA", "nickname": null, "middle_name": null, "last_name": "DAVILA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FAM", "general_issue_code_display": "Family issues/Abortion/Adoption", "description": "H.R. 2792 Control Unlawful Fugitive Felons Act\nH.R. 2824 Increasing Opportunity through Evidence-Based Home Visiting Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66884, "prefix": null, "prefix_display": null, "first_name": "AMALIA", "nickname": null, "middle_name": null, "last_name": "CORBY-EDWARDS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TOB", "general_issue_code_display": "Tobacco", "description": "FY2018 House Agriculture Appropriations Bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21064, "prefix": null, "prefix_display": null, "first_name": "GEOFFREY", "nickname": null, "middle_name": null, "last_name": "MUMFORD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S. 1615/H.R. 3440 The Dream Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 63307, "prefix": null, "prefix_display": null, "first_name": "SERENA", "nickname": null, "middle_name": null, "last_name": "DAVILA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51616, "prefix": null, "prefix_display": null, "first_name": "BEN", "nickname": null, "middle_name": null, "last_name": "VONACHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Public Service Loan Forgiveness\nH.R. 4223 Protecting Our Students by Terminating Graduate Rates that Add to Debt Act (POST GRAD Act)\nH.R. 4508 PROSPER Act - Higher Education Reauthorization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 1575, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "SMULSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60105, "prefix": "ms", "prefix_display": "MS.", "first_name": "ALEXANDRA", "nickname": null, "middle_name": "MARGAUX", "last_name": "GINSBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51616, "prefix": null, "prefix_display": null, "first_name": "BEN", "nickname": null, "middle_name": null, "last_name": "VONACHEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30849 DC DC US US   0 0        

Links from other tables

  • 12 rows from filing_uuid in lobbying_activities
  • 14 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.627ms