musiccaps_details (view)
2 rows where "youtube_published" is on date 2016-04-10
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
幾可亂真的超強手繪 ! 神人 | The instrumental music features an ensemble that resembles the orchestra. The melody is being played by a brass section while strings provide harmonic accompaniment. At the end of the music excerpt one can hear a double bass playing a long note and then a percussive noise. | 2016-04-10T21:25:56Z | AbNoRmALiTy | 他只是在手掌上 畫了個圓後再上一些色彩, 就讓人驚呆了好幾秒, 太錯亂了! 一起來看看超強的手繪立體作品吧! | ["Music", "Thunk"] | ["brass", "double bass", "strings", "instrumental", "no voice", "percussion"] | 2 | -5FoeegAgvU | 11 | |
أغدا ألقاك.. أم كلثوم | The low quality recording features a traditional song that consists of passionate female vocal singing over wooden percussive elements, strings and flute melody. It sounds passionate, emotional and soulful and the recording is noisy and in mono. | 2016-04-10T21:37:36Z | shaifize | أغدا ألقاك ؟.. Om Kalthoum Song فارحم القلب الذى يصبو إليك فغداً تملكه بين يديك !! وغداً تأتلق الجنة أنهارا وظلا وغدا ننسى فلا نأسى على ماضٍ تولى وغداً نسموا فلا نعرف للغيب محلا وغداً للحاضر الزاهر نحيا ليس إلا قد يكون الغيب حلوا إنما الحاضر أحلى هكذا أحتمل العمر نعيماً وعذابا مهجة حرى وقلباً مسه الشوق فذابَ | ["Mantra", "Music", "Middle Eastern music"] | ["low quality", "traditional", "mono", "noisy", "passionate female vocal", "wooden percussive elements", "flute melody", "strings melody", "passionate", "emotional", "soulful"] | 4 | 2dyEnOo3yJ8 | 392 |
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;