musiccaps
2 rows where aspect_list contains "country pop" and audioset_ids contains "/m/04rzd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
A8CJ4YSsUgs | This is a country pop music piece. There is a female vocalist singing melodically as the lead. The melody comprises various elements such as the electric guitar, the bass guitar, the harmonica and the banjo. There is a rock acoustic drum beat in the rhythmic background. The atmosphere is easygoing. This piece could be the opening theme of a teenage sit-com. | ["country pop", "female vocal", "melodic singing", "harmonica", "electric guitar", "bass guitar", "acoustic drums", "banjo", "simple tune", "easygoing"] | ["Singing", "Banjo", "Music", "Mandolin", "Pop music"] | 9 | 200 | 210 | 0 | 0 | ["/m/015lz1", "/m/018j2", "/m/04rlf", "/m/04rzd", "/m/064t9"] | |
n1fY-23ffl0 | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | ["Singing", "Music", "Mandolin", "Ukulele"] | 7 | 240 | 250 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/04rzd", "/m/07xzm"] |
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 );