musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering cymbals" and musiccaps_aspects contains "wide brass melody" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- low quality 2
- shimmering cymbals · 2 ✖
- wide brass melody · 2 ✖
- wide strings melody 2
- background music 1
- classical 1
- epic 1
- intense 1
- joyful 1
- mellow brass 1
- orchestral 1
- passionate 1
- shimmering triangle 1
- suspenseful 1
musiccaps_names (array) 4 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
JESUS CHRIST SUPERSTAR Jesus and Pilate 7B | The low quality recording features an orchestral music that consists of a wide string melody, followed by mellow brass, wide brass melody and shimmering cymbals. It sounds suspenseful and intense - like something that you would hear in the background of a movie scene. | 2011-07-20T12:52:38Z | GABERIALSTORM | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "orchestral", "wide strings melody", "mellow brass", "wide brass melody", "shimmering cymbals", "suspenseful", "intense", "background music"] | 4 | mhru3GXbkHY | 4487 | ||
Pokemon Ruby / Sapphire / Emerald - Title Screen (Orchestrated) | The low quality recording features a classical song that consists of a wide string melody, shimmering triangle, shimmering cymbals and wide brass melody. It sounds epic, joyful and passionate. | 2013-01-19T07:51:30Z | YoshiDude12 | I've decided to attempt orchestrating as much of the RSE soundtrack as I can. I have been planning to orchestrate an entire soundtrack before, but didn't know which one to do first (I've been pretty much just doing random stuff this entire time). It probably won't be the ENTIRE soundtrack (there's just too many), so just the more important music of the game. Not sure if it'll be in "order" from the start of the game to the end, because I've been working with Route 104 again, and that's obviously before Littleroot, Route 101, Oldale, Petalburg etc. So now, I give you the first of the orchestrated RSE soundtrack, the Title Screen. Done with EWQL Symphonic Orchestra Percussion, Hollywood Strings, Brass and Woodwinds. Not sure if I should post download links for each arrangement, or just release all of it at once when I'm "finished", which probably won't be for a while. I'll update this with (or without) a download link if I decide to do the first option. | ["Orchestra"] | ["low quality", "classical", "passionate", "epic", "joyful", "wide strings melody", "shimmering triangle", "shimmering cymbals", "wide brass melody"] | 4 | R4ulZgTCw-k | 2665 |
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;