About this Dataset

Iowa Medicaid Payments & Recipients By Month And County

This dataset contains aggregate Medicaid payments, and counts for eligible recipients and recipients served by month and county in Iowa, starting with month ending 1/31/2011.

Eligibility groups are a category of people who meet certain common eligibility requirements. Some Medicaid eligibility groups cover additional services, such as nursing facility care and care received in the home. Others have higher income and resource limits, charge a premium, only pay the Medicare premium or cover only expenses also paid by Medicare, or require the recipient to pay a specific dollar amount of their medical expenses. Eligible Medicaid recipients may be considered medically needy if their medical costs are so high that they use up most of their income. Those considered medically needy are responsible for paying some of their medical expenses. This is called meeting a spend down. Then Medicaid would start to pay for the rest. Think of the spend down like a deductible that people pay as part of a private insurance plan.
Organization: State of Iowa
Last updated: 2023-01-20T00:02:33.932828
Tags: health-care, medicaid, public-assistance

Tables

Table 1

@usgov.state_of_iowa_iowa_medicaid_payments_recipients_by_mon_4dcb8c82.table_1

802.44 kB
17,200 rows
16 columns

CREATE TABLE table_1 (
  "record_id" BIGINT,
  "report_date" TIMESTAMP,
  "county" VARCHAR,
  "county_fip" DOUBLE,
  "medically_needy_eligible" BIGINT,
  "medically_needy_served" BIGINT,
  "medically_needy_reimbursed" DOUBLE,
  "non_medically_needy_eligible" BIGINT,
  "non_medically_needy_served" BIGINT,
  "non_medically_needy_reimbursed" DOUBLE,
  "medicaid_eligible" BIGINT,
  "medicaid_served" BIGINT,
  "medicaid_reimbursed" DOUBLE,
  "primary_latitude_decimal" DOUBLE  -- Primary Latitude (Decimal),
  "primary_longitude_decimal" DOUBLE  -- Primary Longitude (Decimal),
  "county_primary_location" VARCHAR
);