musiccaps
2 rows where aspect_list contains "punk" and audioset_ids contains "/m/0dl5d"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ARXTRdKCupM | The low quality recording features a punk song that consists of a groovy bass guitar, punchy kick, shimmering hi hats, energetic cymbals and aggressive electric guitar riffs. At the very beginning of the loop, there is a drum stick countdown, after which the bass drops. It sounds energetic, groovy and aggressive. | ["punk", "low quality", "groovy bass guitar", "punchy snare", "punchy kick", "shimmering hi hats", "energetic cymbals", "aggressive electric guitar riffs", "aggressive", "energetic", "groovy", "drum sticks countdown"] | ["Bass guitar", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | 4 | 30 | 40 | 0 | 0 | ["/m/018vs", "/m/03lty", "/m/04rlf", "/m/05r6t", "/m/06by7", "/m/0dl5d"] | |
NzVg-cFQJbE | This is a punk rock song with an energetic, youthful feel that is still grungy and gritty. The guitar is dark and powerful in the low tones, contrasted by another electric guitar that's bright and warm on the off beats. The drummer plays a high octane drum beat with drum fills between each line of the lyrics. | ["punk rock", "rock", "punk", "energetic", "charged up", "bouncy", "gritty", "grungy", "youthful", "heavy grungy electric guitar strumming", "energetic emo vocalist"] | ["Heavy metal", "Music", "Rock and roll", "Progressive rock"] | 3 | 30 | 40 | 0 | 1 | ["/m/03lty", "/m/04rlf", "/m/07sbbz2", "/m/0dl5d"] |
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 );