musiccaps
2 rows where aspect_list contains "smooth bass" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-OAyRsvFGgc | The low quality recording features a cover of a rock song that consists of an electric guitar solo melody played over playback instrumental. The instrumental features a punchy kick and snare hits, soft cymbals and smooth bass. It sounds passionate, even though the recording is muffled and noisy, as it was probably recorded with a phone. | ["low quality", "noisy", "cover", "rock", "electric guitar solo melody", "playback instrumental", "punchy snare", "punchy kick", "smooth bass", "soft cymbals", "passionate", "muffled"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Distortion"] | 4 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/03lty", "/m/04rlf", "/m/0g12c5"] | |
hOSzGYKaJGE | The low quality recording features a rock song that consists of an electric guitar melody, smooth bass, shimmering shakers, snappy rimshots and soft male vocals singing over it. The recording is really noisy and in mono. It sounds cool, groovy and easygoing. | ["rock", "low quality", "electric guitar melody", "smooth bass", "shimmering shakers", "snappy rimshots", "soft male vocal", "noisy", "mono", "cool", "easygoing", "groovy"] | ["Bass guitar", "Guitar", "Music", "Plucked string instrument"] | 4 | 150 | 160 | 0 | 0 | ["/m/018vs", "/m/0342h", "/m/04rlf", "/m/0fx80y"] |
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 );