AreaCode / City table

[Danny J. Lesandrini]

I'm looking for a table of Cities and their Area Codes.
Anyone have one or know where a public version exists.

 

[Danny J. Lesandrini]

Well, I scraped some data from a web site with a comma delimited list of cities for given area codes. Below is the result, if
anyone else is in need of it. Probably not complete. It has 488 entries for the US.

--
Danny J. Lesandrini


AreaCode StateCode City
201 NJ Jersey City
202 DC (All Locations)
203 CT Bridgeport
203 CT New Haven
203 CT Stamford
203 CT Waterbury
205 AL Jackson
205 AL Montgomery
205 AL Selma
206 WA Seattle
207 ME (All Locations)
208 ID (All Locations)
209 CA Merced
209 CA Stockton
210 TX San Antonio
212 NY New York
213 CA Los Angeles
214 TX Dallas
215 PA Philadelphia
216 OH Cleveland
217 IL Champaign
217 IL Decatur
217 IL Springfield
218 MN Brainerd
218 MN Duluth
218 MN Grand Rapids
218 MN International Falls
219 IN Fort Wayne
219 IN Gary
219 IN South Bend
225 LA Baton Rouge
225 LA New Roads
228 MS Gulfport
228 MS Pascagoula
229 GA Albany
229 GA Americus
229 GA Bainbridge
229 GA Valdosta
231 MI Ludington
231 MI Muskegon
231 MI Traverse City
234 OH Akron
234 OH Canton
234 OH Youngstown
240 MD Cumberland
240 MD Frederick
240 MD Hagerstown
248 MI Troy
252 NC Greenville
252 NC Kitty Hawk
253 WA Tacoma
254 TX Killeen
254 TX Waco
256 AL Huntsville
262 WI Racine
262 WI West Bend
267 PA Philadelphia
270 KY Bowling Green
270 KY Owensboro
270 KY Paducah
281 TX Houston
301 MD Cumberland
301 MD Frederick
301 MD Hagerstown
302 DE (All Locations)
303 CO Boulder
303 CO Denver
304 WV (All Locations)
305 FL Key West
305 FL Miami
307 WY (All Locations)
308 NE North Platte
308 NE Scottsbluff
309 IL Moline
309 IL Peoria
310 CA Malibu
310 CA Torrance
310 CA West Los Angeles
312 IL Chicago
313 MI Detroit
314 MO Saint Louis
315 NY Syracuse
315 NY Utica
315 NY Watertown
316 KS Great Bend
316 KS Parsons
316 KS Wichita
317 IN Indianapolis
318 LA Alexandria
318 LA Monroe
318 LA Shreveport
319 IA Burlington
319 IA Davenport
319 IA Dubuque
319 IA Iowa City
320 MN Hutchinson
320 MN Morris
320 MN Saint Cloud
321 FL Orlando
323 CA Los Angeles
330 OH Akron
330 OH Canton
330 OH Youngstown
334 AL Birmingham
334 AL Tuscaloosa
336 NC Winston Salem
337 LA Lafayette
337 LA Lake Charles
347 NY Bronx
347 NY Brooklyn
347 NY Queens
347 NY Staten Island
352 FL Gainesville
352 FL Ocala
360 WA Aberdeen
360 WA Bellingham
360 WA Olympia
361 TX Corpus Christi
361 TX Victoria
385 UT Ogden
385 UT Provo
401 RI (All Locations)
402 NE Lincoln
402 NE Omaha
404 GA Atlanta
405 OK Edmond
405 OK Oklahoma City
406 MT (All Locations)
407 FL Orlando
408 CA Los Gatos
408 CA San Jose
408 CA Sunnyvale
409 TX Beaumont
409 TX Galveston
410 MD Baltimore
410 MD Cambridge
412 PA Pittsburgh
413 MA Pittsfield
413 MA Springfield
414 WI Milwaukee
415 CA Novato
415 CA San Francisco
415 CA San Rafael
417 MO Joplin
417 MO Springfield
419 OH Bowling Green
419 OH Sandusky
419 OH Toledo
423 TN Bristol
423 TN Chattanooga
423 TN Sweetwater
425 WA Seattle area
435 UT Blanding
435 UT Logan
435 UT Richfield
440 OH Ashtabula
440 OH Elyria
443 MD Baltimore
443 MD Cambridge
469 TX Dallas
469 TX Plano
478 GA Macon
478 GA Swainsboro
478 GA Warner Robins
480 AZ Chandler
480 AZ Phoenix
484 PA Allentown
484 PA Reading
501 AR Fayetteville
501 AR Hot Springs
501 AR Little Rock
502 KY Frankfort
502 KY Louisville
503 OR Astoria
503 OR Portland
503 OR Salem
503 OR Tillamoon
504 LA Houma
504 LA New Orleans
505 NM (All Locations)
507 MN Mankato
507 MN Marshall
507 MN Rochester
507 MN Worthington
508 MA Attleboro
508 MA Hyannis
508 MA New Bedford
508 MA Worcester
509 WA Spokane
509 WA Walla Walla
509 WA Yakima
510 CA Hayward
510 CA Oakland
512 TX Austin
513 OH Cincinnati
513 OH Middletown
515 IA Des Moines
515 IA Fort Dodge
516 NY Elmont
517 MI Alpena
517 MI Jackson
517 MI Lansing
518 NY Albany
518 NY Plattsburgh
518 NY Saranac Lake
520 AZ Non-Phoenix areas
530 CA Alturas
530 CA Chico
530 CA Redding
540 VA Fredricksburg
540 VA Harrisonburg
540 VA Roanoke
540 VA Winchester
541 OR Bend
541 OR Burns
541 OR Eugene
541 OR Medford
559 CA Fresno
561 FL Boca Raton
561 FL West Palm Beach
562 CA Long Beach
570 PA Scranton
570 PA Williamsport
571 VA Alexandria
573 MO Hannibal
573 MO Jefferson City
580 OK Enid
580 OK Lawton
580 OK Woodward
601 MS Jackson
601 MS Mc Comb
602 AZ Phoenix
603 NH (All Locations)
605 SD (All Locations)
606 KY London
606 KY Morehead
606 KY Pikeville
607 NY Binghamton
607 NY Elmira
608 WI La Crosse
608 WI Madison
609 NJ Atlantic City
609 NJ Brown Mills
609 NJ Trenton
610 PA Allentown
610 PA Reading
612 MN Minneapolis
614 OH Columbus
615 TN Nashville
616 MI Grand Rapids
616 MI Kalamazoo
617 MA Boston
618 IL Carbondale
618 IL Mount Vernon
619 CA San Diego
623 AZ Buckeye
623 AZ Peoria
623 AZ Phoenix
626 CA Pasadena
630 IL Aurora
631 NY Long Island
636 MO Chesterfield
636 MO Union
641 IA Creston
641 IA Mason City
646 NY New York
650 CA Palo Alto
650 CA San Mateo
651 MN Lindstrom
651 MN Red Wing
651 MN Saint Paul
660 MO Macon
660 MO Marshall
660 MO Sedalia
661 CA Bakersfield
662 MS Columbus
662 MS Greenville
662 MS Tupelo
678 GA Atlanta
682 TX Fort Worth
701 ND (All Locations)
702 NV Las Vegas
703 VA Alexandria
704 NC Charlotte
704 NC Kingstown
706 GA Athens
706 GA Augusta
706 GA Dalton
706 GA Rome
706 GA Toccoa
707 CA Eureka
707 CA Santa Rosa
707 CA Ukiah
708 IL Chicago Heights
710 XX US Government
712 IA Council Bluffs
712 IA Sioux City
713 TX Houston
714 CA Huntington Beach
714 CA Orange
715 WI Eau Claire
715 WI Wausau
716 NY Buffalo
716 NY Jamestown
716 NY Rochester
717 PA Gettysburg
717 PA Harrisburg
718 NY Bronx
718 NY Brooklyn
718 NY Queens
718 NY Staten Island
719 CO Colorado Springs
719 CO Pueblo
720 CO Boulder
720 CO Denver
724 PA New Castle
724 PA Uniontown
727 FL Clearwater
732 NJ Lakewood
732 NJ Neptune
732 NJ New Brunswick
734 MI Ann Arbor
740 OH Cambridge
740 OH Jackson
740 OH Lancaster
740 OH Marietta
757 VA Norfolk
760 CA Bishop
760 CA Blythe
760 CA Indio
760 CA Ridgecrest
763 MN Maple Grove
765 IN Lafayette
765 IN Marion
765 IN Muncie
765 IN Richmond
770 GA Cedartown
770 GA Griffin
770 GA Marietta
770 GA Roswell
773 IL Chicago
775 NV Carson City
775 NV Elko
775 NV Ely
775 NV Reno
775 NV Tonopah
781 MA Norwood
781 MA Saugus
781 MA Weymouth
785 KS Saline
785 KS Topeka
786 FL Miami
801 UT Salt Lake City
802 VT (All Locations)
803 SC Columbia
803 SC Sumter
804 VA Danville
804 VA Lynchburg
804 VA Richmond
805 CA Lompoc
805 CA San Luis Obispo
805 CA Thousand Oaks
806 TX Amarillo
806 TX Lubbock
808 HI (All Locations)
810 MI Flint
810 MI Port Huron
812 IN Bloomington
812 IN Evansville
812 IN New Albany
812 IN Terre Haute
813 FL Tampa
814 PA Altoona
814 PA Erie
814 PA Johnstown
814 PA Warren
815 IL De Kalb
815 IL Freeport
815 IL La Salle
815 IL Rickford
816 MO Kansas City
816 MO Saint Joseph
817 TX Fort Worth
818 CA Glendale
818 CA San Fernando
828 NC Asheville
830 TX Uvalde
831 CA Salinas
831 CA Santa Cruz
832 TX Houston
843 SC Charleston
843 SC Florence
843 SC Myrtle Beach
845 NY Middletown
845 NY Poughkeepsie
847 IL Des Plaines
847 IL Waukegan
850 FL Tallahassee
856 NJ Cherry Hill
856 NJ Vineland
858 CA San Diego
858 CA Solano Beach
859 KY Lexington
860 CT Hartford
860 CT Norwich
863 FL Avon Park
863 FL Clewiston
864 SC Anderson
864 SC Greenville
864 SC Spartanburg
865 TN Knoxville
870 AR Jonesboro
870 AR Pine Bluff
901 TN Jackson
901 TN Memphis
901 TN Union City
903 TX Sherman
903 TX Tyler
904 FL Jacksonville
906 MI Escanaba
906 MI Marquette
906 MI Sault Ste. Marie
907 AK (All Locations)
908 NJ Washington
909 CA Pomona
909 CA San Bernadino
909 CA Temecula
910 NC Fayetteville
910 NC Jacksonville
910 NC Wilmington
912 GA Brunswick
912 GA Savannah
912 GA Vidalia
912 GA Waycross
913 KS Kansas City
913 KS Overland Park
914 NY White Plains
915 TX Abilene
915 TX Alpine
915 TX El Paso
915 TX Midland
916 CA Sacramento
917 NY Bronx
917 NY Brooklyn
917 NY New York
917 NY Queens
917 NY Staten Island
918 OK Bartlesville
918 OK Mcalester
918 OK Tulsa
919 NC Durham
919 NC Raleigh
920 WI Green Bay
920 WI Oshkosh
920 WI Sheboygan
925 CA Concord
925 CA Pleasanton
931 TN Clarksville
931 TN Columbia
931 TN Cookeville
931 TN Manchester
936 TX Huntsville
936 TX Lufkin
937 OH Dayton
937 OH Hillsboro
937 OH Springfield
940 TX Vernon
940 TX Wichita Falls
941 FL Fort Meyers
941 FL Naples
949 CA Irvine
949 CA Laguna Niguel
952 MN Bloomington
954 FL Fort Lauderdale
956 TX Brownsville
956 TX Mcallen
970 CO Fort Collins
970 CO Grand Junction
970 CO Steamboat Springs
971 OR Portland
971 OR Salem
972 TX Dallas
972 TX Plano
973 NJ Paterson
973 NJ Sussex
978 MA Fitchburg
978 MA Peabody
979 TX Wharton

 

