Social Drivers of Health
Database Overview
Data Owner: Data Products
Storage Format: delta
Total Tables: 3
Total Columns: 106
Total Storage Size: ~0.7 GB
This data warehouse contains healthcare data with semantic tables.
Table Summary
Semantic Tables (3 tables)
Semantic tables containing measurable business events and metrics.
Note: Please click on the table link and select the preview tab to see the column level information such as column name, data type and column description.
| Table Name | Primary Key | Columns | Row Count | Size (GB) | Description |
|---|---|---|---|---|---|
sem_ahrf_county_survey | sem_ahrf_county_survey_key | 27 | 27744471 | 0.6905 | The table contains data from county health resources surveys, providing insights into health-related variables across different counties and states. It includes unique identifiers for each record, state and county names, census region information, and survey response values. This data can be used for regional health analysis, understanding trends over time, and evaluating health resource distribution. It is useful for researchers and analysts looking to assess health characteristics and outcomes at a county level. |
sem_ahrf_state_national_survey | sem_ahrf_state_national_survey_key | 15 | 222976 | 0.0051 | The table contains data from the state national survey, including various variables and their associated responses. It can be used for geographic analysis, trend identification, and understanding survey responses over time. Key aspects include state codes, variable names, response values, and the years the data covers, which facilitate detailed analysis of survey results across different states and time periods. |
sem_hpsa_dental | sem_hpsa_dental_key | 64 | 40199 | 0.0027 | The table contains data related to Health Professional Shortage Areas (HPSAs). It includes information such as HPSA IDs, names, designation types, and scores, as well as demographic details like population statistics and poverty levels. This data can be used for analyzing healthcare access, identifying areas in need of healthcare professionals, and assessing the impact of designations on underserved populations. |
Notes
All these semantic tables use delta format for ACID compliance and these tables are created for the AI data explorer.