musiccaps
2 rows where aspect_list contains "amateur recording" and audioset_ids contains "/m/03xq_f"
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 |
---|---|---|---|---|---|---|---|---|---|---|
6lPw0wKu7_M | This audio contains someone playing a big acoustic drum set with a lot of fill-ins before breaking into the next part of the song. It sounds as if it is the big finale. With loud hits on the cymbals a e-bass is playing a long note and the organ is playing loud chords in the higher register. This song may be playing live at a concert. | ["amateur recording", "acoustic drums", "e-bass", "electric organ", "epic", "funky", "slower tempo"] | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | 6 | 180 | 190 | 0 | 0 | ["/m/013y1f", "/m/01s0ps", "/m/03xq_f", "/m/05148p4", "/m/05r5c"] | |
p2yedR_jMTU | Someone is playing a melody on an electric organ in a minor key. An acoustic drum is playing a simple groove with single hits on the ride. An e-bass is playing the root note of the melody accompanied by a clean e-guitar sound fingerpicking the chords. Then a deeper male voice starts singing. This song may be playing in a sad romantic movie scene. | ["amateur recording", "acoustic drums", "e-bass", "organ", "e-guitar", "deeper male voice singing", "mediumto uptempo", "melancholic"] | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | 6 | 0 | 10 | 0 | 0 | ["/m/013y1f", "/m/01s0ps", "/m/03xq_f", "/m/05148p4", "/m/05r5c"] |
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 );