musiccaps
2 rows where aspect_list contains "male voice" and audioset_ids contains "/m/02rr_"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ihJT65fZaHY | This is a gear review jam video. There is a male voice describing the tone that he achieves from using an amp with the electric guitar. The said amp applies an echo effect to the electric guitar, making it sound more dreamy. The performer is playing a simple tune. This piece could be sampled for use in an advertisement jingle or in beat-making. | ["jam", "gear review", "male voice", "single instrument", "electric guitar", "guitar solo", "amp", "echo", "easygoing", "dreamy", "simple tune"] | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | 9 | 30 | 40 | 0 | 0 | ["/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"] | |
n179cK8EubU | This is a gear showcase jam. There is a male voice talking in between the sounds giving information about a reverb pedal. There is an electric guitar playing random tunes with the reverb effect. The tunes in the recording are simple. Sounds from this recording could be sampled for use in beat-making. | ["jam", "instrumental", "single instrument", "male voice", "instructive", "electric guitar", "guitar solo", "effect pedal", "reverb", "simple tunes"] | ["Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Distortion"] | 9 | 320 | 330 | 0 | 0 | ["/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y", "/m/0g12c5"] |
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 );