musiccaps
3 rows where aspect_list contains "hollow snare" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
AJj6GGLaIfI | The low quality recording features a hypnotic mellow synth lead melody, low percussive elements, sustained synth strings and some hollow snare hits. It sounds noisy, resonating, but also nostalgic and sentimental, as it gives off an old console game soundtracks. | ["low quality", "sustained synth strings", "hollow snare", "low percussive elements", "hypnotic mellow synth lead melody", "noisy", "resonating", "nostalgic", "sentimental"] | ["Folk music", "Jazz", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/02w4v", "/m/03_d0", "/m/04rlf"] | |
YddV91xnUz4 | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | ["Singing", "Ska"] | 4 | 310 | 320 | 0 | 0 | ["/m/015lz1", "/m/06rqw"] | |
bxZeGrM_0ac | The low quality recording features a jazz song that consists of a saxophone solo melody played over hollow snare, groovy double bass, shimmering hi hats, shimmering shakers and brass melody. It sounds uptempo, groovy and passionate - like something you would hear in a jazz club. | ["low quality", "jazz", "uptempo", "groovy", "passionate", "saxophone solo melody", "hollow snare", "groovy double bass", "shimmering hi hats", "shimmering shakers", "brass melody", "energetic"] | ["Brass instrument", "Saxophone"] | 4 | 400 | 410 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] |
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 );