musiccaps
2 rows where aspect_list contains "people dancing" and audioset_ids contains "/m/026z9"
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"] | |
ClK_qf_Twm8 | The song is instrumental. The song is medium tempo with a groovy bass line, keyboard harmony, various percussion hits and a steady drumming rhythm. The song has a dance rhythm and is exciting. | ["techno dance music", "electronic dance music", "cymbals crashing loud", "percussion hits", "keyboard harmony", "dance party", "dance club", "dance floor", "electronic dance music", "youthful", "energetic", "teenage romance", "dance hits", "steady rhythm", "medium tempo", "keybiard harmony", "groovy bass line", "people dancing", "dj", "night party"] | ["Disco", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | 1 | 30 | 40 | 0 | 1 | ["/m/026z9", "/m/04rlf", "/m/07gxw", "/m/07s72n", "/m/08cyft", "/m/0ggx5q"] |
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 );