Intermediate tables have suffixes that aren't informative: no suffix, _intermediate, _final, _final1, _final2, _final_pivoted
Proposed naming convention:
_acs for the table containing concatenated, downloaded ACS variables for a particular category (currently has no suffix)
_nta_sums for the table of nta-level aggregated estimates and MOEs (currently _intermediate)
_nta_combos for the table of nta-level aggregated estimates and MOEs, which includes new variables that are combinations of other variables -- either sums or proportions -- and checks for controlled variables (currently _final)
_nta_meds for the table of nta-level aggregated estimates and MOEs, which includes interpolated medians and special variables (currently _final1)
_nta_recalc for tables of nta-level aggregated estimates and MOEs, which have been recalculated in case the denominators have changed in the previous two tables (currently _final2)
_nta_pivoted for tables that have complete, nta-level aggregated estimates and MOEs, where the columns refer to the geography type/ID, which table and variable is represented, then the appropriate estimate and MOE for that variable (Currently _final_pivoted, which looks like this is a pivot of _final, rather than of _final2)
Intermediate tables have suffixes that aren't informative: no suffix, _intermediate, _final, _final1, _final2, _final_pivoted
Proposed naming convention:
_acs for the table containing concatenated, downloaded ACS variables for a particular category (currently has no suffix)
_nta_sums for the table of nta-level aggregated estimates and MOEs (currently _intermediate)
_nta_combos for the table of nta-level aggregated estimates and MOEs, which includes new variables that are combinations of other variables -- either sums or proportions -- and checks for controlled variables (currently _final)
_nta_meds for the table of nta-level aggregated estimates and MOEs, which includes interpolated medians and special variables (currently _final1)
_nta_recalc for tables of nta-level aggregated estimates and MOEs, which have been recalculated in case the denominators have changed in the previous two tables (currently _final2)
_nta_pivoted for tables that have complete, nta-level aggregated estimates and MOEs, where the columns refer to the geography type/ID, which table and variable is represented, then the appropriate estimate and MOE for that variable (Currently _final_pivoted, which looks like this is a pivot of _final, rather than of _final2)