musiccaps
2 rows where aspect_list contains "hymns" and audioset_ids contains "/m/0l14jd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0oIFGARD9xE | A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. | ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] | ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] | 7 | 410 | 420 | 0 | 0 | ["/m/015lz1", "/m/016cjb", "/m/02mscn", "/m/03qtwd", "/m/04rlf", "/m/0l14jd"] | |
2kORDnISun4 | A choral harmony consisting of four parts sings this ethereal harmony. The song is medium tempo with a church organ and orchestra accompaniment. The song is heavenly and innocent. The audio quality is poor. | ["choral harmony", "four part harmony", "church choir", "vocal harmony", "western classical music", "medium tempo", "love song", "heartfelt", "gospel music", "cathedral", "meditational", "devotional", "prayer", "composer", "conductor", "choir", "hymns", "praise and worship", "church service", "poor audio quality", "heavenly", "ethereal voices", "christian choir"] | ["Music", "Choir"] | 1 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/0l14jd"] |
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 );