musiccaps_details (view)

2 rows where musiccaps_aspects contains "synth string section"

✎ View and edit SQL

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
Jak Progresso - Yip Wreck A male rapper sings this rap medley with a backup singer in vocal harmony. The song is medium tempo with a boomy bass line, synth string section and piano accompaniment. The song is storytelling and haunting in its style. The song is a retro rap song with poor audio quality. 2010-02-18T12:01:56Z Ih8thePolice Track 9 of Pestilence ["Music", "Rapping"] ["bad audio quality", "male rapper", "story telling", "emotional", "male backup singer", "piano accompaniment", "medium tempo", "eerie", "haunting", "serious", "steady drumming rhythm", "boomy bass line", "keyboard harmony", "aggressive", "rap song", "goth rap", "synth string section"] 1 TrvI6t4pAP0 2870
guitarra havaiana Seleções 10 hinos volume 01 lap steel guitar junior Dornelas hawaii gitare The music is a soft rock ballad with Hawaiian sounds. The melody is driven by a gliding steel pedal guitar. In the background a synth string section can be heard sustaining chords creating a relaxed ambience. The atmosphere of the song is easy going and relaxed. This is a song you would hear at a hotel lobby in Hawaii. 2013-12-23T01:55:31Z Junior Dornelas (1) Cristo Voltará 0:00 (2) Fala Jesus querido 4:50 (3) Ao Findar o labor 9:10 (4) O Exilado 13:20 (5) noite feliz 16:30 (6) a mão no arado 18:50 (7) O Bom Consolador 21:45 (8) Brilhando com Jesus 26:24 (9) Brilhando com Jesus 28:29 (10) Fala Jesus Querido 31:10 Full Album https://www.palcomp3.com/juniordornelas/album/112748/ pout pourri harpa Cristã 10 Hinos em solos de Guitarra havaiana, http://palcomp3.com/juniordornelas/ baixe os meus solos no palco ["Music", "Wedding music"] ["steel pedal guitar", "hawaiian", "soft rock ballad", "synth string section", "tight drum kit", "relaxed", "laid back"] 5 zYM0gtd_PRo 5488

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;