musiccaps_details (view)
3 rows where search matches "guitar" and musiccaps_aspects contains "bad quality audio" sorted by youtube_description descending
This data as json, CSV (advanced)
musiccaps_aspects (array) 60 ✖
- bad quality audio · 3 ✖
- emotional 2
- medium tempo 2
- passionate 2
- romantic 2
- animated male vocals 1
- animated yodelling 1
- bachata 1
- bollywood music 1
- brass band 1
- buzzing 1
- cheerful 1
- children dancing 1
- children’s song 1
- comical 1
- dance music 1
- deteriorated audio quality 1
- deteriorated music 1
- deteriorating audio quality 1
- enthusiastic 1
- excited 1
- funny 1
- groovy bas slime 1
- groovy bass line 1
- groovy dance hits 1
- guitar accompaniment 1
- guitar lead 1
- guitars strumming rhythm 1
- humming 1
- keyboard tones 1
- latin dance band 1
- latin dance hits 1
- latin dance music 1
- latin love hits 1
- latin percussions 1
- latin pop hits 1
- longing for you 1
- love song 1
- madly in love 1
- male latin singer 1
- male singer 1
- medium fast tempo 1
- movie soundtrack 1
- no percussion instruments 1
- people dancing 1
- poor audio quality 1
- poor audio recording 1
- retro latin hits 1
- soaring vocals 1
- spirited 1
- steady marching drum rhythm 1
- story telling 1
- strong bass line 1
- tamil love songs 1
- tamil movie songs 1
- trumpets play percussively 1
- violin accompaniment 1
- vocal echoes 1
- wedding music 1
- yodelling song 1
musiccaps_names (array) 4 ✖
- Music 3
- Humming 1
- Salsa music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▲ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nenjam Pesuthey Male Humming song | A male singer sings this soaring melody. The song is medium tempo with a guitar accompaniment, strong bass line and a violin accompaniment. The song quality is poor and badly deteriorated. The song is a romantic love song from a Tamil movie. | 2014-03-17T01:41:42Z | VENGADASSALAM K | Photo Add | ["Humming", "Music"] | ["male singer", "soaring vocals", "bad quality audio", "tamil love songs", "poor audio quality", "medium tempo", "emotional", "passionate", "madly in love", "longing for you", "tamil movie songs", "movie soundtrack", "guitar accompaniment", "violin accompaniment", "no percussion instruments", "romantic", "deteriorated audio quality", "humming", "buzzing", "romantic", "love song", "spirited", "passionate", "bollywood music", "strong bass line"] | 1 | k3A5xX8yfig | 4295 | |
BACHATA MIX AVENTURA | A male Latin singer sings this passionate melody. The song is medium tempo with various Latin percussions, groovy bass line, keyboard harmony and a guitar playing lead. The song is romantic and a classic Latin dance groove. The song is a Latin dance hit with a deteriorating audio quality. | 2009-01-05T07:54:32Z | R G COCINA | BACHATA | ["Music", "Salsa music"] | ["male latin singer", "bad quality audio", "latin dance band", "deteriorating audio quality", "groovy dance hits", "retro latin hits", "medium tempo", "bachata", "vocal echoes", "latin percussions", "guitar lead", "keyboard tones", "enthusiastic", "emotional", "passionate", "romantic", "retro latin hits", "latin pop hits", "people dancing", "passionate", "romantic", "groovy bass line", "latin love hits", "wedding music", "people dancing", "latin dance hits", "latin dance music"] | 1 | qsRPTMXFGsA | 4830 | |
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 |
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;