musiccaps_details (view)
2 rows where musiccaps_author = 6 and musiccaps_names contains "Skateboard" sorted by musiccaps_aspects
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kyle Walker Propeller Edit | This song contains electronic drums that sound overdriven with an aggressive kick and clap sounds as snare. A male choir sample is singing a chord melody with breaks in-between. The whole thing sounds urban and epic as if something heroic is happening. | 2015-07-03T17:36:03Z | Btrigga | Rights go to Vans and Thrasher Magazine. Like and subscribe for more edits. | ["Music", "Skateboard"] | ["electronic/rap", "electronic drums", "male choir sample", "epic", "medium tempo"] | 6 | ZaUaqnLdg6k | 3394 | |
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 |
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;