Mailing Addresses
This dataset provides standardized, validated mailing addresses from around the world, including detailed street, city, state/province, postal code, country, and geolocation information. It supports address validation tracking and is ideal for logistics, e-commerce, and customer management applications requiring accurate and up-to-date postal data.
Sample rows
preview · 8 of 200 rows · all 12 columns| address_idstring | is_validatedboolean | validation_sourcestring | street_addressstring | address_line_2string | citystring | state_province_regionstring | postal_codestring | countrystring | validation_datedate | latitudefloat | longitudefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|
| B2F8Z1K9QV | true | USPS | 4012 Main St | Apt 7B | Springfield | IL | 62704 | US | 2023-11-02 | 39.7817 | -89.6501 |
| F8K3T9D2LW | true | Canada Post | 55 Queen St | Suite 210 | Toronto | ON | M5G 2C3 | CA | 2024-01-18 | 43.6532 | -79.3832 |
| V1J2P8R5SD | false | blank | 8-14 Shibuya 2-chome | blank | Shibuya | blank | 150-0002 | JP | blank | 35.6581 | 139.7017 |
| M9N2W6C3QK | false | blank | 12 Oxford Rd | Flat 6 | Manchester | blank | M13 9PL | GB | blank | 53.4668 | -2.2339 |
| R5T7B6G4XM | true | Australia Post | 19 George St | Level 3 | Sydney | NSW | 2000 | AU | 2022-08-20 | -33.8688 | 151.2093 |
| K2L9X4J8SD | true | Correios | 17 Avenida Paulista | Bloco B | Sao Paulo | SP | 01311-200 | BR | 2023-07-12 | -23.5617 | -46.6558 |
| P1W8B7Q6XZ | true | USPS | 305 Park Ave | Suite 300 | New York | NY | 10022 | US | 2024-03-29 | 40.7505 | -73.9716 |
| D6G3Z8V4MP | false | blank | 22 Rue de Rivoli | blank | Paris | blank | 75001 | FR | blank | 48.8556 | 2.3418 |
| H7C4M2L9TR | false | blank | 42 College St | Unit 12 | Dublin | blank | D02 VY06 | IE | blank | 53.3441 | -6.2675 |
| T2S6P1X3BV | true | USPS | 1800 Peachtree Rd NW | Apt 220 | Atlanta | GA | 30309 | US | 2024-06-14 | 33.8007 | -84.3932 |
| Q8M2Z9S1XJ | true | Correos | 77 Calle Gran Via | Piso 5 | Madrid | MD | 28013 | ES | 2022-11-09 | 40.4193 | -3.7058 |
| S3L8B5C2QY | false | blank | 110 St Georges Tce | blank | Perth | WA | 6000 | AU | blank | -31.9535 | 115.8575 |
| E7V6J2N5KW | true | PostNord | 53 Langelinie Alle | blank | Copenhagen | DK | 2100 | DK | 2021-02-10 | 55.6927 | 12.5945 |
| B9G3T2X7ML | true | Google Maps API | 2145 N Clark St | Apt 304 | Chicago | IL | 60614 | US | 2024-05-18 | 41.9214 | -87.6375 |
| U2F6C1X5QZ | true | PostNet | 53 Veld St | blank | Cape Town | WC | 8001 | ZA | 2023-02-27 | -33.9249 | 18.4241 |
| J4P7N3D2YZ | false | blank | 2020 S Main St | Unit 5 | Los Angeles | CA | 90007 | US | blank | 34.0297 | -118.2818 |
| M4K2H7L9VC | false | blank | 15 Rue de la Loi | blank | Brussels | blank | 1040 | BE | blank | 50.8456 | 4.3662 |
| F6Z1Q2W9AP | true | Canada Post | 18 Rue Sainte-Catherine | Boîte 4 | Montreal | QC | H2X 1K3 | CA | 2023-09-03 | 45.5076 | -73.5659 |
| C7N2L4X6VY | false | blank | 2990 Walnut St | blank | Denver | CO | 80205 | US | blank | 39.7655 | -104.9836 |
| W8D2T7H3JQ | true | Posti | 12 Finnlandsgatan | blank | Helsinki | FI | 00560 | FI | 2021-05-24 | 60.1921 | 24.9458 |
What the 200 rows show
from the 200-row sample- 57%is_
validated = true - 33countries
- string 8
- float 2
- date 1
- boolean 1
Columns
12 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
address_id | string | Unique identifier for each mailing address recordunique | B2F8Z1K9QV |
street_address | string | Primary street address including house/building number and street nameup to 255 | 4012 Main St |
address_line_2 | string | Secondary address information (e.g., apartment, suite, unit, floor)up to 255 · optional | Apt 7B |
city | string | City or locality for the mailing addressup to 100 | Springfield |
state_province_region | string | State, province, or region for the mailing addressup to 100 · optional | IL |
postal_code | string | Postal or ZIP code for the mailing addressup to 20 | 62704 |
country | string | Country name (ISO 3166-1 alpha-2 or full name)up to 100 | US |
validation_source | string | Source or service used for address validation (e.g., USPS, Royal Mail, third-party API)up to 100 · optional | USPS |
| Numbers 2 columns | |||
latitude | float | Latitude coordinate for geolocation of the address-90 to 90 · optional | 39.7817 |
longitude | float | Longitude coordinate for geolocation of the address-180 to 180 · optional | -89.6501 |
| Dates and times 1 column | |||
validation_date | date | Date when the address was last validatedoptional | 2023-11-02 |
| True or false 1 column | |||
is_validated | boolean | Indicates if the address has been validated through postal or third-party services | true |
Use it for
A logistics dashboard
The is_
validated rate and a breakdown of validation_ source. Excel, Power BI or Tableau. Why do 114 of 200 rows have is_
validated = true? A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Addresses200B2F8Z1K9QVtrueF8K3T9D2LWtrueV1J2P8R5SDfalse
A software demo
Believable addresses with street_
address, address_ line_ 2 and city to fill a screen in front of a buyer.
This dataset200 rows12 columns
Yours1,000 rows12 columnsaddress_id: UK only
blueprint · mailing-addresses
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 12 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Postal code format matches country standards
- State/province valid for given country
- City and state combination is valid
- Address type: residential or commercial
- Delivery instructions for special cases
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- mailing-addresses