musiccaps
2 rows where aspect_list contains "intense" and end_s = 80
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 |
---|---|---|---|---|---|---|---|---|---|---|
2BBAUwC1BI4 | The low quality recording features an arpeggiated electric guitar melody performance. The recording is noisy and in mono, as it was probably recorded with a phone. It sounds mystical and intense. | ["low quality", "noisy", "mono", "arpeggiated electric guitar melody", "mystical", "intense"] | ["Bass guitar", "Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 70 | 80 | 0 | 0 | ["/m/018vs", "/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
S9-i_pqoUCw | The low quality recording features an aggressive male vocal talking over synth pad chords, sustained, mellow female vocals and reverberant percussion. It sounds suspenseful and intense. The recording is noisy and in mono. | ["low quality", "aggressive male vocal", "synth pad chords", "mellow sustained female vocals", "suspenseful", "intense", "noisy", "mono", "reverberant percussions"] | ["Music", "Speech", "Scary music"] | 4 | 70 | 80 | 0 | 0 | ["/m/04rlf", "/m/09x0r", "/t/dd00037"] |
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 );