musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "calm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drums · 2 ✖
- acoustic guitar · 2 ✖
- calm · 2 ✖
- easygoing 2
- ambient synth 1
- bass guitar 1
- country music 1
- friendly 1
- instrumental 1
- male vocal 1
- mellow singing 1
- mellow tune 1
- modern r&b 1
- no singer 1
- pop soul 1
- psychedelic 1
- relaxing 1
- steel guitar 1
- trippy 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to play steel guitar lesson 19 | This is a country music piece that is played in an instrument lesson recording. The steel guitar is playing a mellow tune while at the forefront while there is a backing composed of the acoustic guitar and the acoustic drums. There is a relaxing and psychedelic feel to the piece. This music could suit well in the soundtrack of a feelgood/comedy movie. It could also be playing in the background at a shopping mall. | 2008-07-24T15:02:22Z | bobbeseymour | Bobbe Seymour shows more stuff at Steel Guitar Nashville | ["Music", "Musical instrument", "Steel guitar, slide guitar", "Bluegrass"] | ["country music", "no singer", "instrumental", "steel guitar", "mellow tune", "acoustic guitar", "acoustic drums", "easygoing", "calm", "relaxing", "psychedelic", "trippy"] | 9 | SvsCM0fLM5g | 2795 | |
michael jackson heal the world lyrics | This is a pop soul/modern r&b piece that is sung by a mellow male vocal in medium pitch. The main tune is played by the acoustic guitar with the bass guitar and the ambient synth supporting the melody in the background. There is a calm and simple acoustic drum beat in the rhythmic background. The song is played on a major scale giving it a positive, optimistic atmosphere. This piece could be used in a romantic setting. It could also be playing in the background of a coffee house or a bookstore. | 2013-02-15T15:05:21Z | harsh gupta | ["Music", "Happy music"] | ["pop soul", "modern r&b", "male vocal", "mellow singing", "acoustic guitar", "ambient synth", "bass guitar", "acoustic drums", "friendly", "easygoing", "calm"] | 9 | kka6zUtE3h8 | 4353 |
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;