musiccaps
1 row where aspect_list contains "acoustic guitar" and audioset_ids = "["/m/04rlf", "/m/0xzly"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
P5IxlG4-CY8 | Someone is playing maracas very skillfully while an acoustic guitar is supported with strumming chords that are constantly changing. This sounds like an amateur recording. This song may be playing at a local music store where people jam. | ["latin/country", "maracas", "acoustic guitar", "fast tempo", "amateur recording"] | ["Music", "Maraca"] | 6 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/0xzly"] |
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 );