area-codes.sql

-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 28, 2012 at 04:56 PM
-- Server version: 5.0.91
-- PHP Version: 5.3.6-pl0-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `areacodes`
--

-- --------------------------------------------------------

--
-- Table structure for table `areacodes`
--

CREATE TABLE IF NOT EXISTS `areacodes` (
  `Area Code` int(3) NOT NULL,
  `Region` tinytext NOT NULL,
  `Description` varchar(256) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `areacodes`
--

INSERT INTO `areacodes` (`Area Code`, `Region`, `Description`) VALUES
(201, 'NJ', 'N New Jersey: Jersey City, Hackensack '),
(202, 'DC', 'Washington, D.C.'),
(203, 'CT', 'Connecticut: Fairfield County and New Haven County; Bridgeport, New Haven '),
(204, 'MB', 'Canada: Manitoba'),
(205, 'AL', 'Central Alabama '),
(206, 'WA', 'W Washington state: Seattle and Bainbridge Island '),
(207, 'ME', 'Maine'),
(208, 'ID', 'Idaho'),
(209, 'CA', 'Cent. California: Stockton '),
(210, 'TX', 'S Texas: San Antonio '),
(211, '', 'Local community info / referral services'),
(212, 'NY', 'New York City, New York '),
(213, 'CA', 'S California: Los Angeles '),
(214, 'TX', 'Texas: Dallas Metro '),
(215, 'PA', 'SE Pennsylvania: Philadelphia '),
(216, 'OH', 'Cleveland '),
(217, 'IL', 'Cent. Illinois: Springfield'),
(218, 'MN', 'N Minnesota: Duluth'),
(219, 'IN', 'NW Indiana: Gary '),
(224, 'IL', 'Northern NE Illinois: Evanston, Waukegan, Northbrook '),
(225, 'LA', 'Louisiana: Baton Rouge, New Roads, Donaldsonville, Albany, Gonzales, Greensburg, Plaquemine, Vacherie '),
(226, 'ON', 'Canada: SW Ontario: Windsor '),
(228, 'MS', 'S Mississippi '),
(229, 'GA', 'SW Georgia: Albany '),
(231, 'MI', 'W Michigan: Northwestern portion of lower Peninsula; Traverse City, Muskegon, Cheboygan, Alanson'),
(234, 'OH', 'NE Ohio: Canton, Akron '),
(236, 'VA', 'Virginia  / Unassigned?'),
(239, 'FL', 'Florida '),
(240, 'MD', 'W Maryland: Silver Spring, Frederick, Gaithersburg '),
(242, '', 'Bahamas'),
(246, '', 'Barbados'),
(248, 'MI', 'Michigan: Oakland County, Pontiac '),
(250, 'BC', 'Canada: British Columbia '),
(251, 'AL', 'S Alabama: Mobile and coastal areas, Jackson, Evergreen, Monroeville '),
(252, 'NC', 'E North Carolina '),
(253, 'WA', 'Washington: South Tier - Tacoma, Federal Way '),
(254, 'TX', 'Central Texas '),
(256, 'AL', 'E and N Alabama '),
(260, 'IN', 'NE Indiana: Fort Wayne '),
(262, 'WI', 'SE Wisconsin: counties of Kenosha, Ozaukee, Racine, Walworth, Washington, Waukesha '),
(264, '', 'Anguilla '),
(267, 'PA', 'SE Pennsylvania: Philadelphia '),
(268, '', 'Antigua and Barbuda '),
(269, 'MI', 'SW Michigan: Kalamazoo, Saugatuck, Hastings, Battle Creek, Sturgis to Lake Michigan '),
(270, 'KY', 'W Kentucky: Bowling Green, Paducah '),
(276, 'VA', 'S and SW Virginia: Bristol, Stuart, Martinsville '),
(278, 'MI', 'Michigan '),
(281, 'TX', 'Texas: Houston Metro '),
(283, 'OH', 'SW Ohio: Cincinnati '),
(284, '', 'British Virgin Islands '),
(289, 'ON', 'Canada: S Cent. Ontario: Greater Toronto Area  Durham, Halton, Hamilton-Wentworth, Niagara, Peel, York, and southern Simcoe County '),
(301, 'MD', 'W Maryland: Silver Spring, Frederick, Camp Springs, Prince George''s County '),
(302, 'DE', 'Delaware'),
(303, 'CO', 'Central Colorado: Denver '),
(304, 'WV', 'West Virginia'),
(305, 'FL', 'SE Florida: Miami, the Keys '),
(306, 'SK', 'Canada: Saskatchewan'),
(307, 'WY', 'Wyoming'),
(308, 'NE', 'W Nebraska: North Platte'),
(309, 'IL', 'W Cent. Illinois: Peoria'),
(310, 'CA', 'S California: Beverly Hills, West Hollywood, West Los Angeles '),
(311, '', 'Reserved for special applications'),
(312, 'IL', 'Illinois: Chicago '),
(313, 'MI', 'Michigan: Detroit and suburbs '),
(314, 'MO', 'SE Missouri: St Louis city and parts of the metro area only '),
(315, 'NY', 'N Cent. New York: Syracuse'),
(316, 'KS', 'S Kansas: Wichita '),
(317, 'IN', 'Cent. Indiana: Indianapolis '),
(318, 'LA', 'N Louisiana: Shreveport, Ruston, Monroe, Alexandria '),
(319, 'IA', 'E Iowa: Cedar Rapids '),
(320, 'MN', 'Cent. Minnesota: Saint Cloud '),
(321, 'FL', 'Florida: Brevard County, Cape Canaveral area; Metro Orlando '),
(323, 'CA', 'S California: Los Angeles '),
(325, 'TX', 'Central Texas: Abilene, Sweetwater, Snyder, San Angelo '),
(330, 'OH', 'NE Ohio: Akron, Canton, Youngstown; Mahoning County, parts of Trumbull/Warren counties '),
(331, 'IL', 'W NE Illinois, western suburbs of Chicago '),
(334, 'AL', 'S Alabama: Auburn/Opelika, Montgomery and coastal areas '),
(336, 'NC', 'Cent. North Carolina: Greensboro, Winston-Salem, High Point '),
(337, 'LA', 'SW Louisiana: Lake Charles, Lafayette '),
(339, 'MA', 'Massachusetts: Boston suburbs, to the south and west '),
(340, 'VI', 'US Virgin Islands '),
(341, 'CA', ''),
(345, '', 'Cayman Islands'),
(347, 'NY', 'New York '),
(351, 'MA', 'Massachusetts: north of Boston to NH, 508, and 781 '),
(352, 'FL', 'Florida: Gainesville area, Ocala, Crystal River '),
(360, 'WA', 'W Washington State: Olympia, Bellingham '),
(361, 'TX', 'S Texas: Corpus Christi '),
(369, 'CA', 'Solano County '),
(380, 'OH', 'Ohio: Columbus '),
(385, 'UT', 'Utah: Salt Lake City Metro '),
(386, 'FL', 'N central Florida: Lake City '),
(401, 'RI', 'Rhode Island'),
(402, 'NE', 'E Nebraska: Omaha, Lincoln'),
(403, 'AB', 'Canada: Southern Alberta '),
(404, 'GA', 'N Georgia: Atlanta and suburbs '),
(405, 'OK', 'W Oklahoma: Oklahoma City '),
(406, 'MT', 'Montana'),
(407, 'FL', 'Central Florida: Metro Orlando '),
(408, 'CA', 'Cent. Coastal California: San Jose '),
(409, 'TX', 'SE Texas: Galveston, Port Arthur, Beaumont '),
(410, 'MD', 'E Maryland: Baltimore, Annapolis, Chesapeake Bay area, Ocean City '),
(411, '', 'Reserved for special applications'),
(412, 'PA', 'W Pennsylvania: Pittsburgh '),
(413, 'MA', 'W Massachusetts: Springfield'),
(414, 'WI', 'SE Wisconsin: Milwaukee County '),
(415, 'CA', 'California: San Francisco County and Marin County on the north side of the Golden Gate Bridge, extending north to Sonoma County '),
(416, 'ON', 'Canada: S Cent. Ontario: Toronto '),
(417, 'MO', 'SW Missouri: Springfield'),
(418, 'QC', 'Canada: NE Quebec: Quebec'),
(419, 'OH', 'NW Ohio: Toledo '),
(423, 'TN', 'E Tennessee, except Knoxville metro area: Chattanooga, Bristol, Johnson City, Kingsport, Greeneville '),
(424, 'CA', 'S California: Los Angeles '),
(425, 'WA', 'Washington: North Tier - Everett, Bellevue '),
(430, 'TX', 'NE Texas: Tyler '),
(432, 'TX', 'W Texas: Big Spring, Midland, Odessa '),
(434, 'VA', 'E Virginia: Charlottesville, Lynchburg, Danville, South Boston, and Emporia '),
(435, 'UT', 'Rural Utah outside Salt Lake City metro '),
(438, 'QC', 'Canada: SW Quebec: Montreal city '),
(440, 'OH', 'Ohio: Cleveland metro area, excluding Cleveland '),
(441, '', 'Bermuda '),
(442, 'CA', 'Far north suburbs of San Diego '),
(443, 'MD', 'E Maryland: Baltimore, Annapolis, Chesapeake Bay area, Ocean City '),
(450, 'QC', 'Canada: Southeastern Quebec; suburbs outside metro Montreal'),
(456, '', 'Inbound International'),
(464, 'IL', 'Illinois: south suburbs of Chicago '),
(469, 'TX', 'Texas: Dallas Metro '),
(470, 'GA', 'Georgia: Greater Atlanta Metropolitan Area '),
(473, '', 'Grenada '),
(475, 'CT', 'Connecticut: New Haven, Greenwich, southwestern '),
(478, 'GA', 'Central Georgia: Macon '),
(479, 'AR', 'NW Arkansas: Fort Smith, Fayetteville, Springdale, Bentonville '),
(480, 'AZ', 'Arizona: East Phoenix '),
(484, 'PA', 'SE Pennsylvania: Allentown, Bethlehem, Reading, West Chester, Norristown '),
(500, '', 'Personal Communication Service'),
(501, 'AR', 'Central Arkansas: Little Rock, Hot Springs, Conway '),
(502, 'KY', 'N Central Kentucky: Louisville '),
(503, 'OR', 'Oregon '),
(504, 'LA', 'E Louisiana: New Orleans metro area '),
(505, 'NM', 'North central and northwestern New Mexico '),
(506, 'NB', 'Canada: New Brunswick'),
(507, 'MN', 'S Minnesota: Rochester, Mankato, Worthington'),
(508, 'MA', 'Cent. Massachusetts: Framingham; Cape Cod '),
(509, 'WA', 'E and Central Washington state: Spokane, Yakima, Walla Walla, Ellensburg'),
(510, 'CA', 'California: Oakland, East Bay '),
(511, '', 'Nationwide travel information'),
(512, 'TX', 'S Texas: Austin '),
(513, 'OH', 'SW Ohio: Cincinnati '),
(514, 'QC', 'Canada: SW Quebec: Montreal city '),
(515, 'IA', 'Cent. Iowa: Des Moines '),
(516, 'NY', 'New York: Nassau County, Long Island; Hempstead '),
(517, 'MI', 'Cent. Michigan: Lansing '),
(518, 'NY', 'NE New York: Albany'),
(519, 'ON', 'Canada: SW Ontario: Windsor '),
(520, 'AZ', 'SE Arizona: Tucson area '),
(530, 'CA', 'NE California: Eldorado County area, excluding Eldorado Hills itself: incl cities of Auburn, Chico, Redding, So. Lake Tahoe, Marysville, Nevada City/Grass Valley '),
(540, 'VA', 'Western and Southwest Virginia: Shenandoah and Roanoke valleys: Fredericksburg, Harrisonburg, Roanoke, Salem, Lexington and nearby areas '),
(541, 'OR', 'Oregon: Eugene, Medford '),
(551, 'NJ', 'N New Jersey: Jersey City, Hackensack '),
(555, '', 'Reserved for directory assistance applications'),
(557, 'MO', 'SE Missouri: St Louis metro area only '),
(559, 'CA', 'Central California: Fresno '),
(561, 'FL', 'S. Central Florida: Palm Beach County '),
(562, 'CA', 'California: Long Beach '),
(563, 'IA', 'E Iowa: Davenport, Dubuque '),
(564, 'WA', 'W Washington State: Olympia, Bellingham '),
(567, 'OH', 'NW Ohio: Toledo '),
(570, 'PA', 'NE and N Central Pennsylvania: Wilkes-Barre, Scranton '),
(571, 'VA', 'Northern Virginia: Arlington, McLean, Tysons Corner '),
(573, 'MO', 'SE Missouri: excluding St Louis metro area, includes Central/East Missouri, area between St. Louis and Kansas City'),
(574, 'IN', 'N Indiana: Elkhart, South Bend '),
(575, 'NM', 'New Mexico '),
(580, 'OK', 'W Oklahoma '),
(585, 'NY', 'NW New York: Rochester '),
(586, 'MI', 'Michigan: Macomb County '),
(600, '', 'Canadian Services'),
(601, 'MS', 'Mississippi: Meridian, Jackson area '),
(602, 'AZ', 'Arizona: Phoenix '),
(603, 'NH', 'New Hampshire'),
(604, 'BC', 'Canada: British Columbia: Greater Vancouver '),
(605, 'SD', 'South Dakota'),
(606, 'KY', 'E Kentucky: area east of Frankfort: Ashland '),
(607, 'NY', 'S Cent. New York: Ithaca, Binghamton; Catskills'),
(608, 'WI', 'SW Wisconsin: Madison'),
(609, 'NJ', 'S New Jersey: Trenton '),
(610, 'PA', 'SE Pennsylvania: Allentown, Bethlehem, Reading, West Chester, Norristown '),
(611, '', 'Reserved for special applications'),
(612, 'MN', 'Cent. Minnesota: Minneapolis '),
(613, 'ON', 'Canada: SE Ontario: Ottawa'),
(614, 'OH', 'SE Ohio: Columbus '),
(615, 'TN', 'Northern Middle Tennessee: Nashville metro area '),
(616, 'MI', 'W Michigan: Holland, Grand Haven, Greenville, Grand Rapids, Ionia '),
(617, 'MA', 'Massachusetts: greater Boston '),
(618, 'IL', 'S Illinois: Centralia'),
(619, 'CA', 'S California: San Diego '),
(620, 'KS', 'S Kansas: Wichita '),
(623, 'AZ', 'Arizona: West Phoenix '),
(626, 'CA', 'E S California: Pasadena '),
(627, 'CA', 'No longer in use [was Napa, Sonoma counties ; now 707]'),
(628, 'CA', ''),
(630, 'IL', 'W NE Illinois, western suburbs of Chicago '),
(631, 'NY', 'New York: Suffolk County, Long Island; Huntington, Riverhead '),
(636, 'MO', 'Missouri: W St. Louis metro area of St. Louis county, St. Charles County, Jefferson County area south '),
(641, 'IA', 'Iowa: Mason City, Marshalltown, Creston, Ottumwa '),
(646, 'NY', 'New York  NYC: Manhattan only'),
(647, 'ON', 'Canada: S Cent. Ontario: Toronto '),
(649, '', 'Turks & Caicos Islands'),
(650, 'CA', 'California: Peninsula south of San Francisco  San Mateo County, parts of Santa Clara County '),
(651, 'MN', 'Cent. Minnesota: St. Paul '),
(660, 'MO', 'N Missouri '),
(661, 'CA', 'California: N Los Angeles, Mckittrick, Mojave, Newhall, Oildale, Palmdale, Taft, Tehachapi, Bakersfield, Earlimart, Lancaster '),
(662, 'MS', 'N Mississippi: Tupelo, Grenada '),
(664, '', 'Montserrat '),
(669, 'CA', 'Cent. Coastal California: San Jose '),
(670, 'MP', 'Commonwealth of the Northern Mariana Islands '),
(671, 'GU', 'Guam'),
(678, 'GA', 'N Georgia: metropolitan Atlanta '),
(679, 'MI', 'Michigan: Dearborn area '),
(682, 'TX', 'Texas: Fort Worth areas '),
(684, '', 'American Samoa'),
(689, 'FL', 'Central Florida: Metro Orlando '),
(700, '', 'Interexchange Carrier Services'),
(701, 'ND', 'North Dakota'),
(702, 'NV', 'S. Nevada: Clark County, incl Las Vegas '),
(703, 'VA', 'Northern Virginia: Arlington, McLean, Tysons Corner '),
(704, 'NC', 'W North Carolina: Charlotte '),
(705, 'ON', 'Canada: NE Ontario: Sault Ste. Marie/N Ontario: N Bay, Sudbury'),
(706, 'GA', 'N Georgia: Columbus, Augusta '),
(707, 'CA', 'NW California: Santa Rosa, Napa, Vallejo, American Canyon, Fairfield'),
(708, 'IL', 'Illinois: southern and western suburbs of Chicago '),
(709, 'NL', 'Canada: Newfoundland and Labrador'),
(710, '', 'US Government'),
(711, '', 'Telecommunications Relay Services'),
(712, 'IA', 'W Iowa: Council Bluffs'),
(713, 'TX', 'Mid SE Texas: central Houston '),
(714, 'CA', 'North and Central Orange County '),
(715, 'WI', 'N Wisconsin: Eau Claire, Wausau, Superior'),
(716, 'NY', 'NW New York: Buffalo '),
(717, 'PA', 'E Pennsylvania: Harrisburg '),
(718, 'NY', 'New York City, New York '),
(719, 'CO', 'SE Colorado: Pueblo, Colorado Springs'),
(720, 'CO', 'Central Colorado: Denver '),
(724, 'PA', 'SW Pennsylvania '),
(727, 'FL', 'Florida Tampa Metro: Saint Petersburg, Clearwater '),
(731, 'TN', 'W Tennessee: outside Memphis metro area '),
(732, 'NJ', 'Cent. New Jersey: Toms River, New Brunswick, Bound Brook '),
(734, 'MI', 'SE Michigan: west and south of Detroit  Ann Arbor, Monroe '),
(737, 'TX', 'S Texas: Austin '),
(740, 'OH', 'SE Ohio '),
(747, 'CA', 'S California: Los Angeles, Agoura Hills, Calabasas, Hidden Hills, and Westlake Village '),
(754, 'FL', 'Florida: Broward County area, incl Ft. Lauderdale '),
(757, 'VA', 'E Virginia: Tidewater / Hampton Roads area  Norfolk, Virginia Beach, Chesapeake, Portsmouth, Hampton, Newport News, Suffolk '),
(758, '', 'St. Lucia '),
(760, 'CA', 'California: San Diego North County to Sierra Nevada '),
(762, 'GA', 'N Georgia: Columbus, Augusta '),
(763, 'MN', 'Minnesota: Minneapolis NW '),
(764, 'CA', ''),
(765, 'IN', 'Indiana: outside Indianapolis '),
(767, '', 'Dominica '),
(769, 'MS', 'Mississippi: Meridian, Jackson area '),
(770, 'GA', 'Georgia: Atlanta suburbs: outside of I-285 ring road '),
(772, 'FL', 'S. Central Florida: St. Lucie, Martin, and Indian River counties '),
(773, 'IL', 'Illinois: city of Chicago, outside the loop '),
(774, 'MA', 'Cent. Massachusetts: Framingham; Cape Cod '),
(775, 'NV', 'N. Nevada: Reno '),
(778, 'BC', 'Canada: British Columbia: Greater Vancouver '),
(779, 'IL', 'NW Illinois: Rockford, Kankakee '),
(780, 'AB', 'Canada: Northern Alberta, north of Lacombe '),
(781, 'MA', 'Massachusetts: Boston surburbs, to the north and west '),
(784, '', 'St. Vincent & Grenadines '),
(785, 'KS', 'N & W Kansas: Topeka '),
(786, 'FL', 'SE Florida, Monroe County '),
(787, 'PR', 'Puerto Rico '),
(800, '', 'US/Canada toll free '),
(801, 'UT', 'Utah: Salt Lake City Metro '),
(802, 'VT', 'Vermont'),
(803, 'SC', 'South Carolina: Columbia, Aiken, Sumter '),
(804, 'VA', 'E Virginia: Richmond '),
(805, 'CA', 'S Cent. and Cent. Coastal California: Ventura County, Santa Barbara County: San Luis Obispo, Thousand Oaks, Carpinteria, Santa Barbara, Santa Maria, Lompoc, Santa Ynez Valley / Solvang '),
(806, 'TX', 'Panhandle Texas: Amarillo, Lubbock'),
(807, 'ON', 'Canada: W Ontario: Thunder Bay region to Manitoba border'),
(808, 'HI', 'Hawaii'),
(809, '', 'Dominican Republic '),
(810, 'MI', 'E Michigan: Flint, Pontiac '),
(811, '', 'Reserved for special applications'),
(812, 'IN', 'S Indiana: Evansville, Cincinnati outskirts in IN, Columbus, Bloomington '),
(813, 'FL', 'SW Florida: Tampa Metro '),
(814, 'PA', 'Cent. Pennsylvania: Erie'),
(815, 'IL', 'NW Illinois: Rockford, Kankakee '),
(816, 'MO', 'N Missouri: Kansas City '),
(817, 'TX', 'N Cent. Texas: Fort Worth area '),
(818, 'CA', 'S California: Los Angeles: San Fernando Valley '),
(819, 'QC', 'NW Quebec: Trois Rivieres, Sherbrooke, Outaouais , and the Laurentians  '),
(822, '', 'US/Canada toll free '),
(828, 'NC', 'W North Carolina: Asheville '),
(829, '', 'Dominican Republic '),
(830, 'TX', 'Texas: region surrounding San Antonio '),
(831, 'CA', 'California: central coast area from Santa Cruz through Monterey County'),
(832, 'TX', 'Texas: Houston '),
(833, '', 'US/Canada toll free '),
(835, 'PA', 'SE Pennsylvania: Allentown, Bethlehem, Reading, West Chester, Norristown '),
(843, 'SC', 'South Carolina, coastal area: Charleston, Beaufort, Myrtle Beach '),
(844, '', 'US/Canada toll free '),
(845, 'NY', 'New York: Poughkeepsie; Nyack, Nanuet, Valley Cottage, New City, Putnam, Dutchess, Rockland, Orange, Ulster and parts of Sullivan counties in New York''s lower Hudson Valley and Delaware County in the Catskills '),
(847, 'IL', 'Northern NE Illinois: northwestern suburbs of chicago '),
(848, 'NJ', 'Cent. New Jersey: Toms River, New Brunswick, Bound Brook '),
(850, 'FL', 'Florida panhandle, from east of Tallahassee to Pensacola ; western panhandle  are UTC-6'),
(855, '', 'US/Canada toll free '),
(856, 'NJ', 'SW New Jersey: greater Camden area, Mt Laurel '),
(857, 'MA', 'Massachusetts: greater Boston '),
(858, 'CA', 'S California: San Diego '),
(859, 'KY', 'N and Central Kentucky: Lexington; suburban KY counties of Cincinnati OH metro area; Covington, Newport, Ft. Thomas, Ft. Wright, Florence '),
(860, 'CT', 'Connecticut: areas outside of Fairfield and New Haven Counties '),
(862, 'NJ', 'N New Jersey: Newark Paterson Morristown '),
(863, 'FL', 'Florida: Lakeland, Polk County '),
(864, 'SC', 'South Carolina, upstate area: Greenville, Spartanburg '),
(865, 'TN', 'E Tennessee: Knoxville, Knox and adjacent counties '),
(866, '', 'US/Canada toll free'),
(867, 'YT', 'Canada: Yukon, Northwest Territories, Nunavut '),
(868, '', 'Trinidad and Tobago '),
(869, '', 'St. Kitts & Nevis'),
(870, 'AR', 'Arkansas: areas outside of west/central AR: Jonesboro, etc'),
(872, 'IL', 'Illinois: Chicago '),
(876, '', 'Jamaica '),
(877, '', 'US/Canada toll free'),
(878, 'PA', 'Pittsburgh, New Castle '),
(880, '', 'Paid Toll-Free Service'),
(881, '', 'Paid Toll-Free Service'),
(882, '', 'Paid Toll-Free Service'),
(888, '', 'US/Canada toll free'),
(898, '', 'VoIP service'),
(900, '', 'US toll calls  prices vary with the number called'),
(901, 'TN', 'W Tennessee: Memphis metro area '),
(902, 'NS', 'Canada: Nova Scotia, Prince Edward Island'),
(903, 'TX', 'NE Texas: Tyler '),
(904, 'FL', 'N Florida: Jacksonville '),
(905, 'ON', 'Canada: S Cent. Ontario: Greater Toronto Area  Durham, Halton, Hamilton-Wentworth, Niagara, Peel, York, and southern Simcoe County '),
(906, 'MI', 'Upper Peninsula Michigan: Sault Ste. Marie, Escanaba, Marquette '),
(907, 'AK', 'Alaska'),
(908, 'NJ', 'Cent. New Jersey: Elizabeth, Basking Ridge, Somerville, Bridgewater, Bound Brook'),
(909, 'CA', 'California: Inland empire: San Bernardino , Riverside'),
(910, 'NC', 'S Cent. North Carolina: Fayetteville, Wilmington '),
(911, '', 'Emergency'),
(912, 'GA', 'SE Georgia: Savannah '),
(913, 'KS', 'Kansas: Kansas City area '),
(914, 'NY', 'S New York: Westchester County '),
(915, 'TX', 'W Texas: El Paso '),
(916, 'CA', 'NE California: Sacramento, Walnut Grove, Lincoln, Newcastle and El Dorado Hills '),
(917, 'NY', 'New York: New York City '),
(918, 'OK', 'E Oklahoma: Tulsa'),
(919, 'NC', 'E North Carolina: Raleigh '),
(920, 'WI', 'NE Wisconsin: Appleton, Green Bay, Sheboygan, Fond du Lac '),
(925, 'CA', 'California: Contra Costa area: Antioch, Concord, Pleasanton, Walnut Creek '),
(927, 'FL', 'Florida: Cellular coverage in Orlando area'),
(928, 'AZ', 'Central and Northern Arizona: Prescott, Flagstaff, Yuma '),
(931, 'TN', 'Middle Tennessee: semi-circular ring around Nashville '),
(935, 'CA', 'S California: San Diego '),
(936, 'TX', 'SE Texas: Conroe, Lufkin, Nacogdoches, Crockett '),
(937, 'OH', 'SW Ohio: Dayton '),
(939, 'PR', 'Puerto Rico '),
(940, 'TX', 'N Cent. Texas: Denton, Wichita Falls '),
(941, 'FL', 'SW Florida: Sarasota and Manatee counties '),
(947, 'MI', 'Michigan: Oakland County '),
(949, 'CA', 'California: S Coastal Orange County '),
(951, 'CA', 'California: W Riverside County '),
(952, 'MN', 'Minnesota: Minneapolis SW, Bloomington '),
(954, 'FL', 'Florida: Broward County area, incl Ft. Lauderdale '),
(956, 'TX', 'Texas: Valley of Texas area; Harlingen, Laredo '),
(957, 'NM', 'New Mexico '),
(959, 'CT', 'Connecticut: Hartford, New London '),
(970, 'CO', 'N and W Colorado '),
(971, 'OR', 'Oregon: Metropolitan Portland, Salem/Keizer area, incl Cricket Wireless '),
(972, 'TX', 'Texas: Dallas Metro '),
(973, 'NJ', 'N New Jersey: Newark, Paterson, Morristown '),
(975, 'MO', 'N Missouri: Kansas City '),
(976, '', 'Unassigned'),
(978, 'MA', 'Massachusetts: north of Boston to NH '),
(979, 'TX', 'SE Texas: Bryan, College Station, Bay City '),
(980, 'NC', 'North Carolina: '),
(984, 'NC', 'E North Carolina: Raleigh '),
(985, 'LA', 'E Louisiana: SE/N shore of Lake Pontchartrain: Hammond, Slidell, Covington, Amite, Kentwood, area SW of New Orleans, Houma, Thibodaux, Morgan City '),
(989, 'MI', 'Upper central Michigan: Mt Pleasant, Saginaw '),
(999, '', 'Often used by carriers to indicate that the area code information is unavailable for CNID, even though the rest of the number is present');