musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted sound", musiccaps_aspects contains "steady drumming" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- distorted sound · 2 ✖
- steady drumming · 2 ✖
- amateur recording 1
- amateur sound recording 1
- catchy beat 1
- classic melody 1
- classic rock 1
- electronic pop 1
- emotional 1
- groovy beat 1
- guitar accompaniment 1
- inaudible lyrics 1
- incoherent sounds 1
- indistinct chatter 1
- inferior audio quality 1
- keyboard arrangement 1
- loud 1
- male singer 1
- melodic 1
- metal scratching 1
- muffled music 1
- muffled vocals 1
- pop 1
- psychedelic 1
- retro 1
- retro rock and roll 1
- reverb 1
- rock and rock 1
- slow tempo 1
- soft melody 1
- table turner 1
- trance 1
- trap 1
- unpleasant 1
- violin symphony 1
- vocal riff 1
musiccaps_names (array) 7 ✖
- Music 2
- Beatboxing 1
- Drum machine 1
- Gospel music 1
- Scratch 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 | |
keumart Mouth scratch freestyle | This song is an electronic instrumental. It is medium tempo with a recurring vocal riff, steady drumming, table turner arrangement and distorted sounds like metal scratching. The audio is muffled, making it difficult to hear the finer elements of the song.The repetitive beats and rhythm give it a trippy, psychedelic and trance vibe. | 2011-10-31T23:04:06Z | keumart | Keumart Da Green Sayaman Double Swiss Beatbox Champion from "Shaolin Beat Masterz" | ["Beatboxing", "Music", "Scratch", "Drum machine"] | ["distorted sound", "vocal riff", "groovy beat", "table turner", "muffled music", "steady drumming", "catchy beat", "electronic pop", "trap", "psychedelic", "trance", "incoherent sounds", "metal scratching", "loud", "unpleasant", "amateur sound recording", "reverb"] | 7 | KWpsFxRTGkI | 2090 |
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;