musiccaps
2 rows where aspect_list contains "distorted" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3OWArQGgmm0 | The low quality recording features an electric guitar melody, with echoing wobble effect on, that occasionally distorts. It sounds like the player is trying out an effect for his guitar. | ["low quality", "distorted", "electric guitar melody", "noisy", "echoing wobble effect"] | ["Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Chorus effect", "Distortion"] | 4 | 40 | 50 | 0 | 1 | ["/m/01glhc", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/07m2kt", "/m/0g12c5"] | |
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 );