musiccaps_details (view)
2 rows where musiccaps_aspects contains "male backing vocals" and musiccaps_names contains "/t/dd00003"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- male backing vocals · 2 ✖
- acoustic guitar 1
- background noises 1
- bass guitar 1
- drums 1
- e-bass 1
- electric piano 1
- female voice singing 1
- male voice 1
- medium to uptempo 1
- percussion 1
- r&b genre 1
- sensual 1
- tubular bell 1
musiccaps_names (array) 3 ✖
- /t/dd00003 · 2 ✖
- Music 2
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
T pain 1 night ( singing without autotune) | The R&B music features a male voice singing and being backed by similar male voices from time to time. An electric piano accompanies the singer with long-note chords. The drums play a light rhythm and dictate the flow of the music. Towards the end of the music excerpt a bass guitar starts to play. In the beginning of the passage one can hear a tubular bell being struck once. This sound is very similar to a church bell. | 2010-08-09T20:03:24Z | IgetsitinTV | 1 of the extremely rare songs were T-pain sings great without autotune when & where this song was created is unknown but its clear it was before he got signed... | ["Music", "/t/dd00003", "Synthetic singing"] | ["male voice", "male backing vocals", "r&b genre", "electric piano", "drums", "bass guitar", "tubular bell"] | 2 | 0TV9zvfwFhs | 172 | |
Tiare Tahiti Hula Kaanapali, Maui | An acoustic drum is strumming chords while a percussion instrument is playing a bass sound along with an e-bass. A male choir is singing in the background while the female voice is singing the first melody. In the background you can hear voices. This song may be playing in a live performance. | 2009-04-14T04:32:37Z | Amrtvideo | Tiare Tahiti Hula is performed by the dancer Marie and the infectious singing sung by Alaka'i, "The Morning Goddess" of KPOA performed at the Royal Lahaina Resort Hotel in Kaanapali, Maui. | ["Music", "/t/dd00003"] | ["acoustic guitar", "e-bass", "female voice singing", "male backing vocals", "percussion", "background noises", "medium to uptempo", "sensual"] | 6 | C3o8pEsAu5U | 1323 |
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;