musiccaps_details (view)
2 rows where musiccaps_aspects contains "nostalgic" and musiccaps_names contains "Swing music" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- nostalgic · 2 ✖
- acoustic guitar accompaniment 1
- ambient 1
- bells melody 1
- big band 1
- dulcet 1
- emphatic lead 1
- euphoric 1
- fluid 1
- fun 1
- groovy bass lines 1
- happy 1
- instrumental 1
- low quality 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- mood 1
- piano chords progression 1
- pleasant 1
- retro pop 1
- rock and roll 1
- romantic 1
- shimmering cymbals 1
- shimmering shakers 1
- simple melody 1
- slow tempo 1
- smooth bass 1
- soft 1
- soft kick 1
- steady drumming 1
- tinny percussive elements 1
- tom rolls 1
- vintage 1
- wide reverberant brass section melody 1
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 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 |
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;