musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "backup singers", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- backup singers · 2 ✖
- keyboard accompaniment · 2 ✖
- male singer · 2 ✖
- medium tempo 2
- vocal harmony 2
- bad audio quality 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- dance club 1
- dance groove 1
- dance rhythm 1
- energetic 1
- exciting 1
- female singer 1
- groovy bass line 1
- guitar leads 1
- guitar rhythm 1
- guitar strumming 1
- live performance 1
- love song 1
- madly in love 1
- modern country love songs 1
- motown 1
- passionate 1
- people dancing 1
- percussive bass line 1
- poor audio quality 1
- r&b music 1
- …
musiccaps_names (array) 9 ✖
- Music 2
- Disco 1
- Exciting music 1
- Happy music 1
- Rhythm and blues 1
- Singing 1
- Ska 1
- Song 1
- Soul music 1
youtube_published (date) 2 ✖
- 2008-02-27 1
- 2009-04-16 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 | |
Soul Motown R&B Rap Swing Wedding Music Band Hip Cool Disco Top-40 Dance Band Covers www.igmc.net | A male singer sings this cool melody with female and male backup singers in vocal harmony. The song is medium tempo with a groovy bass line, percussive drum rhythm, keyboard harmony and guitar rhythm. The song is exciting and groovy. The song is a R&B cover of a famous pop song. The song has poor audio quality. | 2008-02-27T20:49:11Z | IGMCmusic | 212-765-8714 www.igmc.net Soul Motown R&B Rap Swing Wedding Music Band Hip Cool Disco Top-40 Dance Band Covers www.igmc.net | ["Singing", "Disco", "Music", "Rhythm and blues", "Ska", "Song", "Soul music"] | ["male singer", "female singer", "backup singers", "dance club", "vocal harmony", "r&b music", "soul music", "motown", "song cover", "r&b music", "groovy bass line", "steady drumming rhythm", "keyboard accompaniment", "guitar rhythm", "exciting", "dance groove", "dance rhythm", "people dancing", "dance club", "live performance", "poor audio quality", "medium tempo"] | 1 | AGNqX_OL-dU | 1095 |
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;