musiccaps_details (view)
1 row where musiccaps_names contains "Musical instrument" and youtube_description = "For more gear reviews and videos check out guitarworld.com In this video Guitar World's gear editor Paul Riario demonstrates the features of the Hagstrom Viking guitar."
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hagstrom Viking Guitar | The low quality recording features a cover of a soft rock song and it consists of a mellow electric guitar melody. The recording is a bit noisy. It sounds like an intro section of the song. | 2008-09-30T18:14:00Z | Guitar World | For more gear reviews and videos check out guitarworld.com In this video Guitar World's gear editor Paul Riario demonstrates the features of the Hagstrom Viking guitar. | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion", "Inside, small room"] | ["low quality", "soft rock", "cover", "mellow electric guitar melody", "noisy", "intro"] | 4 | kSdH9z8snac | 4318 |
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;