Iowa Medicaid Payments & Recipients by Month and County

data.iowa.gov | Last Updated 28 Mar 2018

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.

Tags: medicaid, health care, public assistance

This dataset has the following 16 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Report Datereport_as_of_datecalendar_dateLast date in month for which payments occurred
CountycountytextCounty for which the Medicaid recipients reside
County FIPcounty_fipnumberA five-digit code for counties based on Federal Information Processing Standards Publication - FIPS 55-DC3 (December 1994) , Guideline: Codes for Named Populated Places, Primary County Divisions, and Other Locational Entities of the United States, Puerto Rico, and the Outlying Areas (withdrawn February 8, 2005)
GNIS Feature IDgnis_feature_idnumberThe official federal identifier given to physical and cultural geographic features in the United States and associated areas based on ANSI INCITS 446-2008, Identifying Attributes for Named Physical and Cultural Geographic Features (Except Roads and Highways) of the United States, Its Territories, Outlying Areas, and Freely Associated Areas, and the Waters of the Same to the Limit of the Twelve-Mile Statutory Zone.
Medically Needy Eligiblemedneedy_elignumberNumber of Medically Needy Eligible Recipients
Medically Needy Servedmedneedy_recipnumberNumber of Medically Needy Recipients Served
Medically Needy Reimbursedmedneedy_pmtnumberTotal claims reimbursed for the Medically Needy recipients
Non-Medically Needy Eligibleothertxix_elignumberNumber of non-Medically Needy Eligible Medicaid recipients
Non-Medically Needy Servedothertxix_recipnumberNumber of non-Medically Needy Medicaid recipients served
Non-Medically Needy Reimbursedothertxix_pmtnumberTotal claims reimbursed for the non-Medically Needy Medicaid recipients
Medicaid Eligibletotaltxix_elignumberNumber of total eligible Medicaid recipients
Medicaid Servedtotaltxix_recipnumberNumber of total Medicaid recipients served
Medicaid Reimbursedtotaltxix_pmtnumberTotal claims reimbursed for Medicaid recipients
Primary Latitude (Decimal)prim_lat_decnumberPrimary latitude in decimal degrees used to create the primary point for the county as provided by U.S. Geological Survey, 19810501, U.S. Geographic Names Information System (GNIS): U.S. Geological Survey, Reston, VA.
Primary Longitude (Decimal)prim_long_decnumberPrimary longitude in decimal degrees used to create the primary point for the county as provided by U.S. Geological Survey, 19810501, U.S. Geographic Names Information System (GNIS): U.S. Geological Survey, Reston, VA.
County Primary Locationcounty_primary_locationlocationPrimary latitude and longitude in decimal degrees that create the primary point for the county as provided by U.S. Geological Survey, 19810501, U.S. Geographic Names Information System (GNIS): U.S. Geological Survey, Reston, VA. The primary point is generally at or near the geographic center of the county.