musiccaps
2 rows where aspect_list contains "poor audio quality" and audioset_ids contains "/m/06j6l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
AGNqX_OL-dU | A male singer sings this cool melody with female and male backup singers in vocal harmony. The song is medium tempo with a groovy bass line, percussive drum rhythm, keyboard harmony and guitar rhythm. The song is exciting and groovy. The song is a R&B cover of a famous pop song. The song has poor audio quality. | ["male singer", "female singer", "backup singers", "dance club", "vocal harmony", "r&b music", "soul music", "motown", "song cover", "r&b music", "groovy bass line", "steady drumming rhythm", "keyboard accompaniment", "guitar rhythm", "exciting", "dance groove", "dance rhythm", "people dancing", "dance club", "live performance", "poor audio quality", "medium tempo"] | ["Singing", "Disco", "Music", "Rhythm and blues", "Ska", "Song", "Soul music"] | 1 | 60 | 70 | 1 | 1 | ["/m/015lz1", "/m/026z9", "/m/04rlf", "/m/06j6l", "/m/06rqw", "/m/074ft", "/m/0gywn"] | |
LvpImXJMryI | A male singer introduces the DJ lineup with an enthusiastic song. The tempo is medium with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is enthusiastic and energetic. The audio quality is very poor. | ["dj", "male vocals", "dj introduction", "party all night", "dance party", "people dancing", "wave your hands", "party music", "party time", "youthful music", "slow dancing", "electronic dance music", "poor audio quality", "male singer", "backup singers", "dj introduction video", "keyboard harmony", "groovy bass line"] | ["Music", "Rhythm and blues", "Hip hop music"] | 1 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/06j6l", "/m/0glt670"] |
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 );