musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "synth backing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- instrumental · 3 ✖
- no percussion 3
- synth backing · 3 ✖
- no voice 2
- booming and splashing sounds 1
- clicking sounds 1
- distortion guitar 1
- game mode select sounds 1
- game selection music 1
- guitar solo 1
- hammer on 1
- minimal instruments 1
- no other instruments 1
- no voices 1
- romantic theme 1
- shattering glass sound 1
- slow tempo 1
- sound of wind 1
- vibrato 1
musiccaps_names (array) 7 ✖
- Music 3
- Glass 1
- Guitar 1
- Musical instrument 1
- Opera 1
- Plucked string instrument 1
- Shatter 1
youtube_published (date) 3 ✖
- 2010-11-25 1
- 2012-05-07 1
- 2012-11-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Краш-тест стекла Gorilla Glass 2.mp4 | This song features the sound of glass being shattered. There are no voices in this clip. A synth plays a backing sound and holds the chord for the duration of the clip. Toward the end, the sound of wind is played. There are no other instruments in this clip. | 2012-05-07T05:41:20Z | Дмитрий Фатеев | ["Glass", "Music"] | ["synth backing", "shattering glass sound", "no voice", "instrumental", "no percussion", "minimal instruments", "sound of wind"] | 0 | 614LdgrE13A | 717 | ||
Splatterhouse Walkthrough - Phase 3: In the Shadow of the Abyss - Part 2 [HD] (X360, PS3) | This clip features a synth pad and synth swells in the background. Game mode selection sounds are played. A boom and splash sound is played just before the game mode selection sound is played. The synth sounds continue to play in the background. There are no voices in this clip. There are no other instruments in this clip. This sound can be used in an online game. | 2010-11-25T07:12:43Z | TheMediaCows | This is part two of Phase 3: In the Shadow of the Abyss and seventh video of a complete walkthrough of Splatterhouse for X-Box 360 and Playstation 3 played on X-Box 360. Developer: Namco Bandai Games Publisher: Namco Bandai Games | ["Music", "Shatter"] | ["game selection music", "synth backing", "no voices", "clicking sounds", "no percussion", "instrumental", "booming and splashing sounds", "game mode select sounds"] | 0 | N6YT8_jlt0E | 2322 | |
Lindsey Stirling - Phantom of the Opera(Guitar Cover) | This song features a distortion guitar playing a guitar solo. The solo is played at a high pitch. It is a slow tempo solo. The guitarist plays a lot of vibrato when the notes are allowed to ring for a while. The pattern follows three ascending notes followed by three strikes on a lower note. This is followed by one higher note, the lower note and a hammer on to a higher note. A synth plays backing chords. There are no other instruments in this song. The mood of this song is romantic. | 2012-11-06T21:02:35Z | Łukasz Stemler - MusiC | Fell free to add me on facebook https://www.facebook.com/update_security_info.php?wizard=1#!/pages/ManieK/180841045311104 Here's my band http://www.facebook.com/pages/MossaD-Masters-of-speed-strength-and-Disorder/179106888791919 Hey, my friends ! Check out my fanpage on facebook ! I would like to present you my band .M.o.s.s.a.D ! Click the button ' like it ' :D It would be great ;) Greetings ^ ^ It's a new cover of Lindsey. Everything is playing by ear plus some of my ideas :)This is the second version on youtube I guess :) Hope you gonna like that one . All the best. Axelek666 | ["Guitar", "Music", "Musical instrument", "Opera", "Plucked string instrument"] | ["distortion guitar", "guitar solo", "synth backing", "vibrato", "hammer on", "no other instruments", "no percussion", "no voice", "instrumental", "slow tempo", "romantic theme"] | 0 | NKDBwJIwWoU | 2331 |
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;