musiccaps_details (view)
6 rows where musiccaps_aspects contains "passionate female vocal", musiccaps_aspects contains "sustained strings melody" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- passionate female vocal · 6 ✖
- sustained strings melody · 6 ✖
- low quality 4
- emotional 3
- passionate 3
- punchy kick 3
- punchy snare 3
- energetic 2
- hip hop 2
- live performance 2
- addictive 1
- audio cutout 1
- cheering 1
- chimes bells 1
- crowd clapping 1
- crowd talking 1
- echoing effect 1
- energetic cymbals 1
- epic 1
- euphoric 1
- female choir melody 1
- filtered male vocal 1
- flat male vocal 1
- groovy 1
- groovy piano melody 1
- happy 1
- harp melody 1
- mellow arpeggiated piano melody 1
- mellow piano melody 1
- mixed harmonized vocals 1
- mono 1
- noisy 1
- nostalgic 1
- piano chords progression 1
- playback 1
- pop 1
- powerful 1
- repetitive synth hits 1
- rock 1
- shimmering hi hats 1
- shimmering shakers 1
- simple bass 1
- smooth bass 1
- smooth bass guitar 1
- snappy rimshots 1
- snaps 1
- soul 1
- soulful 1
- traditional 1
- video game trailers 1
- vintage 1
- wide electric guitar chords 1
- wide shimmering shakers 1
- wobble bass 1
- wooden percussive elements 1
musiccaps_names (array) 10 ✖
- Music 6
- Music of Asia 2
- Singing 2
- Song 2
- /t/dd00032 1
- Angry music 1
- Carnatic music 1
- Middle Eastern music 1
- Music of Bollywood 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
3 ohin jingle bell | The recording features a live performance of a pop song that consists of passionate female vocal singing over groovy piano melody, sustained strings melody, smooth bass, widely spread shimmering shaker, snaps and snappy rimshots. It sounds euphoric, as it brings a Christmassy vibe, and is also happy and nostalgic. | 2012-12-19T10:33:32Z | Ganaa Jigee | ["Music of Asia", "Music", "Song"] | ["live performance", "pop", "passionate female vocal", "sustained strings melody", "groovy piano melody", "smooth bass", "wide shimmering shakers", "snaps", "snappy rimshots", "euphoric", "happy", "nostalgic"] | 4 | 20Vh6z6Ie0E | 325 | ||
VERY POPULAR OLD PAKISTANI PUNJABI SONG SINGER MADAM NOOR JAHAN YouTube | The low quality recording features a traditional song that consists of passionate female vocal singing over sustained string melody, wobble bass, wooden percussive elements and shimmering shakers. It is a bit noisy, in mono and it sounds vintage, passionate, emotional and soulful. | 2013-06-19T20:26:26Z | KHALIQ Husson | ["Singing", "Carnatic music", "Music", "Middle Eastern music", "Song", "Music of Bollywood"] | ["wobble bass", "wooden percussive elements", "shimmering shakers", "passionate female vocal", "sustained strings melody", "traditional", "vintage", "noisy", "low quality", "passionate", "emotional", "soulful", "mono"] | 4 | 7_Sr2zv1sQc | 862 | ||
GTA 5 FUNNY MUSIC VIDEOS! (GTA V FUNNY MOMENTS) | The Hip Hop song features a passionate female vocal singing and flat male vocal rapping over piano chords, punchy kick and snare hits, repetitive synth hits and sustained strings melody. At the end of the first section there is an echoing effect on vocals. It sounds energetic and addictive, even though the audio cuts out in the middle of the chorus, straight to the verse. | 2016-04-21T18:30:00Z | GTA5Videos | A BRAND NEW EPISODE OF GTA 5 FUNNY MUSIC VIDEOS! Want more GTA V Funny Moments, Fails, Music Videos, Mods and more? Then make sure to hit that Subscribe button! ★ HELP US TO 1 MILLION SUBSCRIBERS! http://bit.ly/350ksubs ツ Creator here: https://www.youtube.com/channel/UCeQPpxV8dXffd7XRhXq48Uw Song list: Smooth Criminal - Michael Jackson My Way - Fetty Wap Me,Myself,and I - G-Eazy x Bebe Rexha In Too Deep - Sum 41 Chumbawamba - Tubthumping Timber - Kesha ft.Pitbull Uma Therman - Fall Out Boy Just Dance - Lady Gaga Rocky Theme "Gonna Fly Now" Daddy - PSY Nasty Freestyle - T-Wayne Gives You Hell - American Rejects I Don't Fuck with You - Big Sean ft. E-40 Grind On Me - Pretty Ricky Watch Out - 2 Chainz Girl on Fire - Alicia Keys Fire Water Burn - Bloodhound Gang No Flex Zone - Rae Sremmurd Another One Bites the Dust - Queen Swag on - Souja Boy Teenage Dirtbag - Wheetus Be a Billionaire - Travie McCoy ft.Bruno Mars In the End - Linkin Park Candy Shop - 50 Cent Hot in Here - Nelly My Band - D-12 Cut It - O.T. Genesis ft.Young Dolph Work - Rihanna ft.Drake Gangsta's Paradise - Coolio ft. L.V R. Kelly - I Believe I Can Fly Macklemore & Ryan Lewis - Downtown Outro Song: Golden Skies by Liam Aidan ------------------------------------------------------------------------------ How to submit a video to GTA5Videos: 1: Upload a video to youtube. 2: Go on our channel and send it to us via 'Send message'. 3: In the youtube message let us know that we're are allowed to upload it & put the link to the video in that message. ------------------------------------------------------------------------------ Playlists: GTA 5 Funny Moments: http://goo.gl/XokJvv GTA 5 Funny Music Videos: http://goo.gl/qeWtAz GTA 5 Mods: http://goo.gl/1mZ3r5 Twitter: http://goo.gl/mJDKLa Facebook: http://goo.gl/JuH3Sn ------------------------------------------------------------------------------ Please respect each other in the comment section! ツ Wondering what kind of promotions we offer? Ask here: http://bit.ly/Getshoutouts | ["Music", "/t/dd00032"] | ["hip hop", "piano chords progression", "repetitive synth hits", "passionate female vocal", "flat male vocal", "punchy snare", "punchy kick", "cheering", "audio cutout", "echoing effect", "sustained strings melody", "energetic", "addictive"] | 4 | FaD9qs2ACpI | 1653 | |
St Julian's School flashmob | The low quality recording features a crowd talking and clapping to a soul song that is played on a playback. The song consists of a passionate female vocal, alongside mixed harmonizing vocals, singing over sustained strings melody, simple bass and harp melody. It sounds emotional and passionate. | 2015-07-16T19:47:33Z | SouthWalesArgus | St Julian's School flashmob for Mrs Gabica | ["Singing", "Music of Asia", "Music"] | ["low quality", "crowd talking", "crowd clapping", "simple bass", "harp melody", "passionate female vocal", "mixed harmonized vocals", "sustained strings melody", "soul", "passionate", "emotional", "live performance", "playback"] | 4 | PuJxL6tLxm4 | 2575 | |
Nightcore - Angels [HD] | The low quality recording features a rock song that consists of mellow piano melody, energetic cymbals, punchy kick, punchy snare, female choir, wide electric guitar chords, sustained strings melody, smooth bass guitar and passionate female vocal singing over it. It sounds epic, powerful and energetic, like something you would hear in video games trailers. | 2012-02-02T12:13:47Z | Le Forkkie | Song: Angels Artist: Within Temptation Picture: http://images2.layoutsparks.com/1/30388/fallen-angel-anime-wolf-31000.jpg Lyrics: Sparkling angel I believe You are my savior In my time of need Blinded by faith I couldn't hear All the whispers The warning's so clear I see the angels I'll lead them to your door There is no escape now No mercy no more No remorse 'cause I still remember The smile when you tore me apart [Chorus:] You took my heart Deceived me right from the start You showed me dreams I wished they'd turn to real You broke the promise And made me realize It was all just a lie Sparkling angel Couldn't see Your dark intentions Your feelings for me Fallen angel Tell me why? What is the reason? The thorn in your eye I see the angels I'll lead them to your door There is no escape now No mercy no more No remorse 'cause I still remember The smile when you tore me apart [Chorus] Could have been forever Now we have reached the end This world may have failed you It doesn't give the reason why You could have chosen A different path of life The smile when you tore me apart [Chorus:] You took my heart Deceived me right from the start You showed me dreams I wished they'd turn in to real You broke a promise And made me realize It was all just a lie Could have been forever Now we have reached the end -- Disclaimer: I own nothing, all original content belongs to their respected artist. This is purely fan-made. Please don't eat me. | ["Music", "Angry music"] | ["low quality", "passionate female vocal", "mellow piano melody", "energetic cymbals", "punchy kick", "punchy snare", "rock", "female choir melody", "wide electric guitar chords", "sustained strings melody", "smooth bass guitar", "energetic", "epic", "powerful", "video game trailers"] | 4 | UsHtZ7Bzi0s | 2949 | |
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 |
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;