musiccaps_details (view)
1 row where musiccaps_aspects contains "bells melody", musiccaps_aspects contains "big band", musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "wide reverberant brass section melody"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
James Last - Happy Music | The low quality recording features a big band song that consists of wide reverberant brass section melody, shimmering shakers and cymbals, bells melody, piano chord progression, smooth bass and soft kick hits. There are some tom rolls that represent a transition into the next section. It sounds happy and fun, but it also gives off euphoric and nostalgic vibes, as it sounds vintage. | 2009-10-19T14:24:00Z | anggip lesmana | JAMES LAST didn't burst forth on the popular music scene with a fanfare of trumpets and explosions of fire-work. He just sort of emerged in a quiet cloak of talent. For three years running LAST was voted best bass player in a German jazz poll. But the minute he found out that having an orchestra and being able to experiment with hit songs was much more satisfying and rewarding, JAMES LAST was on the way to becoming a true giant in the world of today popular music. The remarkable abilities as a bass player are only part of his musical talent. He also is an accomplished songwriter, arranger and bandleader. | ["Swing music", "Music"] | ["low quality", "big band", "wide reverberant brass section melody", "shimmering cymbals", "shimmering shakers", "tinny percussive elements", "tom rolls", "bells melody", "piano chords progression", "smooth bass", "soft kick", "happy", "fun", "nostalgic", "euphoric", "vintage"] | 4 | VnJeG9RGUVM | 3031 |
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;