Area Codes SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
-- 
-- Table structure for table `area_codes`
-- 

CREATE TABLE `area_codes` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(10) NOT NULL,
  `region` varchar(2) NOT NULL,
  `timezone` varchar(20) NOT NULL,
  `description` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=384 DEFAULT CHARSET=latin1 AUTO_INCREMENT=384 ;

-- 
-- Dumping data for table `area_codes`
-- 

INSERT INTO `area_codes` (`id`, `code`, `region`, `timezone`, `description`) VALUES (1, '52 55', 'MX', '-6', 'Mexico: Mexico City area (country code + city code)'),
(2, '201', 'NJ', '-5', 'N New Jersey: Jersey City, Hackensack (see split 973, overlay 551)'),
(3, '202', 'DC', '-5', 'Washington, D.C.'),
(4, '203', 'CT', '-5', 'Connecticut: Fairfield County and New Haven County; Bridgeport, New Haven (see 860)'),
(5, '204', 'MB', '-6', 'Canada: Manitoba'),
(6, '205', 'AL', '-6', 'Central Alabama (including Birmingham; excludes the southeastern corner of Alabama and the deep south; see splits 256 and 334)'),
(7, '206', 'WA', '-8', 'W Washington state: Seattle and Bainbridge Island (see splits 253, 360, 425; overlay 564)'),
(8, '207', 'ME', '-5', 'Maine'),
(9, '208', 'ID', '0.875', 'Idaho'),
(10, '209', 'CA', '-8', 'Cent. California: Stockton (see split 559)'),
(11, '210', 'TX', '-6', 'S Texas: San Antonio (see also splits 830, 956)'),
(12, '211', '--', '--', 'Local community info / referral services'),
(13, '212', 'NY', '-5', 'New York City, New York (Manhattan; see 646, 718)'),
(14, '213', 'CA', '-8', 'S California: Los Angeles (see 310, 323, 626, 818)'),
(15, '214', 'TX', '-6', 'Texas: Dallas Metro (overlays 469/972)'),
(16, '215', 'PA', '-5', 'SE Pennsylvania: Philadelphia (see overlays 267)'),
(17, '216', 'OH', '-5', 'Cleveland (see splits 330, 440)'),
(18, '217', 'IL', '-6', 'Cent. Illinois: Springfield'),
(19, '218', 'MN', '-6', 'N Minnesota: Duluth'),
(20, '219', 'IN', '1.2', 'NW Indiana: Gary (see split 574, 260)'),
(21, '224', 'IL', '-6', 'Northern NE Illinois: Evanston, Waukegan, Northbrook (overlay on 847, eff 1/5/02)'),
(22, '225', 'LA', '-6', 'Louisiana: Baton Rouge, New Roads, Donaldsonville, Albany, Gonzales, Greensburg, Plaquemine, Vacherie (split from 504)'),
(23, '226', 'ON', '-5', 'Canada: SW Ontario: Windsor (overlaid on 519; eff 6/06)'),
(24, '228', 'MS', '-6', 'S Mississippi (coastal areas, Biloxi, Gulfport; split from 601)'),
(25, '229', 'GA', '-5', 'SW Georgia: Albany (split from 912; see also 478; p
To view the full dump, please login
SQL database dumps

Area Codes

Navigation

Popular databases
