musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "dance music" and musiccaps_author = 1 sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_description
musiccaps_aspects (array) 104 ✖
- dance music · 6 ✖
- medium tempo 4
- passionate 4
- instrumental music 3
- live performance 3
- cheerful 2
- enthusiastic 2
- exciting 2
- melancholic 2
- people dancing 2
- poor audio quality 2
- story telling 2
- accordion player 1
- acoustic guitar strumming 1
- acoustic song 1
- ambient crowd noise 1
- ambient room noise 1
- animated male vocals 1
- animated yodelling 1
- bad audio quality 1
- bad quality audio 1
- brass band 1
- cello 1
- children dancing 1
- children’s song 1
- clickers 1
- clicking percussions 1
- comical 1
- composer 1
- couples slow dancing 1
- cymbals crashing 1
- dance club 1
- dance mix 1
- dance rhythm 1
- deteriorated music 1
- discotheque 1
- drum rolls 1
- emotional 1
- energetic 1
- ethnic instruments 1
- euro pop 1
- excited 1
- fats tempo 1
- female latin singer 1
- flute countermelody 1
- flute playing 1
- folk music 1
- footstep sounds 1
- funny 1
- groovy bas slime 1
- groovy bass line 1
- groovy music 1
- guitar accompaniment 1
- guitar playing 1
- guitar playing lead 1
- guitar playing rhythm 1
- guitars strumming rhythm 1
- gypsy music 1
- hardship 1
- home studio 1
- inspiring 1
- instrumental harmony 1
- jam session 1
- keyboard harmony 1
- life is good 1
- live jam 1
- male rapper 1
- maracas playing percussively 1
- medium fast tempo 1
- nostalgic moments 1
- party music 1
- people enjoying the music 1
- percussive bass line 1
- poignant 1
- poor audio recording 1
- purposeful 1
- relaxing 1
- retro hits 1
- retro rock and roll 1
- rock and roll music 1
- rock band 1
- romantic 1
- russian hit songs 1
- russian rap music 1
- spirited 1
- steady drumming rhythm 1
- steady marching drum rhythm 1
- steady rock drumming 1
- string harmony 1
- string quartet 1
- string trio 1
- studio performance 1
- swing music 1
- tap dance rhythm 1
- traditional dancing 1
- trumpets play percussively 1
- underground music 1
- viola 1
- violin 1
- wedding music 1
- western classical music 1
- women dancing 1
- yodelling song 1
- youthful 1
musiccaps_names (array) 16 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Etiqueta Rock and Roll Yo estare aqui.wmv | The song is an instrumental. The tempo is medium with a guitar playing a romantic lead, steady drumming, rock drumming, percussive bass line, cymbals crashing and guitar strumming rhythm. The song is exciting and youthful. The song has a bad audio quality. | 2011-06-08T22:05:27Z | TheMugriento25 | ["Music", "Psychedelic rock", "Rock music", "Roll", "Rock and roll"] | ["rock and roll music", "medium tempo", "steady rock drumming", "guitar playing lead", "cymbals crashing", "drum rolls", "swing music", "percussive bass line", "rock band", "romantic", "exciting", "retro rock and roll", "dance music", "people dancing", "couples slow dancing", "passionate", "spirited", "retro hits", "instrumental music", "bad audio quality"] | 1 | YDBxdZchOuM | 3265 | ||
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
鈴木能律子フラメンコスタジオ*BELEN ご案内 | A female singer sings this traditional melody. The song is medium tempo with a clicking percussion rhythm, guitar strumming accompaniment and tap dancing tones. The song is energetic and passionate. The song has very poor audio quality. | 2012-05-27T11:47:36Z | STUDIO NORI | ["Music", "Tambourine", "Vocal music"] | ["dance music", "maracas playing percussively", "acoustic song", "live performance", "tap dance rhythm", "women dancing", "traditional dancing", "clicking percussions", "clickers", "poor audio quality", "guitar playing rhythm", "energetic", "passionate", "ambient room noise", "dance rhythm", "fats tempo", "female latin singer", "footstep sounds"] | 1 | jtRse-cDB18 | 4286 | ||
The Yodeling Veterinarian of the Alps (Silly Songs with Larry) | A male singer sings in an animated manner. The song is medium fast tempo with a steady drumming rhythm, brass band accompaniment, groovy bass line and guitar strumming rhythm. The song is exciting and cheerful. The song is an animated children’s show tune, but a poor recording of the actual show. | 2010-07-09T06:04:42Z | wez adora | Awesome and Funny :D HHAAHAHAHA | ["Yodeling", "Music"] | ["animated male vocals", "yodelling song", "comical", "poor audio recording", "bad quality audio", "deteriorated music", "children’s song", "excited", "trumpets play percussively", "brass band", "steady marching drum rhythm", "groovy bas slime", "guitars strumming rhythm", "story telling", "dance music", "animated yodelling", "funny", "excited", "children dancing", "cheerful", "medium fast tempo"] | 1 | mOn13E68Td0 | 4467 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
"Eu Quero é Sossego", de K-Ximbinho, com Nonato Lima e Grupo Murmurando.mp4 | The song is an instrumental. The tempo is medium with an accordion player, guitar rhythm, flute player and other percussion playing in harmony. The song is groovy and has gypsy flavour to it. The song audio quality is poor with ambient crowd noises. | 2013-01-24T15:01:39Z | claudeide | Programa Brasileirinho, 20 de Janeiro de 2013 - Acordeonista Nonato Lima toca a música "Eu Quero é sossego", de K-Ximbinho, acompanhado pelo Quinteto Murmurando. | ["Wind instrument, woodwind instrument", "Accordion"] | ["accordion player", "life is good", "relaxing", "jam session", "home studio", "melancholic", "nostalgic moments", "people enjoying the music", "instrumental harmony", "folk music", "flute playing", "guitar playing", "live jam", "instrumental music", "medium tempo", "ambient crowd noise", "enthusiastic", "dance music", "gypsy music", "folk music", "ethnic instruments", "dance music", "live performance"] | 1 | tbovKStEnME | 5051 |
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;