musiccaps_details (view)
2 rows where musiccaps_aspects contains "home recording" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- home recording · 2 ✖
- melancholic · 2 ✖
- slow tempo 2
- accordion harmony 1
- accordion lessons 1
- accordion player 1
- acoustic guitar 1
- bad audio quality 1
- cheerful 1
- emotional 1
- female singing 1
- groovy 1
- high gain music 1
- home video 1
- husky voice 1
- instrumental music 1
- lilting music 1
- lonely 1
- lonely sad 1
- mellow 1
- muffled guitar quality 1
- poignant 1
- pop 1
- romantic 1
- room acoustics 1
- sad 1
- screechy tones 1
- soft 1
- soloist 1
- youtube music video 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
bathtub - waxahatchee (cover) | A female vocalist sings this soft melody. The tempo is slow with acoustic guitar accompaniment. The guitar sound is muffled. The song is sad,poignant, melancholic, sentimental,emotional and lonely. This song is Pop. | 2013-10-01T02:06:18Z | gabbywade | idk hey blog: http://2003rapvideo.tumblr.com/ instagram: veganclit_ | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Vocal music"] | ["home video", "home recording", "female singing", "lonely sad", "room acoustics", "muffled guitar quality", "husky voice", "lonely", "sad", "poignant", "acoustic guitar", "slow tempo", "soft", "mellow", "poignant", "melancholic", "pop"] | 7 | mq_b6QKVsuc | 4495 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 |
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;