musiccaps
2 rows where aspect_list contains "boomy" and audioset_ids contains "/m/013y1f"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DU3Vlaa8rU0 | The low quality recording features a tutorial on boomy organ keys narrated by flat male vocals. It is noisy and the recording is in mono. | ["low quality", "flat male vocal", "tutorial", "organ keys", "mono", "boomy", "noisy"] | ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] | 4 | 290 | 300 | 0 | 0 | ["/m/013y1f", "/m/03gvt", "/m/05148p4", "/m/05r5c"] | |
cX926M1_LqM | The low quality recording features a groovy synth keys melody and synth keys bass playing together. It sounds jazzy, funky, boomy and the recording is noisy and in mono. Sounds like something you would hear in jazz bars. | ["low quality", "groovy synth keys melody", "groovy synth keys bass", "noisy", "mono", "boomy", "funky", "jazz", "groovy"] | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | 4 | 30 | 40 | 0 | 0 | ["/m/013y1f", "/m/01s0ps", "/m/03xq_f", "/m/05148p4", "/m/05r5c"] |
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 );