[Arvin Meyer MVP]

I wrote one which has most of them, but it's old by now, so some of the area
codes are out of date. It also has zip codes. It's an Access 97 MDE and I no
longer have the original mdb to update anything. Right now it lives on Tony
Toews website:

http://www.granite.ab.ca/_download/zipcode.zip

 

[Arvin Meyer MVP]

Well, I scraped some data from a web site with a comma delimited list of
cities for given area codes. Below is the result, if anyone else is in
need of it. Probably not complete. It has 488 entries for the US.

The one I mentioned in an earlier post has somewhere around 80,000 cities
and towns.

 

[Paul Shapiro]

I think the definitive listings of area codes (assuming you're looking for
US/North America) is the North American Numbering Plan:
http://www.nanpa.com/index.html

I don't have a link to a specific list, but maybe you can find something
there.

 

[Danny J. Lesandrini]

Thanks, but I don't see a simple table download for Cities/Codes. That's
what I'm looking for. I'll keep poking around the site.

--
Danny J. Lesandrini
(e-mail address removed)
www.amazecreations.com

I think the definitive listings of area codes (assuming you're looking for US/North America) is the North American Numbering
Plan:
http://www.nanpa.com/index.html

I don't have a link to a specific list, but maybe you can find something there.

 

[Mr B]

Danny,

Here is a link to the download page of my askdoctoraccess website.

http://www.askdoctoraccess.com/downloadpage.htm

If you will scroll to the bottom of the page, there you can down load a
one-table database in Access 2002 format that has just over 15,000 zip codes
and the cities associated with them.

This list is by no means complete, but it is a good start.

--
HTH

Mr B
askdoctoraccess dot com

Thanks, but I don't see a simple table download for Cities/Codes. That's
what I'm looking for. I'll keep poking around the site.