musiccaps
1 row where aspect_list contains "crowd whistles" 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 |
---|---|---|---|---|---|---|---|---|---|---|
naZE-MvNpaI | This song is an amateur recording of a live performance. This features a female voice singing the main melody. This is accompanied by a distortion guitar playing power chords. The percussion plays a simple rock beat. The sound of crowd whistles are heard in this clip. Other instruments are not audible as the quality of the audio is low. This song can be played in a romantic comedy movie. | ["amateur recording", "female voice", "crowd whistles", "distortion guitar", "percussion", "rock song", "breakup song", "upbeat melody"] | ["Singing", "Music", "Pop music", "Yell"] | 0 | 90 | 100 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/064t9", "/m/07sr1lc"] |
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 );