musiccaps
2 rows where aspect_list contains "distorted" and audioset_ids contains "/m/0fx80y"
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 |
---|---|---|---|---|---|---|---|---|---|---|
AVuh8-CucrE | The low quality recording features funky electric guitar chords, electric guitar solo melody and groovy bass playing in the background. The recording is very noisy, distorted and harsh, but it is still easygoing and chill - like something you would listen to when you are trying to relax. | ["low quality", "noisy", "mono", "funky electric guitar chords", "electric guitar solo melody", "groovy bass", "easygoing", "distorted", "harsh", "chill", "relaxing"] | ["Music", "Radio", "Rock and roll", "Plucked string instrument"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06bz3", "/m/07sbbz2", "/m/0fx80y"] | |
NZ2kFIaW05k | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | 4 | 450 | 460 | 0 | 0 | ["/m/0155w", "/m/018vs", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06j6l", "/m/09x0r", "/m/0b9m1", "/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 );