musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano" and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- piano · 3 ✖
- acoustic bass 1
- acoustic guitar solo 1
- amateur recording 1
- audience sounds 1
- concert hall 1
- danceable 1
- drums 1
- gospel 1
- heartfelt 1
- instrumental 1
- jazz chord progression 1
- jazzy 1
- latin jazz 1
- live 1
- loud upright bass 1
- no drums 1
- recital hall 1
- reverb 1
- slower to medium tempo 1
- sneeze 1
- syncopated drums 1
- trio 1
- trumpet solo 1
- upbeat rhythm 1
musiccaps_names (array) 8 ✖
- Inside, large room or hall · 3 ✖
- Music 3
- Harmonic 2
- Brass instrument 1
- Jazz 1
- Keyboard (musical) 1
- Musical instrument 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Let go Let God | This audio contains someone playing a gospel/jazz melody when a very loud drum comes in with a fill-in on the toms. This is an amateur recording and of poor audio-quality. This song may be playing in a gospel church. | 2009-02-21T06:32:49Z | tonyhoustonl | the whole dance of let go let god hope you enjoy. | ["Music", "Keyboard (musical)", "Harmonic", "Inside, large room or hall"] | ["amateur recording", "gospel", "piano", "drums", "jazzy", "slower to medium tempo"] | 6 | ESbtW0CUmp4 | 1559 | |
Matt Andersen - So Gone Now - Halifax, NS | Trio recorded live in a concert hall with a loud upright bass, piano and acoustic guitar playing a solo. Jazz feel and chord progression with no drums. Heartfelt performance. | 2009-04-22T01:20:12Z | techy72 | I took this and with Matt's permission am posting it up here for all of you too SEE!!!! It's a great song and a fantastic preformance!!! | ["Music", "Harmonic", "Inside, large room or hall"] | ["loud upright bass", "acoustic guitar solo", "jazz chord progression", "piano", "no drums", "instrumental", "trio", "concert hall", "live", "heartfelt"] | 8 | d1nz5tZckSA | 3757 | |
Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;