musiccaps_details (view)
4 rows where musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- bass guitar · 4 ✖
- rock and roll · 4 ✖
- electric guitar 3
- acoustic drums 2
- easygoing 2
- groovy 2
- male vocal 2
- simple tune 2
- upbeat 2
- american 1
- baby crying 1
- blues 1
- catchy 1
- classic pop 1
- dance 1
- fast tempo 1
- infectious drumming 1
- instrumental 1
- keyboard harmony 1
- loud 1
- love song 1
- low-to-medium pitch singing 1
- male back vocals 1
- male singer 1
- overdriven 1
- raw 1
- repeated theme 1
- retro 1
- romantic 1
- static 1
- steady drumming 1
- superimposed noises 1
- synthesiser arrangements 1
- tapping sound 1
- violins 1
- vivacious 1
- youthful 1
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 | |
MITCH RIDER & the DETROIT WHEELS - BREAKOUT | This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. | 2011-04-23T15:20:22Z | PaulGTSE | MITCH RIDER & the DETROIT WHEELS with BREAKOUT on the UK PYE DISCO DEMAND LABEL 100mph NORTHERN SOUL | ["Funk", "Music", "Soul music"] | ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] | 9 | GQbUpJFArKI | 1720 | |
ROCK AND ROLL (G) BY SILASOUREN | This is an instrumental rock and roll music piece. An overdriven electric guitar is playing the melody while a bass guitar is playing the background. There is a basic rock drum beat keeping the rhythmic structure. There is a groovy, easygoing atmosphere. This music could be played in the background at a rock bar or a sports venue. | 2010-06-08T13:26:18Z | silasouren | BASE DE ROCK EN G DISFRUTENLA PINCHES | ["Music", "Roll", "Rock and roll"] | ["rock and roll", "instrumental", "electric guitar", "overdriven", "bass guitar", "acoustic drums", "simple tune", "groovy", "easygoing"] | 9 | hzr2aY33EuI | 4155 | |
RickRolling the Baby | A male singer sings this classic pop song. The tempo is fast with keyboard harmony, violins,infectious drumming,funky bass guitar and synthesiser arrangement. There are sounds of static, tapping and a baby crying loudly superimposed on the song. The audio quality is inferior and the recording is amateur. This song is Retro Rock and Roll. | 2008-01-26T06:05:33Z | DessertSage | http://www.marylowd.com | ["Crying, sobbing", "Music", "Baby cry, infant cry", "Inside, small room"] | ["male singer", "fast tempo", "baby crying", "youthful", "romantic", "upbeat", "superimposed noises", "synthesiser arrangements", "infectious drumming", "love song", "romantic", "vivacious", "violins", "bass guitar", "keyboard harmony", "tapping sound", "static", "steady drumming", "classic pop", "rock and roll", "retro"] | 7 | qMbGFWz9who | 4780 |
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;