musiccaps_details (view)
2 rows where musiccaps_aspects contains "backing vocals" and musiccaps_aspects contains "organ"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- backing vocals · 2 ✖
- organ · 2 ✖
- acoustic drums 1
- digital drums 1
- e-bass 1
- fast tempo 1
- female voice singing 1
- male voice singing/rapping 1
- pad sounds 1
- piano 1
- pop/gospel 1
- slow tempo 1
- synth lead 1
- techno/pop 1
musiccaps_names (array) 8 ✖
- Music 2
- Christian music 1
- Dance music 1
- Disco 1
- Dubstep 1
- Hip hop music 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Snap Crackle Pop (Tankypookins Remix) | The kick is playing on every beat along with a fast paced high hat and a snare sound. The digital bass is adding some spice and sounds overdriven. Pad sounds can be heard in the background while a synth lead sound is playing a simple repetitive melody. A male voice is rapping/singing. A lot of backing vocals with delay are adding energy to the mix. This song may be playing in a car. | 2011-12-02T03:59:40Z | Logan Smith | Ice Ice Ice Ice Cream Soda Pop, Let Me See Them Chains Drop! Trip to Norway, Dance team, and I decided to do a little Dubstep remix of the song they were using. The song is, though silly, about the Lord Jesus breaking chains off of our lives. Lemme hear an Amen if you've experienced THAT! You can download this track at http://tank2.bandcamp.com/track/snap-crackle-pop-tankypookins-remix. Thanks all! | ["Disco", "Music", "Techno", "Trance music", "Dubstep", "Dance music", "Hip hop music"] | ["techno/pop", "digital drums", "synth lead", "organ", "pad sounds", "male voice singing/rapping", "backing vocals", "fast tempo"] | 6 | -qcTD2o6I9s | 89 | |
Psalm 91 - New Creation Church - with Lyrics | This song contains a female voice singing along to a piano playing chords and the melody along. An acoustic drum is playing together with an e-bass. In the background you can hear an organ and a background choir. This song may be playing in a church. | 2013-08-12T01:22:29Z | TheCatLadyJ | PSALM 91 - New Creation Church. Song from the album "Unmerited Undeserved". | ["Christian music", "Music"] | ["pop/gospel", "piano", "acoustic drums", "e-bass", "organ", "female voice singing", "backing vocals", "slow tempo"] | 6 | kgvx9drZXpk | 4344 |
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;