musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance groove" and musiccaps_aspects contains "intense drumming" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- dance groove · 2 ✖
- dance music 2
- intense drumming · 2 ✖
- acousitc guitar 1
- bass guitar 1
- bongos 1
- boomy bass line 1
- buoyant 1
- club music 1
- congas 1
- crowd chatter 1
- dance hits 1
- dj 1
- electronic music 1
- emotional 1
- energetic 1
- enthusiastic 1
- excessive reverb 1
- fast tempo 1
- female backup 1
- foreign language 1
- inferior audio quality 1
- inferior sound quality 1
- keyboard harmony 1
- male vocalist 1
- medium tempo 1
- muddled song 1
- muddled vocals 1
- muffled sounds 1
- muffled vocals 1
- passionate 1
- peppy 1
- pop rock 1
- punchy 1
- regional pop 1
- rock 1
- romantic 1
- salsa music 1
- soft pop 1
- synthesiser arrangement 1
- upbeat 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Singing 1
- Tambourine 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 |
---|---|---|---|---|---|---|---|---|---|---|
Dan Nguyen va Cat Tien hat Loi To Tinh De Thuong | A male vocalist sings this pop song. The tempo is medium with keyboard accompaniment ,steady drumming, groovy bass, congas and bongos percussion and acoustic guitar accompaniment with vocal backup. The sound quality of the audio is inferior and there is the sound of chatter in the background .The song is fresh, simple, breezy, romantic, passionate, sentimental and youthful with a dance groove. This song is Regional Pop. | 2015-07-28T01:31:19Z | Oanh Nguyen | ["Singing", "Music", "Wedding music"] | ["male vocalist", "medium tempo", "female backup", "soft pop", "dance groove", "dance music", "muffled sounds", "crowd chatter", "salsa music", "keyboard harmony", "congas", "bongos", "bass guitar", "intense drumming", "acousitc guitar", "muffled vocals", "inferior sound quality", "foreign language", "regional pop", "passionate", "emotional", "romantic", "enthusiastic"] | 7 | JWNWCKdfpzM | 2015 | ||
[100105 HQ]Rainbow レインボー ''Gossip Girl'' Dance Practice for Kim Jung Eun's Chocolate | This is a fast tempo song. The audio quality is inferior so the vocals are muddled making it difficult to comprehend if the vocalist is a male or female. The music is incoherent too but it is possible to identify synth arrangements, intense drumming, boomy bass lines,and keyboard harmony with spirited vocals. The song is upbeat and has a dance groove. It is a pop rock/ synth rock. | 2010-01-05T12:43:13Z | KoreanRainbow | [100105 HQ]Rainbow ''Gossip Girl'' Dance Practice for Kim Jung Eun's Chocolate | ["Music", "Tambourine"] | ["fast tempo", "energetic", "buoyant", "peppy", "punchy", "dance hits", "club music", "dance groove", "dj", "upbeat", "synthesiser arrangement", "electronic music", "boomy bass line", "intense drumming", "inferior audio quality", "excessive reverb", "youthful", "rock", "pop rock", "dance music", "muddled vocals", "muddled song"] | 7 | 5DDg2CzAmgE | 644 |
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;