musiccaps
1 row where aspect_list contains "fart jokes" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Z8L3jychP14 | A female singer sings this casual melody. The tempo is medium with clapping and desk tapping percussion and no other instrumentation. The song is very casual and made up for fun. The song has poor audio quality. | ["female singer", "amateur video", "poor quality", "youthful", "teen age fun", "groovy", "made up songs", "cheerful", "college humour", "killing time", "having fun", "killing time", "make your own songs", "fart jokes", "laughing", "funny videos", "clapping rhythm", "desk tapping rhythm", "no harmony instrumentation", "medium tempo"] | ["Singing", "Music", "Hands", "Clapping"] | 1 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/0k65p", "/m/0l15bq"] |
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 );