musiccaps_details (view)
3 rows where musiccaps_aspects contains "gentle" and musiccaps_aspects contains "simple tune" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- gentle · 3 ✖
- simple tune · 3 ✖
- easygoing 2
- male vocal 2
- melodic singing 2
- acoustic 1
- acoustic drums 1
- acoustic guitar 1
- alternative rock 1
- bass guitar 1
- calming 1
- classical music 1
- electric guitar 1
- instrumental 1
- korean indie rock 1
- mellow 1
- no singer 1
- piano 1
- sentimental 1
- slow tempo 1
- summer 1
- ukulele 1
- violin 1
musiccaps_names (array) 10 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Independent music 1
- Pop music 1
- Singing 1
- Song 1
- Ukulele 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 | ||
cook with chef Duminda - Chocolate Cake | This is a classical music piece. There is a piano playing an arpeggio in the background while a violin gently plays the main tune. The atmosphere of the piece is sentimental. This piece could be used in the background of tutorial videos. It could also be playing in the background at a coffee shop. | 2013-04-15T07:10:55Z | Chef Duminda | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["classical music", "no singer", "instrumental", "piano", "violin", "gentle", "sentimental", "simple tune"] | 9 | MWS-Uxf1MRw | 2276 | ||
"White Sandy Beach" - Play along karaoke style | This is an acoustic piece. There is a male vocalist singing melodically. There is a simple tune being played on a ukulele. The atmosphere of the piece is easygoing. This piece could be used in the background of wholesome social media content. | 2007-06-28T01:14:21Z | honoluluadvertiser | Notes: Remember the number you see next to the chords indicate the number of times you need to repeat the strum pattern. The strum pattern is: Down Down Up Up Down Chords: F, Bb, Bbm, and C7 | ["Music", "Ukulele"] | ["acoustic", "male vocal", "melodic singing", "ukulele", "simple tune", "gentle", "summer", "easygoing", "calming"] | 9 | RS43EP1EXz4 | 2702 |
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;