musiccaps
2 rows where aspect_list contains "live recording" and audioset_ids contains "/t/dd00003"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3otUlQ4wvLY | This amateur recording features a male voice. This is accompanied by an electric guitar. The notes of the chords are first plucked and the chord is struck once. There is no percussion and no other instruments in this song. This is a slow tempo song. The mood of this song is romantic. | ["amateur recording", "guitar song", "male voice", "no percussion", "slow tempo", "foreign language", "minimal instruments", "live recording", "romantic theme"] | ["Music", "/t/dd00003"] | 0 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003"] | |
3tK7PpCo0PQ | A male singer-songwriter accompanied by a strummed acoustic guitar and singing passionately a heartfelt folk song. The recording is somewhat low fidelity and live. | ["low fidelity", "live recording", "acoustic guitar", "passionate male singer", "singer-songwriter", "strumming", "heartfelt", "folk"] | ["Music", "/t/dd00003", "Outside, urban or manmade"] | 8 | 80 | 90 | 0 | 1 | ["/m/04rlf", "/t/dd00003", "/t/dd00128"] |
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 );