musiccaps
2 rows where aspect_list contains "guitar lead" and audioset_ids contains "/m/01glhc"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1RwhRTe-OKk | The song is an instrumental. The song is medium tempo with three guitars playing in harmony, guitar accompaniment, guitar harmony, guitar lead and a strong bass line. The song is emotional and spirited. The song has an average audio quality and is played in front of a live audience. | ["poor audio quality", "home video recording", "guitar band", "instrumental music", "medium tempo", "guitars playing in harmony", "groovy bass line", "guitar lead", "guitar accompaniment", "entertaining", "emotional", "passionate", "spirited", "lilting"] | ["Banjo", "Tapping (guitar technique)", "Music"] | 1 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/01glhc", "/m/04rlf"] | |
1jATjKL2vAE | This music is instrumental. The tempo is fast with a rhythmic guitar lead. There is minimal instrumentation and the music is an upbeat, energetic and catchy riff. | ["instrumental", "fast tempo", "rhythmic guitar", "resounding", "guitar solo", "guitar lead", "acoustic guitar", "melodic", "energetic", "spirited"] | ["Tapping (guitar technique)", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 7 | 10 | 20 | 0 | 0 | ["/m/01glhc", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );