musiccaps
2 rows where aspect_list contains "audio distortion" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
8akqVDDGsNQ | The low quality recording features a live performance of an Alternative/Indie song and it consists flat male vocal singing over electric guitar chord progression, thin, but groovy bass guitar, punchy kick and snare hits, soft rimshots, soft crash cymbal, shimmering hi hats and a drum break. It sounds energetic, groovy and addictive, due to the cadence. | ["low quality", "live performance", "alternative/indie", "flat male vocal", "audio distortion", "electric guitar chord progression", "punchy kick", "shimmering hi hats", "punchy snare", "soft rimshots", "groovy thin bass guitar", "soft crash cymbal", "drum break", "addictive", "groovy", "energetic"] | ["Music", "Rock and roll", "Exciting music"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07sbbz2", "/t/dd00035"] | |
xLZp-3_71Vs | The low quality recording features a passionately arpeggiated electric guitar melody. The recording is noisy and at the end, there is a subtle inhale through the nose. The audio suddenly distorts in the middle of the loop. | ["low quality", "noisy", "arpeggiated electric guitar", "reverb", "audio distortion", "passionate", "nose inhale"] | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 4 | 30 | 40 | 1 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/m/0fx80y", "/t/dd00125"] |
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 );