musiccaps_details (view)
4 rows where musiccaps_aspects contains "claps", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- claps · 4 ✖
- passionate · 4 ✖
- passionate male vocal · 4 ✖
- low quality 3
- shimmering hi hats 3
- emotional 2
- punchy kick 2
- r&b 2
- 4 on the floor kick 1
- addictive 1
- background harmonizing male vocals 1
- boomy 1
- brass melody 1
- breathy flute melody 1
- disco 1
- funky 1
- gliding bass 1
- groovy bass 1
- harmonizing background vocals 1
- noisy 1
- piano melody 1
- poor quality mix 1
- punchy snare 1
- reverberant 1
- shimmering tambourine 1
- speaker 1
- strings melody 1
- sustained strings melody 1
- synth strings melody 1
- tinny bells melody 1
- tinny high pitched synth lead melody 1
- traditional 1
- wooden percussions 1
musiccaps_names (array) 6 ✖
- Music 3
- Disco 1
- Folk music 1
- Happy music 1
- Shuffle 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 |
---|---|---|---|---|---|---|---|---|---|---|
"Odyssey" Shuffle | The low quality recording features a R&B song playing on a speaker, judging by the reverberant and boomy sound of it. The song consists of passionate male vocal singing over shimmering hi hats, claps, groovy bass and "4 on the floor" kick pattern, It sounds passionate, like something you would dance to with your partner. | 2009-12-01T13:37:07Z | Freda Terry | Chicago Vocational School's (CVS) line dance instructor Graham is teaching a few of his students Betty 1, Betty 2, Faylesha, Jackie and Freda the "Odyssey" shuffle. His class is held at CVS on Mondays at 7pm to 8:30pm. Music is a Temptation's remix. | ["Music", "Shuffle"] | ["low quality", "r&b", "boomy", "passionate male vocal", "claps", "shimmering hi hats", "groovy bass", "noisy", "passionate", "speaker", "reverberant", "4 on the floor kick"] | 4 | -M6K3QoHh40 | 38 | |
Pieter T - If My Girl | The low quality recording features a R&B song that consists of passionate male vocals, alongside background harmonizing male vocals, singing over tinny bells melody, synth strings melody, tinny high pitched synth lead melody, shimmering hi hats, gliding bass, punchy kick and claps. It sounds passionate and emotional, even though the mix of the song is poor. | 2011-10-30T05:12:06Z | IceFrettz | Pieter T - If My Girl From the album Life, Love & Lessons. Available now on itunes. | ["Music", "Happy music"] | ["low quality", "r&b", "passionate male vocal", "background harmonizing male vocals", "tinny bells melody", "synth strings melody", "tinny high pitched synth lead melody", "shimmering hi hats", "gliding bass", "punchy kick", "claps", "passionate", "emotional", "poor quality mix"] | 4 | 3IYd8cCmUkQ | 454 | |
bajarangi dar pe hum tere roz ayenge | The low quality recording features a traditional song that consists of a passionate male vocal singing over breathy flute melody, shimmering tambourine, claps, wooden percussion and strings melody. It sounds passionate and emotional. | 2011-06-30T03:54:31Z | hanumanmaharaj | karne vandan charno mein bajarangi dar pe hum tere roz ayenge - hanuman bhajan by gulshan kumar taken from album hanuman chalisa | ["Folk music"] | ["low quality", "traditional", "passionate male vocal", "breathy flute melody", "strings melody", "wooden percussions", "shimmering tambourine", "claps", "passionate", "emotional"] | 4 | 5AdeNHlPnvs | 639 | |
70's Disco Fever To 20 Songs | The Disco song features a passionate male vocal, alongside harmonizing background vocals, singing over sustained strings melody, piano melody, brass melody, punchy kick and snare hits, shimmering hi hats and some claps. It sounds funky, addictive and passionate - like something you would hear in clubs during the 70s. | 2010-08-16T05:53:04Z | djcrd09 | DJ CRD-These R My Top 20 Disco/Funk Groovin Songs..Enjoy..Hop U Like..Don't Forget 2 Subscribe And Comment djcrd09@yahoo.com | ["Disco", "Music", "Soul music"] | ["disco", "harmonizing background vocals", "passionate male vocal", "sustained strings melody", "piano melody", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "claps", "funky", "addictive", "passionate"] | 4 | yzjbAxCnt7U | 5451 |
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;