musiccaps_details (view)
3 rows where musiccaps_aspects contains "male vocal", musiccaps_names = "["Music", "Roll", "Rock and roll"]" and musiccaps_names contains "Roll"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ROCK AND ROLL DANCE Argentina ZONA SUR | This is a rock and roll piece used as an accompaniment for a dance. There is a male vocal singing at a low-to-medium pitch. The main melody is being played by an electric guitar while the bass guitar is repeating a bass line with a groovy pattern in the background. The acoustic drums are playing an upbeat 4/4 rock and roll beat. There is a raw feeling to it. The tune is catchy. This piece could be playing in the background of a sports bar or a rock bar. It could also work well at sports venues. | 2007-10-26T05:36:25Z | jorgetapdance | rock and roll - ZONA SUR dedicado a todos los rockers ABEL-LUISITO-DANI. la larva - TOTITO - SIMON y mas..... EL EDEN 2006 - | ["Music", "Roll", "Rock and roll"] | ["rock and roll", "dance", "male vocal", "low-to-medium pitch singing", "electric guitar", "bass guitar", "loud", "raw", "catchy", "upbeat"] | 9 | D8-x1T8M4gk | 1442 | |
SOY TU ROMANTICO ROCK AND ROLL | This is a rock music piece. The male vocalist is singing melodically in the Spanish language. The keyboard is playing the chords of the song while the electric guitar joins with the occasional fills. There is a relatively quiet bass guitar supporting them in the background. The acoustic drums provide a basic rock beat for the rhythm. It has an easygoing feeling. This piece could be used in a teenage drama taking place in a Spanish-speaking country. | 2011-07-13T23:21:03Z | Alejandro Emmanuel | ["Music", "Roll", "Rock and roll"] | ["rock music", "male vocal", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "spanish", "easygoing"] | 9 | deIj55UAxeo | 3806 | ||
Poison- I Won't Forget you Lyrics | This is a glam metal/heavy metal ballad. There is a male vocal and male back vocals singing melodically. The melody is being played on an electric guitar with a chorus effect applied alongside a bass guitar. The rhythmic background consists of a rock acoustic drum beat.The atmosphere is both hard-hitting and sentimental at the same time. This piece could be playing in the background of a rock/metal bar. It could also be included in the soundtrack of an 80s themed romance movie. | 2009-08-26T19:16:57Z | GenreLyrics | Thank you MaSSaChRoNiC for suggesting this song to me. | ["Music", "Roll", "Rock and roll"] | ["glam metal", "heavy metal", "ballad", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "hard-hitting", "sentimental", "medium tempo"] | 9 | uiHyWdYkBvY | 5133 |
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;