musiccaps_details (view)
3 rows where musiccaps_aspects contains "female voice", musiccaps_aspects contains "flute" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- female voice · 3 ✖
- flute · 3 ✖
- sentimental 2
- acoustic drums 1
- bass guitar 1
- birds singing 1
- catchy 1
- crying 1
- easygoing 1
- electric guitar 1
- emotional 1
- heart-touching 1
- hindi film music 1
- medium tempo 1
- piano 1
- pop music 1
- shouting-like singing 1
- sitar 1
- sound effects 1
- strings 1
- tv series 1
- walking 1
musiccaps_names (array) 5 ✖
- Music 3
- Happy music 1
- Sigh 1
- Soul music 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dil Tujhe Dia Tha... (Malhar) | This is a Hindi film music piece. Initially, there is a female voice crying. Afterwards, an orchestra made up of a flute, a string element, a sitar and a piano starts playing an emotional tune. The atmosphere of the piece is heart-touching. It could be used in the soundtracks of Bollywood movies during heartbreaking scenes. | 2008-07-10T00:15:10Z | IMIRZA777 | oldie. | ["Traditional music", "Music"] | ["hindi film music", "female voice", "crying", "flute", "strings", "sitar", "piano", "sentimental", "emotional", "heart-touching"] | 9 | nnc6m1pBJ4c | 4578 | |
LaLa - Lost Ones ♪ | This is a pop music piece. There is a female vocalist singing in a shout-like style. There is a flute and an electric guitar playing the melody with the bass guitar playing in the background. The rhythm is provided by a medium tempo acoustic drum beat. The tune is catchy. The piece is in the major key and there is an easygoing atmosphere to it. This piece could be used in the soundtrack of a sit-com during the credits section. | 2009-01-11T02:11:54Z | Hysteria | LaLa - Lost Ones DJ Vida V Presents American Mija no copyright to this video | ["Music", "Soul music", "Happy music"] | ["pop music", "female voice", "shouting-like singing", "flute", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "catchy", "sentimental", "medium tempo"] | 9 | svNayU6q3Dg | 4987 | |
Phim Hài Mới 2020 | ĐỐ LÀM ÔNG CƯỜI Tập 3 | Hài Dân Gian Hay Nhất 2020 | Hài Tết Đặc Sắc | This is an excerpt from a TV series. There are female voices that can be heard. There is a walking sound. The birds are singing. There is a mellow flute tune being played. Various sounds can be sampled from this recording. | 2016-10-25T11:54:01Z | Style TV | Phim Hài Mới 2020 | ĐỐ LÀM ÔNG CƯỜI Tập 3 | Hài Dân Gian Hay Nhất 2020 | Hài Tết Đặc Sắc : https://www.youtube.com/watch?v=w9EGDo9Yybc “Đố làm ông cười” – câu chuyện dân gian nhẹ nhàng, hài hước; đề cao những con người có đức tính kiên trì, nhẫn nại và chân thành trong tình yêu. Dù có gặp bao nhiêu thất bại đi chăng nữa nhưng nếu có niềm tin, sự chân thành thì cuối cùng cũng sẽ cảm hóa được người khác. Phim do công ty cổ phần truyền hình cáp STV (Styletv, joyfm, infotv) thực hiện. Kênh YOUTUBE CHÍNH THỨC công ty cổ phần truyền hình cáp STV ▶SUBSCRIBE kênh youtube : https://goo.gl/TdnHRF ▶Fb: https://goo.gl/6aDW1f ▶ Web: https://goo.gl/QQsHJx ▶Phát lúc 21h15 trên kênh Styletv. VTVcap 12 thứ 7 hàng tuần. Mời cả nhà đón xem Trân trọng cảm ơn! | ["Music", "Sigh"] | ["tv series", "female voice", "sound effects", "walking", "birds singing", "flute"] | 9 | w9EGDo9Yybc | 5245 |
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;