Nielsen DMA codes -- List of Regional Market Areas

Just doing some research for a database. Apparently the Nielsen rating company has divided the country up into a number of markets. Most of them are single metropolitan areas, but some cover wider areas across state lines.

The list of Designated Market Area (DMA) codes is available at this link:
http://www.stssamples.com/dma-codes.asp

And with states added, roughly translates to to this. (Check it to be sure)

500	Portland-Auburn	OR
501	New York	NY
502	Binghamton	NY
503	Macon	GA
504	Philadelphia	PA
505	Detroit	MI
506	Boston (Manchester)	MA
507	Savannah	GA
508	Pittsburgh	PA
509	Ft. Wayne	IN
510	Cleveland-Akron (Canton)	OH
511	Washington (Hagerstown)	DC
512	Baltimore	MD
513	Flint-Saginaw-Bay City	MI
514	Buffalo	NY
515	Cincinnati	OH
516	Erie	PA
517	Charlotte	NC
518	Greensboro-High Point-West Salem	NC
519	Charleston	SC
520	Augusta-Aiken	GA
521	Providence-New Bedford	RI
522	Columbus (Opelika)	GA
523	Burlington-Plattsburgh	VT
524	Atlanta	GA
525	Albany	GA
526	Utica	NY
527	Indianapolis	IN
528	Miami-Fort Lauderdale	FL
529	Louisville	KY
530	Tallahassee-Thomasville	FL
531	Tri-Cities	TN
532	Albany-Schenectady-Troy	NY
533	Hartford & New Haven	CT
534	Orlando-Daytona Beach-Melborn	FL
535	Columbus	OH
536	Youngstown	OH
537	Bangor	ME
538	Rochester	NY
539	Tampa-Saint Petersburg (Sarasota)	FL
540	Traverse City-Cadillac	MI
541	Lexington	KY
542	Dayton	OH
543	Springfield-Holyoke	MA
544	Norfolk-Portsmth-Newpt News	VA
545	Greenville-North Bern-Washington	NC
546	Columbia	SC
547	Toledo	OH
548	West Palm Beach-Fort Pierce	FL
549	Watertown	NY
550	Wilmington	DE
551	Lansing	MI
552	Presque Isle	PA
553	Marquette	WI
554	Wheeling-Steubenville	WV
555	Syracuse	NY
556	Richmond-Petersburg	VA
557	Knoxville	TN
558	Lima	OH
559	Bluefield-Beckley-Oak Hill	WV
560	Raleigh-Durham (Fayetville)	NC
561	Jacksonville	FL
563	Grand Rapids-Kalamazoo-Battle Creek	MI
564	Charleston-Huntington	SC
565	Elmira (Corning)	NY
566	Harrisburg-Lancaster-Lebanon-York	PA
567	Greenville-Spartanburg-Asheville-Anderson	NC
569	Harrisonburg	VA
570	Myrtle Beach-Florence	SC
571	Ft. Myers-Naples	FL
573	Roanoke-Lynchburg	VA
574	Johnstown-Altoona-Saint College	PA
575	Chattanooga	TN
576	Salisbury	MD
577	Wilkes Barre-Scranton-Hazelton	PA
581	Terre Haute	IN
582	Lafayette	IN
583	Alpena	MI
584	Charlottesville	VA
588	South Bend-Elkhart	IN
592	Gainesville	FL
596	Zanesville	OH
597	Parkersburg	WV
598	Clarksburg-Weston	WV
600	Corpus Christi	TX
602	Chicago	IL
603	Joplin-pittsburg	MO
604	Columbia-Jefferson City	SC
605	Topeka	KA
606	Dothan	AL
609	St. Louis	MO
610	Rockford	IL
611	Rochester-Mason City-Austin	IL
612	Shreveport	LA
613	Minneapolis-Saint Paul	MN
616	Kansas City	KA
617	Milwaukee	WI
618	Houston	TX
619	Springfield	MO
622	New Orleans	LA
623	Dallas-Fort Worth	TX
624	Sioux City	IA
625	Waco-temple-bryan	TX
626	Victoria	TX
627	Wichita Falls & Lawton	KA
628	Monroe-El Dorado	AR
630	Birmingham (Anniston and Tuscaloosa)	AL
631	Ottumwa-Kirksville	IA
632	Paducah-Cape Girard-Harrisburg	KY
633	Odessa-Midland	TX
634	Amarillo	TX
635	Austin	TX
636	Harlingen-Weslasco-brnsvl-mca	TX
637	Cedar Rapids-Wtrlo-Iwc&Dub	IA
638	St. Joseph	MO
639	Jackson	TN
640	Memphis	TN
641	San Antonio	TX
642	Lafayette	LA
643	Lake Charles	LA
644	Alexandria	LA
647	Greenwood-Greenville	MS
648	Champaign and Springfield-Decatur	IL
649	Evansville	IN
650	Oklahoma City	OK
651	Lubbock	TX
652	Omaha	NE
656	Panama City	FL
657	Sherman-Ada	TX
658	Green Bay-Appleton	WI
659	Nashville	TN
661	San Angelo	TX
662	Abilene-sweetwater	TX
669	Madison	WI
670	Fort Smith-Fay-Sprngdl-Rgrs	AR
671	Tulsa	OK
673	Columbus-Tupelo-West Point-Hstn	OH
675	Peoria-Bloomington	IL
676	Duluth-Superior	MN
678	Wichita-Hutchinson Plus	KA
679	Des Moines-Ames	IA
682	Davenport-Rock Island-Moline	IL
686	Mobile-Pensacola (Fort Walt)	AL
687	Minot-Bismarck-Dcknsn(Wlstn)	ND
691	Huntsville-Decatur	AL
692	Beaumont-Port Arthur	TX
693	Little Rock-Pine Bluff	AR
698	Montgomery-Selma	AL
702	La Crosse-Eau Claire	WI
705	Wausau-Rhinelander	FL
709	Tyler-Longview(Lfkn&Ncgd)	TX
710	Hattiesburg-Laurel	MS
711	Meridian	ID
716	Baton Rouge	LA
717	Quincy-Hannibal-Keokuk	IL
718	Jackson	MS
722	Lincoln & Hastings-Krny	NE
724	Fargo-Valley City	ND
725	Sioux Falls (Mitchell)	SD
734	Jonesboro	AR
736	Bowling Green	KY
737	Mankato	MN
740	North Platte	NE
743	Anchorage	AK
744	Honolulu	HI
745	Fairbanks	AK
746	Biloxi-Gulfport	MI
747	Juneau	AK
749	Laredo	TX
751	Denver	CO
752	Colorado Springs-Pueblo	CO
753	Phoenix (Prescott)	AZ
754	Butte-Bozeman	MT
755	Great Falls	MT
756	Billings	MT
757	Boise	ID
758	Idaho Falls-Pocatllo (Jackson)	ID
759	Cheyenne-Scottsbluff	WY
760	Twin Falls	ID
762	Missoula	MT
764	Rapid City	SD
765	El Paso (Las Cruces)	TX
766	Helena	MT
767	Casper-Riverton	WY
770	Salt Lake City	UT
771	Yuma-El Centro	AZ
773	Grand Junction-Montrose	CO
789	Tucson (Sierra Vista)	AZ
790	Albuquerque-Santa Fe	NM
798	Glendive	MT
800	Bakersfield	CA
801	Eugene	OR
802	Eureka	OR
803	Los Angeles	CA
804	Palm Springs	CA
807	San Francisco-Oakland-San Jose	CA
810	Yakima-Pasco-Richland-knnwck	WA
811	Reno	NV
813	Medford-Klamath Falls	OR
819	Seattle-Tacoma	WA
820	Portland	OR
821	Bend	OR
825	San Diego	CA
828	Monterey-Salinas	CA
839	Las Vegas	NV
855	Santabarbra-Sanmar-Sanluob	CA
862	Sacramento-Stockton-Modesto	CA
866	Fresno-Visalia	CA
868	Chico-Redding	CA
881	Spokane	WA