musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- groovy · 4 ✖
- low quality 4
- noisy · 4 ✖
- passionate male vocal · 4 ✖
- punchy snare 3
- funky 2
- groovy bass 2
- punchy kick 2
- arpeggiated electric guitar melody 1
- boogie 1
- boomy bass guitar 1
- chill 1
- cover 1
- emotional 1
- funky electric guitar melody 1
- funky electric guitars melodies 1
- groovy synth keys 1
- harmonizing male vocals 1
- live performance 1
- loud stuttering low frequency audio crackle 1
- messy 1
- mono 1
- passionate 1
- reggae 1
- rock 1
- rock playback 1
- shimmering hi hats 1
- shimmering open hats 1
- simple hi hat 1
- synth lead melody 1
musiccaps_names (array) 17 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LA Amp Show 2008 -- Carl Verheyen & Steve Trovato (Mercury Magnetics room) | The low quality recording features a cover of a boogie song sung by a passionate male vocalist, followed by funky electric guitar melodies. It sounds passionate, groovy, funky and the recording is in mono and noisy. | 2008-10-10T00:30:35Z | MercuryMagnetics | Mercury Magnetics - Carl Verheyen and Steve Trovato live jam at the Amp Show 2008 in the Mercury Magnetics room. Check out www.stevetrovato.com ! | ["Singing", "Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "boogie", "cover", "funky electric guitars melodies", "passionate male vocal", "passionate", "groovy", "funky"] | 4 | 89eBh_Djflw | 899 | |
DUBPLATE SESSION, JAMAICA ( RANKSMASTER SOUND) FEAT LUCAN SCISSORS AND DOCTOR C | The low quality recording features a reggae song that consists of passionate male vocal singing over groovy bass, simple hi hats and punchy snare. There are some loud stuttering low frequency audio crackly noises in the recording, which makes it a bit uncomfortable to listen. It sounds groovy and chill regardless. | 2009-05-14T22:07:51Z | Karl Ranks | LIVE RECORDING SESSION AT ROOF INT'L STUDIO,OCHO RIOS | ["Music", "Drum machine"] | ["low quality", "noisy", "reggae", "passionate male vocal", "loud stuttering low frequency audio crackle", "groovy bass", "simple hi hat", "punchy snare", "groovy", "chill"] | 4 | Ex0ukzO5z9M | 1602 | |
Love me two times 2 (Doors) played on Gibson and piano bass | The low quality recording features a synth lead melody and groovy synth piano playing over rock songs played on playback. The song consists of a punchy kick and snare hits, shimmering hi hats, funky electric guitar melody, groovy bass and passionate male vocals singing over it in the beginning. It sounds funky and groovy, while the recording is a bit noisy. | 2007-04-13T18:21:38Z | serenities | The Doors; Love me two times, played on a Gibson G101 (1967) and a Fender Rhodes Piano Bass (1966). Original background song by The Doors. | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "rock playback", "punchy snare", "shimmering hi hats", "funky electric guitar melody", "groovy bass", "passionate male vocal", "punchy kick", "groovy synth keys", "synth lead melody", "groovy", "funky"] | 4 | Simd4JoehW8 | 2782 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;