musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2010-05-19
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- dance groove 2
- slick drumming 2
- accordion song 1
- acoustic guitar 1
- ambient 1
- blues 1
- complex chords 1
- complex harmony 1
- cymbal crashes 1
- cymbal rides 1
- dance club mix 1
- dance hits 1
- electric guitar 1
- fast tempo 1
- female singer 1
- female voice 1
- foreign language 1
- funk/soul 1
- funky music 1
- groovy bass lines 1
- groovy drum rhythm 1
- guitar accompaniment 1
- guitar rhythm 1
- improvisation 1
- infectious drum grooves 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- lively 1
- lively spirited 1
- love songs 1
- minimal instruments 1
- moderate tempo 1
- no percussion 1
- peppy 1
- percussion hit 1
- perky 1
- piano accompaniment 1
- pop song 1
- reggae style influences 1
- retro pop hits 1
- rhythmic 1
- rhythmic counter play 1
- rock 1
- romantic 1
- romantic theme 1
- soothing 1
- soul 1
- strong percussive bass line 1
- syncopated bass lines 1
- trumpets 1
- vivacious 1
musiccaps_names (array) 6 ✖
- Music · 3 ✖
- Music of Bollywood 1
- New-age music 1
- Reggae 1
- Soul music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HONK - Hesitation | This music is instrumental. The tempo is fast with trumpet harmony, keyboard accompaniment, infectious drumming, syncopated, funky bass lines, lively piano and electric and acoustic guitar riffs. The music is upbeat, groovy, complex harmony, ambient, soulful and funky. This song is Funk Soul; | 2010-05-19T16:30:27Z | 123c123c123c | Honk - Honk LP :: 1974 | ["Swing music", "Music", "Soul music"] | ["instrumental", "fast tempo", "rock", "blues", "trumpets", "lively spirited", "complex harmony", "complex chords", "cymbal rides", "dance groove", "peppy", "perky", "vivacious", "keyboard harmony", "piano accompaniment", "groovy bass lines", "acoustic guitar", "electric guitar", "slick drumming", "trumpets", "lively", "ambient", "soothing", "improvisation", "soul", "funk/soul", "rhythmic", "dance groove", "syncopated bass lines", "rhythmic counter play", "infectious drum grooves"] | 7 | 2sIfE3KOi5s | 410 | |
High Tone ft Pupajim - Rub a Dub Anthem | A female singer sings this cool melody. The song is medium tempo with a percussive bass line, slick drumming rhythm, guitar accompaniment , keyboard accompaniment and various percussion hits. The song has a strong dance groove and retro pop in style. | 2010-05-19T17:31:01Z | Smashing Sound | Out back (jarring effect 17-05-2010) | ["Music", "Reggae"] | ["female singer", "strong percussive bass line", "reggae style influences", "groovy drum rhythm", "guitar rhythm", "slick drumming", "keyboard accompaniment", "funky music", "guitar accompaniment", "dance groove", "retro pop hits", "cymbal crashes", "romantic", "love songs", "dance hits", "dance club mix", "percussion hit"] | 1 | TabaOeYq2ek | 2848 | |
New-Age Korean traditional music group IS - MBC drama, HyangDanJeon | This pop song features a female voice singing the main melody in a foreign language. This is accompanied by an accordion playing a harmonized melody in the background. There is no percussion in this song. Minimal instruments are used in this song. The theme of this song feels romantic. | 2010-05-19T12:42:41Z | InfinityofSound | MBC drama, HyangDanJeon | ["New-age music", "Music", "Music of Bollywood"] | ["pop song", "romantic theme", "female voice", "foreign language", "accordion song", "moderate tempo", "no percussion", "minimal instruments"] | 0 | aJHv6TV7JpY | 3528 |
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;