musiccaps_details (view)

4 rows where search matches "ballad" and musiccaps_aspects contains "noisy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_author 1 ✖

  • 4 4
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
Charice crying while singing Maghintay Ka Lamang The low quality recording features a live performance of a ballad song that consists of sustained strings, soft crash cymbals and soft piano melody. At the very end of the loop, there are passionate muddy female vocals. It sounds passionate, emotional and heartfelt, while it is a bit noisy too. 2011-02-14T13:17:04Z Hachie Simon Please subscribe to my channel :) Gobless you! Maghintay Ka Lamang by Charice Pempengco on GMA SNBO presents Charice Home for the Valentines Special ["Music", "/t/dd00004"] ["low quality", "noisy", "live performance", "sustained stings", "passionate muddy female vocal", "soft piano melody", "ballad", "soft crash cymbal", "passionate", "emotional", "heartfelt"] 4 Wdtku1dqJo0 3115
Tìm lại bầu trời - hướng dẫn guitarist CHop Bi (phần 2 - chơi mẫu) The low quality song features a cover of a ballad song and it consists of arpeggiated acoustic guitar melody and passionate male vocal singing over it. The recording is very noisy and in mono, like it was recorded with a phone, but regardless it sounds emotional and passionate. 2012-03-10T11:35:16Z thachsungabc Lớp guitar - CLB nghệ thuật trẻ Hà Nội - link: http://enbac.com/Ha-Noi/Tong-hop/p1174061/Lop-guitar-CLB-nghe-thuat-tre-chieu-sinh-Thong-bao-chuong-trinh-tang-dan-guitar-cho-hoc-vien-moi.html ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] ["low quality", "arpeggiated acoustic guitar melody", "noisy", "passionate male vocal", "cover", "ballad", "passionate", "emotional", "mono"] 4 cOgNXgF21u4 3702

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;