musiccaps
2 rows where audioset_ids contains "/m/03r5q_" and author_id = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|
1SqihV_DnEg | The track is a lullaby song that features a mellow male vocal with a mellow voice. A soft xylophone plays a melody on the foreground while a deep bass guitar adds a certain bounciness to the song's rhythm. The atmosphere is calmed and dreamy. | ["lullaby", "xylophone", "mellow male vocals", "bass guitar", "dreamy", "kids music", "mid tempo", "nostalgic"] | ["Jingle (music)", "Music", "Song", "Lullaby"] | 5 | 30 | 40 | 0 | 1 | ["/m/03r5q_", "/m/04rlf", "/m/074ft", "/m/07pkxdp"] | |
cbq6Q2htPRM | The music contains an energetic female voice which is sharp and clear. It is between rapping and singing. In the background are electronic music effects, at medium to high pitch. The atmosphere is smooth and confident. A drum kit plays a mid tempo pattern and It is very digital sounding. | ["female singer", "r&b", "hip-hop", "fuzzy synth", "kick", "guitar", "electronic bass", "smooth", "electronic drum kit"] | ["Afrobeat", "Funk", "Jingle (music)", "Music", "Rapping", "Hip hop music"] | 5 | 30 | 40 | 1 | 1 | ["/m/0145m", "/m/02x8m", "/m/03r5q_", "/m/04rlf", "/m/06bxc", "/m/0glt670"] |
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 );