musiccaps_details (view)
1 row where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "no voices", musiccaps_aspects contains "tremolo bar" and musiccaps_names contains "Plucked string instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Smiths - Some Girls Are Bigger Than Others (guitar riff) | This song features an electric guitar playing the main melody. The guitar plays three ascending chords. Each chord is strummed once at the beginning of the bar. The tremolo bar is used to give the sound a tremulous effect. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be played in a guitar instruction video. | 2012-01-03T09:49:44Z | yoooyooomaaa | Gretsch G5122 Ibanez CS9 MXR carbon copy | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "no voices", "tremolo bar", "three chords", "no other instruments", "instrumental"] | 0 | uxLY3CBoPo8 | 5144 |
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;