musiccaps_details (view)
2 rows where musiccaps_aspects contains "strings" and musiccaps_aspects contains "wind sound" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- strings · 2 ✖
- wind sound · 2 ✖
- electronic sounds 1
- harp 1
- horns 1
- low audio quality 1
- low pitch percussive sound 1
- quiet female voice 1
- recorded on phone 1
- still atmosphere 1
- video game music 1
musiccaps_names (array) 4 ✖
- Music 2
- Lullaby 1
- New-age music 1
- Television 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Witcher 3 - 'Lullaby of Woe' | The music features a female voice quietly singing a melody. A harp is accompanying the singer. Violins can be heard fading out from the beginning of the music excerpt. In the background one can hear the wind blowing softly. Towards the ending of the music excerpt a low pitch percussive sound can be heard. | 2015-08-27T02:28:40Z | BastianRP | By Marcin Przybyłowicz. Not owned by me. Copyright CD Projekt RED. | ["New-age music", "Music", "Lullaby"] | ["quiet female voice", "harp", "strings", "wind sound", "still atmosphere", "low pitch percussive sound"] | 2 | OLy3C8YpMsY | 2429 | |
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;