musiccaps_details (view)

4 rows where musiccaps_aspects contains "emotional" and musiccaps_names contains "Exciting music"

✎ 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
Michael ofori ogyegyentwie ghana gospel music A male vocalist sings this sweet melody in a foreign language. The tempo is medium with keyboard accompaniment, steady drumming, synthesiser arrangement and acoustic guitar. The song has a simple, easy melody. It is earnest, emotional, calm and soothing. This song is a Regional Pop song. 2009-04-20T09:40:57Z gimwhp Michael Ofori, Ghanaian born live in the United States. Singer of Gospel music. ["Music of Africa", "Funk", "Music", "Reggae", "Rhythm and blues", "Soul music", "Exciting music"] ["male singer", "medium tempo", "foreign language", "world music", "keyboard accompaniment", "steady drumming", "straight bass lines", "synth arrangements", "african", "melodic", "calm", "simple groove", "acoustic guitar", "romantic", "emotional", "peaceful", "serene"] 7 D3FyfFIKLVc 1430
sound twins music The low quality recording features a cover of a R&B song that contains passionate female vocals, alongside background harmonizing female vocals, singing over punchy kick, claps, groovy bass, smooth keys and short strings chords. It sounds romantic, emotional and groovy. 2007-06-18T18:59:27Z MSRTV6 princess feat. Blunty Dont call me. ["Music", "Song", "Exciting music"] ["r&b", "cover", "passionate female vocal", "background harmonizing female vocals", "punchy kick", "claps", "groovy bass", "smooth synth keys", "short strings chords", "romantic", "emotional", "groovy", "low quality"] 4 bkYWnzw_5Bs 3646
Lil Wayne - Lose Control (New Music 2012) ft. Brisco [ Song from Tha Carter IV ] A male singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a slick drumming rhythm, keyboard accompaniment, beep tones, strong bass line and slick percussion hits. The song is groovy and story telling in nature. The song has poor audio quality. 2011-08-02T20:05:16Z REDKAN MUSIC Lil Wayne - Lose Control (New Music 2012) ft. Brisco Lil Wayne - Lose Control (New Music 2011) ft. Brisco Lil Wayne - Lose Control (New Music 2011) ft. Brisco ["Music", "Exciting music"] ["male singer", "backup singers", "rap music", "drum rolls", "hip hop music", "hood", "ghetto boys", "piano accompaniment", "slick drumming rhythm", "solid drum play", "story telling", "energetic", "emotional", "beep tones", "hi- hop dance hits", "medium tempo", "hip hop dance hits", "poor audio quality", "strong bass line"] 1 jlIbJVfnHB4 4280
N'Sync - Selfish This is the live recording of a boy band performing a pop music piece. The male vocals are singing melodically. There is a keyboard and a bass guitar playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is emotional. This piece could be included in the soundtrack of a teenage romance/drama movie. 2007-07-24T07:50:18Z Yan Chat N'Sync - Selfish... N'Sync Popodyssey Live... ["Singing", "Music", "Exciting music"] ["live performance", "pop music", "dance-pop", "boy band", "male vocals", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "emotional", "tear-jerking"] 9 kw2wPVxUgQY 4367

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;