musiccaps_details (view)
1 row where musiccaps_aspects contains "no singer", musiccaps_aspects contains "tar" and "youtube_published" is on date 2009-12-16
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hosein Nourshargh, Majid Dearkhshani, Shahriar Nazari. Moscow, 2009 | This is an Iranian classical music piece. There is no singer in the piece. The melody is being played by the tar which is an Iranian lute. The rhythm is being played by the daf which is an Iranian percussion instrument. The atmosphere is profound. This piece could be playing in the background at an Iranian cuisine restaurant. It could also be used in the soundtrack of a mystery movie that takes place in the Middle East. | 2009-12-16T05:25:56Z | Arctide Descendants | Иранская классическая музыка , Чахар-мезраб Нава с авазом. Хосейн Нуршарг - голос, Маджид Дэрахшани - тар, Шахриар Назари - дайере. Поэзия Бахмана Рафеи. Мосфильм, 16.10.09 Tchaharmezrab Nava with avaz. Hosein Nourshargh - voice, Majid Derakhshani - tar, Shahriar Nazari - dayere. Verses by Bahman Rafeie. Mosfilm studio, 16.10.09 چهارمضراب نوا و آواز. مجید درخشانی و حسین نورشرق.شعر بهمن رافعی | ["Traditional music", "Music"] | ["iranian classical music", "no singer", "instrumental", "tar", "daf", "vibrant", "profound", "eastern sounding"] | 9 | BQ_KrefFiTw | 1236 |
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;