musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussion", musiccaps_aspects contains "strings" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- percussion · 3 ✖
- strings · 3 ✖
- medium to uptempo 2
- acoustic drums 1
- acoustic guitars 1
- acoustic piano 1
- ballad 1
- brass section 1
- cinematic 1
- e-bass 1
- epic 1
- flutes 1
- higher pitch 1
- male voice singing 1
- orchestral 1
- oriental/orchestral 1
- oud 1
- romantic 1
- saxophone 1
- trumpets 1
- upright bass 1
musiccaps_names (array) 7 ✖
- Brass instrument 1
- Music 1
- Orchestra 1
- Saxophone 1
- Soundtrack music 1
- Tender music 1
- Theme music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lior Boker playing "A gate that closed" in maqam sika | This composition contains acoustic guitars strumming chords panned to the right side of the speakers. Other plucked string instruments are playing a melody along. An acoustic drum is playing a simple dance groove with a pregnant hihat. In the background you can hear an upright bass and violins playing a melody on the next part of the song. A male voice is singing in the mid-to high range. This song may be playing live. | 2008-09-19T14:59:57Z | lior boker | Lior Boker with the Israeli Andalusian Orchestra and Shimon Sibony | ["Orchestra"] | ["oriental/orchestral", "acoustic guitars", "oud", "strings", "acoustic drums", "percussion", "upright bass", "male voice singing", "higher pitch", "medium to uptempo"] | 6 | DPW5M1FYxu4 | 1473 | |
CHERYL BERDELL - Giving It All To You | This song contains an acoustic piano playing a melody in the mid- to high range along with a simple bassline playing long notes. A saxophone is playing a loud melody in a higher key. In the background you can hear strings and some fast percussive rolls. THe audio contains white noise. This song may be playing on a romantic date. | 2010-01-13T13:33:15Z | NaturalSoulBrother1 | Give it time to kick in and I'm pretty sure this is one of them tunes that will stay buzzing around your head for days to come. Great piece of Chicago Modern Soul and a great feel good tune as well. Hope you enjoy. | ["Brass instrument", "Saxophone"] | ["ballad", "acoustic piano", "strings", "e-bass", "saxophone", "percussion", "romantic"] | 6 | fKni4PUSxu4 | 3941 | |
War Thunder Soundtrack: Australia/Germany Menu Music | This song contains an orchestra playing an epic sounding piece. Trumpets are playing the main melody along with a brass section providing chords, other string instruments are playing a short melody with the bow and someone is playing marching snares before a cymbal roll comes in and flutes are taking over along with strings in the background. This song may be playing in a war hero movie. | 2013-06-29T15:28:08Z | Rakashin7 | This song is called "Advance Australia" Composed by Zakhar Antonov Performed by the Baltic Symphony Orchestra Was 'Battle Music 2' before patch 1.79 You can buy the soundtrack here: http://warthunder.com/en/soundtrack Some songs, including the main theme, aren’t available for purchase, so you can get them for free here: https://www.mediafire.com/?fadgeteb22... Replace "tube" in the URL with "repeat" to have the music repeat =D Vote for your favorite air battle music here: http://strawpoll.me/6946245 =O | ["Theme music", "Music", "Soundtrack music", "Tender music"] | ["cinematic", "orchestral", "epic", "trumpets", "brass section", "flutes", "strings", "percussion", "medium to uptempo"] | 6 | sQMzHk9MRAI | 4948 |
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;