musiccaps_details (view)
2 rows where musiccaps_author = 2 and musiccaps_names contains "Television" sorted by youtube_channel
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 12 ✖
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 | |
Deep forest - The sound of Africa | The music features a girlish female voice singing a sparse melody. The bass guitar and drums drive the pulse of the music but the drums play a more active role in that regard. Towards the middle of the music excerpt a crescendo leading into an orchestra hit can be heard. After this, a calming synth pad sound can be heard providing harmonic context. | 2008-08-29T21:34:21Z | xalphakirx | Deep forest - The sound of Africa | ["Music", "Television"] | ["drums", "bass guitar", "girlish female voice", "calming synth pad sound", "orchestra hit"] | 2 | 6jZ8VNANHwM | 780 |
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;