musiccaps
1 row where aspect_list contains "guitar rhythm" and aspect_list contains "soul music"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- backup singers 1
- dance club 1
- dance groove 1
- dance rhythm 1
- exciting 1
- female singer 1
- groovy bass line 1
- guitar rhythm · 1 ✖
- keyboard accompaniment 1
- live performance 1
- male singer 1
- medium tempo 1
- motown 1
- people dancing 1
- poor audio quality 1
- r&b music 1
- song cover 1
- soul music · 1 ✖
- steady drumming rhythm 1
- vocal harmony 1
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"] |
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 );