musiccaps
1 row where aspect_list contains "enthusiastic" and aspect_list contains "people talking ambient sounds"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- aisi an pop 1
- asian pop hits 1
- backup singers 1
- bleeding crowd noise 1
- energetic 1
- enthusiastic · 1 ✖
- exciting 1
- groovy drumming rhythm 1
- guitar rhythm 1
- male singer 1
- people talking ambient sounds · 1 ✖
- percussive bass line 1
- piano accompaniment 1
- pop hits 1
- rapping vocals 1
- vocal harmony 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
AtJ2RXQ98kY | A male singer sings this cool melody with backup singers in vocal harmony. The tempo is medium with a groovy drumming rhythm, guitar accompaniment, piano accompaniment, percussive bass line and ambient crowd noises. The song is a modern Asian pop song. | ["male singer", "backup singers", "asian pop hits", "bleeding crowd noise", "rapping vocals", "vocal harmony", "exciting", "enthusiastic", "groovy drumming rhythm", "percussive bass line", "piano accompaniment", "guitar rhythm", "people talking ambient sounds", "energetic", "youthful", "pop hits", "aisi an pop"] | ["Blues", "Disco", "Music", "Speech"] | 1 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/026z9", "/m/04rlf", "/m/09x0r"] |
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 );