musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "string section" and musiccaps_author = 6 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- string section · 2 ✖
- acoustic guitar 1
- acoustic piano 1
- ballad/pop 1
- brasssection 1
- e-bass 1
- e-guitar 1
- female voice singing 1
- male and female singer 1
- mood-lifting 1
- rock&rollmusic 1
- slow tempo 1
- soft sounding 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 2
- Rock and roll 1
- Roll 1
- Tender music 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Melodies Of Life (OST Final Fantasy IX) | AMV - Emiko Shiratori | An acoustic guitar is playing single notes of a minor chord progression alongside an acoustic piano playing a melody on itself. Then a string-section comes in for a moment elevating the emotional piece giving it a beauty and soft sadness. The instruments are slightly panned to the left and right side of the speakers. The female voice is softly singing with a little bit of reverb on her voice. This song may be playing at a theater-performance. | 2006-01-25T14:25:37Z | geekster129 | This AMV is dedicated to all Final Fantasy IX and Final Fantasy fans around the world, and to the geniuses behind the Final Fantasy series: Hironobu Sakaguchi, Yoshitaka Amano,Tetsuya Nomura, Yoshinori Kitase, the musical genius, Nobuo Uematsu, and all the members of the Final Fantasy development team who have put their countless efforts on creating such a beautiful masterpiece. And, most of all... To all the viewers of this AMV, thank you very very much for all the kind words on the comments, and all the stories that you share. Thank you again. You can find the karaoke version: https://www.youtube.com/watch?v=u4bqksY_6JM | ["Music", "Tender music"] | ["ballad/pop", "acoustic piano", "acoustic guitar", "string section", "female voice singing", "slow tempo", "soft sounding"] | 6 | 3mNOJpN_qOQ | 499 | |
I dig rock and roll music-Cass Elliot & Sammy Davis Jr | The drums are playing a funky groove together with the e-bass. An almost clean e-guitar is playing an additional melody in the background. A male and female voice are singing together accompanied by a string section in the background while a brass section is giving short and strong responses as a buildup and breakingpoint. This song may be playing at a veny-shop. | 2008-01-12T16:33:20Z | aguz2211 | ["Music", "Roll", "Rock and roll"] | ["rock&rollmusic", "brasssection", "e-bass", "string section", "male and female singer", "e-guitar", "mood-lifting", "uptempo"] | 6 | zOvFaef41iw | 5471 |
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;