musiccaps_details (view)
3 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "groovy music" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- fast tempo · 3 ✖
- groovy music · 3 ✖
- spirited · 3 ✖
- energetic 2
- instrumental music 2
- live performance 2
- passionate 2
- amateur band 1
- ambient noises 1
- average audio quality 1
- bad recording 1
- banjo player 1
- chaotic harmony 1
- college music festival 1
- country blue grass 1
- cymbals crashing 1
- dissonant harmonies 1
- emotional 1
- entertaining 1
- fast guitar strumming 1
- flamenco guitar 1
- folk music 1
- folk singer 1
- groovy tempo 1
- guitar accompaniment 1
- guitar lead 1
- guitar strumming 1
- heavy metal drumming 1
- instrumentalist 1
- latin singer 1
- live band 1
- love performance 1
- love video performance 1
- male singer 1
- metal band 1
- passionate music 1
- passionate singing 1
- percussive bass line 1
- poor audio quality 1
- romantic 1
- soloist 1
- spirited singing 1
- street musician 1
- teen spirit 1
- traditional latin music 1
- very poor audio quality 1
- virtuoso 1
- walking bass line 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 3
- Banjo 1
- Bluegrass 1
- Burst, pop 1
- Flamenco 1
- Rock and roll 1
- Singing 1
- Song 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World Fastest Banjo Player | The song is an instrumental. The song is medium tempo with a groovy rhythm and fast fingers playing this banjo solo. The song is entertaining and exciting. The song is of poor audio quality and a live performance video. | 2009-05-12T15:23:34Z | eriobras | Erio Meili on May 10, 2009, picking the tune "Sunday", at 330 bpm at the Titanic Harbor Stage, 660 notes per minute (10 notes per second) - former record was on June15, 2008 at 320 bpm | ["Banjo", "Music", "Bluegrass"] | ["banjo player", "fast tempo", "groovy music", "love video performance", "instrumental music", "virtuoso", "walking bass line", "entertaining", "love performance", "soloist", "country blue grass", "entertaining", "energetic", "passionate", "spirited", "instrumentalist", "poor audio quality", "live performance"] | 1 | 0HXYdGGKV2k | 141 | |
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
CloseHead - Heart Of Pop (percayalah) @SMAN 11 Jakarta | The song is instrumental.The tempo is fast with a strong metal drumming rhythm, groovy bass line, cymbals crashing, guitar lead and guitar rhythm. The song is chaotic and energetic. The song has very poor audio quality. | 2014-02-19T18:36:24Z | ricky t julianto | Closehead - Heart Of Pop (percayalah) Event NEOVECTOR @SMAN 11 Jakarta Video Rec & Editing : Ricky T Julianto | ["Music", "Burst, pop", "Rock and roll"] | ["live band", "very poor audio quality", "ambient noises", "chaotic harmony", "bad recording", "percussive bass line", "metal band", "college music festival", "heavy metal drumming", "guitar strumming", "guitar lead", "cymbals crashing", "chaotic harmony", "dissonant harmonies", "groovy music", "amateur band", "youthful", "energetic", "spirited", "teen spirit", "instrumental music", "fast tempo"] | 1 | DaeJYtWgcoI | 1497 |
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;