This dataset can be accessed in the following ways
SQL Query copied to clipboard
SELECT covid19_usa_health_insurance_coverage.country_name AS country_name, covid19_usa_health_insurance_coverage.location AS location, covid19_usa_health_insurance_coverage.medical_expansion_decision_status AS medical_expansion_decision_status, covid19_usa_health_insurance_coverage.share_employer_health_insurance_coverage AS share_employer_health_insurance_coverage, covid19_usa_health_insurance_coverage.share_medicaid_health_insurance_coverage AS share_medicaid_health_insurance_coverage, covid19_usa_health_insurance_coverage.share_medicare_health_insurance_coverage AS share_medicare_health_insurance_coverage, covid19_usa_health_insurance_coverage.share_military_health_insurance_coverage AS share_military_health_insurance_coverage, covid19_usa_health_insurance_coverage.share_non_group_health_insurance_coverage AS share_non_group_health_insurance_coverage, covid19_usa_health_insurance_coverage.share_uninsured_health_insurance_coverage AS share_uninsured_health_insurance_coverage, covid19_usa_health_insurance_coverage.uninsured_number AS uninsured_number FROM covid19_usa_health_insurance_coverage
https://dataport.open.denodo.com/server/covid_19_data/rws_covid19_cases_detailed_country_level_information/views/covid19_usa_health_insurance_coverage?%24count=25
Information from the Kaiser Family Foundation about the status of medicaid expansion decision, health insurance coverage and the number of uninsured by state in the United States.
| location | medical_expansion_decision_status | share_employer_health_insurance_coverage | share_non_group_health_insurance_coverage | share_medicaid_health_insurance_coverage | share_medicare_health_insurance_coverage | share_military_health_insurance_coverage | share_uninsured_health_insurance_coverage | uninsured_number | country_name | links |
|---|---|---|---|---|---|---|---|---|---|---|
| United States | Adopted-37 states (incl. DC); Not Adopted-14 states | 0.493878 | 0.061575 | 0.203846 | 0.137638 | 0.01432 | 0.088744 | 28264700 | United States of America | |
| Alabama | Not Adopted | 0.469639 | 0.05416 | 0.195321 | 0.158831 | 0.020334 | 0.101714 | 483400 | United States of America | |
| Alaska | Adopted | 0.481289 | 0.036663 | 0.213177 | 0.09428 | 0.054222 | 0.120369 | 85400 | United States of America | |
| Arizona | Adopted | 0.444624 | 0.054478 | 0.223905 | 0.155921 | 0.014926 | 0.106147 | 743500 | United States of America | |
| Arkansas | Adopted | 0.41875 | 0.055587 | 0.272687 | 0.156044 | 0.014092 | 0.082839 | 242000 | United States of America | |
| California | Adopted | 0.473513 | 0.072321 | 0.263108 | 0.109437 | 0.010025 | 0.071597 | 2774100 | United States of America | |
| Colorado | Adopted | 0.521138 | 0.071739 | 0.184908 | 0.12462 | 0.021058 | 0.076538 | 425200 | United States of America | |
| Connecticut | Adopted | 0.539067 | 0.054411 | 0.206315 | 0.139429 | 0.007382 | 0.053396 | 185100 | United States of America | |
| Delaware | Adopted | 0.499181 | 0.046987 | 0.213844 | 0.170235 | 0.012211 | 0.057541 | 54000 | United States of America | |
| District of Columbia | Adopted | 0.52949 | 0.070671 | 0.276694 | 0.083288 | 0.008133 | 0.031723 | 21200 | United States of America | |
| Florida | Not Adopted | 0.400105 | 0.096502 | 0.180374 | 0.17389 | 0.017602 | 0.131528 | 2741500 | United States of America | |
| Georgia | Not Adopted | 0.485606 | 0.056954 | 0.174446 | 0.12208 | 0.023168 | 0.137747 | 1406800 | United States of America | |
| Hawaii | Adopted | 0.546016 | 0.045881 | 0.174571 | 0.146854 | 0.04816 | 0.038517 | 52200 | United States of America | |
| Idaho | Adopted | 0.47093 | 0.086793 | 0.165503 | 0.145958 | 0.019326 | 0.11149 | 191700 | United States of America | |
| Illinois | Adopted | 0.542221 | 0.056267 | 0.18986 | 0.134853 | 0.006235 | 0.070565 | 877700 | United States of America | |
| Indiana | Adopted | 0.538545 | 0.04669 | 0.176247 | 0.145585 | 0.008269 | 0.084664 | 549200 | United States of America | |
| Iowa | Adopted | 0.543551 | 0.054852 | 0.193881 | 0.14967 | 0.008617 | 0.049429 | 151100 | United States of America | |
| Kansas | Not Adopted | 0.546663 | 0.061609 | 0.140833 | 0.140903 | 0.022788 | 0.087204 | 245500 | United States of America | |
| Kentucky | Adopted | 0.469138 | 0.042121 | 0.264665 | 0.153286 | 0.015049 | 0.055742 | 240800 | United States of America | |
| Louisiana | Adopted | 0.424444 | 0.053352 | 0.292851 | 0.134502 | 0.015482 | 0.079368 | 358700 | United States of America | |
| Maine | Adopted | 0.484482 | 0.063896 | 0.184382 | 0.172266 | 0.016477 | 0.078497 | 102000 | United States of America | |
| Maryland | Adopted | 0.55642 | 0.053524 | 0.185045 | 0.126533 | 0.018836 | 0.059643 | 350200 | United States of America | |
| Massachusetts | Adopted | 0.55258 | 0.056341 | 0.232192 | 0.126462 | 0.005214 | 0.02721 | 181200 | United States of America | |
| Michigan | Adopted | 0.509564 | 0.051755 | 0.224316 | 0.154645 | 0.005832 | 0.053887 | 526500 | United States of America | |
| Minnesota | Adopted | 0.573955 | 0.055442 | 0.179237 | 0.140896 | 0.006986 | 0.043484 | 238700 | United States of America |