musiccaps_details (view)
2 rows where musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "inspirational"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- cheerful · 2 ✖
- inspirational · 2 ✖
- afro beats 1
- akuba 1
- bright drumming 1
- carefree 1
- catchy 1
- classical vocalist 1
- clave 1
- composers 1
- conductor 1
- conga 1
- dance groove 1
- dominant music 1
- emotional 1
- fast tempo 1
- foreign language 1
- happy 1
- high pitched singing 1
- lilting music 1
- live performance 1
- lyrical singing 1
- male singer 1
- nigerian music 1
- opera classics 1
- opera hall 1
- opera legend 1
- opera singer 1
- philharmonic orchestra 1
- pizzicato 1
- pleasant 1
- poignant 1
- positive 1
- propulsive percussion 1
- reflective 1
- reggae 1
- retro classic hits 1
- slow tempo 1
- string section harmony 1
- string section singing 1
- subdued harmony 1
- ugandan song 1
- upstroke rhythm guitar 1
- vintage opera 1
- violins strings plucked 1
- western classic music legends 1
- western classical music 1
- world music 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Afrobeat 1
- Dance music 1
- Music of Africa 1
- Opera 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Frühlingsstimmenwaltzer- Natalie Dessay- A Flat | A female opera singer sings this high pitched lyrical melody. The song tempo is slow with a philharmonic orchestra accompaniment, with a string section harmony and pizzicato violin play. The song is extremely emotional and spirited. The song is a vintage opera hit. | 2007-03-25T06:59:02Z | LaViolettaValery | natalie dessay and her debut at the Vienna State Opera - 1993!! | ["Music", "Opera"] | ["opera singer", "high pitched singing", "vintage opera", "string section harmony", "western classic music legends", "live performance", "philharmonic orchestra", "lyrical singing", "string section singing", "slow tempo", "opera classics", "opera legend", "lilting music", "subdued harmony", "retro classic hits", "classical vocalist", "emotional", "poignant", "cheerful", "positive", "inspirational", "violins strings plucked", "pizzicato", "composers", "conductor", "opera hall", "western classical music"] | 1 | CZWLPPO0KL4 | 1377 | |
Sitya Loss Remix - Eddy Kenzo | A male vocalist sings this energetic Nigerian song. The tempo is fast and upbeat with keyboard harmony and Afro beats of conga, clave, drums and akuba. The music is upbeat, catchy, spirited, energetic, youthful and pulsating with a dance groove. This song is a Reggae song. | 2014-02-20T13:25:19Z | Eddy Kenzo | big talent young managment | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | ["male singer", "fast tempo", "nigerian music", "world music", "propulsive percussion", "upstroke rhythm guitar", "dominant music", "pleasant", "catchy", "youthful", "dance groove", "happy", "cheerful", "carefree", "conga", "clave", "akuba", "bright drumming", "reggae", "ugandan song", "foreign language", "afro beats", "reggae", "inspirational", "reflective"] | 7 | Xaq-segSEsQ | 3200 |
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;