musiccaps
2 rows where aspect_list contains "entertaining", aspect_list contains "groovy bass line", aspect_list contains "instrumental music" and aspect_list contains "passionate"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 1RwhRTe-OKk | The song is an instrumental. The song is medium tempo with three guitars playing in harmony, guitar accompaniment, guitar harmony, guitar lead and a strong bass line. The song is emotional and spirited. The song has an average audio quality and is played in front of a live audience. | ["poor audio quality", "home video recording", "guitar band", "instrumental music", "medium tempo", "guitars playing in harmony", "groovy bass line", "guitar lead", "guitar accompaniment", "entertaining", "emotional", "passionate", "spirited", "lilting"] | ["Banjo", "Tapping (guitar technique)", "Music"] | 1 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/01glhc", "/m/04rlf"] | |
| f8QGA4vN6HY | The song is an instrumental. The tempo is fast with a groovy jazz drumming rhythm with good brush works, strong bass line, piano accompaniment and various percussion hits. The song is groovy and energetic. The song is jazz fusion. | ["jazz music", "groovy bass line", "jazz fusion", "dance rhythm", "dj", "modern jazz hits", "documentary soundtrack", "dancing all night", "sophisticated", "piano accompaniment", "brush work", "fast tempo", "instrumental music", "relaxing", "passionate", "techno jazz line", "funk music", "entertaining"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 1 | 0 | 10 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );