About this Dataset

Long Term Care, And Individual And Small Group Major Medical/Hospital Rate Increases

This dataset provides a historical view of proposed long term care, and individual and small group major medical/hospital rate increases starting in January 2005.
Organization: State of Iowa
Last updated: 2023-01-19T23:56:01.595287
Tags: hospital, individual, long-term-care, major-medical, small-group

Tables

Table 1

@usgov.state_of_iowa_long_term_care_and_individual_and_small__1ad9aa33.table_1

88.55 kB
1,839 rows
11 columns

CREATE TABLE table_1 (
  "company_name" VARCHAR,
  "closedon" VARCHAR,
  "form_numbers" VARCHAR,
  "effective_date" VARCHAR,
  "approved" VARCHAR,
  "approvedyn" VARCHAR,
  "negotiated" DOUBLE  -- Negotiated %,
  "negotiated_28754e" BOOLEAN  -- Negotiated?,
  "type_of_product" VARCHAR,
  "proposed" DOUBLE  -- Proposed %,
  "increase" DOUBLE
);