musiccaps
2 rows where aspect_list contains "pop" and audioset_ids contains "/m/0l14gg"
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 |
---|---|---|---|---|---|---|---|---|---|---|
5fPxUI0Fl-4 | This song contains two acoustic guitars picking a melody. A digital drum is playing a simple groove when a male voice starts to sing in a higher register with backing vocals. Then the melody drops one octave. The guitars are panned to the left and right side of the speakers. This song may be playing on a road trip with friends. | ["pop", "acoustic guitars", "male voice singing", "digital drums", "medium to uptempo"] | ["Music", "Soundtrack music", "Happy music"] | 6 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/0l14gg", "/t/dd00031"] | |
fsXfBoNcLeM | The Pop song features a flat female vocal rapping, alongside passionate background female vocal singing, over straight piano chords, simple synth bass, wide distorted synth and wide synth brass chords, followed by groovy hi hats, punchy kick and snare hits. It sounds uplifting and energetic. | ["pop", "flat female vocal", "passionate background female vocal", "wide synth brass chords", "distorted wide synths", "straight piano chords", "punchy kick", "punchy snare", "groovy hi hats", "simple synth bass", "energetic", "uplifting"] | ["Music", "Rapping", "Soundtrack music"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06bxc", "/m/0l14gg"] |
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 );