musiccaps
2 rows where aspect_list contains "acoustic drums", aspect_list contains "e-guitar" and aspect_list contains "mid-range"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- acoustic drums · 2 ✖
- e-bass 2
- e-guitar · 2 ✖
- mid-range · 2 ✖
- acoustic guitar 1
- amateur recording 1
- brass section 1
- funky 1
- keyboard 1
- male backing vocals 1
- male singer 1
- male voice singing 1
- medium tempo 1
- pop 1
- rock&roll 1
- uplifting mood 1
- uptempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Aw2ctwyhe28 | This song contains acoustic drums with a fat kick drum and a funky bassline. The acoustic guitar is strumming chords in the background being panned to the left side of the speaker while a e-guitar panned to the right side of the speaker is playing the lead melody strumming chords with a wah-wah pedal. A male backing voice is singing the same melody in a loop. The male lead voice is singing over the backing vocals. This song may be playing on a road trip. | ["pop", "acoustic guitar", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "mid-range", "male backing vocals", "medium tempo", "funky"] | ["Music", "Ska"] | 6 | 120 | 130 | 0 | 0 | ["/m/04rlf", "/m/06rqw"] | |
ktw_J6ZW0MM | A male voice is singing with reverb and delay in his voice. An acoustic drum is playing a faster groove on the piano, a tambourine can be heard. An electric bass is playing repeating notes without a lot of changes. A brass section is repeating a theme while keyboards and a guitar are playing along. This song may be playing live in-between an entertainment-show. | ["rock&roll", "acoustic drums", "e-bass", "brass section", "e-guitar", "keyboard", "male singer", "mid-range", "uptempo", "uplifting mood", "amateur recording"] | ["Singing", "Country", "Sampler", "Folk music", "Music", "Pop music", "Song"] | 6 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/01lyv", "/m/01v1d8", "/m/02w4v", "/m/04rlf", "/m/064t9", "/m/074ft"] |
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 );