musiccaps_details (view)
2 rows where "youtube_published" is on date 2013-12-06
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
One Republic - Apologize (Lyrics) | A male singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a percussive string section, strong bass line, guitar lead, steady drumming rhythm , keyboard accompaniment and various percussion clicks. The song is emotional and romantic. The song is of poor audio quality. | 2013-12-06T06:01:44Z | Giz Ruar | "Apologize" belongs to One Republic. From the "Dreaming Out Loud" album, 2006. http://onerepublic.com/ Please, suscribe to my channel. TY! My Facebook Official Page: https://www.facebook.com/GizelleSixxJ If you want a special lyric video, just let me know in a comment below the video and I'll try to make it. Thanks for watching. | ["Music", "Happy music"] | ["male singer", "backup singers", "guitar lead", "medium tempo", "steady drumming rhythm", "string section playing rhythmically", "cymbals crashing", "slick percussion clicks", "strong bass line", "keyboard harmony", "modern pop hits", "emotional", "romantic", "together for ever", "i’m sorry", "forgive me", "love song", "poor audio quality", "heartfelt", "vocal harmony", "clapping percussions"] | 1 | -wymN80CiYU | 105 | |
Carnatic music vocal- Bhajare Chitta- Kalyani ragam- Mishrachappu | The audio contains a female voice singing carnatic tones/melody over a shrutibox/drone sound. The audio quality is decent but contains a lot of white noise. It's assumed that this is an amateur recording. This song may be playing at a music teacher's home demonstrating scales to a student. | 2013-12-06T06:28:52Z | Srivaralaxmi Venkatraman | It is a very beautiful master piece in the ragam kalayani composed by Sri Muthuswamy Dhikshitar set to mishrachappu thalam. V Nandhini(B'High Artist) is hailing from the parampara of Shri Kotthavasal Venkatrama Iyer. She has been preforming and teaching carnatic vocal for the past 40 years. | ["Carnatic music", "Mantra", "Music"] | ["oriental/carnatic/vocal", "shrutibox", "drone sound", "female voice singing", "amateur recording"] | 6 | ad6UhYwTXXQ | 3559 |
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;