musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chemong ding chu - Janglal Khongsai | The Soul song features a passionate male vocal singing over shimmering hi hats and shakers, groovy bass, widely spread wooden percussions, punchy kick and snare hits, wide sustained strings melody and mellow piano melody. It sounds emotional and passionate. | 2015-11-12T17:56:14Z | Bombiel Media | Senorita 3: Thadou-Kuki Visual Album M.Lien Thugs Production | ["Music of Asia", "Christian music", "Music", "Song"] | ["soul", "passionate male vocal", "wide wooden percussions", "punchy kick", "groovy bass", "wide sustained strings melody", "mellow piano melody", "shimmering hi hats", "punchy snare", "emotional", "passionate"] | 4 | BiQik0xsWxk | 1279 | |
Roots Reggae Mix | The low quality recording features a reggae song that consists of passionate male vocals singing over shimmering hi hats, snappy snare, punchy kick, groovy bass, brass melody and funky electric guitar chords. It sounds chill and easygoing. | 2009-01-22T20:42:39Z | lessofslack | A roots reggae mix with horace andy, meditations, congos max romeo, hugh mundell, king tubby! Enjoy Reggae Roots! THE PLAYLIST IS HERE!!!! 1.The Meditations - Rasta Shall Conquer(Greatest Hits 197X)--- 2. Dr Alimantado - Born For a Purpose 3.Dennis Brown - Black Liberation(Words Of Wisdom1979)--- 4.Max Romeo & The Upsetters - My Jamaican Collie(The Coming Of Jah 1967-76)--- 5.Horace Andy - If I(In The Light/In The Light Dub 1977)--- 6.Hugh Mundell - Jah Will Provide(Africa Must Be Free 1983)--- 7.i forgot - update in a few weeks--- 8.The Terrors - Assemble Not Thyself(The Chantells & Friends-Children Of Jah 1977-79)--- 9.Horace Andy - Do You Love My Music(In The Light/In The Light Dub 1977)--- Thanks to all supporters of good old Reggae Tunes! -peace- | ["Funk", "Music", "Reggae", "Song"] | ["low quality", "reggae", "passionate male vocals", "shimmering hi hats", "snappy snare", "groovy bass", "brass melody", "funky electric guitar chords", "punchy kick", "easygoing", "chill"] | 4 | L0-l1LIa22g | 2141 | |
sound twins music | The low quality recording features a cover of a R&B song that contains passionate female vocals, alongside background harmonizing female vocals, singing over punchy kick, claps, groovy bass, smooth keys and short strings chords. It sounds romantic, emotional and groovy. | 2007-06-18T18:59:27Z | MSRTV6 | princess feat. Blunty Dont call me. | ["Music", "Song", "Exciting music"] | ["r&b", "cover", "passionate female vocal", "background harmonizing female vocals", "punchy kick", "claps", "groovy bass", "smooth synth keys", "short strings chords", "romantic", "emotional", "groovy", "low quality"] | 4 | bkYWnzw_5Bs | 3646 | |
Silent Hill Shattered Memories - Hell Frozen Rain | The low quality recording features a rock song that consists of a passionate female vocal singing over punchy kick and snare hits, shimmering hi hats, wide electric guitar melody and groovy bass guitar. It sounds energetic and addictive in the first half of the loop, while in the second part it's mellow and softer. | 2009-12-17T08:21:09Z | Person Whatname | Artist : Akira Yamaoka Vocals: Mary Elizabeth McGlynn at 3:56, it's "THERE's one that confuses me". thanks to ares5566 for the correction. From Silent Hill Shattered Memories Soundtrack. This song plays during the credits, depends on which ending you get. AWESOME FACT : at 3:34, you can hear part of Silent Hill 1 theme :) | ["Punk rock", "Psychedelic rock", "Rock music", "Song", "Progressive rock"] | ["low quality", "rock", "passionate female vocal", "wide electric guitar melody", "groovy bass", "shimmering hi hats", "punchy kick", "punchy kick", "mellow", "energetic", "addictive", "soft"] | 4 | qrzNABqN420 | 4828 | |
not ashamed - boundless worship band | The Rock Orchestra song features energetic crash cymbals, punchy kick and snare hits, groovy bass, wide electric guitar chords and simple strings melody. It sounds epic, powerful and energetic - like a theme song for an opening track of some anime. | 2008-06-20T12:19:31Z | awaefler | not ashamed got very famous in the first weeks. Now we're starting with youtube. | ["Music", "Opera", "Song", "Classical music"] | ["low quality", "rock orchestra", "energetic crash cymbals", "punchy kick", "punchy snare", "groovy bass", "wide electric guitar melody", "simple strings melody", "energetic", "epic", "powerful"] | 4 | qwGT6wvYdLo | 4834 |
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;