musiccaps_details (view)
2 rows where musiccaps_author = 6 and "youtube_published" is on date 2013-05-16
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Titanic Piano: How to play My heart will go on Titanic Piano Intro! | This audio contains someone playing a ballad on a piano then a male voice starts talking and the piano-playing ends. This song may be playing at home practicing piano. | 2013-05-16T20:03:17Z | Marks Piano - PGN Piano | Try all my lessons free for 30 days: http://markspiano.com Titanic Piano Lesson: Learn how to play Titanic Piano version with my easy tutorial! I would also advise you to learn the My heart will go on Titanic Piano chord progression. It helps you a lot When you know how to play Titanic Piano chords because it offers you some basic foundation on which to play the entire song! I have been teaching piano online for over 10 years now! My Heart Will Go On to help so many people to learn how to play the piano! If you enjoyed my lesson, please consider subscribing to my youtube channel! | ["Electric piano", "Keyboard (musical)", "Piano"] | ["piano", "male voice talking", "medium tempo", "ballad"] | 6 | 7KIn0zojwu8 | 831 | |
| Casar Hum Hum Gino e Geno Part Felipe Borges 2013 | A male voice is singing/shouting phrases while an acoustic drum is playing a dance groove along with an e-bass. On top of that a acoustic guitar is playing a melody and another one is strumming chords while an accordion is playing a loud melody that seems to be the lead. The drum fill-ins are panned to the left and right side of the speakers. This song sounds like the people are having fun. This song may be playing at a dance event in the countryside. | 2013-05-16T00:23:52Z | W Comunicação | Nova Música do Gino e Geno Lançamento | ["Music of Africa", "Music", "Ska", "Music of Latin America"] | ["country/folk", "acoustic drums", "e-bass", "accordion", "acoustic guitar", "male voice singing", "uptempo", "positive energy"] | 6 | Fv9swdLA-lo | 1674 |
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;