musiccaps_details (view)
2 rows where musiccaps_aspects contains "horns" and musiccaps_author = 2
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- horns · 2 ✖
- drums 1
- electronic sounds 1
- harp 1
- low audio quality 1
- male voice 1
- marimba 1
- recorded on phone 1
- strings 1
- trumpets 1
- tuba 1
- video game music 1
- wind sound 1
- yodeling 1
youtube_published (date) 2 ✖
- 2008-01-31 1
- 2008-07-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Home on the Range "Yodle Adle Eedle Idle Oo" Russian | The music features for the most part an instrumental but almost at the end of the excerpt a male voice starts to yodel. Up to that point the melody is being played by a marimba, then trumpets and horns, possibly trombones too. A tuba is holding the beat pulsation in the low register. At the end of the excerpt a harp can be heard. | 2008-07-01T06:11:14Z | Titania1989 | =) | ["Yodeling", "Music", "Song", "Steelpan"] | ["trumpets", "marimba", "horns", "tuba", "drums", "yodeling", "male voice", "harp"] | 2 | F5e-SEICJP4 | 1612 | |
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;