Radio Stations

W3.CSS Template

W3.CSS Template

OUR RADIO STATIONS TO VIEW AND TUNE-IN..

THE TEAM OF THE RADIO STATION

Radio Country Worldwide

Where would contemporary country be today without old country songs? We don't want to even think about it, so instead we're simply going to enjoy five decades of the finest country music to ever be written. From Waylon to Willie, Dolly to Loretta, this is a who's who of country music Hall of Famers. See the full tracklist for Holler's Classic Country Songs Playlist below:

1. Glen Campbell - Wichita Lineman

2. Dolly Parton - Coat of Many Colors

3. Tom T. Hall - That's How I Got To Memphis

4. John Denver - Take Me Home, Country Roads

5. Waylon Jennings & Willie Nelson - Mammas Don't Let Your Babies Grow up to Be Cowboys

6. George Strait - Check Yes or No

7. Conway Twitty & Loretta Lynn - Louisiana Woman, Mississippi Man

8. The Highwaymen - American Remains

9. Johnny Cash - I Walk The Line

10. Townes Van Zandt - Poncho & Lefty

11. George Jones - Tennessee Whiskey

12. Merle Haggard - Mama Tried

13. The Carter Family - Can the Circle Be Unbroken

14. Johnny Paycheck - Take This Job and Shove It

15. Dwight Yoakam - Fast As You

16. The Highwaymen - Highwayman

17. Eddy Arnold - Cowpoke

18. Jeannie C. Riley - Harper Valley P.T.A

19. Bobbie Gentry - Ode To Billie Joe

20. Tammy Wynette - Stand By Your Man

21. Alan Jackson - Chattahoochee

22. Charley Pride - Is Anybody Goin' to San Antone?

23. Lynn Anderson - Rose Garden

24. Charlie Rich - The Most Beautiful Girl

25. Ronnie Milsap - I wouldn't Have Missed It For The World

26. The Charlie Daniels Band - Long Haired Country Boy

27. Emmylou Harris - Boulder to Birmingham

28. Alabama - I'm in a Hurry (And Don't Know Why)

29. Lee Greenwood - God Bless The U.S.A

30. Hank Williams Jr - A Country Boy Can Survive

31. Vince Gill - Go Rest High On That Mountain

32. Tanya Tucker - Delta Dawn

33. Kenny Rogers - The Gambler

34. Buck Owens - Act Naturally

35. Don Williams - It Must Be Love

36. Nitty Gritty Dirt Band - Fishin' in the Dark

37. Eddie Rabbitt - I Love a Rainy Night

38. Billie Jo Spears - '57 Chevrolet

39. Linda Martell - Color Him Father

40. Jessi Colter - Why You Been Gone so Long

41. Gram Parsons - Love Hurts

42. Billy Joe Shaver - Old Five and Dimers Like Me

43. Kinky Friedman - Sold American

44. Porter Wagoner - The Carroll Country Accident

45. Jesse Winchester - The Brand New Tennessee Waltz

46. Jerry Jeff Walker - Pissin' In the Wind

47. David Allan Coe - Longhaired Redneck

48. Guy Clark - New Cut Road

49. Terry Allen - Amarillo Highway (for Dave Hickey)

50. Tompall & The Glaser Brothers - Lovin' Her Was Easier

51. Ernest Tubb - Walking The Floor Over You

52. Lefty Frizzell - Saginaw, Michigan

53. Stonewall Jackson - Waterloo

54. Jerry Reed - She Got the Goldmine (I Got The Shaft)

55. Connie Smith - If It Ain't Love (Let's Leave It Alone)

56. Little Jimmy Dikens - May the Bird of Paradise Fly Up Your Nose

57. Johnny Horton - The Battle of New Orleans

58. Marty Robbins - Big Iron

59. Henson Cargill - Skip A Rope

60. The Statler Brothers - Hello Mary Lou

61. Ricky Skaggs - Highway 40 Blues

62. The Oak Ridge Boys - Leaving Louisiana In Broad Daylight

63. Buck Owens - My Heart Skips A Beat

64. Crystal Gayle - Don't It Make My Brown Eyes Blue

65. Dolly Parton & Kenny Rogers - Islands In the Stream

66. Roger Miller - King Of The Road

67. Don Williams - Tulsa Time

68. Larry Gatlin & The Gatlin Brothers - All the Gold In California

69. Porter Wagoner & Dolly Parton - The Last Thing On My Mind

70. Dave Dudley - Six Days On The Road

71. Emmylou Harris - Two More Bottles of Wine

72. The Bellamy Brothers - Let Your Love Flow

73. Bobby Bare - Marie Laveau

74. Ray Stevens - Misty

75. Webb Pierce - There Stands The Glass

76. Red Foley - Chattanoogie Shoe Shine Boy

77. The Bellamy Brothers - Old Hippie

78. Ernest Tubb - Waltz Across Texas

79. Shenandoah - Sunday In the South

80. Mac Davis - Stop and Smell The Roses

81. Rosanne Cash - Tennessee Flat Top Box

82. Jimmy Dean - Big Bad John

83. John Anderson - I'm Just an Old Chunk of Coal (But I'm Gonna Be a Diamond)

84. Lacy J. Dalton - 16th Avenue

85. David Allan Coe - You Never Even Called Me by My Name

86. Jerry Reed - East Bound and Down

87. C.W. McCall - Convoy

88. Ray Price - For the Good Times

89. Toby Keith - I Should've Been A Cowboy

90. John Michael Montgomery - Sold (The Grundy County Auction Incident)

91. David Lee Murphy - Dust On The Bottle

92. Mark Chesnutt - Bubba Shot The Jukebox

93. Waylon Jennings - Luckenbach, Texas (Back to the Basics of Love)

94. Hank Williams & Drifting Cowboys - Jambalaya (On the Bayou)

95. Kris Kristofferson - Me and Bobby McGee

96. Conway Twitty - Hello Darlin'

97. Johnny Cash & June Carter Cash - Jackson

98. Kitty Wells - It Wasn't God Who Made Honky Tonk Angels

99. George Strait - Amarillo By Morning

100. Merle Haggard - Okie From Muskogee

