musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow woodwinds melody" and musiccaps_author = 4 sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 2
- mellow woodwinds melody · 2 ✖
- passionate 2
- classical 1
- cymbal riser 1
- emotional 1
- epic 1
- live performance 1
- loud brass section melody 1
- low brass melody 1
- mono 1
- muffled 1
- muffled percussion 1
- noisy 1
- orchestra 1
- powerful 1
- reverberant 1
- soft wide strings melody 1
- suspenseful 1
- suspenseful violin melody 1
musiccaps_names (array) 4 ✖
- Music 1
- Orchestra 1
- Sad music 1
- String section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ennio Morricone Vienna 12.12.2007 (part 4) | The low quality recording features a live performance of an orchestra and it consists of loud brass melody, mellow woodwinds melody, suspenseful violin melody and muffled percussion. It sounds epic, powerful and passionate. The recording is in mono, a bit noisy and it is reverberant as it was performed in a large concert hall. | 2008-08-12T15:10:07Z | Tomáš Vlček | Ennio Morricone conducts his own music at Vienna Stadthalle - Ecstasy of gold (reprise). | ["String section", "Orchestra"] | ["low quality", "live performance", "noisy", "mono", "reverberant", "orchestra", "muffled", "epic", "powerful", "passionate", "suspenseful violin melody", "muffled percussion", "loud brass section melody", "mellow woodwinds melody"] | 4 | cJ80eZY03Yg | 3697 |
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;