musiccaps
1 row where aspect_list contains "amateur singing" and aspect_list contains "song cover"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- amateur singing · 1 ✖
- cameras clicking 1
- crowds clapping 1
- crowds whistling 1
- dealing with depression 1
- emotional 1
- encouraging crowd 1
- female singer 1
- guitar accompaniment 1
- home video 1
- inspiring 1
- live performance 1
- loneliness 1
- motivational 1
- music concert 1
- passionate 1
- poor audio quality 1
- romantic 1
- song cover · 1 ✖
- spirited 1
- strong bass line 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
69oU6LfyQ_4 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | ["Applause", "Music", "Crackle"] | 1 | 30 | 40 | 0 | 1 | ["/m/028ght", "/m/04rlf", "/m/07pzfmf"] |
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 );