musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "slow tempo", musiccaps_author = 7 and musiccaps_names contains "Wedding music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- slow tempo · 2 ✖
- amateur recording 1
- celestial 1
- classic melody 1
- classic rock 1
- distorted sound 1
- emotional 1
- enigmatic 1
- female singer 1
- flute harmony 1
- guitar accompaniment 1
- harp 1
- inaudible lyrics 1
- indistinct chatter 1
- inferior audio quality 1
- keyboard arrangement 1
- male singer 1
- mellifluous dulcet 1
- melodic 1
- melodic piano accompaniment 1
- middle eastern music 1
- middle eastern stringed instrument 1
- muffled vocals 1
- mystical 1
- pleasant 1
- pop 1
- retro 1
- retro rock and roll 1
- rock and rock 1
- soft melody 1
- …
musiccaps_names (array) 4 ✖
- Music 2
- Wedding music · 2 ✖
- Gospel music 1
- Singing 1
youtube_published (date) 2 ✖
- 2009-04-07 1
- 2011-06-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BJ Thomas ~ Rock And Roll Lullaby | A male vocalist sings this melodic song. The tempo is medium with muffled vocals, violin harmony, rhythmic guitar , steady drumming and straight bass lines. The language and lyrics of the song are inaudible because of the amateur recording.This song is a Classic Rock and Roll. | 2011-06-25T22:02:46Z | IP Casino Resort Spa | BJ Thomas sings "Rock And Roll Lullaby" in Studio A in the IP Casino Resort Spa on June 24, 2011 | ["Singing", "Gospel music", "Music", "Wedding music"] | ["male singer", "slow tempo", "inaudible lyrics", "amateur recording", "melodic", "indistinct chatter", "soft melody", "emotional", "distorted sound", "violin symphony", "guitar accompaniment", "keyboard arrangement", "muffled vocals", "inferior audio quality", "rock and rock", "classic melody", "pop", "classic rock", "retro", "retro rock and roll", "steady drumming"] | 7 | BUzsQ6WohH4 | 1245 | |
arabic traditional music very soothing RUM | A female vocalist sings this ethereal melody. The tempo is slow with a beautiful flute harmony, melodious piano accompaniment, Arabic guitar and groovy bass lines. The song has no lyrics with ethereal vocalisation. It is soft, mellifluous, calming, pleasant,enigmatic, celestial and ethereal with a middle eastern feel. | 2009-04-07T18:06:11Z | detroitjeeper | song: ya mahla el fussha performed by Tarik ElNasser and RUM BAND RUM Band is a Jordanian band led by Tarik ElNasser who is a composer and a vocalist in some of his work, Rum Band might not be that famous but their work is very well known among Arabs for being the amazing soundtracks for so many big hit soap operas and TV series. | ["Music", "Wedding music"] | ["female singer", "slow tempo", "vocalisation", "middle eastern music", "pleasant", "celestial", "mellifluous dulcet", "enigmatic", "mystical", "middle eastern stringed instrument", "harp", "flute harmony", "melodic piano accompaniment", "steady bass line"] | 7 | mvZLlJpyDyc | 4501 |
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;