musiccaps
1 row where aspect_list contains "acoustic guitar" and aspect_list contains "southern country gospel music"
This data as json, CSV (advanced)
aspect_list (array) 6 ✖
- acoustic guitar · 1 ✖
- banjo 1
- live recording 1
- poor audio quality 1
- southern country gospel music · 1 ✖
- twangy female vocalist 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
qW4kBJsudLI | This recording was done live, and the audio quality is poor. The style is country gospel or country worship music. There's a banjo being used to play arpeggios, and acoustic guitar strumming. The singer has a twangy and full-bodied female country voice. | ["live recording", "banjo", "acoustic guitar", "poor audio quality", "southern country gospel music", "twangy female vocalist"] | ["Music", "Mandolin", "Steel guitar, slide guitar", "Vocal music"] | 3 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/04rzd", "/m/06w87", "/m/0y4f8"] |
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 );