musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo" and "youtube_published" is on date 2016-03-30
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- slow tempo · 2 ✖
- amateur recording 1
- calm 1
- contrast song fade 1
- emotional 1
- k-pop 1
- k-pop hits 1
- korean pop 1
- love song 1
- male vocalist 1
- male voice speaking 1
- mellow 1
- mellow guitar 1
- passionate 1
- romantic 1
- saxophone 1
- soft 1
- soft acoustic guitar accompaniment 1
- song fade 1
- synthesiser arrangements 1
- vigorous introduction 1
musiccaps_names (array) 4 ✖
- Brass instrument 1
- Music 1
- Saxophone 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kim Jaejoong MUSIC QUIZ | A male vocalist sings this mellow pop. The tempo is slow in contrast to the enthusiastic introductory bit in this section. The song is soft, mellow, emotional, repetitive, melancholic, nostalgic and passionate with a soft acoustic guitar accompaniment. This could be a song fade. This song is a Korean Pop/K-Pop song. | 2016-03-30T01:17:32Z | JaejoongArabFansC3 | Website: http://jaejoongarabfans.com/ Facebook: https://www.facebook.com/JaejoongArabFans Twitter: https://twitter.com/JaejoongArabFan | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "vigorous introduction", "synthesiser arrangements", "contrast song fade", "soft acoustic guitar accompaniment", "korean pop", "k-pop", "k-pop hits", "mellow guitar", "song fade", "love song", "romantic", "emotional", "passionate", "mellow", "soft", "calm"] | 7 | 4i1aizhCnfg | 596 | |
[드림뮤직] 색소폰 강의(3강) - 색소폰 저음&고음 소리내는 요령 Saxophone lesson | This audio contains a male voice talking when someone starts playing a melody in the lower mid-range on a saxophone. This song may be playing live during a saxophone class. | 2016-03-30T07:50:34Z | 드림뮤직 | 성남실용음악의 중심! 드림뮤직 아카데미. 수강문의 : http://www.d-music.co.kr 학원에 방문해주시면 악보를 제공 해 드립니다. | ["Brass instrument", "Saxophone"] | ["amateur recording", "male voice speaking", "saxophone", "slow tempo"] | 6 | dlhlQKTz3Vs | 3812 |
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;