musiccaps_details (view)
2 rows where musiccaps_aspects contains "folk singer" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- folk singer · 2 ✖
- live audience 2
- live performance 2
- male singer 2
- medium tempo · 2 ✖
- poor audio quality 2
- accordion player 1
- amateur music 1
- ambient crowd noises 1
- ambient street noise 1
- arabic folk singer 1
- crowd noise 1
- emotional 1
- euro pop 1
- european folk song 1
- excited vocals 1
- family reunion 1
- groovy bass line 1
- group singing 1
- live band 1
- march rhythm drumming 1
- memories 1
- passionate 1
- rom 1
- screaming 1
- sentimental 1
- social gathering 1
- spirited 1
- steady drumming rhythm 1
- violin playing solo 1
- wedding music 1
youtube_published (date) 2 ✖
- 2008-09-28 1
- 2011-05-09 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 | |
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;