musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "blues" and musiccaps_aspects contains "happy" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- blues · 3 ✖
- happy · 3 ✖
- blues drum kit 1
- bouncy bass 1
- brass melody 1
- bright male vocals 1
- electric guitar melody 1
- electric guitar stabs 1
- electric keyboard 1
- falsetto male vocals 1
- fast tempo 1
- fun 1
- funky 1
- groovy 1
- harmonizing background male vocals 1
- low quality 1
- major key 1
- noisy 1
- positive 1
- punchy kick 1
- punchy snare 1
- raspy male vocals 1
- shimmering hi hats 1
- simple bluesy drum beat 1
- throaty male vocal 1
- twangy electric guitar 1
- twelve bar blues 1
- upbeat 1
- vintage 1
- walking double bass 1
musiccaps_names (array) 8 ✖
- Music 3
- Blues 1
- Music of Asia 1
- Rattle 1
- Rock and roll 1
- Singing 1
- Ska 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Blues Willies - Shout | The track is an upbeat blues song that features falsetto and raspy male vocals. A drum kit plays an energetic and happy beat. A bass guitar follows the rhythm and adds a bouncy vibe to the song. The overall sound of the instruments is bright and happy. A guitar follows the bass and the drum kit. | 2007-05-03T10:44:42Z | Alfredo | I Blues Willies al concertone del primo Maggio 2007 a S. Giovanni. A parte il mitico Chuck Berry, l'unico vero gruppo che c'entrava qualcosa con il rock'n'roll! www.blueswillies.it | ["Singing", "Music of Asia", "Music", "Ska", "Whoop", "Rock and roll"] | ["blues", "upbeat", "falsetto male vocals", "raspy male vocals", "fast tempo", "blues drum kit", "positive", "happy", "bright male vocals", "bouncy bass"] | 5 | vtVfl5Ff5lw | 5216 | |
Sesame Street - Shake Your Rattle And Roll | The low quality recording features a blues song that consists of throaty male vocals, alongside harmonizing male vocals, singing over electric guitar melody, brass melody, shimmering hi hats, punchy snare and kick hits and walking double bass. It is a bit noisy and it sounds funky, groovy, happy, fun and vintage - like something you would want to dance to. | 2007-07-19T01:58:43Z | LittleJerryFan92 | Sing it, baby! | ["Music", "Rattle"] | ["low quality", "noisy", "brass melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "punchy kick", "throaty male vocal", "walking double bass", "groovy", "funky", "harmonizing background male vocals", "blues", "vintage", "happy", "fun"] | 4 | oh5XmtSAOuM | 4651 | |
Backing Track Blues in C | This is a bright and twangy twelve bar blues song. We hear some intricate piano playing, a bright and warm electric guitar on which chords are being played, and a groovy walking bassline. This song would be suitable in a blues bar. | 2010-10-06T06:10:59Z | MrYae bass lesson | ["Blues", "Music"] | ["blues", "twangy electric guitar", "electric keyboard", "twelve bar blues", "major key", "happy", "electric guitar stabs", "simple bluesy drum beat"] | 3 | nzdlPYd8XUs | 4599 |
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;