musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "arpeggiated electric guitar melody", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- arpeggiated electric guitar melody · 2 ✖
- emotional 2
- live performance · 2 ✖
- low quality 2
- punchy kick · 2 ✖
- rock 2
- addictive 1
- boomy bass guitar 1
- crowd cheering 1
- crowd singing 1
- flat male vocal 1
- groovy 1
- groovy bass guitar 1
- harmonizing male vocals 1
- messy 1
- noisy 1
- passionate male vocal 1
- punchy snare 1
- shimmering hi hats 1
- shimmering open hats 1
- snappy rimshots 1
musiccaps_names (array) 7 ✖
- Music 2
- Bass guitar 1
- Blues 1
- Musical instrument 1
- Punk rock 1
- Rock and roll 1
- Singing 1
youtube_published (date) 2 ✖
- 2006-04-19 1
- 2008-04-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
"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;