musiccaps_details (view)
3 rows where musiccaps_aspects contains "fast beat" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- fast beat · 3 ✖
- virtuosic 2
- acoustic guitar solo 1
- beat boxing 1
- complex chords 1
- complex rhythms 1
- digeridoo 1
- electric bass 1
- electric guitar 1
- fast strumming acoustic guitar 1
- fiddle 1
- flamenco influence 1
- guiro 1
- hand claps 1
- hand percussion 1
- latin 1
- lively 1
- low tuned bass drum 1
- male vocalist 1
- manic 1
- modern electric bass 1
- oompah 1
- passionate female singer 1
- piano 1
- quick tempo 1
- simple chord progression 1
- tambourine 1
- wah 1
- yodeling 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ondrej Smeykal Playing a Chad Butler Didgeridoo | solo performance of a virtuosic didgeridoo player playing a fast beat with complex rhythms. Sounds like beat boxing. | 2008-09-17T01:43:06Z | · Michael Medina | Ondrej Smeykal Playing a Chad Butler Didgeridoo. This was didgeridoo number 360 and was available at https://bhumsiva.com/galery?gallery=360 | ["Didgeridoo", "Music"] | ["digeridoo", "virtuosic", "complex rhythms", "fast beat", "beat boxing"] | 8 | RGTWqZoswAo | 2686 | |
Toque Celular- Crazy Yodeling | A virtuosic Male yodeler accompanied by an oompah band playing a fast beat and simple chord progression with electric bass, piano, fiddle, and drums. The feeling is manic. | 2009-10-18T18:13:22Z | Pedro Júnior | Tune Cellphone Song Music- Yodeling ioleleihu ioleleiu io-lele-i-hu | ["Music of Africa", "Yodeling", "Jingle (music)", "Music", "Music of Latin America"] | ["yodeling", "oompah", "simple chord progression", "fast beat", "electric bass", "male vocalist", "virtuosic", "piano", "fiddle", "manic"] | 8 | TqWmuwAYmnI | 2869 | |
( Rumba ) Parrita & Canelita " Remix " Dj Barajero | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | 2011-05-27T11:41:49Z | DJ Barajero | Parrita Canelita Remix Dj Barajero Flamenco Rumba Salsa Reggueton Verano Nuevo 2011 2012 2013 | ["Flamenco", "Music", "Music of Latin America"] | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | 8 | YzpzKyzyL0Y | 3331 |
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;