musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "people talking"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- enthusiastic · 2 ✖
- instrumental · 2 ✖
- people talking · 2 ✖
- accompanying music 1
- amateur recording 1
- ambient background sounds 1
- amplified guitar 1
- background noises 1
- brass band 1
- bright trumpeting 1
- buoyant 1
- cheering 1
- clapping 1
- dance groove 1
- dissonant 1
- electric guitar 1
- energetic 1
- enthusiastic electronic guitar melody 1
- fast tempo 1
- groovy bass line 1
- hard hitting drumming 1
- hard rock 1
- high spirited 1
- home recording 1
- intense 1
- jive 1
- keyboard harmony 1
- live performance 1
- loud 1
- medium tempo 1
- metal 1
- muffled music 1
- people talking in the background 1
- poor audio quality 1
- powerful 1
- pulsating 1
- retro rock 1
- rhythmic acoustic guitar 1
- rock 1
- rock and roll 1
- rock instrumental 1
- sonic power’ 1
- spirited 1
- upbeat 1
- vehement 1
- wind instruments 1
- youthful 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 | |
Curt Mitchell Chop Shop Solo Rockoryon Cover | This music is an Electric Guitar instrumental. The tempo is fast with a dissonant background score . There is the sound of people talking in the background. The music is superimposed on a track which doesn’t seem to be in sync. The lead however is powerful, loud, intense and emphatic. This is a Rock Instrumental. | 2009-08-10T15:54:08Z | OR1ON Orion Meshorer | (RockOryon Cover - when I was 12 years old) This is a great solo from Curt Mitchell Chop Shop. working hard on this solo, has improved my playing tremendously. it still needs more refinement but I want to use this occasion and thank Dear Curt Mitchell for his great teachings. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["instrumental", "electric guitar", "people talking in the background", "home recording", "amateur recording", "rock instrumental", "intense", "loud", "amplified guitar", "youthful", "enthusiastic", "vehement", "spirited", "sonic power’", "medium tempo", "background noises", "accompanying music", "people talking", "loud", "powerful", "intense", "rock", "hard rock", "metal", "dissonant"] | 7 | hBQFoDI3NMI | 4082 |
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;