Baselight

Medicaid CY2017 StateOfMichigan 20181106

City of Ferndale, Michigan

@usgov.city_of_ferndale_michigan_medicaid_cy2017_stateofmichi_70b81a3c

Loading...
Loading...

About this Dataset

Medicaid CY2017 StateOfMichigan 20181106

This dataset contains Medicaid data from patients under 18 years of age for the state of Michigan in 2017. This dataset contains percentage of visits to the Emergency Room, Hospital, and Urgent Care, noting Asthma and Diabetes patients. Medicaid data was provided by the Michigan Department of Health and Human Services (MDHHS) to Data Driven Detroit in 2018. Data Driven Detroit aggregated the dataset for a statewide analysis. Null values represent no Medicaid data or suppressed numbers (smaller than 6) to protect the information of individuals.

Click here for metadata (descriptions of the fields).
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T06:57:06.278990
Tags: health, statewide

Tables

Table 1

@usgov.city_of_ferndale_michigan_medicaid_cy2017_stateofmichi_70b81a3c.table_1
  • 15.42 KB
  • 1 row
  • 22 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "state" VARCHAR,
  "stateid" BIGINT,
  "under18_tot" BIGINT,
  "under5_tot" BIGINT,
  "under5_er" BIGINT,
  "under5_hosp" BIGINT,
  "fiveplus_tot" BIGINT,
  "fiveplus_er" BIGINT,
  "tot_er_visits" BIGINT,
  "tot_hosp_visits" BIGINT,
  "asthmact" BIGINT,
  "diabetes1ct" BIGINT,
  "diabetes2ct" BIGINT,
  "diabetesotherct" BIGINT,
  "geoid" BIGINT,
  "pctundr5er" DOUBLE,
  "pctovr5er" DOUBLE,
  "pctasthma" DOUBLE,
  "pctdiabetes" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);

Share link

Anyone who has the link will be able to view this.