musiccaps
2 rows where aspect_list contains "acoustic guitar" 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"] | |
Ve6Zy1BXBbY | This low quality audio features a child singing the main melody. This is accompanied by other children's voices singing vocables in the background in harmony. An acoustic guitar strums chords. There are no other instruments in this song. This song has a holiday mood. This song can be played in a Christmas movie. | ["amateur recording", "low quality audio", "child's voice", "vocables backing", "acoustic guitar", "no percussion", "no other instruments", "holiday song", "slow tempo"] | ["Christmas music", "Singing", "Humming", "Music", "Choir", "Vocal music", "Child speech, kid speaking"] | 0 | 30 | 40 | 0 | 0 | ["/m/0140xf", "/m/015lz1", "/m/02fxyj", "/m/04rlf", "/m/0l14jd", "/m/0y4f8", "/m/0ytgt"] |
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 );