musiccaps
2 rows where aspect_list contains "acoustic guitar accompaniment" and audioset_ids contains "/m/07s0s5r"
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 |
---|---|---|---|---|---|---|---|---|---|---|
15Mw2jyyHk0 | This song is an instrumental. The tempo is fast and vigorous, with the musician playing a very rapid harmony on the Spanish guitar with an acoustic guitar accompaniment; the song is energetic, vibrant, enthusiastic, and shows a lot of dexterity with the instrument. This song is an instrumental Pop rock song. | ["instrumental", "spanish guitar", "energetic", "vigorous", "spirited", "rhythmic guitar", "extremely rapid guitar rhythm", "dexterity", "acoustic guitar accompaniment", "muffled audio", "inferior quality audio"] | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum"] | 7 | 30 | 40 | 0 | 1 | ["/m/018vs", "/m/0326g", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r"] | |
g4xhZgKwiNo | A male vocalist sings this classic song. The tempo is slow with guitar accompaniment. The song has minimal instruments and is mellow, soft, sentimental, emotional, nostalgic, calming, soothing and mellifluous with vocal emphasis. This song is classic pop. | ["male vocalist", "slow tempo", "vocal emphasis", "acoustic guitar accompaniment", "minimal instruments", "edelweiss", "sound of music", "classic song", "lucid guitar lead", "soft", "mellow", "serene", "calming", "soothing", "emphatic vocals", "nostalgia", "sentimental’"] | ["Guitar", "Acoustic guitar", "Music", "Strum", "Plucked string instrument", "Tender music"] | 7 | 30 | 40 | 1 | 1 | ["/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/07s0s5r", "/m/0fx80y", "/t/dd00034"] |
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 );