musiccaps_details (view)
2 rows where musiccaps_aspects contains "sound effects", musiccaps_names contains "Music" and musiccaps_names contains "Sigh"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- sound effects · 2 ✖
- birds singing 1
- cinematic 1
- danger 1
- dark synth 1
- darl 1
- female voice 1
- flute 1
- no vocals 1
- reverb vocal sample 1
- scary 1
- tv series 1
- video game 1
- walking 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- Sigh · 2 ✖
- Inside, large room or hall 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Legend of Zelda Twilight Princess Walkthrough 22 (4/9) "Hyrule Castle: Tower" | The track is a video game soundtrack. A scary sounding synth sustains a dissonant chord that indicates danger. What seems to be an infant is sampled, the sound has reverb and distortion. There's a tension atmosphere.The overall vibe of the track is dark. | 2010-08-31T13:50:25Z | Zelda Dungeon | ~ Chapter 22: Hyrule Castle ~ Part 4 of 9: Tower ==Contents== 0:04 Blocks + Soldiers (Wolf Form!) 0:37 Stairs 1: Jump 0:50 Area 1: Lizalfos 1:05 Stairs 2: Double Clawshot 1:20 Area 2: Lizalfos (Harder) 1:30 Stairs 3: Spinner 1:42 Area 3: Darknut 2:37 Goody Room (OPTIONAL!!!) 4:48 Atop Hyrule Castle 5:30 Lengthy Introduction 6:15 Ganondorf Rambles 7:34 Uh Oh... Corresponding Twilight Princess Site Walkthrough Chapter: https://www.zeldadungeon.net/twilight-princess-walkthrough/hyrule-castle/ | ["Music", "Sigh", "Inside, large room or hall"] | ["cinematic", "video game", "scary", "sound effects", "dark synth", "reverb vocal sample", "no vocals", "danger", "darl"] | 5 | 50QEapyTPD4 | 624 | |
Phim Hài Mới 2020 | ĐỐ LÀM ÔNG CƯỜI Tập 3 | Hài Dân Gian Hay Nhất 2020 | Hài Tết Đặc Sắc | This is an excerpt from a TV series. There are female voices that can be heard. There is a walking sound. The birds are singing. There is a mellow flute tune being played. Various sounds can be sampled from this recording. | 2016-10-25T11:54:01Z | Style TV | Phim Hài Mới 2020 | ĐỐ LÀM ÔNG CƯỜI Tập 3 | Hài Dân Gian Hay Nhất 2020 | Hài Tết Đặc Sắc : https://www.youtube.com/watch?v=w9EGDo9Yybc “Đố làm ông cười” – câu chuyện dân gian nhẹ nhàng, hài hước; đề cao những con người có đức tính kiên trì, nhẫn nại và chân thành trong tình yêu. Dù có gặp bao nhiêu thất bại đi chăng nữa nhưng nếu có niềm tin, sự chân thành thì cuối cùng cũng sẽ cảm hóa được người khác. Phim do công ty cổ phần truyền hình cáp STV (Styletv, joyfm, infotv) thực hiện. Kênh YOUTUBE CHÍNH THỨC công ty cổ phần truyền hình cáp STV ▶SUBSCRIBE kênh youtube : https://goo.gl/TdnHRF ▶Fb: https://goo.gl/6aDW1f ▶ Web: https://goo.gl/QQsHJx ▶Phát lúc 21h15 trên kênh Styletv. VTVcap 12 thứ 7 hàng tuần. Mời cả nhà đón xem Trân trọng cảm ơn! | ["Music", "Sigh"] | ["tv series", "female voice", "sound effects", "walking", "birds singing", "flute"] | 9 | w9EGDo9Yybc | 5245 |
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;