musiccaps
1 row where aspect_list contains "low quality" and audioset_ids = "["/m/02p0sh1", "/m/04rlf", "/m/09x0r"]"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
BN63M3_lPCQ | The low quality recording features a folk song playing in the background while the flat male vocalist is speaking. The song contains shimmering shakers, acoustic rhythm guitar, wooden percussion and harmonica melody. The song sounds happy, joyful and soulful. | ["low quality", "folk", "flat male vocal", "shimmering shakers", "acoustic rhythm guitar", "wooden percussions", "harmonica melody", "happy", "joyful", "soulful"] | ["Traditional music", "Music", "Speech"] | 4 | 170 | 180 | 0 | 0 | ["/m/02p0sh1", "/m/04rlf", "/m/09x0r"] |
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 );