musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "rock" and musiccaps_names contains "Bass guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- groovy · 3 ✖
- low quality 3
- noisy 3
- rock · 3 ✖
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- cool 1
- cover 1
- crushed audio 1
- distorted bass guitar 1
- easygoing 1
- electric guitar melody 1
- emotional 1
- harmonizing male vocals 1
- live performance 1
- messy 1
- mono 1
- muffled instrumental 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- shimmering open hats 1
- shimmering shakers 1
- smooth bass 1
- snappy rimshots 1
- soft male vocal 1
musiccaps_names (array) 7 ✖
- Bass guitar · 3 ✖
- Music 3
- Guitar 1
- Plucked string instrument 1
- Punk rock 1
- Radio 1
- Rock and roll 1
youtube_published (date) 3 ✖
- 2006-04-19 1
- 2008-10-25 1
- 2009-11-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rats - Pearl Jam | The low quality recording features a cover of a rock song and it consists of distorted bass guitar playing over muffled audio. The recording is distorted and very noisy, almost crushed, but it still sounds groovy. | 2009-11-05T15:21:32Z | frschone | I like this song very much, so I thought, lets cover it. There is much improvisation in it. In the solo itself I did my own thing :P | ["Bass guitar", "Music", "Radio"] | ["distorted bass guitar", "crushed audio", "muffled instrumental", "noisy", "low quality", "cover", "rock", "groovy"] | 4 | R3urUtvSgkU | 2662 | |
Nothing In This World - The Kinks | The low quality recording features a rock song that consists of an electric guitar melody, smooth bass, shimmering shakers, snappy rimshots and soft male vocals singing over it. The recording is really noisy and in mono. It sounds cool, groovy and easygoing. | 2008-10-25T20:42:37Z | weeniebobeenie | Nothin in this world can stop me worryin bout that girl | ["Bass guitar", "Guitar", "Music", "Plucked string instrument"] | ["rock", "low quality", "electric guitar melody", "smooth bass", "shimmering shakers", "snappy rimshots", "soft male vocal", "noisy", "mono", "cool", "easygoing", "groovy"] | 4 | hOSzGYKaJGE | 4100 | |
"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;