musiccaps_details (view)

3 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names contains "Music of Asia"

✎ View and edit SQL

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
MUSICA CRISTIANA Ayudame Señor Jose Felipe This is a Christian gospel music piece. The male vocalist is singing melodically in the Spanish language. There is an acoustic guitar playing the main melody while a bass guitar plays in the background. In the rhythmic background, the acoustic drums are playing a calm beat. The atmosphere is religious. This music would suit well in Christian religious events in Spanish speaking countries. 2009-08-18T23:55:02Z YETSEL ["Music of Asia", "Christian music", "Music", "Song"] ["christian", "gospel", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "religious", "devotional"] 9 CdgQIiMdBa4 1387
Happy happy - (Ost.You are my destiny) This slow jazz song features a female voice. This is accompanied by an acoustic guitar playing chords. A keyboard plays a fills using a xylophone-like tone. The bass plays the root notes of the chords. Finger snaps are played in some spaces between lines. A shaker provides the percussion for this song. The song features a jazz chord progression providing some complexity to this song. The mood of this song is romantic. This song can be played in a romantic movie. 2009-10-22T16:51:15Z Supitcha Kh i'm sone!! i know the picture on video is YoonA because she acted YAMD "Yuri" i mean "Sung Yuri" because she sung this song my title is ambiguous :: sorry to make you misunderstanding :) thanks for watch my video ---------------------------------------------- Ost.You are my destiny Artist : Sung yu ri Title: 너는 내 운명 / Neoneun Nae Unmyeong Also known as: You Are My Destiny / You Are My Life Genre: Romance, family Episodes: 178 Broadcast network: KBS1 Broadcast period: 2008-May-05 to 2009-Jan-09 Air time: Monday to Friday 8:25 PM Im Yoon Ah as Jang Sae Byuk Park Jae Jung as Kang Ho Se ["Music of Asia", "Music", "Song"] ["slow jazz song", "young female voice", "acoustic guitar", "finger snaps", "keyboard", "shaker", "romantic mood"] 0 CgK0DU3KFBc 1392
รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music This is a Valentine's ballad. The male vocalist is singing gently in the Thai language. There is an acoustic guitar, a piano and a flute playing the melody interchangeably. There is a simple acoustic drum beat in the rhythmic background. The atmosphere of this piece is romantic. It could be used in romantic social media content in Thailand. It could also be used in romantic movies and TV shows that take place in Thailand. 2016-02-05T05:56:27Z ป.ฉลาดใหญ่ รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music ฝากกดติดตามช่อง ป.ฉลาดใหญ่ บันเทิงศิลป์ ด้วยนะครับ คลิกที่ลิ้งค์เลย https://www.youtube.com/channel/UC98T... แสลงใจ อ้ายมีเขา แต่เจ้ามีอ้าย กลิ่นไฟเก่า บ่ฮักกะส่าง อยู่กับอ้ายน้อยใจบ่ ผัวสำรอง เมียสำรอง ฮัก คารม ซ่อยข่อยแหน่ ["Music of Asia", "Music", "Song", "Happy music"] ["ballad", "male vocal", "gentle singing", "acoustic guitar", "piano", "flute", "acoustic drums", "sentimental", "romantic", "valentines", "thai"] 9 L0oun9F67tg 2142

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;