musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "simple bass" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- emotional · 2 ✖
- passionate 2
- simple bass · 2 ✖
- acoustic guitar solo melody 1
- country 1
- fruity male vocal 1
- heartfelt 1
- keys chords 1
- low quality 1
- passionate reverberant male vocal 1
- percussive acoustic rhythm guitar 1
- wide arpeggiated acoustic guitar melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Christmas music 1
- Folk music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
George Jones - Colour of the Blues - Country Music Experience | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | 2012-10-07T07:52:56Z | Country Music Experience | Country Music Experience : (Re)Discover the finestcountry Music Selection. Country Music experience is your channel for all the country music, where you can experience music, in high audio quality. Subscribe to stay connected to our channel and receive all of our video updates! -Country Music experience | ["Christmas music", "Music"] | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | 4 | tGic59TlrVg | 5022 | |
Kjarkas - Mi gran amor | The low quality recording features a passionate, reverberant male vocal singing over a wide arpeggiated acoustic guitar melody and acoustic guitar solo melody, followed by a simple bass. It sounds emotional and passionate. | 2012-11-07T23:29:37Z | Erick Salazar | Mi amor, mi gran amor, mi mas bella ilusión, mejor canción, los ojos de mi alma a quien cuide, la tierna ilusión que alimente... | ["Folk music", "Music"] | ["low quality", "passionate reverberant male vocal", "acoustic guitar solo melody", "wide arpeggiated acoustic guitar melody", "simple bass", "emotional", "passionate"] | 4 | TWV3YLscSaw | 2839 |
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;