musiccaps_details (view)
4 rows where musiccaps_names contains "Orchestra" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- live performance 2
- low quality 2
- passionate 2
- accordion melody 1
- ambient street noise 1
- arabic folk singer 1
- chindong 1
- classical 1
- commercial 1
- crowd chattering 1
- crowd noise 1
- electric guitar melody 1
- epic 1
- excited vocals 1
- folk 1
- folk singer 1
- fruity male vocal 1
- groovy 1
- groovy bass 1
- groovy bass line 1
- jazz song 1
- latin style percussion 1
- live audience 1
- live band 1
- low quality audio 1
- male narrator 1
- male singer 1
- medium tempo 1
- passionate male opera vocal 1
- poor audio quality 1
- powerful 1
- punchy snare 1
- screaming 1
- shimmering hi hats 1
- steady drumming rhythm 1
- violin playing solo 1
- wedding music 1
- wide brass melody 1
- wide strings melody 1
- woodwinds melody 1
musiccaps_names (array) 12 ✖
- Music 4
- Orchestra · 4 ✖
- Speech · 4 ✖
- Jazz 2
- Accordion 1
- Classical music 1
- Music of Latin America 1
- Musical instrument 1
- Opera 1
- Rattle (instrument) 1
- Singing 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Sexy Sound Served on a Plate | The low quality recording features a classical song that consists of passionate male opera vocal singing over wide strings melody, wide brass melody and woodwinds melody, over which there is a fruity male vocal talking. It sounds passionate, epic and powerful - like something for commercial. | 2013-12-20T09:02:07Z | LG TV | Slim, stylish, considerate of your needs, full-bodied... we're not talking about your ideal woman; we're talking about LG's latest product, SoundPlate (LAP340). We are proud to introduce you to the LG SoundPlate, a slim base-type speaker system that enhances the TV viewing experience with immersive audio. For more product information, please visit our websites! LG.com: http://www.lg.com/uk/speakers-sound-systems/lg-LAP340 Blog: http://whylgtv.lge.com/archives/6183 | ["Music", "Opera", "Orchestra", "Speech", "Classical music"] | ["low quality", "classical", "fruity male vocal", "passionate male opera vocal", "wide strings melody", "wide brass melody", "woodwinds melody", "passionate", "epic", "powerful", "commercial"] | 4 | YK1AEw1kf28 | 3275 | |
salam- pentru cristofor la udi | A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. | 2008-09-28T14:54:29Z | elicsir0515 | talent:X | ["Jazz", "Music", "Orchestra", "Speech"] | ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] | 1 | bZJoTauRldE | 3634 | |
ある道化師の週末 / cicala-mvta (chin-dong-punk-jazz!!) | This is a low quality audio clip. This jazz song features percussion playing a Latin style beat. A chindong is being played along with the main percussion. This instrument has a 'tin' sound. There are no other instruments in this song. The male singer narrates one line in the course of this song. This is an instrumental song. The mood of this song is happy. | 2008-11-30T14:28:35Z | ebirin831 | Cicala-Mvta is One of Japanese Most Exciting and Original Groups. Both Traditional Chindon and the Retro-futuristic Sound of Cicala-Mvta is an Entirely Natural Combination of the Old and New, the East with the West. (Amazon review) Cicala Mvta is a group described by some UK music critics as the most impressive exponents of contemporary Japanese grass roots music. The music presents old-fashioned and brass band music. Featuring chindon, a kind of Japanese drum, saxophones, clarinets and tubas, Cicala Mvta's music is a kind of street music originally played at funerals or the openings of local shops. But the band blends the cheesy music with social critique, thus creating a sarcastic outlook, in both its musical style and in its stage performance. (TAIPEI TIMES By Yu Sen-lun Jun 18, 2004) シカラムータLIVE! 2008.11.29 @京都『磔磔』 | ["Jazz", "Music", "Orchestra", "Rattle (instrument)", "Speech"] | ["jazz song", "low quality audio", "latin style percussion", "chindong", "male narrator"] | 0 | sZQ4TeLueSs | 4960 |
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;