musiccaps
2 rows where aspect_list contains "guitar lead", aspect_list contains "guitar rhythm" and aspect_list contains "poor audio quality"
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 |
---|---|---|---|---|---|---|---|---|---|---|
h2f_CKjQQg8 | The song is instrumental. The song is medium tempo with an electric guitar lead, groovy bass line, steady drumming rhythm, cymbal crashes and keyboard harmony. The song is exciting and energetic. The song is a rock tune with poor audio quality. | ["guitar lead", "medium tempo", "people cheering", "screaming sounds", "strong bass line", "guitar rhythm", "instrumental music", "poor audio quality", "live show performance", "cymbals crashing tones", "exciting", "energetic", "emotional", "cast introduction", "rock band playing", "steady drumming rhythm"] | ["Applause", "Music"] | 1 | 70 | 80 | 0 | 1 | ["/m/028ght", "/m/04rlf"] | |
sR8rlTIU8_Y | A male and female singer sing this vocal duet with a choral vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, guitar lead, guitars playing rhythm and keyboard harmony. The song is devotional and congregational. The song is a Christian praise and worship song with poor audio quality. | ["poor audio quality", "male singer", "female singer", "guitar lead", "choral harmony", "backup singers", "vocal duet", "congregational singing", "christian praise songs", "praise and worship", "medium tempo", "guitar rhythm", "groovy bass line", "keyboard harmony", "meditative", "congregational", "devotional", "inspiring", "prayer", "motivational", "string drumming rhythm"] | ["Christian music", "Music"] | 1 | 130 | 140 | 1 | 1 | ["/m/02mscn", "/m/04rlf"] |
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 );