musiccaps_details (view)
1 row where musiccaps_aspects contains "horns", musiccaps_aspects contains "wind sound", musiccaps_names contains "Music" and musiccaps_names contains "Television"
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 |
---|---|---|---|---|---|---|---|---|---|---|
New Super Smash Bros. Brawl Video 1-31-08 [English] | The music excerpt sounds as if it was recorded with a low-quality phone and so the quality of the audio is also low. A repeating melody is being played by horns from an orchestra ensemble. Strings can be heard providing harmonic context. Wind sounds as well as electronic and video game sounds can be heard in the background. It sounds as if the atmosphere is tense and a fight is going on. | 2008-01-31T15:32:55Z | Lynx644 | Staright from the dojo website, heres the link and yea thanks for watching... http://www.smashbros.com/en_us/index.html | ["Music", "Television"] | ["video game music", "recorded on phone", "low audio quality", "wind sound", "electronic sounds", "horns", "strings"] | 2 | zR4ebAuqy8w | 5474 |
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;