musiccaps_details (view)
2 rows where musiccaps_aspects contains "female singer", musiccaps_names = "["Music", "Wedding music"]" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Wedding Song - This is the Day | A female singer sings this emotional melody. The song is medium tempo with a guitar accompaniment and a subtle bass line with no percussion instruments. The song is emotional and romantic. The song is a wedding song. | 2008-06-01T08:00:56Z | Francis H | This song is lovingly dedicated for my everdearest wife "Riza" I love you...for free chord lyrics of this song follow this link: http://www.nfphampden.com/thisday.pdf | ["Music", "Wedding music"] | ["female singer", "wedding songs", "medium tempo", "acoustic love song", "no percussions", "together forever", "never give up", "wedding super hits", "wedding love song", "prayer", "motivational", "inspiring", "strength", "caring", "kindness", "sharing", "relaxing and comforting", "emotional", "guitar accompaniment", "subtle bass line", "romantic emotional", "promises", "wedding vows"] | 1 | e8wnUU5pIWE | 3846 | |
arabic traditional music very soothing RUM | A female vocalist sings this ethereal melody. The tempo is slow with a beautiful flute harmony, melodious piano accompaniment, Arabic guitar and groovy bass lines. The song has no lyrics with ethereal vocalisation. It is soft, mellifluous, calming, pleasant,enigmatic, celestial and ethereal with a middle eastern feel. | 2009-04-07T18:06:11Z | detroitjeeper | song: ya mahla el fussha performed by Tarik ElNasser and RUM BAND RUM Band is a Jordanian band led by Tarik ElNasser who is a composer and a vocalist in some of his work, Rum Band might not be that famous but their work is very well known among Arabs for being the amazing soundtracks for so many big hit soap operas and TV series. | ["Music", "Wedding music"] | ["female singer", "slow tempo", "vocalisation", "middle eastern music", "pleasant", "celestial", "mellifluous dulcet", "enigmatic", "mystical", "middle eastern stringed instrument", "harp", "flute harmony", "melodic piano accompaniment", "steady bass line"] | 7 | mvZLlJpyDyc | 4501 |
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;