musiccaps_details (view)
2 rows where musiccaps_aspects contains "country song" and musiccaps_aspects contains "harmonica"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- country song · 2 ✖
- folk song 2
- harmonica · 2 ✖
- acoustic guitar 1
- auto harp 1
- breakup 1
- breakup song 1
- country pop 1
- despondent 1
- dobro 1
- emotional 1
- female singer 1
- instrumental 1
- lonely 1
- love song 1
- medium tempo 1
- mellow 1
- melodious tune 1
- moderate tempo 1
- no other instruments 1
- no percussion 1
- no voices 1
- regional music 1
- resonator guitar 1
- sad song 1
- sentimental 1
- soft 1
- steady bass lines 1
- steady drumming 1
- upbeat 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guitar Harmonica WildWood Flower Folk music Country rack blues | This folk song features a harmonica playing the main melody. This is accompanied by an acoustic guitar strumming chords. There are no other instruments in this song. This is an instrumental song. There are no voices in this song. The mood of this song is upbeat and happy. This song can be played in a movie scene involving a highway drive. | 2008-06-01T07:49:24Z | Matthew Shelton | http://harmonicasuperstart.com/ Guitar and Harmonica simultaneously played: WildWood Flower Folk to Country styles, same song, 1 harmonica, two different keys. Go to HarmonicaSuperStart.com for more great info on playing the harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["harmonica", "acoustic guitar", "country song", "folk song", "no voices", "instrumental", "no percussion", "no other instruments", "moderate tempo", "upbeat"] | 0 | fWfQxB2pVrc | 3952 | |
~Good As I Was To You~ (With Lyrics) | A female singer sings this sad Country song. The tempo is medium with a Harmonica harmony, steady bass line, acoustic guitar, auto harp and dobro accompaniment. The song is soft, mellow, sad, poignant, emotional, sentimental and despondent with a melodious tune. This Song is a classic Country Pop. | 2008-09-22T07:04:10Z | VampiressSilvia | Lorrie Morgan's Good As I Was To You With the lyrics | ["Christian music", "Music"] | ["female singer", "medium tempo", "country song", "despondent", "melodious tune", "country pop", "regional music", "folk song", "love song", "sad song", "breakup song", "breakup", "harmonica", "steady drumming", "steady bass lines", "auto harp", "dobro", "resonator guitar", "mellow", "lonely", "soft", "sentimental", "emotional"] | 7 | tUJ_ZniLjhc | 5038 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;