musiccaps
2 rows where audioset_ids contains "/m/07lnk" and author_id = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|
IbaQjxGDT-o | Electronic dance music features a repeating melody played by an electronic sound. The beat of the music is being driven by a kick drum played on every beat, a hi-hat played four times every beat and some sampled claps played on beats two and four. In the background one can hear an altered female voice singing a short melody. Another electronic/synth sound can be heard in the background having sparse interventions. The music is meant to be danced to. | ["electronic sounds", "kick drum", "altered female voice", "hi-hat", "electronic dance music genre"] | ["Drum and bass", "Music of Asia", "Music", "Pop music", "Techno", "Trance music", "Electronica"] | 2 | 30 | 40 | 0 | 1 | ["/m/0283d", "/m/028sqc", "/m/04rlf", "/m/064t9", "/m/07gxw", "/m/07lnk", "/m/0m0jc"] | |
Vi2posMLsrg | The electronic instrumental music features a melody played by a synth sound and being accompanied by other electronic sounds. In the low-register a bass electronic sound can be heard playing at times twice every beat, driving the pulse of the music. In the second half of the music excerpt another electronic sound can be heard in the upper register playing chords. | ["electronic music genre", "low-pitch bass electronic sound", "instrumental", "no voice"] | ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] | 2 | 30 | 40 | 0 | 1 | ["/m/0283d", "/m/04rlf", "/m/07lnk", "/m/07s72n", "/m/08cyft", "/m/0ggx5q", "/m/0m0jc"] |
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 );