Medicaid CMS-64 FFCRA Increased FMAP Expenditure
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicaid_cms_64_ffcra_increased_fmap_expenditure
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicaid_cms_64_ffcra_increased_fmap_expenditure
During a public health emergency in the Families First Coronavirus Response Act (FFCRA), a new optional Medicaid eligibility group was added called COVID-19 testing eligibility group. States reported these expenditures under sections 6004 and 6008 through the Medicaid Budget and Expenditure System (MBES) on the Form CMS-64. The data in these reports constitute summary level preliminary expenditure information related to these FFCRA provisions for each state
Notes:
CREATE TABLE table_1 (
"state" VARCHAR,
"total_computable_all_medical_assistance_expenditures" VARCHAR,
"total_federal_share_all_medical_assistance_expenditures" VARCHAR,
"total_federal_share_ffcra_sections_6008_and_6004" VARCHAR,
"total_federal_share_section_6008_expenditures_6_2_perc_eb62877e" VARCHAR -- Total Federal Share Section 6008 Expenditures (6.2 Percentage Point FMAP Increase),
"total_federal_share_section_6004_covid_19_testing_grou_43e2786e" VARCHAR -- Total Federal Share Section 6004: COVID-19 Testing Group MAP + ADM Expenditures (100% Federal Match),
"total_federal_share_section_6004_covid_19_testing_grou_a2ec634a" VARCHAR -- Total Federal Share Section 6004: COVID-19 Testing Group MAP Expenditures (100% Federal Match),
"total_federal_share_section_6004_covid_19_testing_grou_0a2d8bd4" BIGINT -- Total Federal Share Section 6004: COVID-19 Testing Group ADM Expenditures (100% Federal Match),
"quarter_end_date" TIMESTAMP
);Anyone who has the link will be able to view this.