musiccaps
2 rows where aspect_list contains "simple hi hats" and audioset_ids contains "/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 |
---|---|---|---|---|---|---|---|---|---|---|
1Q9DXhXMSFI | The Low Quality recording features a regional Mexican song sung by reverberant male vocals over acoustic guitar chords, punchy snare and kick hits, groovy bass and funky piano chords. There is a short snare roll at one point that serves as a transition to the next section of the song. Sounds a bit muffled, as it is a live performance, but also energetic and fun. | ["low quality", "regional mexican", "reverberant male vocal", "acoustic guitar chords", "groovy bass", "funky piano chords", "simple hi hats", "punchy kick", "punchy snare", "snare roll", "energetic", "fun"] | ["Music", "Pop music", "Ska"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/064t9", "/m/06rqw"] | |
s6U8DtBK3Us | The low quality recording features a rock song that consists of harmonizing background vocals, alongside passionate male vocals, singing over, at least, punchy snare, simple hi hats, smooth bass, thin kick and punchy snare hits. The recording is so noisy that the actual song can barely be heard, but regardless it sounds vintage, energetic and uplifting. | ["low quality", "noisy", "vintage", "harmonizing background vocals", "passionate male vocal", "punchy snare", "saxophone melody", "rock", "simple hi hats", "thin kick", "smooth bass", "uplifting", "energetic"] | ["Swing music", "Music of Africa", "Music", "Ska"] | 4 | 30 | 40 | 1 | 1 | ["/m/015y_n", "/m/0164x2", "/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 );