musiccaps
2 rows where audioset_ids contains "/m/02rr_" and audioset_names = "["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
NzvkMWY4EjA | Solo performance of an electric guitar player strumming chords. The tone is overdriven and warm. The genre is rock. | ["electric guitar", "overdrive", "strumming", "rock", "warm"] | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | 8 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0b9m1", "/m/0g12c5"] | |
kaabXWuPWRg | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0b9m1", "/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 );