musiccaps_details (view)
2 rows where search matches "ballad", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "ballad" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic guitar · 2 ✖
- ballad · 2 ✖
- acoustic drums 1
- big band 1
- clarinet 1
- ending 1
- flute 1
- gentle singing 1
- jazz genre 1
- male vocal 1
- medium quality audio recording 1
- piano 1
- romantic 1
- sentimental 1
- slow tempo 1
- strings 1
- thai 1
- valentines 1
musiccaps_names (array) 5 ✖
- Music 2
- Happy music 1
- Music of Asia 1
- Song 1
- Theremin 1
youtube_published (date) 2 ✖
- 2008-08-01 1
- 2016-02-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Goodbye - Benny Goodman 1980 | The jazz music features a clarinet playing a melody that's ending a song. A big band that incorporates a jazz acoustic guitar accompanies the clarinet. The tempo is slow and the style is ballad. The medium quality audio recording leads me to believe this is an older recording. | 2008-08-01T22:23:11Z | SwingCla | "Benny Goodman in Japan 1980" Playlist = http://bit.ly/2wGtUzi / "Aurex Jazz Festival", Sep.3,1980 at Budokan(Tokyo,Japan) / cl:Benny Goodman, p:Teddy Wilson, tp:Tony Terran, tb:Dick Nash, g:Eddie Duran, b:Al Obidinski, dr:John Markham | ["Music", "Theremin"] | ["clarinet", "strings", "acoustic guitar", "big band", "jazz genre", "slow tempo", "ballad", "ending", "medium quality audio recording"] | 2 | 8GKbDSu9Xd0 | 908 | |
รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music | This is a Valentine's ballad. The male vocalist is singing gently in the Thai language. There is an acoustic guitar, a piano and a flute playing the melody interchangeably. There is a simple acoustic drum beat in the rhythmic background. The atmosphere of this piece is romantic. It could be used in romantic social media content in Thailand. It could also be used in romantic movies and TV shows that take place in Thailand. | 2016-02-05T05:56:27Z | ป.ฉลาดใหญ่ | รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music ฝากกดติดตามช่อง ป.ฉลาดใหญ่ บันเทิงศิลป์ ด้วยนะครับ คลิกที่ลิ้งค์เลย https://www.youtube.com/channel/UC98T... แสลงใจ อ้ายมีเขา แต่เจ้ามีอ้าย กลิ่นไฟเก่า บ่ฮักกะส่าง อยู่กับอ้ายน้อยใจบ่ ผัวสำรอง เมียสำรอง ฮัก คารม ซ่อยข่อยแหน่ | ["Music of Asia", "Music", "Song", "Happy music"] | ["ballad", "male vocal", "gentle singing", "acoustic guitar", "piano", "flute", "acoustic drums", "sentimental", "romantic", "valentines", "thai"] | 9 | L0oun9F67tg | 2142 |
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;