musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "suspenseful" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- passionate · 2 ✖
- suspenseful · 2 ✖
- classical 1
- cymbal riser 1
- emotional 1
- live performance 1
- low brass melody 1
- mellow woodwinds melody 1
- mono 1
- mystical 1
- noisy 1
- passionate male vocal 1
- soft wide strings melody 1
- soulful 1
- sustained suspenseful strings melody 1
- traditional 1
- wooden percussive elements 1
musiccaps_names (array) 4 ✖
- Music 1
- Percussion 1
- Sad music 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Great Ghazal Singer Ahmad Wali with Siar Hashimi on Tabla | The low quality recording features a live performance of a traditional song that consists of wooden percussive elements, sustained suspenseful strings melody and passionate male vocal singing over it. It sounds passionate, mystical, soulful and suspenseful, even though the recording is a bit noisy and in mono. | 2009-03-05T15:38:49Z | TaalPanchamSawari | Ghazal Tabla: Siar Hashimi Taal: Kehrwa | ["Tabla", "Percussion"] | ["mono", "noisy", "low quality", "traditional", "live performance", "wooden percussive elements", "sustained suspenseful strings melody", "passionate male vocal", "soulful", "passionate", "mystical", "suspenseful"] | 4 | yx7BZ_djE-U | 5449 | |
Top 10 Most Dangerous Animals | The low quality recording features a classical song that consists of a soft wide strings melody, followed by mellow woodwinds melody and low brass melody. There is a short snippet of a cymbal riser at the very end of the loop. It sounds passionate, emotional and suspenseful. | 2009-04-04T16:07:11Z | Angelo Ierullo | Top 10 . These weights are totally bogus, I was a tad nuts the day I made the video. | ["Music", "Sad music"] | ["classical", "low quality", "soft wide strings melody", "mellow woodwinds melody", "low brass melody", "cymbal riser", "passionate", "emotional", "suspenseful"] | 4 | 3PuzzYmTDA4 | 464 |
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;