musiccaps_details (view)
2 rows where musiccaps_aspects contains "simple" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- simple · 2 ✖
- alternative 1
- amplified keyboard 1
- bass 1
- calm 1
- children’s song 1
- dreamy 1
- eastern tune 1
- easygoing 1
- electronic drums 1
- female vocalist 1
- generic 1
- gentle 1
- indie rock 1
- love song 1
- lullaby 1
- male vocal 1
- mellifluous 1
- melodic 1
- melodic piano accompaniment 1
- melodic singing 1
- no percussions 1
- passionate 1
- pleasant 1
- romantic 1
- sentimental 1
- slow tempo 1
- soothing 1
- sound of static 1
- synchronous singing 1
- vocal choral harmony 1
- vocal treat 1
musiccaps_names (array) 4 ✖
- Music 2
- Song · 2 ✖
- Jingle (music) 1
- Lullaby 1
youtube_published (date) 2 ✖
- 2008-11-30 1
- 2013-06-30 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 | |
Indie Music Lounge - Amy | This is an indie/alternative music piece. There is a male vocalist singing melodically. In the background, an eastern sounding tune is playing with a bass and electronic drum beat alongside it. The atmosphere is generic and easygoing. This piece could fit well as an advertisement jingle. | 2013-06-30T15:52:07Z | janicehunter75 | Indie Music Lounge "indie music" "indie music videos" "indie rock" "indie band" "recording studio" "music gear" "pro tools" "pro audio" bogner marshall neve api "universal audio" drums bass teletronix fender mesaboogie ssl shure neuman akg | ["Jingle (music)", "Music", "Song"] | ["indie rock", "alternative", "male vocal", "melodic singing", "eastern tune", "bass", "electronic drums", "simple", "generic", "easygoing"] | 9 | WoWF7gGzGVY | 3137 |
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;