musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic sounds" and musiccaps_aspects contains "video game music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electronic sounds · 2 ✖
- video game music · 2 ✖
- fast tempo 1
- horns 1
- incessant grunting 1
- instrumental 1
- intense 1
- low audio quality 1
- male talking 1
- pig grunting 1
- recorded on phone 1
- shooting 1
- strings 1
- synthesiser arrangements 1
- toy 1
- two unrelated audios 1
- wind sound 1
musiccaps_names (array) 4 ✖
- Music 2
- Oink 1
- Quack 1
- Television 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pug vs Robo Pig | This music is video game background music. The tempo is fast with aggressive synth articulation and electronic sounds like shooting and crashing . There is also a superimposed sound of a toy pig grunting incessantly with a man talking in the background. | 2011-01-23T08:41:26Z | isblokken | Our Puppy 'Meg' vs 'Mr Bacon'. With added stoopid Mortal Kombat sound effects. | ["Music", "Quack", "Oink"] | ["instrumental", "fast tempo", "video game music", "shooting", "synthesiser arrangements", "electronic sounds", "pig grunting", "toy", "male talking", "incessant grunting", "two unrelated audios", "intense"] | 7 | IF-77lLlMzE | 1884 | |
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;