musiccaps
1 row where aspect_list contains "random" and aspect_list contains "rock"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- compilation 1
- disorganized 1
- electric guitar 1
- electronic drums 1
- female vocal 1
- generic 1
- jingle 1
- keyboard 1
- pop 1
- random · 1 ✖
- rock · 1 ✖
- static sound effect 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4AfykLGm0j8 | This is a compilation of various different music pieces all in one recording to advertise a radio software. The pieces are generic in nature. There is a rock music piece with an electric guitar playing. After a static sound effect, it switches to a pop music piece. There is a female vocalist singing over a keyboard and electronic drum beat background. There is a random feeling to this track. | ["compilation", "jingle", "generic", "rock", "electric guitar", "static sound effect", "pop", "female vocal", "keyboard", "electronic drums", "disorganized", "random"] | ["Music", "Radio"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06bz3"] |
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 );