musiccaps
2 rows where aspect_list contains "alternative rock" and audioset_ids = "["/m/015lz1", "/m/04rlf", "/m/06rqw"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
5xBfKiQcMZQ | A male vocalist sings this enthusiastic song. The tempo is fast with infectious drumming, groovy bass lines, funky electric guitar harmony and an energetic keyboard accompaniment with vocal backup. The song is energetic, high-spirited, youthful, infectious, pulsating and vigorous. This song is a popular Alternative Rock. | ["male vocalist", "fast tempo", "male vocal backup", "cymbals", "bass drum", "bright drumming", "funky keyboard harmony", "groovy electric guitar accompaniment", "funky bass line", "youthful", "spirited", "enthusiastic", "energetic", "lively", "vigorous", "rock", "hard rock", "alternative rock"] | ["Singing", "Music", "Ska"] | 7 | 100 | 110 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/06rqw"] | |
Ux1vBolJf5Q | A male voice is singing in a higher register along with male background voices. An acoustic drum is playing a complex groove with a lot of fill-ins. A e-bass is holding the groove along with a e-guitar strumming single chords. This song may be playing live at a festival in the 70s. | ["alternative rock", "e-guitar", "e-bass", "acoustic drums", "male backing voices", "male voice singing", "higher register", "old recording"] | ["Singing", "Music", "Ska"] | 6 | 50 | 60 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/06rqw"] |
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 );