musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "ambient" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- ambient · 3 ✖
- medium fast tempo · 3 ✖
- acoustic guitar 1
- aesthetic 1
- ambient emphatic 1
- cello 1
- classical 1
- club music 1
- contemporary pop 1
- dance music 1
- dance pop 1
- digital drumming 1
- dulcet 1
- electric guitar harmony 1
- electric guitar riff 1
- electro pop 1
- electronic music 1
- emotional 1
- emphatic bass lines 1
- energetic 1
- euphonious 1
- female singer 1
- funk 1
- groovy rhythm 1
- infectious drumming 1
- instrumental 1
- keyboard arrangement 1
- lively trumpets 1
- lively violin 1
- male vocalist 1
- mellifluent 1
- melodious viloin 1
- orchestral music 1
- passionate 1
- piano accompaniment 1
- pleasant 1
- powerful vocals 1
- r&b 1
- romantic piano accompaniment 1
- seasoned vocals 1
- soul 1
- sweet 1
- synth pop 1
- synthesiser articulation 1
- tambourine beats 1
- upbeat 1
- violin symphony 1
- vocal backup 1
musiccaps_names (array) 8 ✖
- Music 2
- /m/05zppz 1
- /t/dd00003 1
- Background music 1
- Pop music 1
- Singing 1
- Ska 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gimme More (Britney Spears) - Cover/Male Singing. | A female singer sings soft pop songs. The tempo is medium fast with electronically arranged music, electric guitar harmony, digital drum beats, and melodious vocal backup. The song is simple, soft, emotional, upbeat, catchy, with a dance groove. This song is an Electro Pop song. | 2013-03-03T05:27:25Z | TheMaleBritney | Please Like, Subscribe, Share and Comment :D I Don't Own "Gimme More" Britney Does. Heres the link to buy the original Gimme More: https://itunes.apple.com/au/album/gimme-more-single/id264025647 | ["Singing", "Music", "/m/05zppz", "Pop music", "/t/dd00003"] | ["female singer", "medium fast tempo", "emotional", "contemporary pop", "upbeat", "groovy rhythm", "dance music", "dance pop", "club music", "electro pop", "synth pop", "ambient", "electronic music", "synthesiser articulation", "digital drumming", "keyboard arrangement", "electric guitar riff", "vocal backup"] | 7 | MY0PsDE3xHs | 2279 | |
Rufus Thomas - The Memphis Train | A male vocalist sings this powerful pop. The tempo is medium fast with an emphatic and groovy bass line, lively trumpet harmony, piano accompaniment, electric guitar rhythm, tambourine beats and infectious drums. The song is lively,spirited, engaging, vivacious,passionate, compelling and ambient with powerful vocals . This Song is an R&B/Funk. | 2010-04-08T08:17:16Z | Matthew East | ["Ska"] | ["male vocalist", "medium fast tempo", "lively trumpets", "emphatic bass lines", "ambient", "seasoned vocals", "powerful vocals", "electric guitar harmony", "piano accompaniment", "tambourine beats", "infectious drumming", "funk", "r&b", "soul", "passionate", "energetic", "ambient emphatic"] | 7 | hYlSisv-VRU | 4117 | ||
Aston - Telephone (Violin-Piano Cover) | This music is a violin instrumental. The tempo is medium fast with the violins going from lively to soft with a romantic piano melody and acoustic guitar accompaniment. The music is orchestral with a dulcet violin symphony. It is pleasant, mellifluous, passionate, romantic; euphonious, emotional, sweet and engaging. This music is a contemporary orchestra . | 2011-01-08T08:49:04Z | Tarek Nour | Lady Gaga's Telephone Cover Enjoy !! =) | ["Background music", "Music", "Wedding music"] | ["instrumental", "medium fast tempo", "lively violin", "classical", "cello", "melodious viloin", "dulcet", "violin symphony", "pleasant", "aesthetic", "ambient", "orchestral music", "euphonious", "mellifluent", "sweet", "romantic piano accompaniment", "acoustic guitar"] | 7 | oqMlq2zWr0c | 4659 |
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;