musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums" and musiccaps_aspects contains "background noises"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic drums · 3 ✖
- background noises · 3 ✖
- e-bass 3
- e-guitar 2
- double-bass 1
- epic 1
- female voice singing 1
- funk/rock 1
- hardrock 1
- higher register 1
- male voice 1
- medium to uptempo 1
- pop/rock 1
- singing 1
- slow to medium tempo 1
- synth-strings 1
- uptempo 1
- voices 1
musiccaps_names (array) 7 ✖
- Music 3
- Angry music 1
- Funk 1
- Heavy metal 1
- Rhythm and blues 1
- Skateboard 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Как разжечь огонь без спичек | An acoustic drum is playing a simple groove with a strong kick. The e-bass is playing on every hit of the kick together with an e-guitar strumming a chord. A female voice is singing a slow paced melody. In the background you can hear some maschine sounds and piping sounds. This song may be playing in a James Bond movie-scene. | 2011-06-12T15:43:43Z | Scotch Soda | Как разжечь огонь в безвыходной ситуации, когда вы заперты на кухне, а зомби вокруг и у вас нет спичек. Подробности на http://scotchnsoda.net | ["Funk", "Music", "Rhythm and blues", "Soul music"] | ["funk/rock", "acoustic drums", "e-guitar", "e-bass", "female voice singing", "slow to medium tempo", "background noises"] | 6 | CRxIJ7YbcZA | 1368 | |
Park Sessions Woodward at Tahoe - TransWorld SNOWboarding | The drums are playing the kick along with an e-bass. Then 16th notes come in played on a hihat. A male singer with a higher register voice is singing loudly. The song seems to be building up before breaking into the next part. This song may be playing cruising down a hill with a skateboard. | 2014-02-14T19:29:51Z | Snowboarder Magazine | Our Donner party turned out way better! Take a look at the Woodward Tahoe setup and one word is immediately burned into your head: flow. You can see it in the way jibs are laid out—it's not just a bunch of rails in a row, they're spread around so you can pinball back and forth, here and there down the run. Land one, react and pick your line that way. Flow. People throw "it's like a concrete skatepark" around a lot but it's definitely the case here. It's not just Lane Knaack or Eric Rosenwald or any one person either, but this communal team effort that everyone involved is down for, and this ethos actually goes for all of the Woodward Terrain Parks across the country... This is an excerpt from an article that originally appeared in the January issue of TransWorld SNOWboarding. If you're down and want to read the whole thing, subscribe to the mag: Print https://www.circsource.com/store/Subscribe.html?magazineId=338&sourceCode=I9ABNN Digital https://www.circsource.com/store/Subscribe.html?magazineId=347&sourceCode=I9ABNN iPad https://itunes.apple.com/us/app/transworld-snowboarding/id395403589?mt=8 For more videos check out www.twsnow.com | ["Music", "Skateboard"] | ["pop/rock", "e-bass", "acoustic drums", "background noises", "male voice", "higher register", "singing", "medium to uptempo"] | 6 | UtZofZjccBs | 2952 | |
Cradle Of Filth - Mannequin (OFFICIAL MUSIC VIDEO) | Someone is playing an acoustic drumset with an open hi-hat and fast aggressive fill-ins. An e-bass is playing a simple bassline along. In the background you can hear strings playing a melody while an e-guitar is playing an arpeggio melody on top. In the background you can hear people cheering and singer/singers at the end of a phrase. This song may be playing in a live concert. | 2008-02-11T21:40:56Z | Cradle Of Filth | Official music video for Cradle Of Filth "Mannequin" from Damnation And A Day SUBSCRIBE to Cradle of Filth on YouTube: http://bit.ly/subs-cof-yt SUBSCRIBE to Nuclear Blast YouTube: http://bit.ly/subs-nb-yt | ["Heavy metal", "Music", "Angry music"] | ["hardrock", "acoustic drums", "double-bass", "e-guitar", "synth-strings", "background noises", "voices", "e-bass", "uptempo", "epic"] | 6 | oVhhEku6ECA | 4637 |
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;