musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "dreamy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- amateur recording · 4 ✖
- dreamy · 4 ✖
- harp 2
- medium tempo 2
- accordion 1
- acoustic piano 1
- e-guitars 1
- medium to uptempo 1
- melancholic 1
- melancholy 1
- peaceful 1
- pop 1
- slow melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Harp -Scorpions – Still loving you | This audio contains someone playing a piece of music on a harp. The piece sounds dreamy and peaceful. There is some reverb from the room in the recording. This song may be playing for a soft indie-video-game. | 2015-11-25T13:54:38Z | Anastasia Korenevskaya | Harp Cover (кавер на арфе) harp cover на композицию: ————————————————— Возможны выступления на различных мероприятиях: свадьба,концерт, корпоратив, выездная регистрация,помолвка, романтическое свидание, предложение руки и сердца, день рождение юбилей, банкет, презентация, выставка, Новый год. По вопросам сотрудничества, выступлений на мероприятиях, обучения игры на арфе и фортепиано: (vk.com/infiniamena) или через сайт http://infiniamena.ru Поблагодарить можно здесь: http://yasobe.ru/na/arfu_i_disk mp3 доступно в круппе вк: http://vk.com/harp_in_moscow Мой канал на youtube: https://www.youtube.com/c/AnastasiaKonopleva Следующий harp cover (кавер на арфе) через неделю ---------------------------------- Принимаются заказы на harp cover поздравления. Если вы хотите оригинально поздравить близких и друзей, вы можете заказать кавер на арфе специально для них. Любимая песня, Ваша свадебная песня, что что угодно :) ————————————————— Возможны переложения нот на заказ: фортепиано - арфа гитара - арфа скрипка - арфа виолончель - арфа гобой - арфа флейта - арфа орган - арфа гусли - арфа Валторна - арфа труба - арфа туба - арфа тромбон - арфа кларнет - арфа домра балалайка - арфа Переложение и исполнение: Анастасия Коноплева (Anastasia Konopleva) арфа. | ["Harp", "Pizzicato"] | ["amateur recording", "harp", "medium to uptempo", "melancholic", "dreamy", "peaceful"] | 6 | EkMgPJfSL04 | 1584 | |
Yann Tiersen - La valse d'Amelie (Piano - Accordion) | This audio contains someone playing a fast paced piece with a fast left hand and a slower melody in the right hand playing in the midrange. Someone starts playing an accordion alone. This song may be playing live jamming with your friend. | 2008-02-06T13:38:35Z | Andrea Rossi | Beautiful song from "Le fabuleux destin d'Amelie Poulain" by Yann Tiersen, executed with piano and accordion. Enjoy it. Ora anche su myspace e facebook! Now available on myspace and facebook! http://www.myspace.com/vitedarte http://www.facebook.com/pages/Vite-darte/115844915145405 | ["Accordion"] | ["amateur recording", "acoustic piano", "accordion", "medium tempo", "dreamy", "melancholy"] | 6 | FMjUGdTn7lU | 1639 | |
Journey - Don't Stop Believin' Guitar Cover (with Bass) | This audio contains various e-guitars playing different parts and melodies of a song. One is playing as bass, another one is fingerpicking chords while another one is playing a distorted arpeggio melody on top. This song may be played live by a busker with a loop padel. | 2010-04-22T07:02:16Z | UnitedWeTabDotCom | Don't Stop Believin' played by Tommy Kessler of Blondie and Rock Of Ages (Broadway). For private one on one lessons with Tommy anywhere in the world, please visit www.studywithastar.com/guitar and click the "Indie" tab. Inquires please contact tommykessler@gmail.com | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "e-guitars", "dreamy", "pop", "medium tempo"] | 6 | YxkYVsE0UdQ | 3326 | |
豎琴演奏:蘭陵王片尾曲【手掌心】丁噹原唱 | This audio contains someone playing a dreamy melody on the harp. This audio is an amateur recording. You can hear white noise from the recorder. This song may be playing in an anime movie. | 2014-06-26T05:29:18Z | NUVO樂器 | 張悅臨(Evelyn)11歲豎琴演奏,學豎琴將近五年。 蘭陵王片尾曲【手掌心】(丁噹原唱)使用Aoyama Orpheus 46A踏板豎琴 【我和孩子的音樂夢】http://blog.udn.com/sheldon88/article | ["Harp", "Pizzicato"] | ["amateur recording", "harp", "slow melody", "dreamy"] | 6 | ZZrvO__SNtA | 3391 |
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;