musiccaps
1 row where aspect_list contains "country music" and aspect_list contains "song cover"
This data as json, CSV (advanced)
aspect_list (array) 24 ✖
- autoharp accompaniment 1
- backup singers 1
- bad audio quality 1
- classic county hits 1
- country classics 1
- country music · 1 ✖
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- groovy rhythm 1
- guitar strumming 1
- male singer 1
- medium tempo 1
- nostalgia 1
- old memories 1
- pleasant 1
- pop super hits 1
- retro hits 1
- song cover · 1 ✖
- steady drumming 1
- story telling 1
- walking bas s line 1
- walking bass line 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
3KQy3Cajo4E | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | ["Christian music", "Music", "Musical instrument"] | 1 | 150 | 160 | 0 | 0 | ["/m/02mscn", "/m/04rlf", "/m/04szw"] |
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 );