musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "rebellious" and musiccaps_names contains "Distortion" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 30 ✖
- rebellious · 2 ✖
- rock music 2
- acoustic drums 1
- aggressive 1
- amateur recording 1
- bass guitar 1
- bell tones 1
- distorted tones 1
- electric guitar 1
- electric guitar lead 1
- energetic 1
- exciting 1
- experimental 1
- female vocal 1
- goofing around 1
- guitar overtones 1
- guitar practice routine 1
- hard metal 1
- instrumental music 1
- jarring tones 1
- live performance 1
- loud 1
- medium tempo 1
- no 1
- no other instrumentation 1
- no percussion instrumentation 1
- percussion instruments 1
- playing alone 1
- playing rhythmically 1
- spirited 1
musiccaps_names (array) 5 ✖
- Distortion · 2 ✖
- Music 2
- Electric guitar 1
- Pink noise 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mas - Ruido Rosa en el Vive Latino 2011 | This is an amateur recording of a live rock music performance. There is a female vocalist singing in the lead. The electric guitar is playing the main melody with a bass guitar in the background. There is a fast-paced and loud acoustic drum beat in the rhythmic background. The atmosphere is loud and rebellious. | 2011-04-12T02:37:35Z | Ricardo Garcia | Ruido Rosa haciendo honor a su nombre, bien por la fuerza de su baterista!!! | ["Music", "Pink noise", "Distortion"] | ["rock music", "amateur recording", "live performance", "female vocal", "electric guitar", "acoustic drums", "bass guitar", "loud", "rebellious", "energetic"] | 9 | Lg1HG6D_0Qk | 2213 | |
Kirby's Epic Yarn: Fanmade boss battle music (intro) | The song is an instrumental. The song is medium tempo with an overdriven guitar playing a jarring lead in rhythmic fashion and guitar over tones that sound like bell tones. The song is aggressive and experimental. The song is a modern rock intro. | 2010-06-20T16:06:40Z | joinmebowser9000 | the title says it all. maybe its to heavy for this kirby game xD | ["Electric guitar", "Music", "Distortion", "Sad music"] | ["electric guitar lead", "distorted tones", "experimental", "playing alone", "guitar practice routine", "no percussion instrumentation", "goofing around", "instrumental music", "playing rhythmically", "guitar overtones", "no", "percussion instruments", "jarring tones", "bell tones", "rock music", "exciting", "spirited", "rebellious", "aggressive", "no other instrumentation", "medium tempo", "hard metal"] | 1 | rfah0bhmYkc | 4893 |
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;