musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "enthusiastic", aspect_list contains "passionate" and aspect_list contains "poor audio quality"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0pewITE1550 | The song is an instrumental. The song is medium tempo with various marching band drums playing in sync. The song is highly energetic and spirited. The song is bad in audio quality. The song is a college marching band playing enthusiastically. | ["poor audio quality", "medium tempo", "instrumental music", "groovy rhythm", "various percussion instruments", "steady drum rhythm", "various percussion hits", "snares", "drums", "drum sticks", "dance rhythm", "samba", "cheerleaders", "college band", "marching band", "enthusiastic", "passionate", "energetic", "high on adrenaline"] | ["Music", "Roll"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07s8j8t"] | |
sgJT5lIFttM | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | 1 | 280 | 290 | 1 | 1 | ["/m/04rlf", "/m/07pp8cl", "/t/dd00125", "/t/dd00126"] |
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 );