About this Dataset

Iowa Medicaid Payments & Recipients By Month And Vendor

This dataset shows aggregated Medicaid payments, client participation, recipients, bed hold days, and other days by vendors/health care providers by month in Iowa starting with July 2011. Vendors within this dataset fall into the following categories: Skilled Nursing Facilities, Intermediate Care Facilities, Residential Care Facilities, State Operated - Intermediate Care Facilities for Individuals with Mental Disabilities, Community-Based Intermediate Care Facilities for Individuals with Mental Disabilities, and Nursing Facilities for the Mentally Ill.
Organization: State of Iowa
Last updated: 2023-01-19T23:50:50.864714

Tables

Table 1

@usgov.state_of_iowa_iowa_medicaid_payments_recipients_by_mon_be6512a1.table_1

2.16 MB
100,463 rows
10 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "report_date" TIMESTAMP,
  "provider_type" VARCHAR,
  "vendor_number" BIGINT,
  "vendor_name" VARCHAR,
  "payment" DOUBLE,
  "client_participation" DOUBLE,
  "total_recipients" BIGINT,
  "bed_hold_days" BIGINT,
  "other_days" BIGINT
);