musiccaps_details (view)
6 rows where musiccaps_aspects contains "rock and roll" and musiccaps_author = 0 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- percussion 6
- rock and roll · 6 ✖
- bass 4
- male voice 4
- low quality audio 3
- moderate tempo 3
- fast tempo 2
- acoustic song 1
- amateur band 1
- amateur recording 1
- call and response style 1
- crowd singing 1
- dance song 1
- doo wop 1
- female backing voice 1
- female backing voices 1
- gospel style 1
- guitars 1
- happy mood 1
- happy song 1
- instrumental 1
- lead guitar 1
- live recording 1
- low quality recording 1
- no voices 1
- organ song 1
- overdriven guitar 1
- piano 1
- quirky sounds from the crowd 1
- rock and roll bass riffs 1
- saxophone 1
- song for celebration 1
- vocal harmony 1
musiccaps_names (array) 17 ✖
- Music 6
- Rock and roll 3
- Psychedelic rock 2
- Rock music 2
- Bass guitar 1
- Bluegrass 1
- Funk 1
- Musical instrument 1
- Percussion 1
- Pop music 1
- Pulse 1
- Punk rock 1
- Roll 1
- Singing 1
- Ska 1
- Soul music 1
- Yell 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bon Jovi - Shout. 6 November 2010 Madrid | This rock and roll song features a male voice singing the main melody. This is accompanied by percussion playing a fast tempo beat. Guitars play chords. The bass plays the root notes of the chords. The vocal melody follows a gospel style call and response theme. The main voice sings one line and the crowd responds by singing another line. The tempo of this song is fast. This is a low quality audio and other instruments cannot be identified. | 2010-11-07T12:53:34Z | Christian Gamdek | Bon Jovi - Shout. 6 November 2010 Madrid Recorded by The Red Scarf Girl PHOTOS: http://www.facebook.com/album.php?aid=243743&id=574951338&l=9986f2817b | ["Music", "Yell"] | ["rock and roll", "low quality audio", "male voice", "bass", "percussion", "gospel style", "crowd singing", "guitars", "call and response style", "fast tempo"] | 0 | SGcjdZ19R1k | 2755 | |
Masonics - Outside Looking In | This low quality audio features an electric guitar playing a solo. The sounds of the instruments are not clear due to the low audio quality. The percussion plays a fast beat in the background. There are no voices in this song. This song can be played in a car chase sequence in a movie. | 2006-12-12T13:44:19Z | beatsvillerecords | The Masonics perform "I'm on the Outside Looking In" at "The Cluny" in Newcastle-Upon-Tyne. | ["Music", "Musical instrument", "Pop music", "Pulse", "Percussion"] | ["rock and roll", "low quality audio", "percussion", "lead guitar", "no voices", "instrumental", "fast tempo"] | 0 | YqAsph_ouRM | 3314 | |
Rock-Jerry & The Sounds 2014 Taarasti | This rock and roll song is a live recording of low quality. This features a male voice singing the main melody. This is accompanied by percussion playing a simple melody in common time. The bass plays a rock and roll bassline. The keyboard plays chords and fills using a piano tone. An acoustic guitar plays chords. A voice from the crowd sings a quirky sound at the beginning of the second bar. This song can be used in a retro movie in a music festival or carnival scene. | 2014-10-21T16:53:27Z | seti kolj | Kunnianosoitus Suomalaisen rockin pioneerille | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Rock and roll", "Bluegrass"] | ["rock and roll", "live recording", "low quality recording", "amateur band", "acoustic song", "bass", "quirky sounds from the crowd", "piano", "percussion", "moderate tempo"] | 0 | b8okzVltB5Q | 3604 | |
SOUL RE VISION - Let The Good Times Roll | This rock and roll song features a male voice singing the main melody. There is a female and male backing voice singing in harmony. This is accompanied by percussion playing a simple beat in common time. The bass plays a 12 bar blues lick. The organ fills in between lines. The mood of this song is happy. The quality of audio is low. This song can be played at a celebration party. | 2012-12-16T21:40:10Z | Krzysztof Rybarczyk | Dr Blues & SOUL RE VISION Let The Good Times Roll /Louis Jordan/ MTP Hala 2 - POZNAŃ (PL) 09.12.2012 Występ przed koncertem grupy Dżem. www.SoulReVision.pl www.DrBlues.pl fb: Soul Re Vision -- Krzysztof Rybarczyk /Dr Blues/ - vocal, guitar Jakub Kurek - trumpet Łukasz Matuszewski - tenor sax Piotr Banyś - trombone Janusz Musielak - guitar Adam Bieranowski - piano Piotr Skraburski - hammond Joanna Dudkowska - bass guitar Tomasz Boguś - drums Rejestracja audio - Piotr Madziar Rejestracja video - MM Studio | ["Bass guitar", "Funk", "Music", "Rock and roll", "Soul music"] | ["rock and roll", "amateur recording", "male voice", "female backing voice", "vocal harmony", "percussion", "rock and roll bass riffs", "organ song", "happy song", "song for celebration", "moderate tempo"] | 0 | JFJuEOZx1K4 | 1985 | |
Základní taneční - Rock n roll.mpg | This clip features a rock and roll song. The main melody is sung by a male voice. Female voices sing backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat in common time. A saxophone is playing fills in between lines. Due to the low audio quality, other instruments are not clearly audible. This song can be played in a dance party with a retro theme. | 2010-10-05T18:44:42Z | tkclassic | ["Music", "Psychedelic rock", "Rock music", "Roll", "Rock and roll"] | ["rock and roll", "dance song", "doo wop", "male voice", "female backing voices", "percussion", "saxophone", "bass", "low quality audio"] | 0 | UC_XpUcIQ_8 | 2893 | ||
Мумий Тролль - Медведица (live from Piter, Алые Паруса 07) | This rock and roll song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat in common time. An overdriven guitar plays chords with licks in between lines. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a movie scene when the protagonist is walking into a hotel prior to a fight scene. | 2007-06-28T16:52:07Z | Мумий Тролль (Mumiy Troll) | Russias biggest rock band, Mumiy Troll began as one of the most socially dangerous bands in the world as noted by a local Communist party chief in the former Soviet Union; yet, was hailed as Best Band of the Millennium by leading Russian music critics after the fall of communism. Mumiy Troll are the most influential and successful independent artists in Russia today. Part of Mumiy Troll's success can be attributed to their multi-genre sound, a hybrid of rock and pop which songwriter Lagutenko calls "rockapops". The Los Angeles Times has described the band "a nuclear meltdown of The Bravery, Tom Petty and The Afghan Whigs." http://www.mumiytroll.com/en http://en.wikipedia.org/wiki/Mumiy_Troll http://www.myspace.com/mumiy http://www.ikra.tv | ["Singing", "Music", "Ska"] | ["rock and roll", "male voice", "overdriven guitar", "percussion", "bass", "moderate tempo", "happy mood"] | 0 | vEN9szBPBkw | 5166 |
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;