musiccaps
2 rows where aspect_list contains "hissing tones" 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 |
---|---|---|---|---|---|---|---|---|---|---|
OHrrS6AKW_c | The tune is instrumental. The tempo is variable with a drum machine playing different styles and tempos. The song is a demonstration of a synth drum module with a guitar lead playing in the background. The audio quality is poor with hissing tones. | ["drum machine", "electronic music", "techno drumming", "dj", "rehearsal", "practice session", "hissing tones", "groovy rhythm", "youtube demo video", "various tempos", "different drumming styles", "electric guitar lead", "ambient room noise", "synth module demo", "instrumental music", "variables tempos", "slick drumming tones"] | ["Guitar", "Music", "Musical instrument", "Drum machine"] | 1 | 30 | 40 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/0cfdd"] | |
Y_eh6C0EBP8 | The song is an instrumental followed by a long pause. The song is medium tempo and features an electric guitar playing a solemn solo. The song is passionate and mysterious. The audio quality is poor. | ["instrumental music", "long pause", "electric guitar solo", "poor audio quality", "song introduction", "soloist", "hissing tones", "ambient room sounds", "documentary sound track", "advertisement jingle", "amplified guitar solo", "solemn", "emotional", "energetic", "guitar amplifier tone", "medium tempo", "instrumental music"] | ["Silence", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 1 | 0 | 10 | 0 | 1 | ["/m/028v0c", "/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 );