musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "lesson recording"
This data as json, CSV (advanced)
aspect_list (array) 7 ✖
- clean sound 1
- electric guitar · 1 ✖
- guitar lesson 1
- instructive speaking 1
- lesson recording · 1 ✖
- male voice 1
- simple tune 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
3noh9LiQNrs | This is the recording of a guitar lesson. The instructor at first plays the chords on a clean sounding electric guitar and then describes the nature of the chord that he is playing. The chords that were strummed could be used as clean electric guitar samples in beat-making. | ["lesson recording", "guitar lesson", "electric guitar", "clean sound", "simple tune", "male voice", "instructive speaking"] | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 9 | 190 | 200 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0b_fwt", "/m/0fx80y", "/t/dd00125"] |
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 );