musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "sustained strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- passionate · 4 ✖
- punchy kick · 4 ✖
- sustained strings melody · 4 ✖
- low quality 3
- shimmering hi hats 3
- emotional 2
- groovy bass 2
- punchy snare 2
- addictive 1
- background music 1
- brass melody 1
- chimes bells 1
- cinematic 1
- claps 1
- disco 1
- echoing flat male vocal 1
- echoing synth bell melody 1
- electric guitar melody 1
- filtered male vocal 1
- funky 1
- groovy 1
- harmonizing background vocals 1
- harmonizing male vocal 1
- hip hop 1
- joyful 1
- mellow arpeggiated piano melody 1
- passionate female vocal 1
- passionate male vocal 1
- piano melody 1
- pop 1
- pulsating synth melody 1
- shimmering open hats 1
- traditional 1
- wooden percussions 1
musiccaps_names (array) 5 ✖
- Music 4
- Tender music 2
- Disco 1
- Jazz 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 |
---|---|---|---|---|---|---|---|---|---|---|
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
Shukri Jamal - Abbaan lafaa dhabe lafasaa (Oromo Music 2014 New) | The low quality recording features an echoing flat male vocal, alongside harmonizing male vocal, singing over sustained strings melody, shimmering open hats, wooden percussions, punchy kick and groovy bass. It sounds traditional and passionate. | 2014-04-18T18:56:19Z | Oromp3 | Check http://www.oromp3.com/ for more Oromo music, comedy, drama & MP3 Songs. | ["Jazz", "Music"] | ["low quality", "echoing flat male vocal", "wooden percussions", "shimmering open hats", "sustained strings melody", "punchy kick", "groovy bass", "joyful", "passionate", "traditional", "harmonizing male vocal"] | 4 | Bap5P9buB0Y | 1264 | |
Mali Bang Mag Mahal by CRSP (official music video) | The low quality recording features a hip hop song that consists of a mellow arpeggiated piano melody played over sustained strings melody, chime bell and filtered male vocal in the first half of the loop. In the second half the beat drops and it consists of a punchy kick and snare hits, shimmering hi hats and passionate female vocals singing over. It sounds passionate, groovy and emotional. | 2013-07-04T05:19:16Z | MrRight VEVO | Directed by : Lilcoli Tugista Singer : Still One & Loraine Composed by : Right One Arranged by : Still One & Right One Released : July 2013 | ["Music", "Tender music"] | ["low quality", "hip hop", "mellow arpeggiated piano melody", "filtered male vocal", "sustained strings melody", "chimes bells", "punchy kick", "punchy snare", "shimmering hi hats", "passionate female vocal", "passionate", "emotional", "groovy"] | 4 | jD0nqkyuHPg | 4242 | |
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;