musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "passionate", musiccaps_author = 4 and musiccaps_names contains "Wedding music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- emotional 2
- low quality 2
- noisy 2
- passionate · 2 ✖
- classical 1
- crowd clapping 1
- electric guitar melody 1
- live performance 1
- mono 1
- reverberant acoustic guitar melody 1
- shimmering hi hats 1
- subtle female vocal 1
- sustained violin melody 1
- theremin solo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweet Memories- Tess Sears tribute to her mom Dawn Sears | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | 2014-12-23T23:40:06Z | Tesla Dawn | Tess Sears sings her moms song Sweet Memories in memory of her mother Dawn Sears at the first Monday night Time Jumper meeting after her passing. | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | 4 | -WvVG0wHcTc | 57 | |
Anoushka SHANKAR aux Nuits de Fourvière | The low quality recording features a reverberant acoustic guitar melody. It sounds passionate and emotional. The recording is noisy. | 2013-12-02T14:14:15Z | Rakam Embert | Bonus : Norah JONES (Ravi Shankar's daughter & Anoushka' sister)https://drive.google.com/file/d/0BzChOCqe5MhCWWlIX0ptVHhiaEE/view?usp=sharing Anoushka Shankar (née le 9 juin 1981 à Londres) est une joueuse de sitar et une compositrice indienne. Elle est la fille et élève du célèbre Ravi Shankar, dont elle a écrit une biographie, Bapi, l'amour de ma vie (publiée en français en 2004). Elle l'accompagnait lors de toutes ses tournées, et a publié elle-même plusieurs albums. Sa demi-sœur est Norah Jones, autre fille de Ravi Shankar. En octobre 2010, elle épouse le réalisateur Joe Wright et a un fils en 2011, nommé Zubin. Discographie : - Anoushka (1998) - Anourag (2000) - Live at Carnegie Hall (2001) - Rise (2005) - Breathing under Water (2008), avec Karsh Kale - Traveller (2011) (cf Wikipedia) | ["Music", "Wedding music", "Middle Eastern music"] | ["low quality", "reverberant acoustic guitar melody", "passionate", "emotional", "noisy"] | 4 | 9hCnEfZFZ04 | 1035 |
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;