musiccaps_details (view)
3 rows where musiccaps_aspects contains "meditative", musiccaps_author = 7 and musiccaps_names contains "New-age music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- meditative · 3 ✖
- celestial 2
- enigmatic 2
- mellow 2
- soft 2
- ambient 1
- ambient nature sounds 1
- amplified xylophone 1
- angelic 1
- breeze 1
- burgeoning note 1
- calming 1
- cello 1
- celtic folk music 1
- celtic new age 1
- cheerful chimes 1
- chimes 1
- delicate 1
- downtempo 1
- dreamy 1
- dulcet 1
- electronic 1
- emotional 1
- enchanting 1
- ethereal 1
- female singer 1
- female vocalist 1
- gentle wind 1
- harp 1
- haunting 1
- high notes 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- lullaby 1
- medium tempo 1
- melancholic 1
- mellifluous 1
- modern classical 1
- mysterious 1
- mystical 1
- new age 1
- no lyrics 1
- nostalgic 1
- opera 1
- organ accompaniment 1
- pacifying 1
- piano harmony 1
- pleasant 1
- seagulls 1
- sentimental 1
- soft piano harmony 1
- soothing 1
- sound of water 1
- sound of waves 1
- sublime 1
- vocalisation 1
musiccaps_names (array) 4 ✖
- Music 3
- New-age music · 3 ✖
- Lullaby 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
VITAS MV - 搖籃曲 / Lullaby (歌迷制作) by Dieforsing | A female vocalist sings this dulcet melody. The tempo is medium with soft piano accompaniment, keyboard harmony, chimes, harp, and xylophone sounds , ambient sounds of nature like the sound of sea gulls, waves, water gently hitting the rocks, breeze along with the mellifluous vocalisation. The song is soothing, calming, meditative, peaceful, mellifluous, celestial, mystical, dreamy and dreamy. This song is a Lullaby. | 2010-06-07T14:12:52Z | Vitas HongKong | 歌曲:Колыбельная 來源:百度Vitas吧 songs by Dieforsing 扣子_China http://blog.sina.com.cn/yaojee http://www.vitas.com.cn http://www.vitas.com.ru | ["New-age music", "Music", "Lullaby"] | ["female vocalist", "medium tempo", "vocalisation", "no lyrics", "breeze", "gentle wind", "dulcet", "meditative", "pleasant", "chimes", "mellifluous", "celestial", "enchanting", "enigmatic", "mystical", "angelic", "sound of waves", "seagulls", "sound of water", "ambient nature sounds", "harp", "amplified xylophone", "soft piano harmony", "high notes", "dreamy", "lullaby", "soothing", "pacifying", "keyboard harmony"] | 7 | Rqv5fu1PCXA | 2727 | |
Enya - Evening Falls | A female vocalist sings this delicate harmony. The tempo is slow with an organ accompaniment. It is soft, mellow, meditative, enigmatic, mysterious, melancholic and haunting. This song is a Modern Classical. | 2006-11-01T15:54:46Z | Servet Tonga | Evening Falls video clip | ["New-age music", "Music"] | ["female singer", "opera", "organ accompaniment", "enigmatic", "mysterious", "soft", "mellow", "ethereal", "celestial", "new age", "meditative", "modern classical", "downtempo", "electronic", "melancholic", "celtic new age", "celtic folk music", "delicate", "haunting", "sublime", "soft", "mellow", "delicate"] | 7 | _nrz_BawPMY | 3492 | |
sea going motorboat bateauxdumidi@gmail.com | This music is an instrumental with a melancholic piano melody, mesmerising sound of chimes, simple keyboard harmony and a burgeoning cello note. The music is calming, meditative, nostalgic, emotional, sentimental, mellow, soothing and ambient. | 2010-02-22T15:55:55Z | bateauxdumidi | Formidable navire Mer - Riviere pour faire le boucle danube et retour par la mediterranee Spacieux bateau grace a sa largeur de 4 metre un fond en 6 mm cote 5/4 mm Large plabord et bastingage en inox Base sur les linge des bateaux de peche du mer de nord Description; a l'avant grand lit double a la francaise beaucoup de rangement . Salle de bain avec douche lave main et wc marine. Grande cuisine avec frigo neuf "compresseur 24 volt " dinette avec table et rangement , tres gande salon timonnerie , chauffage central avec radiateur. salle de bain avec douche et wc marine electrique enorme cocpit- plage de au moins 4 x 4 m avec en acces au cave/debarasse equipement tres complet avec radar auto pilot sondeur gps | ["New-age music", "Music", "Soul music"] | ["instrumental", "piano harmony", "cheerful chimes", "burgeoning note", "keyboard accompaniment", "soft", "calming", "meditative", "cello", "ambient", "sentimental", "nostalgic", "emotional", "mellow"] | 7 | ndjLkbP6Y9Y | 4566 |
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;