musiccaps_details (view)
3 rows where musiccaps_names contains "/m/05zppz" and musiccaps_names contains "Singing" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional 2
- acoustic drums 1
- amateur recording 1
- ambient 1
- club music 1
- contemporary pop 1
- crowd clapping 1
- dance music 1
- dance pop 1
- digital drumming 1
- e-bass 1
- electric guitar riff 1
- electro pop 1
- electronic music 1
- female singer 1
- footstep sound 1
- fruity male vocal 1
- groovy rhythm 1
- italian ballad 1
- keyboard arrangement 1
- live performance 1
- low quality 1
- male opera voice 1
- medium fast tempo 1
- medium tempo 1
- mid range singing 1
- mixed harmonizing choir 1
- mono 1
- noisy 1
- passionate 1
- soulful 1
- strings 1
- synth pop 1
- synthesiser articulation 1
- upbeat 1
- vocal backup 1
musiccaps_names (array) 9 ✖
- /m/05zppz · 3 ✖
- /t/dd00003 3
- Music 3
- Singing · 3 ✖
- Choir 1
- Opera 1
- Pop music 1
- Speech 1
- Vocal music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Francis Coppola singing Male Femmena | A male voice is singing loudly with an opera technique while an acoustic drum is playing along with a e-bassline. Underlined by strings playing a melody. This song may be playing at a wedding. | 2007-07-23T20:57:52Z | Francis Coppola | Russo's on the Bay Howard beach NYC- Born in Queens NYC Frankie singing mala femmena 2004. My Origin is from Pomigliano D'arco, Castello di Cisterno and Brusciano.; NAPOLI Mt. Versuvio | ["Singing", "Music", "/m/05zppz", "Vocal music", "/t/dd00003"] | ["italian ballad", "strings", "acoustic drums", "e-bass", "male opera voice", "mid range singing", "medium tempo", "amateur recording"] | 6 | zdtVT2xwrHU | 5500 | |
Gimme More (Britney Spears) - Cover/Male Singing. | A female singer sings soft pop songs. The tempo is medium fast with electronically arranged music, electric guitar harmony, digital drum beats, and melodious vocal backup. The song is simple, soft, emotional, upbeat, catchy, with a dance groove. This song is an Electro Pop song. | 2013-03-03T05:27:25Z | TheMaleBritney | Please Like, Subscribe, Share and Comment :D I Don't Own "Gimme More" Britney Does. Heres the link to buy the original Gimme More: https://itunes.apple.com/au/album/gimme-more-single/id264025647 | ["Singing", "Music", "/m/05zppz", "Pop music", "/t/dd00003"] | ["female singer", "medium fast tempo", "emotional", "contemporary pop", "upbeat", "groovy rhythm", "dance music", "dance pop", "club music", "electro pop", "synth pop", "ambient", "electronic music", "synthesiser articulation", "digital drumming", "keyboard arrangement", "electric guitar riff", "vocal backup"] | 7 | MY0PsDE3xHs | 2279 | |
Treorchy Male Choir & Tom Jones singing Amazing Grace | The low quality recording features a live performance of a harmonizing mixed choir, introduced by a fruity male vocal. There is a footstep and crowd clapping sound right after introduction. The recording is a bit noisy, in mono and it sounds passionate, emotional and soulful. | 2009-11-27T01:22:15Z | Llantrisant | Tom Jones and the Treorchy Male Choir performing "Amazing Grace" on his Christmas TV Show, 1969. Visit www.treorchymalechoir.com | ["Singing", "Music", "Opera", "/m/05zppz", "Speech", "Choir", "/t/dd00003"] | ["low quality", "noisy", "mono", "footstep sound", "fruity male vocal", "crowd clapping", "mixed harmonizing choir", "emotional", "passionate", "soulful", "live performance"] | 4 | V5HMIxuAtv8 | 2973 |
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;