musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass guitar", musiccaps_author = 9 and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- bass guitar · 2 ✖
- cheerful 2
- christmas music 2
- acoustic drums 1
- cebuano language 1
- electric guitar 1
- electric piano 1
- female vocal 1
- female voice 1
- festive 1
- festive singing 1
- joyful 1
- keyboard 1
- male vocal 1
- male voice 1
- melodic singing 1
- romanian 1
- sleigh bells 1
musiccaps_names (array) 4 ✖
- Christian music 2
- Christmas music · 2 ✖
- Music 2
- Jingle (music) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
COLINDE SUPERBE NASTACUTA IUGA YouTube | This is a Christmas music piece. There is one male and one female vocalist singing in a festive manner in the Romanian language. There is a keyboard playing the melody and a bass guitar playing in the background. The rhythm is kept by the sleigh bells. The atmosphere is joyful. This piece could be playing in the background at a Christmas event in Romania. | 2012-11-22T21:22:42Z | Giuliano Bungardi | ["Christmas music", "Christian music", "Music"] | ["christmas music", "romanian", "male vocal", "female vocal", "festive singing", "bass guitar", "keyboard", "sleigh bells", "cheerful", "joyful"] | 9 | HTQySJM4Jhg | 1805 | ||
Mag-ambahan | This is a Christmas music piece. There is a male voice and a female voice singing melodically in the Cebuano language. The electric piano is playing the main melody while the electric guitar and the bass guitar are playing in the background. The rhythm is provided by a simple and upbeat acoustic drum beat. The atmosphere is festive and cheerful. This piece could be the opening theme of a Christmas movie that takes place in the southern Philippines. | 2010-12-10T09:35:04Z | ryahnz | Mag-ambahan ta ning pasko sa kalipay Ang kagul-anan ta ato nga isalikway Ug duyog ning awit sa malipayong dughan Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya Wad-on ta ang mga kayugot Isalikway ta ang pagdumot Ang pagpasaylo mao'y angay buhaton ta Ning adlaw sa manunubos (Repeat Mag-ambahan stanza) Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya | ["Christmas music", "Christian music", "Jingle (music)", "Music"] | ["christmas music", "male voice", "female voice", "melodic singing", "cebuano language", "electric piano", "electric guitar", "bass guitar", "acoustic drums", "festive", "cheerful"] | 9 | tDZPGf8WYmI | 5016 |
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;