musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive" and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- addictive · 3 ✖
- energetic 2
- groovy bass 2
- low quality 2
- shimmering hi hats 2
- alternative/indie 1
- audio distortion 1
- bright brass melody 1
- crackles 1
- drum break 1
- electric guitar chord progression 1
- electric rhythm guitar chords 1
- energetic crash 1
- flat male vocal 1
- funk/soul 1
- funky 1
- funky guitar melody 1
- groovy 1
- groovy thin bass guitar 1
- harmonizing background male vocal 1
- harmonizing mixed vocals 1
- live performance 1
- mono 1
- noisy 1
- passionate male vocal 1
- punchy kick 1
- punchy kick hits 1
- punchy snare 1
- reverberant 1
- rock 1
- shimmering cymbals 1
- soft crash cymbal 1
- soft rimshots 1
- soft snare hits 1
- thin snare 1
musiccaps_names (array) 7 ✖
- Music 3
- Rock and roll · 3 ✖
- Exciting music 1
- Psychedelic rock 1
- Roll 1
- Singing 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ill Scarlett - Babylon Song @ Sound of Music | The low quality recording features a live performance of an Alternative/Indie song and it consists flat male vocal singing over electric guitar chord progression, thin, but groovy bass guitar, punchy kick and snare hits, soft rimshots, soft crash cymbal, shimmering hi hats and a drum break. It sounds energetic, groovy and addictive, due to the cadence. | 2008-06-25T11:52:33Z | KyleCherops | ill Scarlett - "Babylon Song" live at Sound of Music Festival 2008 Burlington, ON | June 14, 2008 video 04 of 10 shot by Kyle Cheropita www.ishotyourset.net www.cherops.com | ["Music", "Rock and roll", "Exciting music"] | ["low quality", "live performance", "alternative/indie", "flat male vocal", "audio distortion", "electric guitar chord progression", "punchy kick", "shimmering hi hats", "punchy snare", "soft rimshots", "groovy thin bass guitar", "soft crash cymbal", "drum break", "addictive", "groovy", "energetic"] | 4 | 8akqVDDGsNQ | 931 | |
The Music City Soul Brothers - let our love go on (Music City) | The low quality recording features harmonizing mixed vocals singing over groovy bass, shimmering cymbals, soft snare hits, funky guitar melody and bright brass melody. The recording is very noisy, in mono, with some crackles in it and it sounds funky and addictive - thanks to those vocals. Sounds like something you would hear in clubs during the 60s and 70s. | 2014-01-27T18:37:44Z | Alex Rural Soul | this song remind me the impressions Hit "it's allright"..i love this style of mid tempo soul ... for first time on youtube!!!! | ["Singing", "Swing music", "Music", "Psychedelic rock", "Rock and roll"] | ["funk/soul", "low quality", "harmonizing mixed vocals", "groovy bass", "shimmering cymbals", "soft snare hits", "bright brass melody", "funky guitar melody", "funky", "noisy", "crackles", "addictive", "mono"] | 4 | ZsmfIMEzrQs | 3422 | |
The Connells - Scotty's Lament | The Rock song features a passionate male vocal, layered with harmonizing background male vocals, singing over electric rhythm guitar chords spread widely in the stereo image, thin snare, energetic crash, groovy bass, shimmering hi hats and punchy kick hits. The drums are very reverberant, which is probably the reason why they sound softer. It sounds addictive, thanks to those harmonizing vocals, and energetic overall. | 2007-11-12T22:30:12Z | streetsintherain | The video for "Scotty's Lament", made in 1987. | ["Music", "Roll", "Rock and roll"] | ["rock", "passionate male vocal", "harmonizing background male vocal", "electric rhythm guitar chords", "groovy bass", "thin snare", "energetic crash", "shimmering hi hats", "punchy kick hits", "reverberant", "addictive", "energetic"] | 4 | hKSg3zFB2dE | 4095 |
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;