musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-01-11 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- acoustic drums 1
- bass guitar 1
- carnatic classical 1
- carnatic violin 1
- cartoons 1
- catchy 1
- complex 1
- easygoing 1
- electric guitar 1
- emotional 1
- female voice 1
- flute 1
- live performance 1
- low cello melody 1
- low quality 1
- male vocal 1
- medium tempo 1
- orchestral 1
- passionate 1
- pop music 1
- sentimental 1
- shouting-like singing 1
- tabla 1
- versatile singing 1
- vibrant 1
- wide violin melody 1
musiccaps_names (array) 11 ✖
- Music 2
- Bowed string instrument 1
- Classical music 1
- Drum 1
- Happy music 1
- Musical instrument 1
- Orchestra 1
- Percussion 1
- Soul music 1
- Tabla 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LaLa - Lost Ones ♪ | This is a pop music piece. There is a female vocalist singing in a shout-like style. There is a flute and an electric guitar playing the melody with the bass guitar playing in the background. The rhythm is provided by a medium tempo acoustic drum beat. The tune is catchy. The piece is in the major key and there is an easygoing atmosphere to it. This piece could be used in the soundtrack of a sit-com during the credits section. | 2009-01-11T02:11:54Z | Hysteria | LaLa - Lost Ones DJ Vida V Presents American Mija no copyright to this video | ["Music", "Soul music", "Happy music"] | ["pop music", "female voice", "shouting-like singing", "flute", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "catchy", "sentimental", "medium tempo"] | 9 | svNayU6q3Dg | 4987 | |
Mozart 'Dissonance' Quartet K.465 - 1st Movement | The low quality recording features an orchestral music played by wide violin melody and low cello. It sounds emotional and passionate - like something you would hear in old cartoons. | 2009-01-11T07:47:23Z | Calder Quartet | Calder Quartet live at the Colburn School December 5th 2008 | ["Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["low quality", "wide violin melody", "low cello melody", "emotional", "passionate", "orchestral", "cartoons"] | 4 | mjZylz3nCwQ | 4489 | |
Carnatic Music Demonstration: Mridangam Solo (Part 1/3) | This is a Carnatic classical music piece. It is being performed live. There is a male vocalist singing in a versatile manner. The melody is being played by a Carnatic violin line. The rhythmic background is composed of the tabla percussion. The atmosphere is vibrant and the instrumentation is complex. This piece can be an educational example of a Carnatic music piece to be taught in music schools. | 2009-01-11T20:56:26Z | Anantha R. Krishnan - Misterdangam | NOTE TO VIEWERS: CLOSED CAPTIONING IS AVAILABLE IN ENGLISH (although knowledge of Carnatic music terminology is assumed) Part 1: http://www.youtube.com/watch?v=zYa3ksSrCqw Part 2: http://www.youtube.com/watch?v=DtPCcyyzrKA Part 3: http://www.youtube.com/watch?v=vwzSMTCWZf8 Excerpts from Sangita Kalanidhi Shri Palghat Raghu's lecture / demonstration on Carnatic music, entitled "The Multifaceted Splendour of Misram", held at the Madras Music Academy in December of 2007. In this segment, Shri Raghu explains how a mridangam solo (thani avarthanam) must flow seamlessly as a part of a composition. The song Enthundi (Durbar, Misra Chapu) is presented in Part 1, along with a full thani avarthanam composed by Shri Raghu in Parts 2 and 3. Performed by: Abhishek Raghuram (vocal) Mysore Srikanth (violin) Anantha R. Krishnan (mridangam) | ["Tabla", "Drum", "Percussion"] | ["carnatic classical", "live performance", "male vocal", "versatile singing", "carnatic violin", "tabla", "complex", "vibrant"] | 9 | zYa3ksSrCqw | 5491 |
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;