musiccaps
2 rows where aspect_list contains "amateur band" and audioset_ids contains "/m/06by7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
GYx6HNQbP1w | The song is an instrumental. The tempo is medium with a strong drumming rhythm, keyboard harmony, string synth harmony, guitar lead and a bass guitar shadowing the melody line in harmony. The song has rock music influences with a sense of mystery and adventure. The song is a soundtrack for an adventure sports documentary. | ["instrumental musical", "mysterious", "medium tempo", "string section harmony", "keyboard harmony", "guitar playing", "shadow guitar bass line", "steady drumming rhythm", "rock music", "amateur band", "adventure", "suspense", "adrenaline rush", "passionate", "spirited", "home video soundtrack", "adventure sports documentary", "documentary soundtrack", "unexpected"] | ["Blues", "Electric guitar", "Heavy metal", "Music", "Rock music", "Progressive rock"] | 1 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/02sgy", "/m/03lty", "/m/04rlf", "/m/06by7", "/m/0dl5d"] | |
b8okzVltB5Q | This rock and roll song is a live recording of low quality. This features a male voice singing the main melody. This is accompanied by percussion playing a simple melody in common time. The bass plays a rock and roll bassline. The keyboard plays chords and fills using a piano tone. An acoustic guitar plays chords. A voice from the crowd sings a quirky sound at the beginning of the second bar. This song can be used in a retro movie in a music festival or carnival scene. | ["rock and roll", "live recording", "low quality recording", "amateur band", "acoustic song", "bass", "quirky sounds from the crowd", "piano", "percussion", "moderate tempo"] | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Rock and roll", "Bluegrass"] | 0 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/05r6t", "/m/05w3f", "/m/06by7", "/m/07sbbz2", "/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 );