musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and "youtube_published" is on date 2010-06-12
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- energetic · 2 ✖
- passionate 2
- boomy bass lines 1
- catchy vocal riff 1
- crowd noise 1
- digital drum 1
- electronic instruments 1
- emotional 1
- energetic drums 1
- enthusiastic 1
- fast tempo 1
- folk 1
- groovy bass 1
- insistent 1
- jamaican folk 1
- keyboard harmony 1
- live performance 1
- low quality 1
- male singer 1
- mellow synth keys melody 1
- minimal instruments 1
- muffled male vocal 1
- noisy 1
- piano accompaniment 1
- r&b 1
- raspy vocals 1
- reggae 1
- repetitive rhythm 1
- synthesiser arrangements 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 6 ✖
- Electric piano 1
- Keyboard (musical) 1
- Music 1
- Music of Africa 1
- Piano 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rehearsal Part IV - Urban R&B Worship Flowing and Worshiping | The low quality recording features a live performance of a R&B song that consists of muffled male vocal singing over groovy bass guitar, mellow synth keys melody and energetic drums. There are some crowd noises in the background. The recording is noisy, as it was probably recorded with a phone, but it sounds energetic, passionate and emotional. | 2010-06-12T04:53:53Z | Gospel Musicians | http://gospelmusicians.com/ - Jamal Hartwell, Lydell on bass Tate, Cash on Drums. Worshipping during rehearsal to some Urban Worship | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "crowd noise", "live performance", "r&b", "energetic drums", "muffled male vocal", "groovy bass", "mellow synth keys melody", "energetic", "passionate", "emotional"] | 4 | 2I6pPRWKsCQ | 348 | |
Lee 'Scratch' Perry = Word Sound | A male vocalist sings this spirited song. The tempo is fast with keyboard harmony, piano accompaniment,groovy bass lines, digital drum and synthesiser arrangement. The song is catchy, enjoyable, youthful, energetic and vivacious with recurring and insistent rhythm and a dance groove. This song is a Reggae song. | 2010-06-12T15:29:53Z | mrmsclvr | From Lee Perry 'Smoking' - VPCD1358 - | ["Music of Africa", "Music", "Reggae"] | ["male singer", "fast tempo", "boomy bass lines", "vibrant", "enthusiastic", "energetic", "passionate", "piano accompaniment", "reggae", "folk", "jamaican folk", "catchy vocal riff", "keyboard harmony", "repetitive rhythm", "insistent", "synthesiser arrangements", "raspy vocals", "upbeat", "vibrant", "enthusiastic", "energetic", "minimal instruments", "electronic instruments", "digital drum"] | 7 | sgwvhvkNELc | 4973 |
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;