musiccaps_details (view)
3 rows where musiccaps_aspects contains "messy", musiccaps_aspects contains "noisy", musiccaps_aspects contains "thin" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raskahuele--LA Sound System | The low quality recording features a live performance of a reggae song that consists of shimmering cymbals, addictive brass melody and muffled male vocal singing over it. It is noisy and in mono, and it sounds thin, harsh, muddy, messy and energetic. | 2008-06-22T17:38:28Z | Geovanni De Leon | LASS | ["Music", "Ska", "Music of Latin America"] | ["low quality", "shimmering cymbals", "noisy", "mono", "addictive brass melody", "muffled male vocal", "live performance", "reggae", "loud", "thin", "harsh", "muddy", "messy", "energetic"] | 4 | GkB_BkyVyPs | 1752 | |
Elmo | The low quality recording features a kids song played through a toy and it consists of childish vocal singing over groovy piano chords and funky guitar melody. It is noisy, in mono and it sounds happy, fun, but also thin, messy, muffled and crushed. | 2007-05-07T00:40:48Z | lttleD03 | Me dancing we elmo lol | ["Music", "Synthetic singing", "Inside, small room"] | ["low quality", "noisy", "kids song", "crushed", "mono", "audio stuttering", "muffled", "messy", "thin", "happy", "fun", "groovy piano", "childish vocal", "funky guitar melody"] | 4 | J7d3nuS9wqg | 1969 | |
Kizomba Dance | The low quality recording features an afrobeats song played on speaker in a medium size room, and it consists at least syncopated rimshots, shimmering open hats, synth keys melody, groovy bass, repetitive male vocal melody and harmonizing vocals layered with it. Even though the recording is noisy, thin, messy and in mono, it still sounds groovy and like something you would want to dance to. | 2013-01-28T16:55:25Z | Zlatan Vlad | Sara Lopez and Albir Rojas Music : To Semedo-P`ra Ti | ["Music", "Tambourine"] | ["low quality", "afrobeats", "syncopated rimshots", "shimmering open hat", "synth keys melody", "repetitive male vocal melody", "harmonizing vocals", "mono", "noisy", "thin", "messy", "groovy bass", "groovy"] | 4 | dvDSgmqbrM0 | 3826 |
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;