Take a journey through the decades with our country list of 100 of the most popular country songs of all time - hits that have been crossover sensations, covered hundreds of times, or that were, quite simply, standalone bangers.

1. Man! I Feel Like A Woman! - Shania Twain

2. Before He Cheats - Carrie Underwood

3. Jolene - Dolly Parton

4. Ring of Fire - Johnny Cash

5. Islands In the Stream - Dolly Parton, Kenny Rogers

6. Need You Now - Lady A

7. Wagon Wheel - Darius Rucker

8. Take Me Home, Country Roads - John Denver

9. Dance The Night Away - The Mavericks

10. Love Story (Taylor's Version) - Taylor Swift

11. Always on My Mind - Willie Nelson

12. Achy Breaky Heart - Billy Ray Cyrus

13. He Stopped Loving Her Today - George Jones

14. Lookin' for Love - Johnny Lee

15. Here You Come Again - Dolly Parton

16. Chicken Fried - Zac Brown Band

17. The Gambler - Kenny Rogers

18. You're Still The One - Shania Twain

19. Miami, My Amy - Kieth Whitley

20. Rhinestone Cowboy - Glen Campbell

21. Crazy - Patsy Cline, The Jordanaires

22. I Will Always Love You - Dolly Parton

23. Fancy - Reba McEntire

24. Chattahoochee - Alan Jackson

25. Girl Crush - Little Big Town

26. Don't It Make My Brown Eyes Blue - Crystal Gale

27. Boot Scootin' Boogie - Brooks & Dunn

28. Cowboy Take Me Away - The Chicks

29. Let Your Love Flow - The Bellamy Brothers

30. Stand By Your Man - Tammy Wynette

31. That Don't Impress Me Much - Shania Twain

32. Old Town Road - Lil Nas X

33. Cotton Eye Joe - Rednex

34. The Devil Went Down to Georgia - The Charlie Daniels Band

35. I Walk the Line - Johnny Cash

36. Follow Your Arrow - Kacey Musgraves

37. 9 to 5 - Dolly Parton

38. King Of The Road - Roger Miller

39. Ode To Billy Joe - Bobbie Gentry

40. All I Wanna Do - Sheryl Crow

41. Wichita Lineman - Glen Campbell

42. Mama Tried - Merle Haggard & The Stangers

43. Mammas Don't Let Your Babies Grow Up To Be Cowboys - Waylon Jennings, Willie Nelson

44. Love Hurts - Gram Parsons

45. Independence Day - Martina McBride

46. Seven Year Ache - Rosanne Cash

47. Guitars, Cadillacs - Dwight Yoakam

48. All My Ex's Live In Texas - George Strait

49. Jambalaya (On The Bayou) - Hank Williams, Drifting Cowboys

50. Coward Of The County - Kenny Rogers

51. The Most Beautiful Girl - Charlie Rich

52. Banks Of The Ohio - Olivia Newton-John

53. A Boy Named Sue - Johnny Cash

54. The End of the World - Skeeter Davis

55. Distant Drums - Jim Reeves

56. When You're In Love With A Beautiful Woman - Dr. Hook

57. From A Distance - Nanci Griffith

58. Tennessee Whiskey - Chris Stapleton

59. Hurt - Johnny Cash

60. I Love This Bar - Toby Keith

61. Our Song - Taylor Swift

62. Coat of Many Colors - Dolly Parton

63. All I Have to Do Is Dream - The Everly Brothers

64. When You Say Nothing at All - Keith Whitley

65. Dixieland Delight - Alabama

66. Don't Take The Girl - Tim McGraw

67. How Do I Live - LeAnn Rimes

68. Whiskey Lullaby - Brad Paisley, Alison Krauss

69. Bad Moon Rising - Creedence Clearwater Revival

70. By The Time I Get To Phoenix - Glen Campbell

71. Live Like You Were Dying - Tim McGraw

72. My Church - Maren Morris

73. Church Bells - Carrie Underwood

74. Help Me Make It Through The Night - Sammi Smith

75. I'll Be Your Baby Tonight - Bob Dylan

76. Sweet Home Alabama - Lynyrd Skynyrd

77. Highwayman - The Highwaymen

78. Annie's Song - John Denver

79. Rose Garden - Lynn Anderson

80. Okie From Muskogee - Merle Haggard

81. Beautiful Crazy - Luke Combs

82. Over And Over - Nelly, Tim McGraw

83. Bless The Broken Road - Rascal Flatts

84. Home - Blake Shelton

85. Country Girl (Shake It For Me) - Luke Bryan

86. Drunk On A Plane - Dierks Bentley

87. Dirt Road Anthem - Jason Aldean

88. Copperhead Road - Steve Earle

89. Closer to Fine - Indigo Girls

90. Goodbye Earl - The Chicks

91. Angel Of The Morning - Juice Newton

92. Theme from The Dukes of Hazzard - Waylon Jennings

93. I Am A Man Of Constant Sorrow - The Soggy Bottoms

94. Your Cheatin' Heart - Hank Williams, Drifting Cowboys

95. Jackson - Johnny Cash, June Carter Cash

96. These Boots Are Made for Walkin' - Nancy Sinatra

97. All My Rowdy Friends Are Coming Over Tonight - Hank Williams, Jr

98. Drink In My Hand - Eric Church

99. East Bound and Down - Jerry Reed

100. Don't Come Home A-Drinkin' (With Lovin' On Your Mind) - Loretta Lynn

We've got a hefty selection of brand-new bangers that have been released on our Best New Country 2023 playlist.There's nothing like a New Music Friday. Every week we wait patiently for that fresh batch of new tunes from our favourite superstars and fast-rising acts. Whether it's Miranda Lambert or Ashley McBryde, BRELAND or Eric Church, we all want to dig in and get our dose of brand-new music.It's been a packed week for new releases! Our featured artist for the second week of January is Margo Price. With the release of her new album Strays, Modern Outlaw's finest has reunited the Price Tags for an extraordinary and pulsating album of psychedelic Americana.Alongside Price, we've got new songs from Ian Munsick, Alana Springsteen, Drayton Farley and so many more!

1. Margo Price & Sharon Van Etten - Radio

2. Ian Munsick - River Run

3. Alana Springsteen - you don't deserve a country song

4. Drayton Farley - Norfolk Blues

5. Callista Clark & Jimmie Allen - Wish You Wouldn't

6. Wyatt Flores - Break My Bones

7. Priscilla Block - Me Pt.2

8. George Birge - Cowboys Talkin'

9. Jordana Bryant - Can I Get It Back

10. Dierks Bentley - Same Ol' Me

11. Walker County - Mirror Mirror

12. Griffen Palmer - Second Guessing

13. Royale Lynn - Runs in the Water

14. Chris Young - Looking for You

15. High Valley & Alison Krauss - Do This Life

16. Old Dominion - Ain't Got a Worry

17. Blanco Brown - I'll Never

The 60s - a decade that saw Loretta Lynn sign her first ever record deal, the Country Music Hall of Fame and Museum open in Nashville and the first-ever CMA Awards ceremony. It was all going on, and the music was on fire! Here's Holler's selection of 100 of the best country songs from the decade.

1. Jackson - Nancy Sinatra, Lee Hazlewood

2. Ring of Fire - Johnny Cash

3. Harper Valley P.T.A - Jeannie C. Riley

4. Kay - John Wesley Ryles, I

5. Just Because I'm A Woman - Dolly Parton

6. Skip a Rope - Henson Cargill

7. Mama Tried - Merle Haggard

8. Only Daddy That'll Walk the Line - Waylon Jennings

9. Gentle On My Mind - Glen Campbell

10. Stand By Your Man - Tammy Wynette

11. Ode To Billie Joe - Bobbie Gentry

12. Just Between You and Me - Charley Pride

13. Homecoming - Tom T. Hall

14. Crazy - Patsy Cline, The Jordanaires

15. Hello Walls - Faron Young

16. The Race Is On - George Jones

17. May the Bird of Paradise Fly Up Your Nose - Little Jimmy Dickens

18. King Of The Road - Roger Miller

19. Big Bad John - Jimmy Dean

20. Saginaw, Michigan - Lefty Frizzell

21. Act Naturally - Buck Owens

22. She Thinks I Still Care - George Jones

23. The Carroll Country Accident - Porter Wagoner

24. Don't Touch Me - Jeannie Seely

25. (Margie's At) The Lincoln Park Inn - Bobby Bare

26. The Last Thing On My Mind - Porter Wagoner, Dolly Parton

27. Once a Day - Connie Smith

28. Wine Me Up - Faron Young

29. Don't Come Home A-Drinkin' (With Lovin' On Your Mind) - Loretta Lynn

30. I Fall To Pieces - Patsy Cline, The Jordanaires

31. D-I-V-O-R-C-E - Tammy Wynette

32. Six Days On The Road - Dave Dudley

33. A Six Pack To Go - Hank Thompson

34. Okie From Muskogee - Merle Haggard

35. Touch Me - Willie Nelson

36. My Big Iron Skillet - Wanda Jackson

37. Dang Me - Roger Miller

38. Folsom Prison Blues - Johnny Cash

39. Wichita Lineman - Glen Campbell

40. Eleven Roses - Hank Williams, Jr.

41. Walk Through This World With Me - George Jones

42. Sea of Heartbreak - Don Gibson

43. It's Such A Pretty World Today - Wynn Stewart

44. I've Got A Tiger By The Tail - Buck Owens

45. Bright Lights and Country Music - Bill Anderson

46. I've Been Everywhere - Hank Snow

47. Pop a Top - Jim Ed Brown

48. Phantom 309 - Red Sovine

49. Flowers On the Wall - The Statler Brothers -

50. Almost Persuaded - David Houston

51. Burning Memories - Ray Price

52. Still - Bill Anderson

53. Chug-A-Lug - Roger Miller

54. Don't You Ever Get Tired of Hurting Me - Ray Price

55. Statue of a Fool - Jack Greene

56. Walk On By - Leroy Van Dyke

57. Ribbon of Darkness - Marty Robbins

58. Crystal Chandelier - Carl Belew

59. I Wouldn't Buy a Used Car from Him - Norma Jean

60. The Bridge Washed Out - Warner Mack

61. Distant Drums - Jim Reeves

62. Stateside - Mel Tillis

63. Me & Mr. Hohner - Bobby Darin

64. The Weight - Jackie DeShannon

65. Don't Let Me Down - Dillard & Clark

66. LA - Memphis - Tyler - Dale Hawkins

67. Detroit City - Bobby Bare

68. We'll Get Ahead Someday - Porter Wagoner, Dolly Parton

69. Yakety Axe - Chet Atkins

70. The End of the World - Skeeter Davis

71. Send Me The Pillow You Dream On - Johnny Tillotson

72. Honey - Bobby Goldsboro

73. Wolverton Mountain - Claude King

74. The Rubber Room - Porter Wagoner

75. Brown Eyed Handsome Man - Waylon Jennings

76. Abilene - George Hamilton IV

77. Streets Of Bakersfield - Buck Owens

78. Drug Store Truck Drivin' Man - The Byrds

79. Up On Cripple Creek - The Band

80. Sin City - The Flying Burrito Brothers

81. Galveston - Glen Campbell

82. Rings of Gold - Dottie West, Don Gibson

83. Just Someone I Used to Know - Porter Wagoner, Dolly Parton

84. Life Has Its Little Ups and Downs - Charlie Rich

85. Next In Line - Conway Twitty

86. Kansas City Star

87. A Tombstone Every Mile - Dick Curless

88. Dumb Blonde - Dolly Parton

89. A Boy Named Sue - Johnny Cash

90. Wings Of a Dove - Ferlin Husky

91. The Game of Triangles - Bobby Bare, Norma Jean, Liz Anderson

92. Charlie's Shoes - Billy Walker

93. The Ballad of Jed Clampett - Lester Flatt, Earl Scruggs

94. We Must Have Been Out Of Our Minds - George Jones, Melba Montgomery

95. There Goes My Everything - Jack Greene

96. Laura (What's He Got That I Ain't Got) - Leon Ashley

97. Your Good Girl's Gonna Go Bad - Tammy Wynette

98. By The Time I Get To Phoenix - Glen Campbell

99. How Does That Grab You, Darlin'? - Nancy Sinatra

100. Girl from the North Country - Bob Dylan, Johnny Cash

RADIO INTERNATIONAL MUSIC GERMANY

SAM BROADCASTER GERMANY

RADIO SAM GERMANY	RADIO SAM BROADCASTER GERMANY	RADIO TOP TEN GERMANY	RADIO SAM STEREO GERMANY	RADIO EENDRAG GERMANY
RADIO VOORTREKKER STEREO	SAM-LIVE GERMANY	RADIO SPRINGBOK GERMANY	RADIO GBM-LIVE GERMANY	RADIO AFRIKAANS STEREO
RADIO SAM COUNTRY GERMANY	RADIO SAM BROADCASTING STUDIOS	RADIO BOERVOLK STEREO GERMANY	RADIO SAM OLDIES-ROCK	RADIO AFRIKAANS STUDIOS

Why All Country Music Sounds the Same

Hypothesize

I hypothesize that all country music sounds the same because of similiarities in the components of songs. Specifically, because many country music songs are composed with vocals and guitar, the way the guitar is played and the kinds of lyrics used in the songs may be key components in determining whether or not all country music does sound similar. The way the guitar is played can be determined by the chord progression, and I hypothesize that many country songs all use the same chord progession, whereas in other genres of music, there will be a greater variation of the chord progressions used in songs. I also suspect that the lyrics have some similarity in the words used and a naive-Bayes analysis may be suitable.

The complete code can be found on github here.

Method

A chord progression is the different chords used in songs, as well as the order in which they are used. For example Pearl Jam's 'Elderly woman...' uses a chord progression D C G G for the much of the verse and chorus. Both the notes used and their respective order is needed. The assumption that the guitar plays the characteristic 'sound' of the song and can be infered from the data gained from the chord progression of the guitar.

A python webscraper mines guitar tabluture from the internet, specifically ultimate-guitar.com and reads them to obtain the chords used in songs. The python code retrives the chords that users of the site have entered. Because the guitar tablature is user submitted, only 5 star rated tablatures are used in standard tuning, for greatest accuracy. A 5 star rating is achieved when all users of the tablature rate the tab as 5-star. Mining the tablature for data on the various chord progressions played in songs, the end goal would be analyze different genres of music to show that country music shows less variation in the chords and chord progressions used compared to other genres of music.

Guitar tablature Example

See here ▼

Below is an example of typical guitar tablature from ultimate-guitar.com

Band- Metallica
Song- TuesdAYS gONE
 
  A5                   E5                   F#5                   D
      x 0 2 2 x x          0 2 2 x x x          2 4 4 x x x          x x 0 2 3 2
 
         Dsus4                Dsus2                  G                   F#m
      x x 0 2 3 3          x x 0 2 3 0          3 2 0 0 3 3          2 4 4 2 2 2
 
         GIII
      3 5 5 4 3 3
 
Gtr I (Eb Ab Db Gb Bb Eb) - 'acoustic'
Gtr II (Eb Ab Db Gb Bb Eb) - 'dobro'
Gtr III (Eb Ab Db Gb Bb Eb) - 'acoustic'
Gtr IV (Eb Ab Db Gb Bb Eb) - 'acoustic'
 
 Intro
  Slowly H.=50
                   A5                                 E5
 3/4
  Gtr I
                    |           |                      |    ||
                    /           /                      /    //
 
  Gtr II
                                                       ~~
|-------|-------||-----------|----------------------|------------|
|-------|-------||-14--------|-14------14b16r=(14)--|-12---------|
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|----------------------|------------|
|
| Gtr III
|                                                      ~~
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|----------------------|------------|
|-------|-------||-11--------|-11b13r=(11)----------|--9---------|
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|----------------------|------------|
|
| Gtr IV
|-------|-------||-----------|----------------------|------------|
|-------|-------||-----------|--2-------------------|------------|
|-------|-------||--------2--|----------2-----------|------------|
|-------|-------||-----2-----|------------------2---|--------2---|
|-------|-------||--0--------|----------------------|-----2------|
|-------|-------||-----------|----------------------|--0---------|
 
 
                    F#5                                   D
  |        |  |      |         ||    |        |     |     |  | || |
  /        /  /      /         //    /        /     /     /  / // /
 
                        ~~~~~~~                           ~
|-----------------|----------------|--------------------|----------|
|----12b13r=(12)--|-12-10-(10)-----|----10b12r====(10)--|-7--------|
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|----------|
|
|                    ~~                                   ~
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|----------|
|-----9b10r==(9)--|--7-------------|----------7b9r=(7)--|-4--------|
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|----------|
|
|                    PM---------------------------|
|-----------------|----------------|--------------------|----------|
|-----------------|----------------|--------------------|-------3--|
|-1---------------|----------------|-2------------------|----2-----|
|-----2-----------|-------------4--|-----4--------------|-0--------|
|-------------2---|---------4------|----------------4---|----------|
|-----------------|--2-------------|--------------------|----------|

The python webscraper built goes through all the tabs of a particular genre and grabs all the chords played in the song. The chord progression is obtained by simply finding the 4-chord combination that is most common. This chord progression is then added to an SQL database, along with the artist name, song title genre and subgenre. An example of sub-genre to a genre is bluegrass, which is a sub-genre to country. This relationship was taken from exploring how ultimate-guitar.com specifies. Once database of all the chord progressions is obtained, a subsection can be queried from the list, i.e. accouding to subgenre, and it is sorted and plotted. A cumulative distribution is also obtained from the sorted list and is useful for determining global variation.

SQL Query Example

Accessing top 10 most frequent Americana chords

Query

Joins the appropriate tables in the database.

Filter by subgenre.

Group by chord progression.

Order by their total count, descending.

Select appropriate columns.

See here ▼

# -*- coding: utf-8 -*-
"""
Spyder Editor
 
Created on July 10th
"""
 
import sqlite3
conn = sqlite3.connect('chordProgdb2.sqlite')
cur = conn.cursor()
 
def main():
  cur.execute('''
  SELECT chord.prog, COUNT(*)
  FROM Song AS master
  LEFT JOIN Genre AS subgenre_tbl ON subgenre_tbl.id = master.subgenre_id
  LEFT JOIN Genre ON genre.id = master.genre_id
  LEFT JOIN ChordProg AS chord ON chord.id = master.chordProg_id
  WHERE subgenre_tbl.name = 'Americana'
  GROUP BY chord.prog
  ORDER BY COUNT(*) DESC
  LIMIT 10
  ;
  ''')
 
  top10Americana= cur.fetchall()
  conn.commit
  print(list(top10Americana))
 
if __name__=="__main__":
  main()

1 2	`out: [(u'DGDG', 7), (u'CGAmC', 6), (u'GCGC', 6), (u'GEmGEm', 6), (u'B7EAE', 5), (u'CFCF', 5),` `(u'EEEE', 5), (u'DADA', 4), (u'DEmCG', 4), (u'DGCG', 4)]`

Though the data is not very big in size it may be a good question to ask why the data is even in a SQL database in the first place, since the total data is only a few megabytes, and will easily fit in memory. My reason is that it is a good habit I have developed, to load, save, and access SQL tables in databases. Moreover, adding to the database can easily be done and is standaradized using the entity relationship diagram (ERD), data can be added from other data sources, and is the database can be incorporated to other projects easily.

100 Greatest Country Music Artists

  1. Johnny Cash
  2. Hank Williams
  3. Patsy Cline
  4. Dolly Parton
  5. The Carter Family
  6. George Jones
  7. Willie Nelson
  8. Loretta Lynn
  9. Jimmie Rodgers
10. Garth Brooks
11. Merle Haggard
12. Waylon Jennings
13. Bill Monroe
14. Tammy Wynette
15. Conway Twitty
16. Roy Acuff
17. Marty Robbins
18. Flatt & Scruggs
19. Buck Owens
20. The Stanley Brothers / Ralph Stanley
21. Gene Autry
22. Bob Wills
23. Chet Atkins
24. Hank Snow
25. George Strait
26. Lefty Frizzell
27. Vince Gill
28. Ernest Tubb
29. Kenny Rogers
30. Reba McEntire
31. Alison Krauss & Union Station

32. Charley Pride
33. Eddy Arnold
34. Roy Clark
35. Alabama
36. Randy Travis
37. Kitty Wells
38. The Judds
39. Dwight Yoakam
40. Trisha Yearwood
41. Alan Jackson
42. Tanya Tucker
43. Tom T. Hall
44. Glen Campbell
45. Shania Twain
46. The Sons of the Pioneers
47. "Tennessee" Ernie Ford
48. Patty Loveless
49. Charlie Rich
50. Slim Whitman

51. Brad Paisley
52. Jim Reeves
53. Faron Young
54. The Oak Ridge Boys
55. Martina McBride
56. Faith Hill
57. Porter Wagoner
58. June Carter Cash
59. Tim McGraw
60. Mel Tillis
61. Ricky Skaggs
62. "Little" Jimmy Dickens
63. The Gatlin Brothers
64. Connie Smith
65. Mary Chapin Carpenter
66. Brooks & Dunn
67. Jean Shepard
68. Toby Keith
69. Gillian Welch
70. Dixie Chicks
71. Hank Williams Jr.
72. Cowboy Copas
73. Ray Price
74. Travis Tritt
75. Roger Miller
76. Mickey Gilley
77. Patsy Montana
78. Ronnie Milsap
79. Keith Urban
80. Kenny Chesney
81. Dottie West
82. The Statler Brothers
83. Clint Black
84. Lee Ann Womack
85. Bobby Bare
86. The Louvin Brothers
87. The Blue Sky Boys
88. Leann Rimes
89. Del McCoury Band
90. Rosanne Cash
91. Don Gibson
92. The Kendalls
93. Montgomery Gentry
94. Emmylou Harris
95. Blake Shelton
96. Lynn Anderson
97. Diamond Rio
98. Jerry Reed
99. David Allan Coe
100. Boxcar Willie

Greatest Bluegrass Songs

  1. With Body And Soul - Bill Monroe & His Bluegrass Boys
  2. Foggy Mountain Breakdown - Lester Flatt & Earl Scruggs & The Foggy Mountain Boys
  3. Rank Stranger - The Stanley Brothers & The Clinch Mountain Boys
  4. Blue Moon Of Kentucky - Bill Monroe & His Bluegrass Boys
  5. Rocky Top - The Osborne Brothers
  6. On The Sunny Side Of The Mountain - Jimmy Martin & The Sunny Mountain Boys
  7. Orange Blossom Special - The Stonemans // Johnson Mountain Boys
  8. Jerusalem Ridge - Kenny Baker & Bill Monroe
  9. I Am A Man Of Constant Sorrow - Stanley Brothers (1959) // Soggy Bottom Boys (2000)
10. Fox On the Run - Country Gentlemen (Rebel Records, studio, 1971)
11. I'll Fly Away - Alison Krauss & Gillian Welch
12. I'll Meet You In Church Sunday - The Stanley Brothers
13. New Muleskinner Blues - Bill Monroe & His Bluegrass Boys
14. Mountain Dew - Grandpa Jones
15. I Don't Believe You've Met My Baby - Jerry Douglas Band w/Alison Krauss
16. You Don't Know My Mind - Jimmy Martin & The Sunny Mountain Boys
17. Molly & Tenbrooks - Bill Monroe & His Bluegrass Boys
18. Wayfaring Stranger - Emmylou Harris
19. Salt Creek - Norman Blake, Tony Rice & Doc Watson
20. Paradise - Jim & Jesse McReynolds & The Virginia Boys
21. Little Maggie - Ralph Stanley & The Clinch Mountain Boys
22. I Wouldn't Change You If I Could - Jim Eanes & The Shenandoah Valley Boys
23. I Wonder How The Old Folks Are At Home - Mac Wiseman & The Country Boys
24. How Mountain Girls Can Love - The Stanley Brothers & The Clinch Mountain Boys
25. Uncle Pen - Bill Monroe & The Bluegrass Boys (1950)
     // Ricky Skaggs & Kentucky Thunder (1983)
26. The Boys Are Back In Town - Patty Loveless
27. Wild Horses - Old And In The Way
28. I've Got That Old Feeling - Alison Krauss & Union Station
29. Wagon Wheel - Old Crow Medicine Show
30. Feudin' Banjos - Arthur Smith & Don Reno
     // Duelin' Banjos - Eric Weissberg w/ Steve Mandell
31. Clinch Mountain Backstep - The Stanley Brothers & The Clinch Mountain Boys
32. Worried Man Blues (1971) - Wade Mainer
33. High On A Mountain - Del McCoury & The Dixie Pals
34. I Am A Pilgrim - The Kentucky Colonels
35. Drink Up And Go Home - Jimmy Martin & The Sunny Mountain Boys
36. Dooley - Dillards
37. I Know You Rider - Seldom Scene
38. Ruby, Are You Mad? - The Osborne Brothers
39. Callin' Baton Rouge - New Grass Revival
40. Last Train To Kitty Hawk - Balsam Range
41. The Little Mountain Church - Doyle Lawson & Quicksilver
42. Devil's Train - James King Band
43. Roll In My Sweet Baby's Arms - Lester Flatt, Earl Scruggs & The Foggy Mountain Boys
44. Freight Train - Jim & Jesse McReynolds & The Virginia Boys
45. High Lonesome Sound - Vince Gill
46. It's Mighty Dark To Travel - Bill Monroe & His Bluegrass Boys
47. Georgie Buck - Carolina Chocolate Drops
48. I Saw The Light - Roy Acuff w/The Nitty Gritty Dirt Band
49. Meet Me By The Moonlight - The Stanley Brothers & The Clinch Mountain Boys
50. A Voice From On High - Bill Monroe & His Bluegrass Boys
51. The Fields Have Turned Brown - Ralph Stanley & The Clinch Mountain Boys
52. Girl At The Crossroads Bar - The Bluegrass Cardinals
53. 'Tis Sweet To Be Remembered - Mac Wiseman & The Country Boys
54. Nine Pound Hammer - Jim & Jesse McReynolds & The Virginia Boys
55. Little Birdie - Wade Mainer (1953) // Red Allen & The Kentuckians
56. Tennessee 1949 - Larry Sparks
57. Walls Of Time - The Johnson Mountain Boys
58. The Ballad Of Jed Clampett - Lester Flatt, Earl Scruggs & The Foggy Mountain Boys
59. Fair And Tender Ladies - Joe Val & The New England Bluegrass Boys
60. Pretty Green Hills - Dave Evans
61. Tortured Tangled Hearts - Dixie Chicks
62. Grayson County Blues - No Speed Limit
63. Pretty Polly - Ralph Stanley & The Clinch Mountain Boys
64. Please Be My Love - Jim & Jesse McReynolds & The Virginia Boys
65. Rocky Road Blues - Bill Monroe & The Bluegrass Boys
66. Long Black Veil - John Duffey
67. Steam-Powered Aereoplane - John Hartford
68. Going Across The Sea - Valley Road
69. I'm On My Way Home - Bill Monroe & His Bluegrass Boys
70. Black Mountain Rag (live) - Doc & Merle Watson
71. Howdy Neighbor, Howdy - Reno & Smiley & The Tennessee Cut-Ups
72. I Found A Hiding Place - Carl Story & His Ramblin' Mountaineers
73. 20 Years Of Farming - James King Band
74. Better Times A Coming - Jim & Jesse McReynolds & The Virginia Boys
75. Sparkling Blue Eyes (1971) - Wade Mainer
76. Gloryland - Ralph Stanley & The Clinch Mountain Boys
77. Angel Band - Ralph Stanley & The Clinch Mountain Boys
78. Me And The Jukebox - Buzz Busby & The Bayou Boys
79. Cabin On The Hill - Lester Flatt & Earl Scruggs
80. Kentucky Borderline - Rhonda Vincent & The Rage
81. Electricity - Jimmy Murphy
82. Little Gloria Rose - Seldom Scene
83. Don't Let Your Sweet Love Die - Reno & Smiley & The Tennessee Cut-Ups
84. Windy Mountain - The Lonesome Pine Fiddlers
85. Bile 'Em Cabbage Down - Heights Of Grass
86. Long Journey Home - The Lilly Brothers & Don Stover
87. Cripple Creek - The Stonemans
88. Rain And Sorrow - Del McCoury & The Dixie Pals
89. Old Home Place - J. D. Crowe & The New South
90. Two Highways - Alison Krauss & Union Station
91. Blue Ridge Cabin Home - The Bluegrass Album Band
92. Duncan & Brady (He's Been On The Job Too Long) - The Johnson Mountain Boys
93. Shady Grove - Ricky Skaggs & Kentucky Thunder
94. Bluegrass Express - Rhonda Vincent & The Rage
95. John Deere Tractor - Larry Sparks & The Lonesome Ramblers
96. Will The Circle Be Unbroken? - The Nitty Gritty Dirt Band
97. Don't Cheat In Our Hometown - Keith Whitley & Ricky Skaggs
98. Kentucky Waltz - Bill Monroe & The Bluegrass Boys
99. Barbara Allen - Moore & Napier
100. Roving Gambler - Country Gentlemen // Larry Sparks // Peter Rowan

101. Colleen Malone - Hot Rize
102. I Wonder Where You Are Tonight - Jim & Jesse McReynolds & The Virginia Boys
103. White Dove - Stanley Brothers & The Clinch Mountain Boys
104. Spanish River - The Masters, featuring Jesse McReynolds
105. Cotton-Eyed Joe - Bill Monroe & The Bluegrass Boys
106. Sally Goodin - Byron Berline Band
107. Sea Of Heartbreak - Country Gentlemen
108. Nashville Cats - Del McCoury Band
109. Free Born Man - Jimmy Martin & The Sunny Mountain Boys
110. Heartaches And Teardrops - Cedar Hill
111. Bringing Mary Home - Country Gentlemen
112. Can't You Hear Me Callin' - Bill Monroe & The Bluegrass Boys
113. More Pretty Girls Than One - Volume Five
114. Someone Play Dixie For Me - Dry Branch Fire Squad
115. Choctaw Hayride - Alison Krauss & Union Station
116. Mary Ann - Jimmy Martin & The Sunny Mountain Boys
117. Kentucky - The Louvin Brothers
118. One Way Track - Boone Creek
119. Hit Parade Of Love - Jimmy Martin amp; The Sunny Mountain Boys
120. O Death - Ralph Stanley & The Clinch Mountain Boys
121. Please Come Home - James Monroe Band
122. When My Blue Moon Turns To Gold Again - Bill & James Monroe & Bluegrass Boys
123. I Know You're Married But I Love You Still - Reno & Smiley & The Tennessee Cut Ups
124. Muddy Waters - Seldom Scene
125. Only Me - Rhonda Vincent w/Willie Nelson
126. Tennessee - Jimmy Martin & The Sunny Mountain Boys
127. Sparkling Brown Eyes - Joe Val & The New England Bluegrass Boys
128. The Legend Of The Rebel Soldier - Country Gentlemen
129. Bed By The Window - James King Band
130. Echo Mountain - Cedar Hill

Honerable Mentions

Carrie Underwood
Florida Georgia Line
Jason Aldean
Luke Bryan
Lady A (Lady Antebellum)
Eric Church
Chris Stapleton
Little Big Town
Dierks Bentley
Heartland
Rascal Flatts
Rodney Atkins
Minnie Pearl
Moe Bandy
Big & Rich
Sara Evans
Floyd Cramer

The Band Perry

Shelby Lynne
Sammi Smith
Earl Thomas Conley
Deanna Carter
Rhonda Vincent
kd lang
Rascal Flatts
Crystal Gale
Rodney Crowell
Nickel Creek
Barbara Mandrell
Shooter Jennings
Lyle Lovett
Gretchen Wilson
Bobbie Gentry
Wynonna Judd
Gary Allan
Terri Clark
Brenda Lee
Shenandoah
Jo Dee Messina

Lee Greenwood
Zac Brown Band
Mavericks
Ferlin Husky
Joe Diffie
Tracy Byrd
Sawyer Brown
Kris Kristoferson
Donna Fargo
Wanda Jackson
Restless Heart

Lonestar
Cole Swindell
Charlie Daniels
Johnny Paycheck
Marty Stuart
Mark Chesnutt
Iris Dement
Cindy Walker
Trace Adkins
Josh Turner
Steve Wariner
Ricky Van Shelton
Nanci Griffith
Joe Nichols
Nitty Gritty Dirt Band
Lucinda Williams
John Anderson
Aaron Tippin
Mindy Smith
Pure Prairie League
Pam Tillis
Sugarland
Ryan Adams
Eddie Rabbitt
Allison Moorer
Billy Ray Cyrus
George Hamilton, IV
Anthony Smith

100 Greatest Country Love Songs

1. I Will Always Love You - Dolly Parton
  2. Crazy - Patsy Cline
  3. You Were Always on My Mind - Willie Nelson
  4. Stand By Your Man - Tammy Wynette
  5. Forever and Ever, Amen - Randy Travis
  6. Hello Darlin' - Conway Twitty
  7. She Believes in Me - Kenny Rogers
  8. Golden Ring - George Jones & Tammy Wynette
  9. How Do I Live - LeAnn Rimes
10. Kiss an Angel Good Morning - Charley Pride
11. Sweet Dreams (Of You) - Patsy Cline
12. Behind Closed Doors - Charlie Rich
13. Unanswered Prayers - Garth Brooks
14. I Cross My Heart - George Strait
15. He Stopped Loving Her Today - George Jones
16. I Can't Stop Loving You - Ray Charles

17. When You Say Nothing at All - Keith Whitley
18. That's the Way Love Goes - Merle Haggard
19. Lady - Kenny Rogers
20. It's Your Love - Tim McGraw (with Faith Hill)
21. I Fall to Pieces - Patsy Cline
22. I Can't Help It (If I'm Still in Love With You) - Hank Williams
23. When I Said I Do - Clint Black and Lisa Hartman Black
24. Before the Next Teardrop Falls - Freddy Fender
25. Gentle on My Mind - Glen Campbell
26. Breathe - Faith Hill
27. Amazed - Lonestar
28. When I Call Your Name - Vince Gill
29. I Swear - John Michael Montgomery
30. Today I Started Loving You Again - Merle Haggard
31. I'm So Lonesome I Could Cry - Hank Williams
32. Ring of Fire - Johnny Cash
33. Annie's Song - John Denver
34. Feels So Right - Alabama
35. You Look So Good in Love - George Strait
36. Help Me Make It Through the Night - Sammi Smith
37. This Kiss - Faith Hill
38. For the Good Times - Ray Price
39. Let's Make Love - Faith Hill & Tim McGraw
40. Have I Told You Lately That I Love You - Gene Autry
41. You're Still the One - Shania Twain
42. Wichita Lineman - Glen Campbell
43. Make the World Go Away - Eddy Arnold
44. Angel Flying Too Close to the Ground - Willie Nelson
45. Strawberry Wine - Deana Carter
46. I Love You - Martina McBride
47. I Believe in You - Don Williams
48. On the Other Hand - Randy Travis
49. I Still Believe in You - Vince Gill
50. Could I Have This Dance - Anne Murray
51. Please Remember Me - Tim McGraw
52. I Love - Tom T. Hall

53. Louisiana Woman, Mississippi Man - Loretta Lynn & Conway Twitty
54. Mama He's Crazy - The Judds
55. I Wouldn't Have Missed It for the World - Ronnie Milsap
56. In Another's Eyes - Garth Brooks
57. He'll Have to Go - Jim Reeves
58. One More Day - Diamond Rio
59. The Woman in Me (Needs the Man in You) - Shania Twain
60. Something That We Do - Clint Black
61. Wrapped Around - Brad Paisley
62. She Thinks I Still Care - George Jones
63. Don't It Make My Brown Eyes Blue - Crystal Gayle
64. Paper Roses - Marie Osmond
65. Love in the First Degree - Alabama
66. I'll Still Be Loving You - Restless Heart
67. Amanda - Waylon Jennings
68. Where've You Been - Kathy Mattea
69. It Was Almost Like a Song - Ronnie Milsap
70. Maybe It Was Memphis - Pam Tillis
71. You Had Me From Hello - Kenny Chesney
72. Good Hearted Woman - Waylon Jennings
73. Would You Lay with Me (In a Field of Stone) - Tanya Tucker
74. What's Forever For - Michael Martin Murphey
75. I've Got a Tiger by the Tail - Buck Owens
76. How Forever Feels - Kenny Chesney
77. That's What I Like About You - Trisha Yearwood
78. The Heart Won't Lie - Reba McEntire
79. I Hope You Dance - Lee Ann Womack
80. We Were in Love - Toby Keith
81. If You See Him, If You See Her - Brooks & Dunn
82. Anymore - Travis Tritt
83. Remember When - Alan Jackson
84. Your Everything - Keith Urban
85. We Danced - Brad Paisley
86. You're the Reason God Made Oklahoma - David Frizzell
87. Cowboy Take Me Away - Dixie Chicks
88. The Keeper of the Stars - Tracy Byrd
89. Some Fools Never Learn - Steve Wariner

90. No One Else on Earth - Wynonna
91. Timber, I'm Falling in Love - Patty Loveless
92. Grow Old - Florida Georgia Line
93. Shut Up and Kiss Me - Mary Chapin Carpenter
94. Love Is The Foundation - Loretta Lynn
95. Together Again - Buck Owens
96. I Fell in Love - Carlene Carter
97. I Melt - Rascal Flatts
98. I'll Go On Loving You - Alan Jackson
99. Somebody Like You - Keith Urban
100. No Place That Far - Sara Evans

Country Music Albums

  1. At Folsom Prison - Johnny Cash
  2. Complete Live At San Quentin - Johnny Cash
  3. Coat Of Many Colors - Dolly Parton
  4. Modern Sounds In Country And Western Music - Ray Charles
  5. Red Headed Stranger - Willie Nelson
  6. Will the Circle Be Unbroken - Nitty Gritty Dirt Band
  7. Honky Tonk Heroes - Waylon Jennings
  8. Showcase - Patsy Cline
  9. Roses In The Snow - Emmylou Harris
10. Big City - Merle Haggard
11. Coal Miners Daughter - Loretta Lynn
12. No Fences - Garth Brooks
13. American Recordings - Johnny Cash
14. I Am What I Am - George Jones
15. Bean Blossom - Bill Monroe
16. The Grass Is Blue - Dolly Parton
17. The Ramblin Man - Waylon Jennings
18. Blood, Sweat, and Tears - Johnny Cash
19. Storms Of Life - Randy Travis
20. Joshua - Dolly Parton
21. San Antonio Rose - Willie Nelson & Ray Price
22. Sentimentally Yours - Patsy Cline
23. Buck Owens Sings Harlan Howard - Buck Owens
24. Strangers - Merle Haggard
25. Moody Blue - Elvis Presley
26. Stand By Your Man - Tammy Wynette
27. Foggy Mountain Banjo - Flatt & Scruggs
28. American III: Solitary Man - Johnny Cash
29. Golden Ring - Tammy Wynette and George Jones
30. The Woman In Me - Shania Twain
31. Breathe - Faith Hill
32. Guitars, Cadillacs, Etc., Etc. - Dwight Yoakam
33. Unchained - Johnny Cash
34. Some Hearts - Carrie Underwood
35. Red Dirt Girl - Emmylou Harris
36. Seven Year Ache - Rosanne Cash
37. Home - Dixie Chicks
38. When Love Finds You - Vince Gill
39. Grievous Angel - Gram Parsons
40. Little Sparrow - Dolly Parton
41. At Carnegie Hall! - Flatt & Scruggs
42. Fearless - Taylor Swift
43. Come On Over - Shania Twain
44. Trio - Dolly Parton, Linda Ronstadt, Emmylou Harris
45. Alison Krauss & Union Station Live - Alison Krauss & Union Station
46. For My Broken Heart - Reba McEntire
47. Pieces of the Sky - Emmylou Harris
48. Gamblin Man - Kenny Rogers
49. Saturday Night And Sunday Morning - Ralph Stanley
50. American IV: When the Man Comes Around - Johnny Cash
51. Blue - Leann Rimes
52. Hazel & Alice - Hazel Dickens and Alice Gerrard
53. Pontiac - Lyle Lovett
54. Always on My Mind - Willie Nelson
55. Blue Clear Sky - George Strait
56. Did I Shave My Legs For This - Deanna Carter
57. Why Not Me - The Judds
58. Killin' Time - Clint Black
59. Hello Darlin' - Conway Twitty
60. Always & Forever - Randy Travis
61. Mountain Soul - Patty Loveless
62. Revival - Gillian Welch
63. Me and Bobby McGee - Kris Kristofferson
64. Songs My Father Left Me - Hank Williams Jr.
65. D-I-V-O-R-C-E - Tammy Wynette
66. A Deeper Shade of Blue - Del McCoury
67. Halos & Horns - Dolly Parton
68. In Pieces - Garth Brooks
69. Need You Now - Lady Antebellum
70. Roots - The Everly Brothers
71. I'm A Lonesome Fugitive - Merle Haggard
72. One on the Way - Loretta Lynn
73. Be Here - Keith Urban
74. Mountain Music - Alabama
75. Hello, I'm Johnny Cash - Johnny Cash
76. Rhinestone Cowboy - Glen Campbell
77. Strait Country - George Strait
78. Honky Tonk Angels - Dolly Parton, Loretta Lynn, Tammy Wynette
79. Highwaymen - The Highwaymen
80. O Brother Where Art Thou - Original Soundtrack (Various)
81. Traveller - Chris Stapleton
82. All I Want - Tim McGraw
83. Van Lear Rose - Loretta Lynn
84. Hag - Merle Haggard
85. Time Well Wasted - Brad Paisley
86. Bluegrass Rules! - Ricky Skaggs
87. King's Record Shop - Rosanne Cash
88. Wide Open Spaces - Dixie Chicks
89. Faith - Faith Hill
90. End Time - Freakwater
91. Same Trailer Different Park - Kacey Musgraves
92. Alot About Living (And A Little About Love) - Alan Jackson
93. Diamonds & Dirt - Rodney Crowell
94. Revolution - Miranda Lambert
95. Shadowland - k.d. lang
96. TNT - Tanya Tucker
97. Come On Come On - Mary Chapin Carpenter
98. Everybody Knows - Trisha Yearwood
99. Nickel Creek - Nickel Creek
100. Chief - Eric Church

a.dezius@gmail.com