musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Synthetic singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- male voice · 2 ✖
- bass guitar 1
- drums 1
- electric piano 1
- female vocal harmony 1
- foreign language song 1
- happy mood 1
- low quality recording 1
- male backing vocals 1
- moderate tempo 1
- r&b genre 1
- simple percussion 1
- trumpet 1
- tubular bell 1
musiccaps_names (array) 4 ✖
- Music 2
- Synthetic singing · 2 ✖
- /t/dd00003 1
- Theme music 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 | |
Kangoo - Sigla iniziale [Zap Zap TV su TMC] | This song is of low quality. This features a male voice singing the main melody in a foreign language. Female voices sing the vocal harmony in this song. This is accompanied by simple percussion. Trumpet play fills in between lines. The mood of this song is happy. | 2009-03-29T10:53:33Z | Ytrewq1989 | ["Theme music", "Music", "Synthetic singing"] | ["low quality recording", "foreign language song", "male voice", "female vocal harmony", "trumpet", "simple percussion", "happy mood", "moderate tempo"] | 0 | BsVsoZ4ojp0 | 1299 |
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;