musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "live performance" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy bass · 6 ✖
- live performance · 6 ✖
- low quality 6
- groovy 3
- passionate 3
- punchy snare 3
- shimmering hi hats 3
- crowd chattering 2
- electric guitar melody 2
- folk 2
- punchy kick 2
- rock 2
- accordion melody 1
- addictive 1
- arpeggiated acoustic guitar melody 1
- barely audible 1
- brass melody 1
- crowd cheering 1
- crowd clapping 1
- crushed 1
- distorted 1
- distorted male vocal 1
- emotional 1
- energetic 1
- energetic drums 1
- exciting 1
- exciting background male vocal 1
- exotic 1
- flat male vocal 1
- fun 1
- …
musiccaps_names (array) 13 ✖
- Singing · 6 ✖
- Music 5
- Music of Latin America 3
- Salsa music 2
- Accordion 1
- Bluegrass 1
- Choir 1
- Musical instrument 1
- Orchestra 1
- Rattle 1
- Speech 1
- Traditional music 1
- Yodeling 1
youtube_published (date) 6 ✖
- 2007-12-08 1
- 2009-07-03 1
- 2009-09-13 1
- 2009-11-24 1
- 2009-12-27 1
- 2015-11-13 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 | |
Norske Artister - Venn | The low quality recording features a live performance of a rock song that contains harmonizing background vocals, alongside passionate female vocals, singing over wide electric guitar melody, punchy snare, groovy bass, punchy kick and shimmering hi hats and crash cymbals. It sounds emotional, passionate and addictive - thanks to that cadence. | 2007-12-08T21:06:41Z | Primož Dimnik | Norske Artister - Venn (Live) Espen Lind, Lene Marlin, Sivert Hoyem, Thomas Dybdahl; Espen Lind, Lene Marlin, Bertine Zetlitz, Sissel Kyrkjebø, Kurt Nilsen; Ravi, Morten Abel, ... | ["Singing", "Music", "Choir"] | ["low quality", "live performance", "rock", "harmonizing background vocals", "passionate female vocals", "wide electric guitar melody", "punchy snare", "groovy bass", "punchy kick", "shimmering hi hats", "emotional", "passionate", "addictive", "shimmering crash cymbal"] | 4 | EsssGCL-Axw | 1597 | |
Voltio - Medley De Salsa Carcelaria (Video En Vivo Desde Oso Blanco) | The low quality recording features a live performance of an urban latin song that consists of flat male vocal singing over groovy piano melody, groovy bass guitar, wooden percussive elements, wide toms, warm brass melody and widely spread claps. There is a short, exciting background male vocal in the middle of the loop. It sounds exotic, groovy and passionate. | 2009-11-24T21:07:11Z | VoltioVEVO | Music video by Voltio performing Medley De Salsa Carcelaria. (C) 2008 SONY BMG MUSIC ENTERTAINMENT (US Latin) LLC YouTube view counts pre-VEVO: 878 | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["low quality", "live performance", "urban latin", "wooden percussive elements", "wide toms", "warm brass", "groovy piano melody", "groovy bass", "flat male vocal", "wide claps", "passionate", "exotic", "groovy", "exciting background male vocal"] | 4 | FEuXIeWoCQQ | 1628 | |
Shake Rattle & Roll~Good Golly Miss Molly by 怪人二十面相 | The low quality recording features a live performance of a rock song and it consists of a distorted male vocal singing over repetitive electric guitar melody, groovy bass and energetic drums. It sounds crushed, distorted, loud, but it is barely audible, as it was recorded with a poor quality microphone. | 2009-12-27T18:05:57Z | Hiddeson | 2009.12.19 怪人二十面相Presents X'mas Rock & Roll Show 函館Live Cafeにて またSBJみたいなみたいな。2曲続けてどうぞ!的な。 ジョニィの音がレイエニスみたいで良い! | ["Singing", "Music", "Rattle", "Salsa music"] | ["low quality", "live performance", "rock", "crushed", "distorted", "loud", "barely audible", "distorted male vocal", "groovy bass", "repetitive electric guitar melody", "energetic drums"] | 4 | _1woPC5HWSg | 3436 | |
YODELING IN KOREA | The low quality recording features a live performance of a folk song and it contains harmonized mixed vocals singing over groovy bass, groovy accordion melody and arpeggiated acoustic guitar solo melody. The recording took place outdoors, since there was some crowd chattering and nature sounds. It sounds happy and fun. | 2009-09-13T15:23:28Z | VascoPolonia | Six Korean college students yodeling at Global Fair & Festival in Incheon, South Korea. | ["Singing", "Yodeling", "Music", "Bluegrass"] | ["low quality", "live performance", "folk", "harmonized vocals", "crowd chattering", "outdoor recording", "groovy bass", "groovy accordion melody", "arpeggiated acoustic guitar melody", "happy", "fun", "nature"] | 4 | gNjeps3EbJA | 4026 | |
Reply1988 Go Kyung-pyo-Ryu Jun-yeol-Lee Dong-hwi, chnages to 'Fire Engine' for Hye-ri 151113 EP3 | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | 2015-11-13T12:53:53Z | tvN drama | tvN Family Comedy Drama Reply 1988 Every Fri-Sat 7:50PM Broadcast | ["Singing", "Music of Latin America"] | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | 4 | oBBTqXQFTiA | 4608 |
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;