musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "piano chords" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- energetic crash cymbal 2
- passionate 2
- passionate male vocal · 2 ✖
- piano chords · 2 ✖
- shimmering hi hats 2
- emotional 1
- harmonizing background female vocals 1
- low quality 1
- mellow bass 1
- mono 1
- noisy 1
- playback 1
- romantic 1
- shimmering shakers 1
- snappy snare 1
- soul/r&b 1
- soulful 1
- sustained strings melody 1
- toms roll 1
- wide acoustic rhythm guitar melody 1
musiccaps_names (array) 6 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Disney On Ice 2009 Finale | The low quality recording features a live performance where the song is played on playback and it consists of sustained strings and piano melody, energetic crash cymbals, shimmering hi hats and toms roll, over which passionate male vocal and harmonizing background female vocals are singing. It sounds emotional, passionate and soulful. | 2009-06-03T19:22:38Z | Freya JW | Disney On Ice was preforming at the Target Center in Minneapolis on March 8th and I was able to go and Oh Em Gee, it was sooo purely magicaly like you don't even know. This video doesn't do it justice!! I was actually crying during this part. | ["Yodeling", "Music", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "playback", "sustained strings melody", "toms roll", "shimmering hi hats", "energetic crash cymbal", "passionate male vocal", "harmonizing background female vocals", "piano chords", "emotional", "passionate", "soulful"] | 4 | bwHPVG6vbNQ | 3665 | |
Max Mutzke - Can´t Wait Until Tonight (official Video) | The Soul/R&B song features a passionate male vocal singing over shimmering hi hats, energetic crash cymbals, wide acoustic rhythm guitar melody, shimmering shakers, snappy snare, piano chords and mellow bass. It sounds passionate and romantic - like something you would sing to your partner. | 2010-01-25T11:53:51Z | Max Mutzke | Der Videoclip zu Can´t Wait Until Tonight von Max Mutzke. Mehr Max gibt es hier http://www.maxmutzke.de | ["Singing", "Music", "Musical instrument", "Soul music"] | ["soul/r&b", "passionate male vocal", "shimmering hi hats", "energetic crash cymbal", "wide acoustic rhythm guitar melody", "shimmering shakers", "snappy snare", "piano chords", "mellow bass", "passionate", "romantic"] | 4 | 5ZX9Ig7XXsw | 668 |
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;