IP2Location™ ZIP Code to Metro Database

IP2Location™ ZIP Code to Metro is a free data offered to our valued customers. This data enables you to map the ZIP code information to metro information. The data is provided in the CSV format, so that you can easily import into any database of your choice.

Download

For Customers Only

Features

Last Update	13 March, 2020
Database Format	CSV Text File (Comma Delimited)

Database Fields

Name	Type	Description
zip_code	VARCHAR(5)	ZIP Code
metro_code	VARCHAR(3)	Metro code
metro_desc	VARCHAR(64)	Metro description

Sample Database

"ZIP_CODE","METRO_CODE","METRO_DESC"
"00501","501","NEW YORK"
"00544","501","NEW YORK"
"01001","543","SPRINGFIELD - HOLYOKE"
"01002","543","SPRINGFIELD - HOLYOKE"
"01003","543","SPRINGFIELD - HOLYOKE"

MySQL Statement

CREATE TABLE `ip2location_zipcode_metro`(
	`zip_code` VARCHAR(5),
	`metro_code` VARCHAR(3),
	`metro_desc` VARCHAR(64),
	INDEX `idx_zip_code` (`zip_code`),
	INDEX `idx_metro_code` (`metro_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-ZIPCODE-METRO.CSV' INTO TABLE `ip2location_zipcode_metro`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

License Information

Attribution is required by mentioning the use of this data as follows, "The IP geolocation data is provided by https://www.ip2location.com", on your webpage and in the documentation or advertising.

IP2Location™ and IP2Proxy™ are registered trademarks of HEXASOFT. All other trademarks are the properties of their respective owners.