musiccaps
2 rows where aspect_list contains "acoustic drums" and audioset_ids contains "/m/0gg8l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
9-R70gSqvrc | A full sounding male voice is singing mid range with kind of a radio effect on his voice. Two banjos are strumming chords with one playing the lead melody on top. One is panned to the right side of the speakers. An acoustic drum is playing a four on the floor groove with a kick on every beat and an e-bass is playing his own melody along. In the background you can hear the sound of a photo taken. This song may be playing in an advertisement for a product. | ["country/rock", "banjo", "male voice singing", "mid-range", "foto shot sound", "acoustic drums", "e-bass", "uptempo"] | ["Blues", "Banjo", "Music", "Squish", "Rock and roll", "Bluegrass"] | 6 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/018j2", "/m/04rlf", "/m/07qlwh6", "/m/07sbbz2", "/m/0gg8l"] | |
SvsCM0fLM5g | This is a country music piece that is played in an instrument lesson recording. The steel guitar is playing a mellow tune while at the forefront while there is a backing composed of the acoustic guitar and the acoustic drums. There is a relaxing and psychedelic feel to the piece. This music could suit well in the soundtrack of a feelgood/comedy movie. It could also be playing in the background at a shopping mall. | ["country music", "no singer", "instrumental", "steel guitar", "mellow tune", "acoustic guitar", "acoustic drums", "easygoing", "calm", "relaxing", "psychedelic", "trippy"] | ["Music", "Musical instrument", "Steel guitar, slide guitar", "Bluegrass"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/06w87", "/m/0gg8l"] |
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 );