home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ced3fe4e-009f-466a-ab92-e6f88275ed99

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
ced3fe4e-009f-466a-ab92-e6f88275ed99 YA 87791 REGENCE BLUECROSS BLUESHIELD OF UTAH 173634 REGENCE BLUECROSS BLUESHIELD OF UTAH 2003 year_end 2004-02-17T00:00:00-05:00   1 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ced3fe4e-009f-466a-ab92-e6f88275ed99/", "filing_uuid": "ced3fe4e-009f-466a-ab92-e6f88275ed99", "filing_type": "YA", "filing_type_display": "Year-End Amendment", "filing_year": 2003, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ced3fe4e-009f-466a-ab92-e6f88275ed99/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2004-02-17T00:00:00-05: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": 87791, "url": "https://lda.senate.gov/api/v1/registrants/87791/", "house_registrant_id": 36624, "name": "REGENCE BLUECROSS BLUESHIELD OF UTAH", "description": null, "address_1": "2890 E. COTTONWOOD PARKWAY", "address_2": null, "address_3": null, "address_4": null, "city": "SALT LAKE CITY", "state": "UT", "state_display": "Utah", "zip": "84121", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "", "contact_telephone": "", "dt_updated": "2022-01-13T14:54:32.324909-05:00"}, "client": {"id": 173634, "url": "https://lda.senate.gov/api/v1/clients/173634/", "client_id": 12, "name": "REGENCE BLUECROSS BLUESHIELD OF UTAH", "general_description": null, "client_government_entity": null, "client_self_select": null, "state": "UT", "state_display": "Utah", "country": "US", "country_display": "United States of America", "ppb_state": "UT", "ppb_state_display": "Utah", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-11-01"}, "lobbying_activities": [{"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "S. 545/H.R. 660, Small Business Health Fairness Act of 2003, entire bill.\r\n\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 27070, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "CANNADAY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "S. 545/H.R. 660, Small Business Health Fairness Act of 2003, entire bill.\r\n\r\nH.R. 1, Medicare Prescription Drug and Modernization Act of 2003, Title I -- Medicare Prescription Drug Benefit, Title II \u2013 Medicare Enhanced Fee-For-Service and Medicare Advantage Programs; Medicare Competition, Title III \u2013 Combating Waste, Fraud and Abuse, Title IV \u2013 Rural Health Care Improvements, Section 402 \u2013 Immediate Establishment of Uniform Standardized Amount in Rural and Small Urban Areas, Title V \u2013 Provisions Relating to Part A, Title VI \u2013 Provisions Relating to Part B, Title IX \u2013 Regulatory Reduction and Contracting Reform, Subtitle B- Contracting Reform, Subtitle C \u2013 Education and Outreach, and Title XI \u2013 Access to Affordable Pharmaceuticals.\r\n\r\nS. 1, Prescription Drug and Medicare Improvement Act of 2003, Title I \u2013 Medicare Prescription Drug Benefit, Section 101 \u2013 Medicare Voluntary Prescription Drug Delivery Program, Section 103 \u2013 Medigap, Section 111 \u2013 Medicare Prescription Drug Discount Card and Transitional Assistance for Low-Income Beneficiaries, Title II \u2013 Medicare Advantage, Title IV \u2013 Medicare Fee-For-Service Improvements, Section 421 \u2013 Establishment of Floor on Geographic Adjustments of Payments for Physician Services, Title V \u2013 Medicare Appeals, Regulatory and Contracting Improvements, Section 521 \u2013 Increased Flexibility in Medicare Administration, Section 531 \u2013 Provider Education and Technical Assistance, Section 532 \u2013 Access to and Prompt Responses from Medicare Contractors.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 27070, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "CANNADAY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "H.R. 1, Medicare Prescription Drug and Modernization Act of 2003, Title I -- Medicare Prescription Drug Benefit, Title II \u2013 Medicare Enhanced Fee-For-Service and Medicare Advantage Programs; Medicare Competition, Title III \u2013 Combating Waste, Fraud and Abuse, Title IV \u2013 Rural Health Care Improvements, Section 402 \u2013 Immediate Establishment of Uniform Standardized Amount in Rural and Small Urban Areas, Title V \u2013 Provisions Relating to Part A, Title VI \u2013 Provisions Relating to Part B, Title IX \u2013 Regulatory Reduction and Contracting Reform, Subtitle B- Contracting Reform, Subtitle C \u2013 Education and Outreach, and Title XI \u2013 Access to Affordable Pharmaceuticals.\r\n\r\nS. 1, Prescription Drug and Medicare Improvement Act of 2003, Title I \u2013 Medicare Prescription Drug Benefit, Section 101 \u2013 Medicare Voluntary Prescription Drug Delivery Program, Section 103 \u2013 Medigap, Section 111 \u2013 Medicare Prescription Drug Discount Card and Transitional Assistance for Low-Income Beneficiaries, Title II \u2013 Medicare Advantage, Title IV \u2013 Medicare Fee-For-Service Improvements, Section 421 \u2013 Establishment of Floor on Geographic Adjustments of Payments for Physician Services, Title V \u2013 Medicare Appeals, Regulatory and Contracting Improvements, Section 521 \u2013 Increased Flexibility in Medicare Administration, Section 531 \u2013 Provider Education and Technical Assistance, Section 532 \u2013 Access to and Prompt Responses from Medicare Contractors.\r\n\r\nLabor HHS Appropriations Bills, Medicare Contractor Funding provisions\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 27070, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "CANNADAY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Labor HHS Appropriations Bill, Medicare Contractor Funding provisions.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 27070, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "CANNADAY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "H.R. 1, Medicare Prescription Drug and Modernization Act of 2003, Title I \u2013 Medicare Prescription Drug Benefit, Title XI \u2013 Access to Affordable Pharmaceuticals Act.\r\n\r\nS. 1, Prescription Drug and Medicare Improvement Act of 2003, Title I \u2013 Medicare Prescription Drug Benefit, Section 101 \u2013 Medicare Voluntary Prescription Drug Delivery Program, Section 103 \u2013 Medigap, Section 111 \u2013 Medicare Prescription Drug Discount Card and Transitional Assistance for Low-Income Beneficiaries.\r\n\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 27070, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "CANNADAY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} UT US 36624 UT UT US US     0 2116318   normalized_name_state 0.9

Links from other tables

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