musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "romantic" and musiccaps_names contains "Exciting music" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- keyboard accompaniment 2
- male singer 2
- medium tempo · 2 ✖
- romantic · 2 ✖
- acoustic guitar 1
- african 1
- backup singers 1
- bad audio quality 1
- calm 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- emotional 1
- energetic 1
- foreign language 1
- guitar leads 1
- guitar strumming 1
- love song 1
- madly in love 1
- melodic 1
- modern country love songs 1
- passionate 1
- peaceful 1
- percussive bass line 1
- serene 1
- simple groove 1
- steady drumming 1
- straight bass lines 1
- synth arrangements 1
- …
musiccaps_names (array) 8 ✖
- Exciting music · 2 ✖
- Music 2
- Funk 1
- Happy music 1
- Music of Africa 1
- Reggae 1
- Rhythm and blues 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
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 |
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;