musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Whoop" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- fast tempo · 3 ✖
- energetic 2
- backup singers 1
- bass guitar 1
- black gospel influences 1
- blues 1
- blues drum kit 1
- bouncy bass 1
- bright male vocals 1
- choral harmony 1
- crooners 1
- electric guitar 1
- emotional 1
- exciting 1
- falsetto male vocals 1
- female singers 1
- groovy bass line 1
- happy 1
- hard-hitting 1
- heavy metal 1
- invigorating 1
- jazz music influences 1
- keyboard accompaniment 1
- live performance 1
- loud 1
- loud acoustic drums 1
- love song 1
- male vocal 1
- music 1
- music you 1
- need your loving 1
- passionate 1
- percussive horn section 1
- positive 1
- powerful singing 1
- raspy male vocals 1
- retro pop influences 1
- soul singers 1
- stro telling 1
- upbeat 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
- Music 3
- Whoop · 3 ✖
- Music of Asia 1
- Rock and roll 1
- Singing 1
- Ska 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SHOUT - The Fabsisters [Cover Of - The Isley Brothers/Lulu] | A female singer sings this soulful melody with backup singers in vocal harmony. The song is fast tempo with a quick drumming rhythm, percussive bass line, guitar strumming rhythm and keyboard accompaniment. The song has black gospel roots. | 2012-02-22T18:56:06Z | The Fabsisters | Please watch: "The Drinks are all on him-Folake (The Fabsisters)" https://www.youtube.com/watch?v=pTs3mNrht_4 -~-~~-~~~-~~-~- Please watch: "The Fabsisters - Can't Be With You Tonight" ➨ https://www.youtube.com/watch?v=lG1ce8BrEQ4 | ["Music", "Whoop", "Yell"] | ["female singers", "vocal harmony", "backup singers", "passionate", "music you", "need your loving", "soul singers", "percussive horn section", "keyboard accompaniment", "crooners", "stro telling", "love song", "emotional", "choral harmony", "black gospel influences", "emotional", "exciting", "energetic", "jazz music influences", "retro pop influences", "music", "fast tempo", "groovy bass line"] | 1 | qpt3umHYfmY | 4824 | |
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 | |
1983 Ronnie James Dio "Stand Up and Shout" (Rock Palace) | This is the live recording of a heavy metal music piece. The male vocalist in the lead has a powerful wide-ranged vocal. There is an overdriven electric guitar that is playing a repeated riff with a bass guitar supporting it in the background. The rhythm is provided by a loud, fast-paced metal beat on the acoustic drums. The atmosphere is hard-hitting and energetic. The piece could be playing in the background of a rock/metal bar. | 2007-06-01T01:16:31Z | music3874 | Ronnie James Dio performing "Stand Up And Shout" on a US late night television show, "The Rock Palace." I believe this was recorded very shortly after the release of the "Holy Diver" album. From the same show, also see: Rainbow in the Dark http://www.youtube.com/watch?v=LmSt1oEIshE Man On The Silver Mountain http://www.youtube.com/watch?v=vOyFE-1LAI0 | ["Music", "Whoop"] | ["heavy metal", "live performance", "male vocal", "powerful singing", "electric guitar", "bass guitar", "loud acoustic drums", "hard-hitting", "energetic", "loud", "invigorating", "fast tempo"] | 9 | zixIuxzCCvs | 5505 |
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;