datausa/datausa-tesseract

datausa-tesseract's Issues

remove outdated cubes

create etl environment in tesseract VM

cube and measure annotation tweaks (propagate changes as needed in ETL scripts)

Please make these changes in saguaro:

acs_yg_total_population_1

• subtopic: "Microdata"

acs_yg_total_population_5

• subtopic: "Microdata"

bea_use

• subtopic: "Industry Flows"

county_business_patterns

• subtopic: "Business Patterns"

"Total Annual Payroll Noise Flag" measure

• hide_in_ui: "true"

"Data Suppression Flag" measure

• hide_in_ui: "true"

"Total Mid-March Employees Noise Flag" measure

• hide_in_ui: "true"

acs_ygsi_gender_by_industry_c_1

• subtopic: "Employment"

acs_ygsi_gender_by_industry_c_5

• subtopic: "Employment"

acs_ygsi_gender_by_industry_1

• subtopic: "Employment"
• hide_in_ui: "true"

onet_by_pums

• topic: "Economy"
• subtopic: "Skills"

"IM Value" measure

• hide_in_ui: "true"

"LV Value" measure

• hide_in_ui: "true"

onet_by_cip

• topic: "Education"
• subtopic: "Skills"

"IM Value" measure

• hide_in_ui: "true"

"LV Value" measure

• hide_in_ui: "true"

acs_ygso_gender_by_occupation_c_1

• subtopic: "Employment"

acs_ygso_gender_by_occupation_c_5

• subtopic: "Employment"

acs_ygso_gender_by_occupation_1

• subtopic: "Employment"
• hide_in_ui: "true"

dartmouth_reimbursements

• subtopic: "Healthcare Costs"

acs_yghsa_health_coverage_type_by_gender_by_age_5

• subtopic: "Healthcare Coverage"

acs_yghsa_health_coverage_type_by_gender_by_age_1

• subtopic: "Healthcare Coverage"
• table_id: "B27001,B27002,B27003,B27004,B27005,B27006,B27007,B27008,B27009"

acs_yghsa_health_coverage_status_by_gender_by_age_5

• subtopic: "Healthcare Coverage"

acs_yghsa_health_coverage_status_by_gender_by_age_1

• subtopic: "Healthcare Coverage"

health_private_insurance_spending_per_enrolle

• subtopic: "Private Insurance Spending"

health_total_private_health_insurance_spending

• subtopic: "Private Insurance Spending"

county_health_ranking

• subtopic: "Risks"

acs_ygh_renters_by_income_percentage_c_1

• hide_in_ui: "true"

bls_ces

• topic: "Economy"
• subtopic: "Employment"

bls_growth_industry

• topic: "Economy"
• subtopic: "Industry Projections"

bls_growth_occupation

• topic: "Economy"
• subtopic: "Occupation Projections"

---

These next few effect a large number of health related cubes (the client provided data separated by topic), so instead of hunting down the specific cube names I'm hoping that it will be easy enough to just "find and replace" these renames.

3 assorted health cubes

• rename subtopic "Social and Behavioral Determinants of Health" to "Social Needs"

5 assorted health cubes

• rename subtopic "Health Outcomes" to "Behavioral Conditions"

6 assorted health cubes

• rename subtopic "Health Care Spending>Medicaid" to "Medicaid Spending"

6 assorted health cubes

• rename subtopic "Health Care Spending>Medicare" to "Medicare Spending"

10 assorted health cubes

• rename subtopic "Health Care Spending" to "Healthcare Spending"

53 assorted health cubes

• rename topic "Health & Safety" to "Health"

update/fix ACS PUMS source annotation link

ingest ACS PUMS into yoderite

Rename measure in tesseract and CMS for CPI

datausa-tesseract/frags/cpi/cpi_index.xml

Line 26 in 3fcab42

<Measure name="Consumer Price Inde" column="unadjusted_percent_change" aggregator="avg" visible="true"/>