musiccaps_details (view)
2 rows where musiccaps_aspects contains "dub" and musiccaps_aspects contains "energetic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- dub · 2 ✖
- energetic · 2 ✖
- aggressive 1
- bass guitar 1
- chaotic 1
- distorted electric guitar 1
- energetic drums 1
- fast tempo 1
- flat male vocal 1
- groovy bass 1
- instrumental 1
- live performance 1
- loud acoustic drums 1
- low quality 1
- noisy 1
- offbeat guitar melody 1
- punk rock 1
- violent 1
musiccaps_names (array) 11 ✖
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Music 1
- Music of Latin America 1
- Percussion 1
- Rimshot 1
- Snare drum 1
youtube_published (date) 2 ✖
- 2006-05-02 1
- 2007-07-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sud Sound System@Villa Ada - feat. Maria Ganja | The low quality recording features a live performance of dub song manically rapped by flat male vocals, followed by energetic drums, groovy bass and offbeat key chords. The recording is noisy and chaotic a bit, as it is probably recorded with a phone. | 2007-07-25T12:28:57Z | Ivano Zizzi | grande performance! Sud sound systema a "Roma Incontra il mondo" VILLA ADA. Nuh se po proibire & erba erba | ["Music", "Music of Latin America"] | ["low quality", "dub", "noisy", "live performance", "energetic", "offbeat guitar melody", "energetic drums", "flat male vocal", "chaotic", "groovy bass"] | 4 | JN_VJCJhC4Y | 1996 | |
DUB TRIO - ILLEGAL DUB | This is an instrumental punk rock/dub music piece. There is a distorted electric playing the main tune with a bass guitar in the background. The rhythmic background consists of a loud and rapid acoustic drum beat. The atmosphere is aggressive. This piece could be used in the soundtrack of a violent video game. | 2006-05-02T17:09:19Z | dubtrio | video for ILLEGAL DUB. from DUB TRIO's album, NEW HEAVY. video directed by: Jason Fried | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "dub", "instrumental", "distorted electric guitar", "bass guitar", "loud acoustic drums", "fast tempo", "aggressive", "energetic", "violent"] | 9 | JpMHnsdsCiY | 2036 |
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;