musiccaps
2 rows where aspect_list contains "lesson recording" and audioset_ids contains "/m/0b_fwt"
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 |
---|---|---|---|---|---|---|---|---|---|---|
2pTnwe3DzCs | This is the recording of a keyboard lesson. There is a male instructor that plays the notes on the keyboard first and then describes the placement of the fingers and the notes that are being played. The audio quality of the lesson is not that great. | ["lesson recording", "amateur recording", "keyboard lesson", "male voice", "instructive speaking"] | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Speech", "Electronic tuner", "Inside, small room"] | 9 | 150 | 160 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/05148p4", "/m/05r5c", "/m/09x0r", "/m/0b_fwt", "/t/dd00125"] | |
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 );