musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "wedding music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- live performance 2
- medium tempo 2
- poor audio quality · 2 ✖
- wedding music · 2 ✖
- acoustic guitar strumming 1
- ambient street noise 1
- arabic folk singer 1
- cello 1
- cheerful 1
- composer 1
- crowd noise 1
- dance music 1
- enthusiastic 1
- excited vocals 1
- exciting 1
- folk singer 1
- groovy bass line 1
- instrumental music 1
- live audience 1
- live band 1
- male singer 1
- party music 1
- passionate 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
- western classical music 1
musiccaps_names (array) 8 ✖
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Jazz 1
- Music 1
- Orchestra 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 |
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;