musiccaps
3 rows where aspect_list contains "harsh" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
XjGm3Bn4j5k | The low quality recording features a live performance of a metal song. The recording is noisy, in mono and so crushed, distorted, harsh and loud that you can barely hear anything but the loud noise. | ["low quality", "noisy", "mono", "metal", "crushed", "distorted", "loud", "live performance", "harsh"] | ["Singing", "Drum", "Drum kit", "Music", "Punk rock", "Rock music", "Bellow"] | 4 | 80 | 90 | 0 | 0 | ["/m/015lz1", "/m/026t6", "/m/02hnl", "/m/04rlf", "/m/05r6t", "/m/06by7", "/m/07q4ntr"] | |
Xoke1wUwEXY | The low quality recording features a live performance of a rock song that features muffled male vocals, loud electric guitar melody, buzzy bass guitar, punchy kick and snare and harsh cymbals. Sounds energetic, vintage and a bit harsh, due to the quality of the recording. | ["rock", "low quality", "loud electric guitar", "buzzy bass guitar", "muffled vocals", "harsh cymbals", "punchy kick", "punchy snare", "harsh", "vintage", "energetic"] | ["Singing", "Music", "Psychedelic rock"] | 4 | 160 | 170 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/05w3f"] | |
_RLsXrr0fQo | The low quality recording features a folk song being covered by passionate male vocal and groovy acoustic guitar melody. It sounds uplifting and a bit harsh, muddy and unbalanced as far as the stereo image goes. | ["low quality", "passionate male vocal", "groovy acoustic guitar melody", "reverberant", "folk", "uplifting", "unbalanced stereo image", "harsh", "muddy"] | ["Singing", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | 4 | 80 | 90 | 0 | 1 | ["/m/015lz1", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07xzm", "/m/0fx80y"] |
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 );