Fix W213CB Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'COVINGTON' and State = 'KY'

Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
cities	ref	CityName	CityName	53	const	12	Using where

Number of rows returned = 1
Start: 1754152289.242
End: 1754152289.2422
Elapsed time: 0.2270 ms 1 records found!
id State CityName RuralArea PopCount Population Latitude Longitude PrimaryAC ZoneDesc EartlinkDSL ISPCount CovadDSL VerizonDSL allegiance SBC RateCenterCityid Population2000 FIPS cTZoffset DST DMAID
6938 KY Covington 0 154 43264 39.065111 -84.509594 859 0 0 0 0 0 6938 43370 2117848 -5 -1 28

*** city ***************

NULL

****** zip code ************

array(13) { ["zipcode"]=> string(5) "41011" ["zip3"]=> string(3) "410" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "COVINGTON" ["zipstate"]=> string(2) "KY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.08" ["iplongitude"]=> string(5) "-84.5" ["ziplocation"]=> string(18) "NA-US-KY-COVINGTON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "12140" ["zippopulation"]=> string(5) "18593" ["zipincome"]=> string(7) "8388607" }

******* zip3 ***********

array(3) { ["zip3"]=> string(3) "410" ["zipcity"]=> string(8) "FLORENCE" ["zipstate"]=> string(2) "KY" }

**** zip3 city**************

array(22) { ["id"]=> string(5) "35645" ["State"]=> string(2) "KY" ["CityName"]=> string(8) "Florence" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "18624" ["Latitude"]=> string(9) "38.993225" ["Longitude"]=> string(10) "-84.642602" ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> NULL ["Population2000"]=> string(5) "23551" ["FIPS"]=> string(7) "2127982" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "28" }

**** cities in DMA per station **************

No Rows in Recordset!

***** cities in DMA by city *************

23 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
14128	OH	Cincinnati	0	354	364040	39.13616	-84.503088	513		0		0	0	0	0	14128	331285	3915000	-5	-1	28
14275	OH	Hamilton	0	155	61368	39.395806	-84.56492	513		0		0	0	0	0	14275	60690	3933012	-5	-1	28
14424	OH	Middletown	0	234	46022	39.506007	-84.375885	513		0		0	0	0	0	14424	51605	3949840	-5	-1	28
6938	KY	Covington	0	154	43264	39.065111	-84.509594	859		0		0	0	0	0	6938	43370	2117848	-5	-1	28
14205	OH	Fairfield	-1	0	39729	39.331156	-84.542842	513		0		0	0	0	0		42097	3925970	-5	-1	28
14532	OH	Oxford	0	114	18937	39.507452	-84.746552	513		0		0	0	0	0	14532	21943	3959234	-5	-1	28
35720	KY	Newport	-1	0	18871	39.088661	-84.490206			0		0	0	0	0		17048	2155884	-5	-1	28
35645	KY	Florence	-1	0	18624	38.993225	-84.642602			0		0	0	0	0		23551	2127982	-5	-1	28
14420	OH	Miamisburg	0	0	17834	39.638525	-84.27528	937		0		0	0	0	0		19489	3949434	-5	-1	28
35649	KY	Fort Thomas	-1	0	16032	39.076011	-84.451273			0		0	0	0	0		16495	2128594	-5	-1	28
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
35635	KY	Erlanger	-1	0	15979	39.013511	-84.594042			0		0	0	0	0		16676	2125300	-5	-1	28
14344	OH	Lebanon	-1	80	10453	39.426724	-84.212631	513		0		0	0	0	0	14344	16962	3942364	-5	-1	28
14193	OH	Eaton	-1	50	7396	39.747603	-84.633818	937		0		0	0	0	0	14193	8133	3924234	-5	-1	28
7081	KY	Maysville	-1	57	7169	38.64392	-83.77589	606		0		0	0	0	0	7081	8993	2151024	-5	-1	28
6946	KY	Cynthiana	-1	58	6497	38.388292	-84.296841	859		0		0	0	0	0	6946	6258	2119432	-5	-1	28
14426	OH	Milford	-1	0	5660	39.174883	-84.284383	513		0		0	0	0	0		6284	3950176	-5	-1	28
6921	KY	Carrollton	-1	90	3715	38.677329	-85.171504	502		0		0	0	0	0	6921	3846	2113024	-5	-1	28
6980	KY	Flemingsburg	-1	35	3071	38.420541	-83.737581	606		0		0	0	0	0	6980	3010	2127856	-5	-1	28
7214	KY	Williamstown	0	103	3023	38.641184	-84.56092	859		0		0	0	0	0	7214	3227	2183406	-5	-1	28
6971	KY	Falmouth	0	81	2378	38.67386	-84.334213	859		0		0	0	0	0	6971	2058	2126434	-5	-1	28
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
14716	OH	Waynesville	-1	0	1949	39.532037	-84.08646	513		0		0	0	0	0	14716	2558	3982418	-5	-1	28
35625	KY	Crittenden	-1	0	731	38.782248	-84.605794			0		0	0	0	0		2401	2118568	-5	-1	28
14721	OH	West Chester	-1	0		39.440956	-84.575746	513		0		0	0	0	0				-5	-1	28

**** cities in zip3 **************

52 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
41042	FLORENCE	KY	40441	Florence	28
41017	FT MITCHELL	KY	34850
41018	ERLANGER	KY	23049	Erlanger	28
41051	INDEPENDENCE	KY	22044	Independence
41011	COVINGTON	KY	18593	Covington	28
41005	BURLINGTON	KY	18294	Burlington
41015	LATONIA	KY	16948
41091	UNION	KY	15060	Union
41001	ALEXANDRIA	KY	14345	Alexandria
41071	NEWPORT	KY	14293	Newport	28
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
41075	FORT THOMAS	KY	13767	Fort Thomas	28
41076	NEWPORT	KY	13065	Newport	28
41031	CYNTHIANA	KY	12947	Cynthiana	28
41048	HEBRON	KY	12047
41056	MAYSVILLE	KY	11034	Maysville	28
41094	WALTON	KY	10032	Walton
41035	DRY RIDGE	KY	8779	Dry Ridge
41040	FALMOUTH	KY	5869	Falmouth	28
41008	CARROLLTON	KY	5851	Carrollton	28
41041	FLEMINGSBURG	KY	5645	Flemingsburg	28
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
41097	WILLIAMSTOWN	KY	5283	Williamstown	28
41030	CRITTENDEN	KY	5021	Crittenden	28
41014	COVINGTON	KY	4909	Covington	28
41016	COVINGTON	KY	4698	Covington	28
41073	BELLEVUE	KY	4685	Bellevue
41074	DAYTON	KY	3958	Dayton
41006	BUTLER	KY	3692	Butler
41007	CALIFORNIA	KY	3431	California
41004	BROOKSVILLE	KY	3236	Brooksville
41095	WARSAW	KY	3067	Warsaw
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
41092	VERONA	KY	2977
41063	MORNING VIEW	KY	2575
41010	CORINTH	KY	2477	Corinth
41059	MELBOURNE	KY	2316	Melbourne
41039	EWING	KY	2091	Ewing
41003	BERRY	KY	2054	Berry
41093	WALLINGFORD	KY	1957
41002	AUGUSTA	KY	1898	Augusta
41033	DE MOSSVILLE	KY	1717
41049	HILLSBORO	KY	1670	Hillsboro
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
41080	PETERSBURG	KY	1565
41043	FOSTER	KY	1532	Foster
41064	MOUNT OLIVET	KY	1505	Mount Olivet
41086	SPARTA	KY	1502	Sparta
41055	MAYSLICK	KY	1454	Mayslick
41046	GLENCOE	KY	1406	Glencoe
41098	WORTHVILLE	KY	1365	Worthville
41045	GHENT	KY	1016	Ghent
41083	SANDERS	KY	927	Sanders
41044	GERMANTOWN	KY	881	Germantown
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
41034	DOVER	KY	840	Dover
41052	JONESVILLE	KY	0

Station W213CB-FX

City COVINGTON-KY

City , is located in DMAID: