musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality" and musiccaps_aspects contains "suspenseful piano melody"
This data as json, CSV (advanced)
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 |
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;