musiccaps
2 rows where audioset_ids contains "/m/04rlf", audioset_ids contains "/m/06j6l" and audioset_ids contains "/t/dd00034"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0Q1JLNfm8oU | This song contains two pianos panned to both sides of the speakers playing melodies in the mid to upper range. A female voice, maybe a child sings a melody in a very high pitch. THis song may be playing as part of a movie-scene. | ["ballad", "pianos", "female voice singing", "very high pitch", "medium tempo", "melancholic"] | ["Music", "Rhythm and blues", "Tender music"] | 6 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/06j6l", "/t/dd00034"] | |
i6WtNBpRll0 | A male rapper sings this emotional melody. The song is medium tempo with a steady techno drumming rhythm, strong bass line, various percussion hits, piano playing accompaniment and synth horns playing countermelody. The song is emotional and storytelling in nature. The song is a modern hip hop song. | ["male singer", "hip hop music", "hip hop hits", "groovy", "synth countermelody", "driving song", "auto tuned vocals", "medium tempo", "slick drumming rhythm", "percussive bass line", "piano accompaniment", "story telling", "emotional", "synth horns playing", "passionate", "the hood", "hustlers life", "money problems", "passionate", "spirited", "poignant", "youthful", "heart break"] | ["Music", "Rhythm and blues", "Tender music"] | 1 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06j6l", "/t/dd00034"] |
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 );