musiccaps_details (view)
2 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "piano" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- fun · 2 ✖
- piano · 2 ✖
- bongo 1
- brass instruments 1
- brass section 1
- busy percussion 1
- charming female vocalist 1
- claves 1
- conga 1
- dance 1
- energetic 1
- energetic female vocalist 1
- fast tempo 1
- group male vocals 1
- latin 1
- salsa music 1
- upbeat 1
musiccaps_names (array) 6 ✖
- Music · 2 ✖
- Afrobeat 1
- Flamenco 1
- Music of Africa 1
- Music of Latin America 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pop'n music 8 - Miami Salsa - El dia feliz | This is a salsa song with an upbeat and vibrant energy. It contains typical salsa instruments like the conga, the trumpet, and the piano. The percussion is upbeat and involves bongos and congas, and the singer is lively. | 2010-03-11T04:44:33Z | Pan | BAILANDO~ | ["Music", "Music of Latin America", "Salsa music"] | ["salsa music", "upbeat", "dance", "fun", "brass instruments", "piano", "bongo", "conga", "claves", "charming female vocalist", "energetic female vocalist"] | 3 | RneRJ5ZnHlE | 2725 | |
flamenco remix 2013 | Energetic, fun latin salsa music with a fast tempo that includes busy percussion, a brass section, piano, group male vocals. | 2012-12-22T20:33:22Z | ole la gitaneria | ["Afrobeat", "Music of Africa", "Flamenco", "Music"] | ["latin", "busy percussion", "brass section", "piano", "group male vocals", "energetic", "fun", "fast tempo"] | 8 | q9Gh-zh-5Ig | 4758 |
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;