musiccaps_details (view)
2 rows where musiccaps_aspects contains "dreamy" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- dreamy · 2 ✖
- lullaby 2
- amplified keyboard 1
- bass guitar 1
- calm 1
- children’s song 1
- female vocalist 1
- gentle 1
- kids music 1
- love song 1
- mellifluous 1
- mellow male vocals 1
- melodic 1
- melodic piano accompaniment 1
- mid tempo 1
- no percussions 1
- nostalgic 1
- passionate 1
- pleasant 1
- romantic 1
- sentimental 1
- simple 1
- slow tempo 1
- soothing 1
- sound of static 1
- synchronous singing 1
- vocal choral harmony 1
- vocal treat 1
- xylophone 1
musiccaps_names (array) 4 ✖
- Lullaby 2
- Music 2
- Song · 2 ✖
- Jingle (music) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Friends Lullaby | The track is a lullaby song that features a mellow male vocal with a mellow voice. A soft xylophone plays a melody on the foreground while a deep bass guitar adds a certain bounciness to the song's rhythm. The atmosphere is calmed and dreamy. | 2011-07-26T00:26:58Z | Iliana Mercedes | baby lullaby | ["Jingle (music)", "Music", "Song", "Lullaby"] | ["lullaby", "xylophone", "mellow male vocals", "bass guitar", "dreamy", "kids music", "mid tempo", "nostalgic"] | 5 | 1SqihV_DnEg | 277 | |
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 |
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;