musiccaps_details (view)
1 row where musiccaps_aspects contains "passionate electric guitar solo melody", musiccaps_names contains "Effects unit" and "youtube_published" is on date 2013-09-05
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 |
---|---|---|---|---|---|---|---|---|---|---|
GIBSON Les Paul Standard 1959 Rosie Collectors Choice #11 | The low quality recording features a passionate electric guitar solo melody being played. It is a bit reverberant too. | 2013-09-05T15:39:53Z | session | Heute hat Olli einen Leckerbissen für euch. Die Gute heißt Rosie und ist Collecters Choice Modell Nummer 11. Wie die GIBSON Les Paul Standard 1959 klingt, zeigt euch Olli in unserem Video! Unsere aktuelle Auswahl an Custom Shop E-Gitarren: https://bit.ly/2YlE4G1 GIBSON Les Paul Modelle bei uns: https://bit.ly/2Sfg0jI Mehr von GIBSON im Überblick: https://bit.ly/2YcGvtW Auf der Suche nach Tipps und Tricks? Hier sind unsere Tutorials: https://bit.ly/2OmRwFE - - - - - SUBSCRIBE: https://bit.ly/2rtV5vG SOCIAL MEDIA: Facebook https://bit.ly/2USWIlQ Twitter https://bit.ly/2VbihNl Instagram https://bit.ly/2RmphGe Schau in unseren Ratgeber: https://bit.ly/2UUodf0 #session #makemoremusic #gibson | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["low quality", "passionate electric guitar solo melody", "reverberant"] | 4 | izVCz3P43p8 | 4225 |
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;