musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_author = 4 and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 林宥嘉 Yoga Lin [ 寵兒 The Loved Ones ] Music Video (電影「我的蛋男情人」主題曲) 陳星合 Acoustic Cover | The low quality recording features a cover of a ballad song that consists of passionate, muddy male vocal singing over arpeggiated acoustic guitar melody. It sounds noisy, muddy and messy, as the frequencies are clashing, but it is also emotional and raw. | 2016-10-01T13:18:56Z | 我是星合HE's channel | 林宥嘉 [ 寵兒 The Loved Ones ] Acoustic Cover 吉他翻唱改編 ►陳星合Facebook粉絲頁 : https://www.facebook.com/shinghemusic ►Instagram : https://www.instagram.com/shinghe0807/ →歡迎追蹤與訂閱← 每週三都會有新的音樂作品哦！！！ 希望你們會喜歡這次的翻唱 :) | ["Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument", "Tender music"] | ["low quality", "passionate muddy male vocal", "arpeggiated acoustic guitar melody", "noisy", "muddy", "cover", "emotional", "ballad", "raw", "messy"] | 4 | -8cgbhIR_pw | 21 | |
| Mako Mermaids: "Across The Sea" Music Video | The low quality recording features a ballad that consists of a soft female vocal singing over a mellow piano melody and shimmering bells at the end of the loop. The recording is noisy and it sounds passionate, emotional and mystical, almost like a lullaby. | 2015-06-06T13:41:20Z | Tom Lewandowski | "Across The Sea" by Amy Ruffle. An enhanced video edit of the song from Jonathan M. Shiff's original television series, 'Mako Mermaids.' High Definition. | ["Music", "Tender music"] | ["low quality", "ballad", "mellow piano melody", "soft female vocal", "shimmering bells", "noisy", "emotional", "passionate", "mystical", "lullaby"] | 4 | 1h2sb2xeCt8 | 296 | |
| Hindi Zahra no Brasil - Music.MP4 | The low quality recording features a live performance of an indie song and it contains passionate female vocal singing over arpeggiated electric guitar melody and shimmering shakers. It is a bit noisy, there are some crowd noises and it sounds passionate, emotional and like an intro section of the song. | 2011-10-18T09:46:24Z | Danilo de Oliveira Azevedo | Hindi Zahra canta "Music" no Show do SESC-Pinheiros, SP, em 14.10.11. A banda: Lucile Loison - vocais Hakim Hamadouche - mandoluth Thibault Frisoni - guitarra Silvano Matadin - baixo Didier Guazzo - bateria Music Hindi Zahra Music is coming now feel it dropping to the ground sounds like my heart beating fast and free now it's always running in my veins till I hear the drums and basses all night music is coming now see it everybody moves till we get thirsty and happy all we need this time for the real thing for the real high for the real love come together now and rock the ground give it all to the sound body soul and mind until you get down now I know what you're longing for what you're waiting for for the right time for the real thing 4x move until you feel it and move until you feel there's no limit no rules between you and that there's no lines no lights so keep it alive keep it high and make it yours and rock the ground one, two times rock the ground and give it all to the sound your body and your soul your mind and get free now for the real thing for the real high for the real love you better, better, better, better now rock the ground one two times, until you feel it rock the ground one two times until you feel it for the real thing for the real love for the real high 4x move until you feel it and move until you feel 5x freedom is one way road until you get there freedom is one way road | ["Music", "Vocal music", "Tender music"] | ["low quality", "crowd noises", "noisy", "indie", "live performance", "passionate female vocal", "shimmering shakers", "arpeggiated electric guitar melody", "emotional", "passionate", "intro"] | 4 | JOhK7oq9KtU | 1999 |
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;