Conferir e substituir suspeitos de erro ou duplicidade na Wikidata about city-codes HOT 1 CLOSED

UPDATE t SET "wdId"='Q22050101' WHERE state='BA' AND "lexLabel"='alagoinhas';
UPDATE t SET "wdId"='Q22063205' WHERE state='BA' AND "lexLabel"='alcobaca';
UPDATE t SET "wdId"='Q22063195' WHERE state='BA' AND "lexLabel"='antas';
UPDATE t SET "wdId"='Q22063188' WHERE state='BA' AND "lexLabel"='araci';
UPDATE t SET "wdId"='Q1649466' WHERE state='BA' AND "lexLabel"='rio.contas';
UPDATE t SET "wdId"='Q22062867' WHERE state='BA' AND "lexLabel"='tanhacu';
UPDATE t SET "wdId"='Q22062864' WHERE state='BA' AND "lexLabel"='taperoa';
UPDATE t SET "wdId"='Q22062863' WHERE state='BA' AND "lexLabel"='tapiramuta';
UPDATE t SET "wdId"='Q22062859' WHERE state='BA' AND "lexLabel"='teodoro.sampaio';
UPDATE t SET "wdId"='Q22062856' WHERE state='BA' AND "lexLabel"='terra.nova';
UPDATE t SET "wdId"='Q22060578' WHERE state='BA' AND "lexLabel"='tremedal';
UPDATE t SET "wdId"='Q22062855' WHERE state='BA' AND "lexLabel"='tucano';
UPDATE t SET "wdId"='Q22062854' WHERE state='BA' AND "lexLabel"='uaua';
UPDATE t SET "wdId"='Q22062853' WHERE state='BA' AND "lexLabel"='ubaira';
UPDATE t SET "wdId"='Q22062851' WHERE state='BA' AND "lexLabel"='ubata';
UPDATE t SET "wdId"='Q22060576' WHERE state='BA' AND "lexLabel"='una';
UPDATE t SET "wdId"='Q22062848' WHERE state='BA' AND "lexLabel"='urucuca';
UPDATE t SET "wdId"='Q22062847' WHERE state='BA' AND "lexLabel"='utinga';
UPDATE t SET "wdId"='Q22062845' WHERE state='BA' AND "lexLabel"='valente';
UPDATE t SET "wdId"='Q22062840' WHERE state='BA' AND "lexLabel"='vera.cruz';
UPDATE t SET "wdId"='Q22062838' WHERE state='BA' AND "lexLabel"='wagner';
UPDATE t SET "wdId"='Q301700' WHERE state='MA' AND "lexLabel"='morros';
UPDATE t SET "wdId"='Q2013023' WHERE state='MA' AND "lexLabel"='presidente.sarney';
UPDATE t SET "wdId"='Q22066885' WHERE state='SP' AND "lexLabel"='anhumas';
UPDATE t SET "wdId"='Q1774484' WHERE state='SP' AND "lexLabel"='moncoes';
UPDATE t SET "wdId"='Q22064419' WHERE state='SP' AND "lexLabel"='tabatinga';
UPDATE t SET "wdId"='Q22064418' WHERE state='SP' AND "lexLabel"='taciba';
UPDATE t SET "wdId"='Q22064413' WHERE state='SP' AND "lexLabel"='tapirai';
UPDATE t SET "wdId"='Q22064411' WHERE state='SP' AND "lexLabel"='taquaral';
UPDATE t SET "wdId"='Q22064407' WHERE state='SP' AND "lexLabel"='tarabai';
UPDATE t SET "wdId"='Q13109202' WHERE state='SP' AND "lexLabel"='teodoro.sampaio';
UPDATE t SET "wdId"='Q22064400' WHERE state='SP' AND "lexLabel"='trabiju';
UPDATE t SET "wdId"='Q22064399' WHERE state='SP' AND "lexLabel"='tremembe';
UPDATE t SET "wdId"='Q22064397' WHERE state='SP' AND "lexLabel"='tuiuti';
UPDATE t SET "wdId"='Q22064394' WHERE state='SP' AND "lexLabel"='turiuba';
UPDATE t SET "wdId"='Q13109246' WHERE state='SP' AND "lexLabel"='uru';
UPDATE t SET "wdId"='Q13109251' WHERE state='SP' AND "lexLabel"='valparaiso';
UPDATE t SET "wdId"='Q22066862' WHERE state='SP' AND "lexLabel"='vera.cruz';
--- ---
COPY (
  select name, state, "wdId", "idIBGE", "lexLabel", creation, extinction,
     "postalCode_ranges", ddd, notes  
   from t ORDER BY std_collate(name), name, state 
) to '/tmp/atualizacao.csv' CSV HEADER