musiccaps_details (view)
2 rows where musiccaps_aspects contains "male vocal", musiccaps_aspects contains "sentimental" and musiccaps_aspects contains "simple tune"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- bass guitar 2
- male vocal · 2 ✖
- melodic singing 2
- sentimental · 2 ✖
- simple tune · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- amp 1
- electric guitar 1
- electronic drums 1
- emotional 1
- female vocal 1
- hmong pop 1
- keyboard 1
- medium tempo 1
- normal tempo 1
- piano 1
- pop music 1
- reverb 1
- romantic 1
- vibrant 1
musiccaps_names (array) 8 ✖
- Music 2
- Independent music 1
- Music of Asia 1
- Pop music 1
- Radio 1
- Reverberation 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
REVERBERATION AMP.wmv | This is a pop music piece being played through a reverberation amp. There is a male and a female vocalist singing melodically. A clean sounding electric guitar is playing a simple tune while a keyboard is holding the chords and a bass guitar is playing in the background. The rhythmic background is provided by a medium tempo electronic drum beat that has characteristics resembling an acoustic drum kit. The atmosphere is sentimental and vibrant. This piece could be used in advertisement jingles. It could be playing in the background in a romantic setting. | 2010-05-30T21:33:11Z | Jared Twedell | SANSUI REVERBERATION AMP. | ["Singing", "Reverberation", "Music of Asia", "Music", "Pop music", "Radio"] | ["pop music", "male vocal", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "amp", "reverb", "simple tune", "sentimental", "vibrant", "medium tempo"] | 9 | Mf6Ql55o7Es | 2286 | |
wa love songs (ai yawn rai ) | This is a hmong pop music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the piano, the acoustic guitar and the bass guitar. The rhythm is being played on the acoustic drums. There is a sentimental, romantic feel to it. The piece could be used in a romantic movie/TV show with a Hmong-language speaking setting. | 2012-12-06T21:05:00Z | ainapyawn hopang saniex hopang | wa love songs (ai yawn rai) | ["Music", "Independent music", "Song"] | ["hmong pop", "male vocal", "melodic singing", "piano", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "emotional", "romantic", "normal tempo", "simple tune"] | 9 | jhgX0OOoytQ | 4274 |
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;