musiccaps_details (view)
2 rows where musiccaps_aspects contains "gentle", musiccaps_aspects contains "romantic" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- gentle · 2 ✖
- romantic · 2 ✖
- slow tempo 2
- acoustic guitar melody 1
- ambient music 1
- amplified keyboard 1
- atmospheric 1
- beautiful 1
- calm 1
- captivating 1
- children’s song 1
- classical 1
- dreamy 1
- emotional 1
- euphonious 1
- female vocalist 1
- guitar lead 1
- guitar solo 1
- instrumental 1
- live performance 1
- love song 1
- lullaby 1
- mellifluous 1
- mellow 1
- melodic 1
- melodic piano accompaniment 1
- mesmerising 1
- no percussions 1
- passionate 1
- pleasant 1
- sentimental 1
- simple 1
- soothing 1
- sound of static 1
- string instrument 1
- synchronous singing 1
- vocal choral harmony 1
- vocal treat 1
- western classical 1
musiccaps_names (array) 7 ✖
- Music 2
- Guitar 1
- Lullaby 1
- Musical instrument 1
- Plucked string instrument 1
- Song 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bella's Lullaby (with lyrics) | A female vocalist sings this pleasant melody. The tempo is slow with a melodic piano accompaniment. There is minimal instrumentation with emphasis on vocals. The song is soft, mellow, soothing, calming, mellifluous, pleasant, and dreamy. This song is a love song, children’s song or a lullaby. | 2008-11-30T03:54:32Z | Camille Chen | Song: Bella's Lullaby Artist: the BELLA CULLEN PROJECT | ["Music", "Song", "Lullaby"] | ["female vocalist", "slow tempo", "vocal choral harmony", "love song", "children’s song", "calm", "soothing", "gentle", "sound of static", "dreamy", "lullaby", "melodic piano accompaniment", "amplified keyboard", "no percussions", "vocal treat", "synchronous singing", "pleasant", "mellifluous", "romantic", "passionate", "sentimental", "melodic", "simple"] | 7 | 1rhsnmWLeGw | 314 | |
Fur Elise on classical guitar performed by Eddie Blatt | This music is instrumental. The tempo is slow with a melodic acoustic guitar solo. The music is soft, euphonious, dreamy, romantic , warm ,ambient and soothing. This is a Classical acoustic instrumental. | 2007-01-23T06:40:15Z | Eddie Blatt | Eddie Blatt plays Fur Elise on classical guitar live at the Byron Bay Community Centre. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["instrumental", "slow tempo", "acoustic guitar melody", "western classical", "classical", "beautiful", "mellow", "euphonious", "captivating", "mesmerising", "guitar solo", "guitar lead", "string instrument", "live performance", "gentle", "emotional", "atmospheric", "ambient music", "romantic"] | 7 | p2sXdmex3xQ | 4683 |
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;