musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "people talking" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- medium tempo · 4 ✖
- people talking · 4 ✖
- poor audio quality · 4 ✖
- ambient room noises 2
- emotional 2
- energetic 2
- groovy bass line 2
- instrumental music 2
- amateur jazz musician 1
- amateur musician 1
- amateur recording 1
- amateur tap dancing 1
- amateur tapping tones 1
- ambient crowd noises 1
- ambient room nosiness 1
- bass rhythm 1
- cheerful 1
- couples dan 1
- dance lessons 1
- dance music 1
- dance rhythm 1
- excited 1
- family gatherings 1
- festive spirit 1
- folk dance music 1
- folk music 1
- groovy music 1
- guitar accompaniment 1
- guitarist 1
- harpist 1
- instrumental duo 1
- jam session 1
- jazz music 1
- jazz musician 1
- keyboard accompaniment 1
- live performance 1
- male singer 1
- male singers love performance 1
- memdiumm tempo 1
- no other instrumentation 1
- out of sync tapping rhythm 1
- passionate 1
- piano accompaniment 1
- positive 1
- rap dancers 1
- romantic 1
- sentimental 1
- south american folk music 1
- steady percussions 1
- story telling 1
- techno drumming rhythm 1
- togetherness 1
- traditional custom dance 1
- unimpressive 1
- violinist 1
- vocoder 1
musiccaps_names (array) 9 ✖
- Music 3
- Singing 2
- Bowed string instrument 1
- Harmonic 1
- Harp 1
- Pizzicato 1
- Rattle (instrument) 1
- Tap 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 |
---|---|---|---|---|---|---|---|---|---|---|
PARARCA - OCT - 2013 - ARPA Y VIOLIN (A) | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | 2013-11-01T18:51:07Z | Johnny Torres | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | 1 | 8DQbnR7hwpc | 904 | ||
Devendra Banhart - Chin Chin & Muck Muck | A male singer raises this passionate melody. The song is medium tempo with an acoustic guitar accompaniment, groovy bass line and a subtle drumming rhythm. The song is passionate and relaxing. The song is played live and has poor audio quality. | 2009-04-21T19:14:32Z | eachnotesecure | Devendra Banhart performs Chin Chin & Muck Muck live at The Independent in San Francisco in April 2009 | ["Singing", "Music", "Rattle (instrument)"] | ["male singer", "live performance", "groovy bass line", "medium tempo", "story telling", "ambient room nosiness", "people talking", "guitar accompaniment", "bass rhythm", "steady percussions", "folk music", "emotional", "energetic", "people talking", "poor audio quality", "folk music", "folk music", "guitarist"] | 1 | jFek2xLbEww | 4243 | |
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 | |
More Bounce To The ounce Rendition | A male singer sings this vocals with a vocoder. The song is medium tempo with a groovy techno drumming rhythm and keyboard accompaniment. The song is passionate but an amateurish production. The audio quality is very poor. | 2007-11-24T00:35:38Z | TalkBoxerDX | Me playing the talkbox first run! This is shout out to all my talk boxers out there! and to TRCP my dads band! also wanna give a special shout out to curbswirvin if it wasn't for him i wouldn't be doing it! | ["Singing", "Music", "Harmonic"] | ["vocoder", "male singers love performance", "poor audio quality", "jam session", "amateur jazz musician", "medium tempo", "amateur musician", "jazz musician", "keyboard accompaniment", "groovy music", "techno drumming rhythm", "poor audio quality", "people talking", "unimpressive", "excited", "energetic", "passionate", "ambient room noises"] | 1 | xL7Krm6FSWE | 5320 |
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;