Some tables have field names with dates in them, so to re-run any reports each year = revisit field names / descriptions

OK, some tables ex B25038 have hard-coded field descriptions that change every 2 years. I think the actual column name would stay the same? and it would just be the description would change. Typicially you never have time dimensions like this. It's last 2 years, last 3 years etc. so its good year after year. If you had a report that you relabeled / shortened any names or descriptions, you would have to be careful the following year.

Column Name Label
GEO_ID Geography
NAME Geographic Area Name
B25038_001E Estimate!!Total:
B25038_001EA Annotation of Estimate!!Total:
B25038_001M Margin of Error!!Total:
B25038_001MA Annotation of Margin of Error!!Total:
B25038_002E Estimate!!Total:!!Owner occupied:
B25038_002EA Annotation of Estimate!!Total:!!Owner occupied:
B25038_002M Margin of Error!!Total:!!Owner occupied:
B25038_002MA Annotation of Margin of Error!!Total:!!Owner occupied:
B25038_003E Estimate!!Total:!!Owner occupied:!!Moved in 2019 or later
B25038_003EA Annotation of Estimate!!Total:!!Owner occupied:!!Moved in 2019 or later
B25038_003M Margin of Error!!Total:!!Owner occupied:!!Moved in 2019 or later
B25038_003MA Annotation of Margin of Error!!Total:!!Owner occupied:!!Moved in 2019 or later
B25038_004E Estimate!!Total:!!Owner occupied:!!Moved in 2015 to 2018
B25038_004M Margin of Error!!Total:!!Owner occupied:!!Moved in 2015 to 2018
B25038_004MA Annotation of Margin of Error!!Total:!!Owner occupied:!!Moved in 2015 to 2018
Parents Reply Children
No Data