musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "crowd noises" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- crowd noises · 2 ✖
- emotional 2
- live performance 2
- low quality 2
- addictive 1
- alternative/indie 1
- electric guitar arp melody 1
- electric guitar solo melody 1
- energetic 1
- energetic cymbals 1
- flat female vocal 1
- groovy bass guitar 1
- muffled kick hits 1
- muffled snare hits 1
- noisy 1
- passionate male vocal 1
- rock 1
- synth keys melody 1
- thin 1
musiccaps_names (array) 4 ✖
- Music 2
- Singing · 2 ✖
- Burst, pop 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
beach house - take care (PRIMAVERA SOUND 2010) | The low quality recording features a live performance of an alternative/indie song and it consists of flat female vocal singing over synth keys and arpeggiated electric guitar melody. There are also some crowd noises in the background. It sounds thin, but also emotional and like something you would want to sing along. | 2010-05-30T10:26:18Z | betoline69 | beach house - take care (PRIMAVERA SOUND 2010) | ["Singing", "Music", "Burst, pop"] | ["low quality", "live performance", "flat female vocal", "synth keys melody", "electric guitar arp melody", "thin", "emotional", "alternative/indie", "crowd noises"] | 4 | FsnRM2irjvI | 1670 | |
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 |
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;