musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "sustained strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- passionate 3
- passionate male vocal · 3 ✖
- shimmering hi hats · 3 ✖
- sustained strings melody · 3 ✖
- low quality 2
- soulful 2
- addictive 1
- brass melody 1
- claps 1
- disco 1
- emotional 1
- energetic crash cymbal 1
- funky 1
- groovy bass piano melody 1
- harmonizing background female vocals 1
- harmonizing background vocals 1
- mono 1
- muted brass melody 1
- noisy 1
- piano chords 1
- piano melody 1
- playback 1
- punchy kick 1
- punchy snare 1
- toms roll 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RAY LEMA & JAZZ SINFÔNICA ORCHESTRA DE SAO PAULO (BRAZIL) - "TWA TAKA NINI" | The low quality recording features a passionate male vocal singing over groovy bass piano melody, muted brass melody, sustained strings melody and shimmering hi hats. It sounds passionate and soulful. | 2010-03-08T09:45:45Z | RAY LEMA | Ray Lema playing his song "Twa Taka Nini" with the Jazz Sinfônica Orquestra from São Paulo, directed by João Mauricio GALINDO - São Paulo- may 2009 | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "passionate male vocal", "groovy bass piano melody", "muted brass melody", "sustained strings melody", "shimmering hi hats", "passionate", "soulful"] | 4 | YXDHyD4HU0E | 3292 | |
Disney On Ice 2009 Finale | The low quality recording features a live performance where the song is played on playback and it consists of sustained strings and piano melody, energetic crash cymbals, shimmering hi hats and toms roll, over which passionate male vocal and harmonizing background female vocals are singing. It sounds emotional, passionate and soulful. | 2009-06-03T19:22:38Z | Freya JW | Disney On Ice was preforming at the Target Center in Minneapolis on March 8th and I was able to go and Oh Em Gee, it was sooo purely magicaly like you don't even know. This video doesn't do it justice!! I was actually crying during this part. | ["Yodeling", "Music", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "playback", "sustained strings melody", "toms roll", "shimmering hi hats", "energetic crash cymbal", "passionate male vocal", "harmonizing background female vocals", "piano chords", "emotional", "passionate", "soulful"] | 4 | bwHPVG6vbNQ | 3665 | |
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;