musiccaps_details (view)
2 rows where musiccaps_aspects contains "intense", musiccaps_aspects contains "low quality" and musiccaps_names contains "Keyboard (musical)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- intense · 2 ✖
- low quality · 2 ✖
- background music 1
- emotional 1
- mellow brass 1
- mellow synth pad chords 1
- mystical 1
- orchestral 1
- passionate 1
- shimmering cymbals 1
- suspenseful 1
- suspenseful piano melody 1
- wide brass melody 1
- wide strings melody 1
musiccaps_names (array) 4 ✖
- Keyboard (musical) · 2 ✖
- Electric piano 1
- Harpsichord 1
- Piano 1
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 | |
JESUS CHRIST SUPERSTAR Jesus and Pilate 7B | The low quality recording features an orchestral music that consists of a wide string melody, followed by mellow brass, wide brass melody and shimmering cymbals. It sounds suspenseful and intense - like something that you would hear in the background of a movie scene. | 2011-07-20T12:52:38Z | GABERIALSTORM | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "orchestral", "wide strings melody", "mellow brass", "wide brass melody", "shimmering cymbals", "suspenseful", "intense", "background music"] | 4 | mhru3GXbkHY | 4487 |
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;