musiccaps
2 rows where aspect_list contains "poor audio quality" and audioset_ids contains "/m/0g293"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8pc8fjPIV-Q | A male singer sings this cool melody with backup female singers in vocal harmony. The song is medium tempo with a groovy rhythm, steady drumming rhythm, disc scratching tones, and piano accompaniment. The song is groovy and has a dance rhythm. The song has poor audio quality. | ["techno dance music", "groovy bass line", "dance club", "dance floor", "people dance", "disc scratching tones", "dj", "techno dance club", "make vocals", "rap vocals", "dance music", "live performance", "female backup singer", "piano accompaniment", "ambient room noise", "poor audio quality", "groovy bass line", "dance rhythm", "steady techno drumming rhythm"] | ["Music", "Tambourine", "Music of Latin America"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07brj", "/m/0g293"] | |
aOGNUGgTQ8k | A female Arabic singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a string section, Arabic percussion instruments, tambourine percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is romantic and celebratory in nature. The audio quality is very poor. | ["female singer", "arabic singer", "arabic pop song", "lyrical singing", "poor audio quality", "medium fast tempo", "backup singers", "vocal harmony", "string section", "arabic percussions", "groovy bass line", "arabic dance song", "arabic pop song", "lyrical singing", "traditional music influences", "belly dancing music", "groovy rhythm", "cheerful", "romantic", "love song", "adoration", "tambourine percussions"] | ["Afrobeat", "Music of Africa", "Music of Asia", "Music", "Pop music", "Reggae", "Middle Eastern music", "Music of Latin America", "Soul music"] | 1 | 210 | 220 | 1 | 1 | ["/m/0145m", "/m/0164x2", "/m/028sqc", "/m/04rlf", "/m/064t9", "/m/06cqb", "/m/06j64v", "/m/0g293", "/m/0gywn"] |
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 );