For each of the releases I've had to clean up the census_table_metadata with these UPDATEs:
update acs2011_5yr.census_table_metadata set table_title=initcap(table_title);
update acs2011_5yr.census_table_metadata set table_title=replace(table_title, 'Ct, Me, Ma, Mi, Mn, Nh, Nj, Ny, Pa, Ri, Vt, Wi', 'CT, ME, MA, MI, MN, NH, NJ, NY, PA, RI, VT, WI') WHERE table_id='B08009';
update acs2011_5yr.census_table_metadata set table_title=replace(table_title, 'Ssi', 'SSI') WHERE table_title LIKE '%Ssi%';
For each of the releases I've had to clean up the
census_table_metadatawith theseUPDATEs:update acs2011_5yr.census_table_metadata set table_title=initcap(table_title);update acs2011_5yr.census_table_metadata set table_title=replace(table_title, 'Ct, Me, Ma, Mi, Mn, Nh, Nj, Ny, Pa, Ri, Vt, Wi', 'CT, ME, MA, MI, MN, NH, NJ, NY, PA, RI, VT, WI') WHERE table_id='B08009';update acs2011_5yr.census_table_metadata set table_title=replace(table_title, 'Ssi', 'SSI') WHERE table_title LIKE '%Ssi%';