musiccaps_details (view)
3 rows where musiccaps_aspects contains "wedding music" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- medium tempo 3
- wedding music · 3 ✖
- enthusiastic 2
- groovy bass line 2
- live performance 2
- passionate 2
- poor audio quality 2
- acoustic guitar strumming 1
- ambient street noise 1
- arabic folk singer 1
- bachata 1
- bad quality audio 1
- cello 1
- cheerful 1
- composer 1
- crowd noise 1
- dance music 1
- deteriorating audio quality 1
- emotional 1
- excited vocals 1
- exciting 1
- folk singer 1
- groovy dance hits 1
- guitar lead 1
- instrumental music 1
- keyboard tones 1
- latin dance band 1
- latin dance hits 1
- latin dance music 1
- latin love hits 1
- latin percussions 1
- latin pop hits 1
- live audience 1
- live band 1
- male latin singer 1
- male singer 1
- party music 1
- people dancing 1
- retro latin hits 1
- romantic 1
- screaming 1
- steady drumming rhythm 1
- string harmony 1
- string quartet 1
- string trio 1
- studio performance 1
- viola 1
- violin 1
- violin playing solo 1
- vocal echoes 1
- western classical music 1
musiccaps_names (array) 9 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Jazz 1
- Orchestra 1
- Salsa music 1
- Speech 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
salam- pentru cristofor la udi | A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. | 2008-09-28T14:54:29Z | elicsir0515 | talent:X | ["Jazz", "Music", "Orchestra", "Speech"] | ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] | 1 | bZJoTauRldE | 3634 | |
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
BACHATA MIX AVENTURA | A male Latin singer sings this passionate melody. The song is medium tempo with various Latin percussions, groovy bass line, keyboard harmony and a guitar playing lead. The song is romantic and a classic Latin dance groove. The song is a Latin dance hit with a deteriorating audio quality. | 2009-01-05T07:54:32Z | R G COCINA | BACHATA | ["Music", "Salsa music"] | ["male latin singer", "bad quality audio", "latin dance band", "deteriorating audio quality", "groovy dance hits", "retro latin hits", "medium tempo", "bachata", "vocal echoes", "latin percussions", "guitar lead", "keyboard tones", "enthusiastic", "emotional", "passionate", "romantic", "retro latin hits", "latin pop hits", "people dancing", "passionate", "romantic", "groovy bass line", "latin love hits", "wedding music", "people dancing", "latin dance hits", "latin dance music"] | 1 | qsRPTMXFGsA | 4830 |
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;