musiccaps_details (view)
2 rows where musiccaps_aspects contains "reggae", musiccaps_author = 4 and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- reggae · 2 ✖
- addictive brass melody 1
- electric guitar licks 1
- energetic 1
- flat male vocal 1
- groovy bass 1
- happy 1
- harsh 1
- live performance 1
- loud 1
- low quality 1
- messy 1
- metallic snare 1
- mono 1
- muddy 1
- muffled male vocal 1
- noisy 1
- offbeat acoustic rhythm guitar chords 1
- shimmering cymbals 1
- simple kick 1
- thin 1
- uplifting 1
- wide background harmonizing female vocals 1
- wide tinny percussive elements 1
musiccaps_names (array) 7 ✖
- Music 2
- Ska · 2 ✖
- Afrobeat 1
- Funk 1
- Mouse 1
- Music of Africa 1
- Music of Latin America 1
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 | |
Eek A Mouse - Talking About The Business | The Reggae song features a flat male vocal singing, alongside wide background harmonizing female vocals, over metallic snare, simple kick hits, offbeat acoustic rhythm guitar chords, groovy bass, electric guitar licks and tinny percussive elements widely spread in the stereo image. Sounds happy and uplifting, like something you can listen to while chilling at the beach. | 2009-08-17T08:56:37Z | GJW | album: eeksperience release: 2001 label: Rfo Records | ["Afrobeat", "Music of Africa", "Funk", "Music", "Mouse", "Ska"] | ["reggae", "offbeat acoustic rhythm guitar chords", "wide background harmonizing female vocals", "flat male vocal", "groovy bass", "electric guitar licks", "metallic snare", "wide tinny percussive elements", "happy", "uplifting", "simple kick"] | 4 | R5JRh08zgMo | 2666 |
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;