musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "classic rock" and musiccaps_aspects contains "guitar accompaniment" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- classic rock · 2 ✖
- emotional 2
- guitar accompaniment · 2 ✖
- male singer 2
- amateur recording 1
- bad audio quality 1
- classic melody 1
- distorted sound 1
- groovy rhythm 1
- inaudible lyrics 1
- indistinct chatter 1
- inferior audio quality 1
- keybiard accompaniment 1
- keyboard arrangement 1
- love songs 1
- medium tempo 1
- melodic 1
- modern pop songs 1
- muffled vocals 1
- new age 1
- passionate 1
- piano accompaniment 1
- pop 1
- pop song 1
- realisation 1
- retro 1
- retro rock and roll 1
- rock and rock 1
- romantic song 1
- sadness 1
- slow tempo 1
- soft melody 1
- steady drumming 1
- steady drumming rhythm 1
- string bass line 1
- violin symphony 1
musiccaps_names (array) 5 ✖
- Music 2
- Christian music 1
- Gospel music 1
- Singing 1
- Wedding music 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 | |
Matthew Perryman Jones - Save you lyrics | A male singer sings this poignant love song. The song is medium tempo with a steady drumming rhythm, strong bass line, keyboard accompaniment, guitar accompaniment and percussion hits. The song is emotional and romantic. The song audio quality is bad. | 2010-08-30T19:02:00Z | dionyts91 | Matthew Perryman Jones' official website: http://mpjmusic.com this is one of the KYLE XY 's, ONE TREE HILL 's , PRETTY LITTLE LIARS' soundtracks !! i love it!! I M SORRY FOR POSSIBLE MISTAKES ON THE LYRICS!! i don't own any rights! | ["Christian music", "Music"] | ["male singer", "classic rock", "pop song", "bad audio quality", "medium tempo", "string bass line", "guitar accompaniment", "piano accompaniment", "keybiard accompaniment", "steady drumming rhythm", "emotional", "passionate", "groovy rhythm", "new age", "romantic song", "sadness", "realisation", "modern pop songs", "love songs"] | 1 | Jq2w30NYstQ | 2037 |
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;