musiccaps_details (view)
2 rows where musiccaps_aspects contains "no other instrumentation" and musiccaps_aspects contains "romantic" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- no other instrumentation · 2 ✖
- passionate 2
- romantic · 2 ✖
- acoustic love song 1
- amateur play 1
- bad audio quality 1
- classical music 1
- dream sequence 1
- echo chamber 1
- eclectic music 1
- emotional 1
- erotic 1
- female chanting tones 1
- guitar strums gently 1
- home video 1
- instrumental music 1
- learner 1
- legato playing 1
- love song 1
- making love 1
- male singer 1
- medium tempo 1
- never let go 1
- no percussions 1
- poor audio quality 1
- recital 1
- relaxing 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- sensual music 1
- slow tempo 1
- spirited 1
- tenor sax 1
- together forever 1
- vibrato style 1
- vocal echoes 1
- youtube music video 1
musiccaps_names (array) 4 ✖
- Brass instrument 1
- Music 1
- Sad music 1
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Spirits and the Melchizedek Children: "So Happy, It's Sad"(Official Music video | A male singer sings this emotional melody with a female backup singer singing chanting tones. The song is slow tempo with a guitar strumming gently and no other instrumentation. The song is emotional and romantic. The song is beautiful and lilting. | 2014-10-16T22:31:42Z | Chad Hess | Spirits and the Melchizedek Children: "So Happy, It's Sad"(Official Music video) Track: So Happy, It's Sad Album: So Happy, It's Sad Available on Vinyl, CD, and all Digital Outlets http://www.spiritsatl.com/ http://www.fallenarrows.com/ captured, directed and edited : Chad Hess http://www.chadhess.com/ Model - Lindsay Appel Make-up : Amy Walls | ["Music", "Sad music"] | ["male singer", "eclectic music", "slow tempo", "no other instrumentation", "dream sequence", "relaxing", "together forever", "never let go", "female chanting tones", "guitar strums gently", "erotic", "love song", "echo chamber", "vocal echoes", "romantic", "passionate", "making love", "acoustic love song", "sensual music"] | 1 | MIexFfOsuJs | 2254 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 |
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;