musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "live audience" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional · 2 ✖
- live audience · 2 ✖
- live performance 2
- male singer · 2 ✖
- passionate 2
- accordion player 1
- amateur music 1
- ambient crowd noises 1
- backup singers 1
- clapping rhythm 1
- dance song 1
- euro pop 1
- european folk song 1
- family reunion 1
- folk singer 1
- groovy bass line 1
- groovy rhythm 1
- group singing 1
- hip hop hits 1
- hip hop music 1
- hip hops love song 1
- love song 1
- march rhythm drumming 1
- medium tempo 1
- memories 1
- piano accompaniment 1
- poor audio quality 1
- rom 1
- romantic 1
- sentimental 1
- slick drumming rhythm 1
- social gathering 1
- spirited 1
- steady drumming line 1
- super hits 1
- together forever 1
musiccaps_names (array) 3 ✖
- Accordion 1
- Music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stevie Hoang - Addicted - new music video 2009 | A male singer sings this cool hip hop love song with backup singers in vocal harmony. The tempo is medium with keyboard accompaniment, piano accompaniment, steady drumming rhythm, clapping percussion and other sonic effects. The song is emotional and romantic with a cool dance groove, | 2009-05-18T16:36:44Z | steviehoang | Buy the Physicial CD http://www.cdbaby.com/cd/steviehoang3 Official Facebook https://www.facebook.com/StevieHoangMusic Twitter https://twitter.com/steviehoang | ["Music", "Soul music"] | ["male singer", "hip hop music", "backup singers", "live performance", "live audience", "super hits", "piano accompaniment", "groovy bass line", "steady drumming line", "slick drumming rhythm", "emotional", "romantic", "passionate", "together forever", "love song", "hip hop hits", "groovy rhythm", "dance song", "hip hops love song", "clapping rhythm"] | 1 | -oP-XX28B0s | 87 | |
Heligonka archiv Setkání v Lošticích 2007 | A male singer sings this emotional melody. The song is medium tempo with a steady drumming rhythm, accordion accompaniment and people singing together in unison. The song is emotional and sentimental. The song audio quality is poor. | 2011-05-09T16:37:53Z | Vrana1935 | ["Accordion"] | ["male singer", "accordion player", "family reunion", "social gathering", "euro pop", "group singing", "european folk song", "folk singer", "medium tempo", "march rhythm drumming", "live audience", "live performance", "ambient crowd noises", "poor audio quality", "amateur music", "emotional", "sentimental", "rom", "passionate", "spirited", "memories"] | 1 | r4JRDHYukZ4 | 4848 |
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;