musiccaps_details (view)
2 rows where musiccaps_aspects contains "classical music", musiccaps_aspects contains "dulcet" and musiccaps_aspects contains "serene"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- classical music · 2 ✖
- dulcet · 2 ✖
- meditative 2
- serene · 2 ✖
- acoustic guitar accompaniment 1
- aerophone 1
- ancient lineage instrument 1
- buzzing sound 1
- calm 1
- calming 1
- catholic prayer 1
- catholic salutation 1
- celestial 1
- contemplative 1
- deliberate 1
- dreamy 1
- elegy 1
- enchanting 1
- enthralling 1
- euphonious 1
- falsetto 1
- female harpist 1
- female singer 1
- flute melody 1
- harp 1
- high notes 1
- hills 1
- indian classical 1
- instrumental 1
- latin music 1
- latin song 1
- mellifluous 1
- mellow 1
- melodic 1
- mountains 1
- mystical 1
- oldest instrument 1
- peaceful 1
- pensive 1
- plucking 1
- resonator 1
- slow tempo 1
- soft 1
- soothing 1
- soprano 1
- sow tempo 1
- western classical 1
- woodwind 1
musiccaps_names (array) 3 ✖
- Music 2
- Opera 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ave Maria by Schubert, Soprano and harpist Marsha Long | A female vocalist sings this melodious harmony. The tempo is slow with a dulcet Harp accompaniment . The song is soft, mellow, meditative, angelic, celestial,mystical, dreamy and mellifluous. This song is a Catholic prayer or salutation. | 2006-08-09T21:52:26Z | cherubofmusic | Ave Maria by Schubert performed by soprano and harpist Marsha Long | ["Music", "Opera"] | ["female singer", "slow tempo", "dreamy", "meditative", "calming", "dulcet", "high notes", "soprano", "falsetto", "buzzing sound", "harp", "female harpist", "plucking", "melodic", "celestial", "enchanting", "mystical", "enthralling", "ancient lineage instrument", "classical music", "western classical", "resonator", "oldest instrument", "latin song", "latin music", "elegy", "catholic prayer", "catholic salutation", "serene", "calming"] | 7 | ByOqw8M2U-Q | 1310 | |
Spiritual music - Sounds of Isha - 'The Seed' | This music is instrumental. The tempo is slow with a flute playing a melodic lead harmony and later joined by a rhythmic acoustic guitar. The song is dulcet, warm, peaceful; calming, meditative,pensive, contemplative, deliberate, mellifluous and euphonious. This music is an Indian Classical. | 2008-07-26T15:02:52Z | PRyde16 | 'The Seed' Album: Sounds of Isha www.ishafoundation.org Support Sounds of Isha by purchasing their music from soundsofisha.org I do not own this music. | ["Music", "Tender music"] | ["instrumental", "sow tempo", "soft", "meditative", "mellow", "mellifluous", "dulcet", "peaceful", "contemplative", "pensive", "mellifluous", "deliberate", "hills", "mountains", "indian classical", "euphonious", "flute melody", "acoustic guitar accompaniment", "soothing", "woodwind", "aerophone", "classical music", "calm", "serene"] | 7 | nPlDt1R8Qfc | 4536 |
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;