musiccaps_details (view)
1 row where musiccaps_aspects contains "solo oboe melody in background" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_names (array) 2 ✖
- Brass instrument · 1 ✖
- French horn 1
musiccaps_aspects (array) 2 ✖
- male voice over 1
- solo oboe melody in background · 1 ✖
youtube_published (date) 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
EUIV Sweden is Overpowered 49 | Male voice over with a solo oboe melody in the background. | 2015-07-18T19:00:02Z | Arumba | Let's play Europa Universalis IV with the Common Sense expansion! In this campaign we will try out the beta patch 1.13, go for a few achievements and enjoy the now much more balanced development system. If you enjoyed this video please consider hitting the Like button, it helps the channel grow by affecting search results on YouTube. Make sure to subscribe to the channel so you stay up to date on new releases!: http://www.youtube.com/subscription_center?add_user=Arumba07 This series is best viewed from the playlist: https://www.youtube.com/playlist?list=PLH-huzMEgGWAyWhNurVDECbIZlfutb1iV | ["Brass instrument", "French horn"] | ["male voice over", "solo oboe melody in background"] | 8 | ryEXhKy1QUI | 4909 |
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;