Dashboard Tables - stlrda/211Dashboard-Workflows GitHub Wiki
RDA 211Dashboard Database (PostgreSQL)
This wiki describes the tables/views (as of 6/26/2020) that the Tableau developer should use when building out the project's dashboard. All of the core ("cre") views ("vu") are filtered to only include regions/counties found in the lkup_areas_of_intr_geo_scope table.
cre_stl_rgnl_fndng_clnd→ funding datacre_vu_bls_unemployment_data→ unemployment data (from BLS) by countycre_vu_bls_unemployment_map_2_zip→ unemployment data (from BLS) by zip-codecre_vu_census_data_by_county_curr→ current census data by countycre_vu_census_tract_2_zip_curr→ current census data by zip-codecre_vu_covid_county→ COVID-19 data by countycre_vu_covid_zip→ COVID-19 data by zip (currently only for St. Louis City and St. Louis county)cre_vu_unemployment_clms→ unemployment claims data by countycre_vu_unemployment_clms_map_2_zip→ unemployment claims data by zip-code
Additionally, there may be use for the lkup_vu_zip_county_trans_gtwy_rgnl view. This view shows which county each zip-code is in. The mapping of zip-code to county is an estimate and was done by assigning the zip-code to whichever county the majority of its residential addresses belonged. For example, if a zip-code had 90% of its residential addresses in County A and 10% in County B, the zip-code was assigned to County A.
United Way 2-1-1 Counts (MySQL)
In addition to the data in the 211Dashboard database, the dashboard developer will also want to incorporate data from United Way's 2-1-1 MySQL database. Fortunately, Tableau allows for multiple data sources, so this shouldn't be a problem. The 2-1-1 Counts data schema is shown below.
