musiccaps
2 rows where aspect_list contains "guitarist talks" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
KduU8kmRsLg | The song is an instrumental tolled by a guitarist introducing the lesson. The tempo is slow, a guitar playing gently with feedback buzz noise. The song is relaxing but has poor audio quality with a feedback noise. | ["ambient noises", "guitarist talks", "electric guitar", "amplifier", "guitar pick", "online lessons", "guitar video blog", "guitar strumming", "feedback noise", "instrumental music", "buzzing noise", "poor audio quality", "pleasant", "relaxing", "youtube guitar lessons", "medium tempo", "lesson intro", "guitar tutor", "guitar strings"] | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | 1 | 0 | 10 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0b_fwt", "/m/0fx80y"] | |
cQX-WgT0ACQ | A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. | ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 1 | 20 | 30 | 0 | 0 | ["/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );