musiccaps_details (view)
2 rows where musiccaps_aspects contains "intense", musiccaps_aspects contains "mystical" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- intense · 2 ✖
- low quality 2
- mystical · 2 ✖
- arpeggiated electric guitar melody 1
- emotional 1
- mellow synth pad chords 1
- mono 1
- noisy 1
- passionate 1
- suspenseful piano melody 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
KPMG Tax Graduate Recruitment Video | The low quality recording features a suspenseful piano melody played over mellow synth pad chords. It sounds intense, mystical, but also passionate, as something you would hear in movies. | 2009-05-04T12:07:40Z | Kept | KPMG's Russian Tax practice has been operating for more than 15 years. The department offers its clients a wide range of tax and legal advisory services, including business structuring in Russia and cross-border M&A transaction support, taxation of legal entities and individuals, litigation, transfer pricing and customs duties for various sectors of the economy. KPMG's Tax department offers exciting projects, intensive training, interaction with outstanding professionals and work with leading Russian and international companies. KPMG's Tax Department welcomes you to its team at any stage of your professional career. | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "suspenseful piano melody", "mellow synth pad chords", "intense", "mystical", "passionate", "emotional"] | 4 | 1y1lEOGBcWM | 319 | |
Dave Ellefson of Megadeth-Five Magics | The low quality recording features an arpeggiated electric guitar melody performance. The recording is noisy and in mono, as it was probably recorded with a phone. It sounds mystical and intense. | 2011-01-29T17:33:56Z | JAAM013 | David Ellefson bass clinic, performing "Five Magics" at Sam Ash 10/7/10 | ["Bass guitar", "Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "mono", "arpeggiated electric guitar melody", "mystical", "intense"] | 4 | 2BBAUwC1BI4 | 339 |
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;