musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "low quality" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- addictive · 3 ✖
- low quality · 3 ✖
- arpeggiated piano melody 1
- bad mix 1
- boomy bass 1
- boomy kick 1
- claps 1
- energetic 1
- flat double male vocals 1
- groovy bass 1
- harmonizing female vocals 1
- hip hop 1
- mellow 1
- mellow piano chords 1
- messy 1
- muddy 1
- passionate 1
- passionate female vocal 1
- punchy kick 1
- rock 1
- shimmering hi hats 1
- short flute licks 1
- soft 1
- soft crash cymbal 1
- traditional 1
- wide electric guitar melody 1
- wooden percussions 1
musiccaps_names (array) 12 ✖
- Song · 3 ✖
- Music 2
- Folk music 1
- Independent music 1
- Middle Eastern music 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rhythm and blues 1
- Rock music 1
- Singing 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kakalimutan Na Kita by Snap, Jhay-Han, Lyreen (420 Music 2015) Ft. Team Independent | The low quality recording features a hip hop song sung with an addictive flow by flat double male vocals over arpeggiated piano melody, boomy, layered bass and kick hits, soft crash cymbal and claps. It sounds muddy and messy as the mix of the song is bad making the frequencies clash with each other - especially in the low end. | 2015-04-28T12:06:35Z | BIÑAN SQUAD SKEPTRON | 1st verse - Snap -https://www.facebook.com/profile.php?id=100008168167035&fref=ufi 2nd and 4th verse - Jhayhan -https://www.facebook.com/jhayhan.abordo14 3rd And Chorus - Lyreen - https://www.facebook.com/lyreen.potss 420 Music 2015 | ["Music", "Independent music", "Rhythm and blues", "Song"] | ["low quality", "hip hop", "arpeggiated piano melody", "boomy kick", "claps", "soft crash cymbal", "flat double male vocals", "boomy bass", "muddy", "messy", "bad mix", "addictive"] | 4 | SG24NL2Xi3A | 2752 | |
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 | |
Ghadoli Bhar Aayee Aan | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music | The low quality recording features a traditional song sung by harmonizing female vocals and followed by wooden percussion, short flute licks and mellow piano chords. It sounds addictive and passionate. | 2012-03-18T14:50:28Z | Catrack Entertainment | This Song/Boliyan represents the Rich Punjabi Culture and Music and is Part of Rituals in every Traditional Punjabi Wedding Ceremony whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. . All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com | ["Singing", "Folk music", "Music", "Wedding music", "Middle Eastern music", "Song"] | ["low quality", "traditional", "harmonizing female vocals", "wooden percussions", "short flute licks", "addictive", "mellow piano chords", "passionate"] | 4 | ucSF9NIxK8A | 5128 |
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;