musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance rhythm", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "piano accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- dance rhythm · 2 ✖
- medium tempo · 2 ✖
- piano accompaniment · 2 ✖
- poor audio quality 2
- amateur recording 1
- amateur tap dancing 1
- amateur tapping tones 1
- ambient room noises 1
- dance groove 1
- dance lessons 1
- emotional 1
- entertaining 1
- guiro percussions 1
- guitar rhythm 1
- instrumental music 1
- jazz music 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- male latin singer 1
- memdiumm tempo 1
- no other instrumentation 1
- out of sync tapping rhythm 1
- passionate 1
- people dancing 1
- people talking 1
- rap dancers 1
- romantic 1
- soaring vocals 1
- spirited 1
- story telling 1
- walking bass line 1
musiccaps_names (array) 4 ✖
- Music 2
- Music of Africa 1
- Ska 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
42nd street tap dance! | The song is instrumental. The tempo is medium with a piano playing solo accompaniment with no other instrumentation. Tap dancers tap to the piano accompaniment not perfectly in sync , with a lot of ambient room noises and people talking. The audio quality is very poor in this home video. | 2010-02-25T02:39:37Z | n3v3rb33ndone3 | classic tap dance to broadway's 42nd street.. Done by dancers at mary ann's dance studio | ["Music", "Tap"] | ["instrumental music", "poor audio quality", "rap dancers", "medium tempo", "amateur tapping tones", "piano accompaniment", "no other instrumentation", "jazz music", "amateur tap dancing", "ambient room noises", "people talking", "memdiumm tempo", "out of sync tapping rhythm", "dance rhythm", "dance lessons", "amateur recording", "instrumental music"] | 1 | pG6yeC3yUY4 | 4693 |
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;