musiccaps
2 rows where aspect_list contains "amateur recording" and audioset_ids contains "/m/0jtg0"
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 |
---|---|---|---|---|---|---|---|---|---|---|
QXe9BpTENCc | This carnatic song features a female voice singing the main melody. This is accompanied by percussion played on the ghatam. A violin plays a melody matching the vocal melody. A morsing is played in the background. Other instruments are not clearly audible due to the low quality of recording. This song can be played in a religious gathering. | ["amateur recording", "low quality audio", "female voice", "traditional song", "carnatic song", "violin", "ghatam", "morsing"] | ["Carnatic music", "Folk music", "Music", "Sitar"] | 0 | 30 | 40 | 0 | 1 | ["/m/015vgc", "/m/02w4v", "/m/04rlf", "/m/0jtg0"] | |
yreWOyWr6Uk | Someone is playing a snare with brushes along to zitars playing a repeating melody. In the background you can hear an e-bass and an acoustic guitar strumming chords. This song may be playing in a live concert. | ["zitar", "acoustic snare", "acoustic drums", "e-bass", "amateur recording", "medium tempo", "relaxing"] | ["Country", "Music", "Musical instrument", "Plucked string instrument", "Sitar"] | 6 | 330 | 340 | 1 | 1 | ["/m/01lyv", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0jtg0"] |
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 );