# Standardise addresses, names and phone numbers

Shape / columns

parse and standardise addresses, names, phone numbers

Page: <https://meridian.online/operations/standardise-addresses-names-and-phone-numbers>

## Status

Runs as a SQL step.

arcform carries it as a `sql:` step today, with the `us_address_standardizer` extension.

## The DuckDB step

a US address parsed into its parts

```sql
INSTALL us_address_standardizer FROM community; LOAD us_address_standardizer;
CREATE TEMP TABLE result AS
SELECT parse_address('123 Main Street, Springfield, IL 62701') AS a;
SELECT a.* FROM result;
SELECT CASE WHEN ((SELECT a.num = '123' AND a.city = 'Springfield' AND a.state = 'IL' AND a.zip = '62701' AND a.street ILIKE 'main%' FROM result)) THEN 'as expected' ELSE error('the address did not come apart into number, street, city, state and zip') END AS verdict;
```

The statement builds its own data.

It needs the `us_address_standardizer` extension.

## What other tools call it

Meridian's classification; an independent blind rating agreed on 86.2% of 312 rows (exact class, version 2).

- Alteryx Designer: [`CASS`](https://help.alteryx.com/current/en/designer/tools/address/cass-tool.html) (read 2026-09-27)
- Alteryx Designer: [`Parse Address`](https://help.alteryx.com/current/en/designer/tools/address/parse-address-tool.html) (read 2026-09-27)
- Talend: [`tAddressRowCloud`](https://help.qlik.com/talend/en-US/components/8.0/address-standardization/address-standardization-component) (read 2026-09-27)
- Talend: [`tBatchAddressRowCloud`](https://help.qlik.com/talend/en-US/components/8.0/address-standardization/address-standardization-component) (read 2026-09-27)
- Talend: [`tLoqateAddressRow`](https://help.qlik.com/talend/en-US/components/8.0/loqate-address-standardization/loqate-address-standardization-component) (read 2026-09-27)
- Talend: [`tMelissaDataAddress`](https://help.qlik.com/talend/en-US/components/8.0/melissa-data-address-standardization/melissa-data-address-standardization-component) (read 2026-09-27)
- Talend: [`tPersonator`](https://help.qlik.com/talend/en-US/components/8.0/melissa-data-address-standardization/melissa-data-address-standardization-component) (read 2026-09-27)
- Talend: [`tQASAddressIncomplete`](https://help.qlik.com/talend/en-US/components/8.0/qas-address-standardization/qas-address-standardization-component) (read 2026-09-27)
- Talend: [`tQASAddressRow`](https://help.qlik.com/talend/en-US/components/8.0/qas-address-standardization/qas-address-standardization-component) (read 2026-09-27)
- Talend: [`tQASAddressUnknown`](https://help.qlik.com/talend/en-US/components/8.0/qas-address-standardization/qas-address-standardization-component) (read 2026-09-27)
- Talend: [`tQASAddressVerified`](https://help.qlik.com/talend/en-US/components/8.0/qas-address-standardization/qas-address-standardization-component) (read 2026-09-27)
- Talend: [`tQASBatchAddressRow`](https://help.qlik.com/talend/en-US/components/8.0/qas-address-standardization/qas-address-standardization-component) (read 2026-09-27)