musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient room noises" and musiccaps_aspects contains "piano accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- ambient room noises · 2 ✖
- jazz music 2
- piano accompaniment · 2 ✖
- amateur recording 1
- amateur tap dancing 1
- amateur tapping tones 1
- bass solo 1
- christian music 1
- church music 1
- dance lessons 1
- dance rhythm 1
- devotional 1
- drum brushes percussions 1
- emotional 1
- fretboard sounds 1
- groovy solo 1
- inspiring 1
- instrumental music 1
- jazz band 1
- live performance 1
- medium tempo 1
- memdiumm tempo 1
- motivational 1
- music interlude 1
- no other instrumentation 1
- out of sync tapping rhythm 1
- people talking 1
- poignant 1
- poor audio quality 1
- rap dancers 1
- romantic 1
- slow tempo 1
- smooth jazz 1
- together forever 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BELLA's LULLABY / RIVER FLOWS IN YOU - Music Video -- NEW VERSION | The song is an instrumental. The song is slow tempo with gentle drum brushes, percussion, bass guitar solo, and piano accompaniment gently. The song is groovy and emotional. The song is possibly a Christian worship song or a smooth jazz song. The audio quality is average. | 2009-11-25T20:46:54Z | peoplewholovenewmoon | A heartbreakingly beautiful performance of this hit song by the Korean composer Yiruma - which is not the official Bella's Lullaby, but proved much more popular with Twilight fans. The version features not just piano but achingly melancholy solos by superb musicians on bass, guitar, sax, and vocals. | ["Bass guitar", "Music", "Musical instrument", "Wedding music"] | ["slow tempo", "drum brushes percussions", "inspiring", "devotional", "romantic", "together forever", "ambient room noises", "poignant", "jazz music", "bass solo", "piano accompaniment", "jazz band", "smooth jazz", "live performance", "church music", "slow tempo", "groovy solo", "emotional", "romantic", "poignant", "inspiring", "motivational", "fretboard sounds", "christian music", "music interlude"] | 1 | 0EOQco76eXQ | 135 | |
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;