musiccaps_details (view)
2 rows where musiccaps_aspects contains "funny", musiccaps_author = 7 and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- funny · 2 ✖
- instrumental 2
- acoustic guitar 1
- animated 1
- animated electronic sound 1
- animated sounds 1
- banjo riff 1
- bee buzzing 1
- camera sounds 1
- children’s song 1
- clapping 1
- clicking sound 1
- crowd cheering 1
- foreign language 1
- four stringed instrument 1
- guitar string plonk 1
- hooting sound 1
- introduction music 1
- kids screaming in joy 1
- male voice talking 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- soft 1
- swishing sound 1
- ukelele melody 1
- vocalisation 1
- water bubbling 1
musiccaps_names (array) 9 ✖
- Guitar · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Banjo 1
- Singing 1
- Speech 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Man of Constant Sorrow Bluesy Guitar Lesson! | This music is an instrumental with a lot of vocalisation and animated sounds. There are sounds of swishing, water bubbling, guitar string plonking, acoustic guitar riff, camera clicking pictures, kids screaming in glee, cheering and clapping. This music seems to be an introduction to a Show. | 2014-06-16T12:31:33Z | Banjo Ben Clark | Lesson link: https://banjobenclark.com/lessons/man-of-constant-sorrow-guitar - I absolutely LOVE this version on guitar! It would be easy to throw together a bunch of bluesy licks that work over the chords, but it's another thing to play bluesy licks that sing the melody, which is what we do here! Make sure you watch the ~30 minute video that matches these tabs and mp3's! | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium fast tempo", "acoustic guitar", "introduction music", "vocalisation", "animated sounds", "banjo riff", "water bubbling", "crowd cheering", "clapping", "kids screaming in joy", "funny", "hooting sound", "clicking sound", "guitar string plonk", "swishing sound", "camera sounds"] | 7 | 7ITwarmdyfI | 824 | |
Chikungunya | This music is a ukelele instrumental. The tempo is medium with the sound of a bee buzzing and an animated sound followed by a dialogue between two men in a foreign language. The music is mellow, soft and simple like it's meant for children. | 2014-10-04T21:51:37Z | Sancocho | Chinkungunya by Sancocho De los Creadores de "Ser Boricua Esta Brutal" Ahora les traemos Un tema exclusivo para internet Chinkungunya. Pronto Esperen el Disco Entero, pronto en Algun Momento y Despues las Presentaciones en Vivo, Creemos! WHAT!?! Composicion por Andre Caro y Osvaldo Friger con la Ayuda de Lejos de Dwella | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "male voice talking", "soft", "mellow", "animated", "foreign language", "four stringed instrument", "bee buzzing", "ukelele melody", "animated electronic sound", "funny", "animated", "children’s song"] | 7 | I_wT76iYBdQ | 1920 |
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;