musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow arpeggiated piano melody", musiccaps_aspects contains "sustained strings melody" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- mellow arpeggiated piano melody · 2 ✖
- sustained strings melody · 2 ✖
- chimes bells 1
- emotional 1
- filtered male vocal 1
- groovy 1
- heartfelt 1
- hip hop 1
- low quality 1
- passionate 1
- passionate female vocal 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- romantic 1
- shimmering crash cymbal 1
- shimmering hi hats 1
- sizzling bells 1
- soul 1
musiccaps_names (array) 3 ✖
- Music 2
- Tender music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wedding Song (With You) -by: Martin Nievera | The Soul song features a passionate male vocal singing over a shimmering crash cymbal, sustained strings melody and mellow arpeggiated piano melody. At the very beginning there are some sizzling bells. It sounds romantic and heartfelt - like something you would want to sing to your partner. | 2009-06-24T15:23:40Z | 022803 | One of the best wedding songs from the album "Best Wishes", sung by Martin Nievera. It was especially dedicated to Julius Babao and Christine Bersola's Wedding.. | ["Music", "Wedding music"] | ["soul", "passionate male vocal", "shimmering crash cymbal", "sustained strings melody", "mellow arpeggiated piano melody", "romantic", "heartfelt", "sizzling bells"] | 4 | 6evOjRxZlHI | 775 | |
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;