musiccaps
1 row where aspect_list contains "guiro percussions" and aspect_list contains "story telling"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- dance groove 1
- dance rhythm 1
- emotional 1
- entertaining 1
- guiro percussions · 1 ✖
- guitar rhythm 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- male latin singer 1
- medium tempo 1
- passionate 1
- people dancing 1
- piano accompaniment 1
- poor audio quality 1
- romantic 1
- soaring vocals 1
- spirited 1
- story telling · 1 ✖
- walking bass line 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2cxvYC9QZac | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | ["Music of Africa", "Music", "Ska"] | 1 | 30 | 40 | 0 | 1 | ["/m/0164x2", "/m/04rlf", "/m/06rqw"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );