musiccaps_details (view)
1 row where musiccaps_aspects contains "guitar lesson", musiccaps_names contains "Musical instrument" and "youtube_published" is on date 2009-04-16
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
intermediate to advanced guitar lesson -Blues Soul R&B Funk Jazz Progression | 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. | 2009-04-16T18:13:58Z | GuitarJamz Lessons | http://guitarjamz.com here is a great progression to solo over, or practice your soloing!! follow me at twitter http://twitter.com/martyschwartz http://youtube.com/martyfs74 | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["lesson recording", "guitar lesson", "electric guitar", "clean sound", "simple tune", "male voice", "instructive speaking"] | 9 | 3noh9LiQNrs | 503 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;