musiccaps_details (view)
2 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "mono"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- addictive · 2 ✖
- live performance · 2 ✖
- low quality 2
- mono · 2 ✖
- noisy 2
- addictive strings melody 1
- breathy flute melody 1
- crackling 1
- energetic 1
- energetic drums 1
- flute melody 1
- folk 1
- groovy strings chords 1
- roomy 1
- simple bass 1
- soulful 1
- strings melody 1
- traditional music 1
- wooden percussive elements 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zdop si Zdup - Dj Vasile | The low quality recording features a live performance of folk songs played by flute, strings and energetic drums. The recording is noisy and in mono, as the audio is crackling and it sounds energetic and kind of addictive thanks to that flute and strings melody. | 2010-10-15T16:42:09Z | Ciprian BT | Zdop si Zdup - Dj Vasile | ["Jazz", "Music"] | ["low quality", "folk", "noisy", "mono", "flute melody", "strings melody", "energetic drums", "crackling", "live performance", "energetic", "addictive"] | 4 | 4mtfOkzOvBI | 606 | |
Fan Veil Bellydance by Zulay Maza @ Bozenka's Bellydance Academy | The low quality recording features a live performance and it consists of groovy strings chords, addictive strings melody, breathy flute melody, simple bass and wooden percussive elements. It is a bit noisy, roomy, mono, but still addictive and soulful. | 2009-07-02T04:25:23Z | Miamibellydancers | Fan Veil Bellydance by Zulay Maza @ Bozenka's Bellydance Academy | ["Music", "Harmonic"] | ["traditional music", "low quality", "live performance", "groovy strings chords", "addictive strings melody", "breathy flute melody", "wooden percussive elements", "simple bass", "addictive", "soulful", "noisy", "roomy", "mono"] | 4 | tWByqbOvYQE | 5045 |
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;