musiccaps_details (view)
3 rows where musiccaps_aspects contains "no percussions", musiccaps_aspects contains "passionate" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- no percussions · 3 ✖
- passionate · 3 ✖
- bad audio quality 2
- love song 2
- amateur music video 1
- ambient noises 1
- amplified keyboard 1
- angst 1
- calm 1
- children’s song 1
- dance music 1
- disc scratching tones 1
- disturbed mind 1
- dj 1
- dj face off 1
- dj maestro 1
- dreamy 1
- eerie tones 1
- emotional metal song 1
- enthusiastic 1
- exciting 1
- exorcism sounds 1
- female vocalist 1
- gentle 1
- groovy bass line 1
- groovy music 1
- guitar accompaniment 1
- hurt 1
- instrumental music 1
- lightning 1
- live audience 1
- live performance 1
- lullaby 1
- male singer 1
- mellifluous 1
- melodic 1
- melodic piano accompaniment 1
- no harmonies 1
- pleasant 1
- rain sounds 1
- retro dj music 1
- romantic 1
- rumbling tones 1
- sentimental 1
- simple 1
- slow tempo 1
- soothing 1
- sound of static 1
- spirited 1
- synchronous singing 1
- syncopated music 1
- techno dance music 1
- thunder noise 1
- vocal choral harmony 1
- vocal treat 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music · 3 ✖
- Independent music 1
- Lullaby 1
- Sampler 1
- Scratching (performance technique) 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bella's Lullaby (with lyrics) | A female vocalist sings this pleasant melody. The tempo is slow with a melodic piano accompaniment. There is minimal instrumentation with emphasis on vocals. The song is soft, mellow, soothing, calming, mellifluous, pleasant, and dreamy. This song is a love song, children’s song or a lullaby. | 2008-11-30T03:54:32Z | Camille Chen | Song: Bella's Lullaby Artist: the BELLA CULLEN PROJECT | ["Music", "Song", "Lullaby"] | ["female vocalist", "slow tempo", "vocal choral harmony", "love song", "children’s song", "calm", "soothing", "gentle", "sound of static", "dreamy", "lullaby", "melodic piano accompaniment", "amplified keyboard", "no percussions", "vocal treat", "synchronous singing", "pleasant", "mellifluous", "romantic", "passionate", "sentimental", "melodic", "simple"] | 7 | 1rhsnmWLeGw | 314 | |
Teddy Sampler 2011.mp4 | A male singer sings this passionate melody. The song is medium tempo with an amplified guitar playing a distant rhythm with a percussive bass line. The song has ambient noises like rain pattering down, thunder rumble sounds and ambient noise. The sound quality is poor with hissing tones. The song is an amateur metal music video. | 2011-12-04T15:25:59Z | agnvik26 | What i managed to do this year. Not good. Hope for better times next year cause this is just laughable, haha! Thx for watching guys, i love all of you who inspires me and like my tricks, thx to you all! | ["Sampler", "Music", "Independent music"] | ["male singer", "bad audio quality", "ambient noises", "rumbling tones", "amateur music video", "no percussions", "thunder noise", "lightning", "guitar accompaniment", "groovy bass line", "rain sounds", "emotional metal song", "angst", "love song", "passionate", "disturbed mind", "hurt", "youthful", "spirited"] | 1 | tEdeb9eSKDI | 5018 | |
1997 World ITF DJ Finals - Scratching Final - DJ Babu vs Tony Vegas | The song is an instrumental. The song is medium with a DJ creating scratchy tones by scratching vinyl on a turntable. The DJ creates an eerie and syncopated rhythm. The audio is bad quality. | 2012-12-14T20:20:54Z | DJ_Fobtronics | Babu as always, great on the cut. Tony Vegas, some nice stuff, but errors cost him. Mis calc'd the encode slightly, chopped the last 4 seconds. Classic Beat Juggling Final here: https://www.youtube.com/watch?v=ZYWhurwQajU | ["Scratching (performance technique)", "Music"] | ["disc scratching tones", "dj", "dance music", "retro dj music", "no harmonies", "exorcism sounds", "no percussions", "eerie tones", "dj maestro", "techno dance music", "instrumental music", "bad audio quality", "groovy music", "live performance", "exciting", "enthusiastic", "passionate", "dj face off", "live audience", "syncopated music"] | 1 | y4vtzCAPv84 | 5378 |
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;