musiccaps
2 rows where aspect_list contains "violin" and audioset_ids contains "/m/07s8j8t"
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 |
---|---|---|---|---|---|---|---|---|---|---|
OI7S7vaBT4I | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | ["Music", "Roll"] | 7 | 60 | 70 | 1 | 1 | ["/m/04rlf", "/m/07s8j8t"] | |
Vt3HzkNtOP4 | An acoustic drum is playing a light Rock&Roll groove with crash hits and emphasis on kick and snare along with a e-bass enhancing the fast paces mood and giving reasons to move the body along to the beat. Strings like a violin are adding some atmosphere with hits in the background and playing a crescendo to break into the next part of the song while male voices are singing together. This song may be playing when having or wanting a good mood. | ["rock&roll", "e-bass", "acoustic drums", "male voices singing", "violin", "uptempo", "good mood"] | ["Music", "Roll", "Rock and roll"] | 6 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/07s8j8t", "/m/07sbbz2"] |
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 );