musiccaps_details (view)
3 rows where musiccaps_author = 4, musiccaps_names contains "Bass guitar" and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 26 ✖
- low quality 3
- noisy 2
- boomy 1
- buzzy bass guitar 1
- chaotic 1
- distorted 1
- electric guitar melody 1
- energetic 1
- energetic drums 1
- filtered female vocal 1
- flat male vocal 1
- fun 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- happy 1
- harsh electric guitar chords 1
- loud 1
- messy 1
- mono 1
- muddy 1
- playback drums instrumental 1
- punchy snare 1
- rock 1
- shimmering cymbals 1
- unbalanced stereo 1
musiccaps_names (array) 13 ✖
- Bass guitar · 3 ✖
- Blues · 3 ✖
- Music 3
- Musical instrument 2
- Funk 1
- Guitar 1
- Harmonic 1
- Plucked string instrument 1
- Pop music 1
- Rhythm and blues 1
- Song 1
- Speech 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 |
---|---|---|---|---|---|---|---|---|---|---|
Blues Rhythms - #1 - Guitar Lesson - Corey Congilio | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | 2012-11-21T19:01:01Z | TrueFire | *FULL COURSE NOW AVAILABLE FOR DOWNLOAD w/ TAB, JAMS & MORE: http://tfir.es/50BluesRhythms COREY CONGILIO: http://tfir.es/CoreyC MORE FREE GUITAR LESSONS: http://bit.ly/TrueFire | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | 4 | NZ2kFIaW05k | 2345 | |
Comb Your Hair by LoveStruck | The low quality recording features a rock song that contains filtered female vocal singing over loud and harsh electric guitar chords, energetic drums and buzzy bass guitar. It sounds chaotic due to the bad mix and since the drums are panned in an unconventional way - making the stereo image unbalanced. It sounds harsh, but also energetic. | 2010-03-19T19:57:05Z | stuspasm | LoveStruck is: Lady Anne, Vocals/ Guitar. Stu Spasm, Bass. Bloody Rich Hutchins, Drums. The band is based in Brooklyn, NYC. This song is out on Limited Edition 7" vinyl... http://www.myspace.com/lovestrucknyc or http://www.reverbnation.com/lovestrucknyc http://vimeo.com/9691399 http://www.facebook.com/pages/LoveStruck/118702 218460?ref=sgm http://garagepunk.ning.com/profile/LadyAnne | ["Blues", "Swing music", "Bass guitar", "Funk", "Music", "Pop music", "Song"] | ["low quality", "loud", "rock", "harsh electric guitar chords", "filtered female vocal", "energetic drums", "unbalanced stereo", "chaotic", "energetic", "buzzy bass guitar"] | 4 | uAgizG1hYw0 | 5096 | |
VALDECI MOURA(Groove soul) IVAN LOPES (PG) slap bass | The low quality recording features a groovy bass guitar played over drums instrumental playback. It sounds muddy, messy and boomy, as the frequencies are clashing with each other. The recording is noisy and in mono. | 2008-07-06T18:52:21Z | valdecimoura | VALDECI MOURA(Groove soul) IVAN LOPES (PG) slap bass | ["Blues", "Bass guitar", "Music", "Musical instrument"] | ["mono", "low quality", "groovy bass guitar", "boomy", "messy", "muddy", "playback drums instrumental", "noisy"] | 4 | ye6O_T8YuHQ | 5424 |
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;