musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "melancholic" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
เพลงจาก Silence of Love โฆษณาไทยประกันชีวิต | This is an advertisement jingle music piece. It is an instrumental piece. The main theme is being played by the piano while there is a synth string sound in the melodic background. There is an emotional, heart-touching atmosphere. This piece could be used in the soundtrack of a drama movie during scenes of tragedy. It could also work well as an advertisement jingle where there is an attempted appeal to emotion. | 2011-07-29T14:09:42Z | Verynoobest | - เพลงประกอบโฆษณาไทยประกันชีวิต Silence of Love - เพลงนี้ชื่อว่า Ee Jook Il Nom Eh Sarang (เป็น Instrumental Version) ของ Lee Soo Young เป็นเพลงประกอบซีรีย์เกาหลี A Love to kill / แค้นเพื่อรัก หรือที่เป็นเวอร์ชั่นไทยก็คือเพลง ผิดที่เธอ ของ ปนัดดา เรืองวุฒิ ครับ ู^ ^ | ["Music", "Sad music"] | ["advertisement jingle", "no singer", "instrumental", "piano", "synth strings", "emotional", "melancholic", "heart-touching"] | 9 | 5ieMy-PAKA0 | 687 | |
Nane Tsora | This music is a western classical. The tempo is slow with violins, trumpets, flute, cello. Viola, bassoon harmony. The music is soft, mellow, mellifluous, rich, elegant and exquisite. This is a live performance/concert. | 2007-05-23T12:20:55Z | ErnestNBE | Gipsy tradtional played by the NBE (www.nbe.nl) in the 2005 New Year's Concert in the Concertgebouw Amsterdam. Soloist on bass trombone is Brandt Attema. | ["Brass instrument", "Clarinet", "Trombone"] | ["instrumental", "slow tempo", "orchestra", "rich", "elegant", "exquisite", "compelling", "concert", "piano", "flute", "live performance", "live orchestra", "symphony", "rich", "melancholic", "trumpets", "violin", "cello", "clarinet", "bassoon", "french horn", "baroque", "intense", "western classic", "clasical music"] | 7 | 8y36aT4C_c0 | 961 | |
Helios - Bless This Morning Year | This is an ambient/electronica music piece. It is an instrumental piece. There is a granular synth playing a vague sounding melody while a warp effect enters and a piano starts playing gently. There is a nostalgic and melancholic feel to it. This piece could be playing in the soundtrack of a drama movie during a scene where the feeling of regret is emphasized. | 2011-12-30T17:19:20Z | 搖滾後 | Urban Exploration Skåne Early 2010 Music: Helios - Bless this morning year - http://myspace.com/heliosmusic | ["Singing bowl"] | ["ambient", "electronica", "no singer", "instrumental", "granular synth", "mellow sounding", "warp effect", "piano", "uneasy", "melancholic", "nostalgic"] | 9 | DQrdOgRb-oA | 1475 | |
Sad Music - Emanetin Bende Sakli - Toygar Isikli | This is an instrumental music piece that was made for a soap opera soundtrack. The piano and the strings are playing gently in a melancholic manner. The atmosphere of the piece is emotional. This piece could be used in the soundtrack of a drama movie during scenes of hopelessness or heartbreak. | 2012-12-02T00:07:15Z | Moustafa Hodroj | ["Cello", "Double bass", "Bowed string instrument"] | ["soap opera music", "no singer", "instrumental", "piano", "strings", "melancholic", "emotional", "downcast"] | 9 | P4aTFrJws40 | 2501 |
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;