musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Bass guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- male voice · 3 ✖
- jam 2
- acoustic guitar 1
- amateur recording 1
- amp 1
- easygoing 1
- electric guitar 1
- exotic 1
- female backing voice 1
- flamenco 1
- gear showcase 1
- happy song 1
- instructive speaking 1
- moderate tempo 1
- organ song 1
- percussion 1
- review 1
- rock and roll 1
- rock and roll bass riffs 1
- sensual 1
- simple tune 1
- single instrument 1
- song for celebration 1
- vocal harmony 1
musiccaps_names (array) 13 ✖
- Bass guitar · 3 ✖
- Music 3
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Speech 2
- Acoustic guitar 1
- Chorus effect 1
- Flamenco 1
- Funk 1
- Rock and roll 1
- Soul music 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Paco de Lucia plays an Erez Perelman Flamenco Guitar Part 1 | This is an instrument review jam that is played in the style of flamenco music. There is an acoustic guitar being played while a male voice gives his opinion concerning the instrument. The character of the sound is sensual. The guitar sounds can be sampled for use in beat-making. | 2011-11-22T11:13:27Z | Erez Perelman | Order Your Handmade Classical or Flamenco Guitar Here: http://erez-perelman.com/contact/ Paco de Lucias playing Erez Perelman flamenco guitar. | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["jam", "flamenco", "acoustic guitar", "male voice", "review", "exotic", "sensual"] | 9 | axqtExFY5-s | 3590 | |
Rivera Ktre 55watt with reverb combo demo | This is a gear showcase video demonstrating the sound difference when an electric guitar is connected to an amp. The electric guitar is playing simple tunes. A male voice is describing the applied effect. Sounds from this piece can be sampled for use in beat-making. | 2007-09-11T14:56:24Z | Rivera Amplification | Paul Rivera Jr of Rivera Amplification shows the Knucklehead Tre 55watt with Reverb combo while Luis Maldonado Plays it | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Speech", "Plucked string instrument"] | ["jam", "gear showcase", "single instrument", "electric guitar", "amp", "male voice", "instructive speaking", "easygoing", "simple tune"] | 9 | n1PTn_NH_K0 | 4512 |
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;