The TV Database can be downloaded freely from:
https://forums.thetvdb.com/viewtopic.php?f=3&t=7550

It is a massive download at ~400MB and expands to ~2GB.

MariaDB [thetvdb]> select @rownum:=@rownum+1 as Num, res.* from (select @rownum:=0) r, (select id, SeriesName from tvseries where SeriesName like '%dallas%') res;
+------+--------+----------------------------------------------+
| Num  | id     | SeriesName                                   |
+------+--------+----------------------------------------------+
|    1 |  77092 | Dallas                                       |
|    2 |  79395 | Dallas Cowboys Cheerleaders: Making the Team |
|    3 |  79949 | Debbie Does Dallas Again                     |
|    4 |  80341 | Dallas SWAT                                  |
|    5 | 319215 | Little Women: Dallas                         |
|    6 | 203581 | Police Women of Dallas                       |
|    7 | 242521 | Dallas (2012)                                |
|    8 | 250374 | Most Eligible Dallas                         |
|    9 | 252679 | The A-List: Dallas                           |
|   10 | 269228 | John Borrowmans Dallas                      |
|   11 | 271452 | Dallas Car Sharks                            |
|   12 | 274997 | Courtney Loves Dallas                        |
|   13 | 307475 | The Real Housewives of Dallas                |
|   14 | 292986 | Donna Decorates Dallas                       |
|   15 | 293986 | Dallas Divas & Daughters                     |
+------+--------+----------------------------------------------+
15 rows in set (0.10 sec)

MariaDB [thetvdb]> select @rownum:=@rownum+1 as Num, res.* from (select @rownum:=0) r, (select id, SeriesName from tvseries where SeriesName like '%dallas%' order by id,SeriesName asc) res;
+------+--------+----------------------------------------------+
| Num  | id     | SeriesName                                   |
+------+--------+----------------------------------------------+
|    1 |  77092 | Dallas                                       |
|    2 |  79395 | Dallas Cowboys Cheerleaders: Making the Team |
|    3 |  79949 | Debbie Does Dallas Again                     |
|    4 |  80341 | Dallas SWAT                                  |
|    5 | 319215 | Little Women: Dallas                         |
|    6 | 203581 | Police Women of Dallas                       |
|    7 | 242521 | Dallas (2012)                                |
|    8 | 250374 | Most Eligible Dallas                         |
|    9 | 252679 | The A-List: Dallas                           |
|   10 | 269228 | John Borrowmans Dallas                      |
|   11 | 271452 | Dallas Car Sharks                            |
|   12 | 274997 | Courtney Loves Dallas                        |
|   13 | 307475 | The Real Housewives of Dallas                |
|   14 | 292986 | Donna Decorates Dallas                       |
|   15 | 293986 | Dallas Divas & Daughters                     |
+------+--------+----------------------------------------------+
15 rows in set (0.04 sec)

MariaDB [thetvdb]> select (@rn := @rn + 1) as Num, t.id, t.SeriesName from tvseries t cross join (select @rn := 0) params where t.SeriesName like '%dallas%' order by t.id asc;+------+--------+----------------------------------------------+
| Num  | id     | SeriesName                                   |
+------+--------+----------------------------------------------+
|    1 |  77092 | Dallas                                       |
|    2 |  79395 | Dallas Cowboys Cheerleaders: Making the Team |
|    3 |  79949 | Debbie Does Dallas Again                     |
|    4 |  80341 | Dallas SWAT                                  |
|    5 | 203581 | Police Women of Dallas                       |
|    6 | 242521 | Dallas (2012)                                |
|    7 | 250374 | Most Eligible Dallas                         |
|    8 | 252679 | The A-List: Dallas                           |
|    9 | 269228 | John Borrowmans Dallas                      |
|   10 | 271452 | Dallas Car Sharks                            |
|   11 | 274997 | Courtney Loves Dallas                        |
|   12 | 292986 | Donna Decorates Dallas                       |
|   13 | 293986 | Dallas Divas & Daughters                     |
|   14 | 307475 | The Real Housewives of Dallas                |
|   15 | 319215 | Little Women: Dallas                         |
+------+--------+----------------------------------------------+
15 rows in set (0.05 sec)