Minor template updates

[awunderground]

• [x] Switch data source for "All" in county Summary/Detail tabs to 1-year for preschool
• [x] Switch data source for "All" in county Summary/Detail tabs to 1-year for college readiness
• [x] Switch data source for "All" in county Summary/Detail tabs to 1-year for digital access
• [x] Switch data source for "All" in county Summary/Detail tabs to 1-year for employment opportunities
• [x] Switch data source for "All" in place Summary/Detail tabs to 1-year for preschool
• [x] Switch data source for "All" in place Summary/Detail tabs to 1-year for college readiness
• [x] Switch data source for "All" in place Summary/Detail tabs to 1-year for digital access
• [x] Switch data source for "All" in place Summary/Detail tabs to 1-year for employment opportunities
• [x] Add 1-year ACS to "More data" for preschool
• [x] Add 1-year ACS to "More data" for college readiness
• [x] Add 1-year ACS to "More data" for digital access
• [x] Add 1-year ACS to "More data" for employment opportunities
• [x] Switch "Quality" to "Data quality" for all tables
• [x] Switch "Metric: Ratio of affordable and available housing units (per 100 households) with low-, very low-, and extremely low-income levels" to "Metric: Ratio of affordable housing units (per 100 households) with low-, very low-, and extremely low-income levels" in the data tables and description page
• [ ] ~Switch "Notes: This metric reports the number of housing units affordable for households with low-incomes (below 80 percent of area median income, or AMI), very low-incomes (below 50 percent of AMI), and extremely low-incomes (below 30 percent of AMI) relative to every 100 households with these income levels." to "Notes: This metric reports the number of housing units affordable for households with low-incomes (below 80 percent of area median income, or AMI), very low-incomes (below 50 percent of AMI), and extremely low-incomes (below 30 percent of AMI) relative to every 100 households with these income levels." in the data tables and description page~
• [ ] ~Update "Limitations: These shares do not reflect the quality of the available and affordable housing units."~

[cdsolari]

Instead of the above for Notes and Limitations, use this for the Notes:

• [x] Switch: "Values above 100 suggest that there are more affordable housing units than households with those income levels. Values below 100 indicate a shortage of affordable housing for households with those income levels. Housing units are counted as affordable for a given income level regardless of whether they are currently occupied by a household at that income level." to:

"Affordability addresses whether sufficient housing units would exist if allocated solely on the basis of cost, regardless of whether they are currently occupied by a household that could afford the unit. Values below 100 suggest that on this basis the affordable stock is insufficient to meet the need. The affordable housing stock includes both vacant and occupied units."

Use this for the Limitations on the Description page:

• [x] Change "These shares do not reflect the quality of the available and affordable housing units. Units counted as available and affordable for households with low or very low incomes may be of poor quality or too small to meet household needs." to:

"This metric does not account for availability of the affordable units. Higher income households may occupy units that are otherwise deemed affordable to lower-income households, rendering these units unavailable. This metric also does not account for the quality of the affordable units, which may be of substandard quality or too small to meet the size of the occupying household."

on 6/15 I found another error that needs correcting with respect to the affordable housing metric for counties:

• [x] In the Source for the More Data tab, reference to the 5-yr ACS should actually be 1-yr ACS

[awunderground]

This is a little messier than I initially thought. Consider the preschool table in the county and place pages for Washington, DC.

• The "Summary" tab for county uses 1-year ACS data

• The "Summary" tab for place uses 1-year ACS data

• The "More Data" tab for county uses 5-year ACS data

• The "More Data" tab for place uses 1-year ACS data AND 5-year ACS data. This is because the "All" row was initially missing for these tabulations and we replaced it with the "Summary" data instead of calculating it with the 5-year data.

• [x] We need to fix the county and place "Summary" table source to use 1-year ACS.

• [x] We need to fix the place "More Data" table source to 1-year + 5-year ACS.