home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b01d684d-de66-4d96-84ac-56f65dd5e463

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
b01d684d-de66-4d96-84ac-56f65dd5e463 MM 6358 BLUE CROSS AND BLUE SHIELD ASSOCIATION 108760 BLUE CROSS AND BLUE SHIELD ASSOCIATION 2001 mid_year 2001-08-13T00:00:00-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/b01d684d-de66-4d96-84ac-56f65dd5e463/", "filing_uuid": "b01d684d-de66-4d96-84ac-56f65dd5e463", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2001, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/b01d684d-de66-4d96-84ac-56f65dd5e463/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "3360000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2001-08-13T00:00:00-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 6358, "url": "https://lda.senate.gov/api/v1/registrants/6358/", "house_registrant_id": 31576, "name": "BLUE CROSS AND BLUE SHIELD ASSOCIATION", "description": null, "address_1": "1310 G STREET, NW", "address_2": null, "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": "AMANDA SCHWARTZ", "contact_telephone": "+1 202-626-4797", "dt_updated": "2026-01-09T12:03:34.477206-05:00"}, "client": {"id": 108760, "url": "https://lda.senate.gov/api/v1/clients/108760/", "client_id": 12, "name": "BLUE CROSS AND BLUE SHIELD 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-02"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Appropriations, Medicare Contractor Funding (no bill introduced)", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "\"Antitrust, Physician Collective Bargaining\", no bill", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "\"Uninsured\" (no bill)\r\n\"(e-health)\", Delivery of health through electronic means (no bill)\r\n\"Mental Health\", Costs of mental health parity benefits (no bill)\r\n\"Medical Privacy\", HHS Final Rule: 45 CFR Parts 160 and 164, HIPAA\r\n\"AHPs/MEWAs\", H.R.1774 (Fletcher)\r\n\"Administrative Simplification\", H.R.1975 (Shadegg), S.836 (Craig)\r\n\"PBOR\", S.1052 entire bill, H.R.526 entire bill(Patients' Bill of Rights)\r\n\"MSAs\", S.284 (McCain)(Bipartisan Patient Pretection Act of 2001 - Part II)\r\n\"Dept. of Labor Rule - Claims Procedures Under ERISA\", extension of compliance date\r\n\"Application of Cost Accounting Standards to FEHBP contracts\"\r\n\"Government-Wide Service Benefit Plan: benefits changes for 2002", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "\"Medicare Reform/Outpatient Prescription Drugs\", S.1135 (Graham) entire bill\r\n\"Medicare+Choice Funding\", no bill\r\n\"Medicare Contractors' Computer Systems Security\", no bill", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "\"Tax Credits to Purchase Health Insurance\", S.590 (Jeffords) entire bill; S.683 (Santorum)\r\n\"Tax Credits for Small Businesses to Purchase Health Insurance\", (Durbin, no bill introduced)", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "\"campaign Finance\", H.R.380 (Shays) Bipartisan Campaign Reform Act of 2001", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "\"Access to Pharmaceuticals/Generics\", H.R.1862 (Brown), S.812 (McCain/Schumer)\"Gretaer Access to Affordable Pharmaceuticals Act of 2001\"", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5554, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "BERRY", "last_name": "TRIMBLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 9172, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12100, "prefix": null, "prefix_display": null, "first_name": "JUSTINE", "nickname": null, "middle_name": null, "last_name": "HANDELMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12420, "prefix": null, "prefix_display": null, "first_name": "KRIS", "nickname": null, "middle_name": null, "last_name": "HALTMEYER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15226, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15691, "prefix": null, "prefix_display": null, "first_name": "CAROLYN", "nickname": null, "middle_name": null, "last_name": "HICKS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18193, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CERISANO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19152, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "LAPIERRE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 19242, "prefix": null, "prefix_display": null, "first_name": "BILL", "nickname": null, "middle_name": null, "last_name": "HEAD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 21168, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22369, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "MUSKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22735, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "ERICKSEN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 23640, "prefix": null, "prefix_display": null, "first_name": "ALISSA", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 24460, "prefix": null, "prefix_display": null, "first_name": "BRENDA", "nickname": null, "middle_name": "LARSON", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30271, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SEROTA", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34598, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "NELL", "last_name": "LEHNHARD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37074, "prefix": null, "prefix_display": null, "first_name": "JOEL", "nickname": null, "middle_name": null, "last_name": "SLACKMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 48436, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINA", "nickname": null, "middle_name": null, "last_name": "NYQUIST", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 8, "name": "Congressional Budget Office (CBO)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31576 DC DC US US   0 0           3360000.0

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 18 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.331ms · Privacy