musiccaps
3 rows where aspect_list contains "rock" and audioset_ids contains "/m/0b9m1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
I368EWBLIs4 | This song is an electric guitar instrumental. The tempo is medium with two amplified guitars playing the lead and harmony respectively with steady drumming. The music is a simple, rhythmic, smooth and engaging Rock instrumental; | ["electric guitar", "instrumental", "instrumental duet", "medium tempo", "distortion", "vibrato", "electric guitar lead", "electric guitar harmony", "steady drumming", "vibrations", "amplified guitars", "sonic power", "rock"] | ["Music", "Harmonic"] | 7 | 230 | 240 | 0 | 1 | ["/m/04rlf", "/m/0b9m1"] | |
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 );