musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "entertaining" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- energetic · 3 ✖
- entertaining · 3 ✖
- poor audio quality · 3 ✖
- exciting 2
- fast tempo 2
- groovy bass line 2
- instrumental music 2
- soloist 2
- acoustic guitar lead 1
- auto tuned female vocals 1
- banjo player 1
- cool solo 1
- country blue grass 1
- dance club 1
- dance floor 1
- dancers 1
- electric guitar harmony 1
- euro pop hits 1
- groovy music 1
- grunge tones 1
- guitar rhythm 1
- instrumentalist 1
- keyboard accompaniment 1
- live performance 1
- love performance 1
- love video performance 1
- male singer 1
- medium tempo 1
- medium tempo home music video 1
- passionate 1
- rap singer 1
- relaxing playlist 1
- retro rock covers 1
- rock music influences 1
- russian pop hits 1
- russian singer 1
- sonic effects 1
- spirited 1
- techno dance hits 1
- techno drumming rhythm 1
- trance party 1
- virtuoso 1
- virtuoso playing 1
- walking bass line 1
musiccaps_names (array) 8 ✖
- Music 3
- Banjo 1
- Bluegrass 1
- Electronic music 1
- Musical instrument 1
- Plucked string instrument 1
- Techno 1
- Ukulele 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 | |
James Hill - Voodoo Child (Hendrix Ukulele Cover) | The song is an instrumental. The tempo is medium with an acoustic guitar playing lead, electric guitar accompaniment and a groovy bass line and no percussion instruments. The song is spirited and energetic. The audio quality is quite poor and the song has rock music influences. | 2015-12-26T16:12:38Z | James Hill | Join my mailing list and get a FREE song: https://www.jameshillmusic.com/join Learn ukulele with me: https://www.uketropolis.com My weekly podcast: https://www.uketropolis.com/podcast Video recorded live without looping or overdubs. RECIPE: 1 Mya-Moe baritone ukulele (Low G - G - B - E) 1 guitar amp (Fender Blues Junior or equivalent) 1 bass amp (15 inch) 1 line splitter (Radial ABY box) 1 Diamond J-Drive pedal (made in Halifax, NS!) 4 busted strings 2 broken fingernails Season to taste and serve hot! | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["acoustic guitar lead", "instrumental music", "entertaining", "cool solo", "relaxing playlist", "electric guitar harmony", "poor audio quality", "virtuoso playing", "medium tempo", "groovy bass line", "guitar rhythm", "exciting", "energetic", "rock music influences", "soloist", "medium tempo home music video", "retro rock covers"] | 1 | 0wzsE67O5tE | 224 | |
Russen Techno Remix | A male Russian singer sings this rap vocals with a female backup singer in vocal harmony. The song is fast tempo with techno drumming rhythm, percussive bass line, keyboard accompaniment and sonic effects. The song is a techno dance hit. The audio quality is poor. | 2008-10-23T14:40:58Z | CoolerRussenking | Russische Musik mit Verschiedenen Bildern. | ["Electronic music", "Music", "Techno"] | ["russian singer", "male singer", "rap singer", "poor audio quality", "fast tempo", "techno drumming rhythm", "groovy bass line", "keyboard accompaniment", "grunge tones", "sonic effects", "auto tuned female vocals", "exciting", "energetic", "entertaining", "dancers", "dance floor", "dance club", "trance party", "russian pop hits", "euro pop hits", "techno dance hits"] | 1 | dDKUjMHerLs | 3770 |
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;