musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Electric piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- male voice · 2 ✖
- instrument review 1
- movie music 1
- music fading out 1
- piano 1
- piano song 1
- reverb 1
- ringing guitar chord 1
- romantic mood 1
- sentimental 1
- showcase 1
- slow pop 1
- slow tempo 1
musiccaps_names (array) 3 ✖
- Electric piano · 2 ✖
- Keyboard (musical) 2
- Piano 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Resolution - Jack's Mannequin (Live, Acoustic) | This slow pop song features the end of a song. A male voice sings one syllable. The piano plays three notes followed by two high pitch notes. A guitar chord is heard ringing in the background. There is no percussion in this song. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2008-11-30T20:47:21Z | cassielovesandrew | ⓒBuzznet 2008, enjoy & comment! :) | ["Electric piano", "Keyboard (musical)", "Piano"] | ["slow pop", "piano song", "reverb", "male voice", "music fading out", "slow tempo", "ringing guitar chord", "romantic mood"] | 0 | QmIhKF1BqCg | 2640 | |
KORG New KRONOS Demo & Review [English Captions] | This is an instrument review recording. There is a piano playing a sentimental tune while a male voice is narrating his experience with the instrument. From the parts where the voice is absent, there are tunes with a movie music feel to them. These lines could be sampled and added to the soundtrack of a movie. | 2014-12-30T03:35:58Z | musictrackjp | KORG New KRONOS DEMO by Katsunori UJIIE. Facebook: Like me please! https://www.facebook.com/musictrack.jp What kind of music gear do you have? " musictrack gear " is now ready to open !! http://gear.musictrack.jp/ | ["Electric piano", "Keyboard (musical)", "Piano"] | ["showcase", "instrument review", "piano", "sentimental", "movie music", "male voice"] | 9 | vG0QJ3bjfqk | 5170 |
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;