musiccaps
3 rows where audioset_ids contains "/m/02x8m" and author_id = 8
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 |
---|---|---|---|---|---|---|---|---|---|---|
FtskdD6Py7Y | Amateur recording of solo beat boxing of a cover of a popular song. | ["beat boxing", "cover", "popular song", "amateur recording"] | ["Funk", "Music"] | 8 | 30 | 40 | 0 | 0 | ["/m/02x8m", "/m/04rlf"] | |
JEJLTct-014 | Funk music featuring a bass guitar, synth melody, synth counter melody and group vocals, with a snare on the backbeat. | ["funk", "group vocals", "synth melody", "electric bass guitar", "backbeat", "synth counter melody"] | ["Funk", "Music"] | 8 | 380 | 390 | 0 | 0 | ["/m/02x8m", "/m/04rlf"] | |
w0QJT6ywza0 | A chic 80's pop/R&B song that is an influence on the synthpop of today. Features a male vocalist singing in falsetto, doubled vocals and lush vocal harmonies, a driving beat, low toms, a sharp electronic clap, synth pads and a steady synth bassline. | ["80's pop", "r&b", "synthpop", "male falsetto", "chic", "doubled vocals", "lush vocal harmonies", "driving beat", "synth pads", "steady synth bass", "low toms", "sharp electronic clap"] | ["Funk", "Music"] | 8 | 110 | 120 | 0 | 0 | ["/m/02x8m", "/m/04rlf"] |
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 );