musiccaps_details (view)
3 rows where "youtube_published" is on date 2011-04-23 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- acoustic drums 1
- acoustic guitars strumming 1
- amateur recording 1
- american 1
- bass guitar 1
- blues 1
- country music 1
- dance rhythm 1
- e-guitar 1
- easygoing 1
- electric guitar 1
- emotional 1
- energetic 1
- exciting 1
- groovy 1
- groovy bas slime 1
- groovy bass line 1
- guitar band 1
- home music video 1
- instrumental music 1
- male back vocals 1
- male vocal 1
- medium fast tempo 1
- medium tempo 1
- music jam 1
- poor audio quality 1
- repeated theme 1
- rock and roll 1
- simple tune 1
- spirited 1
- ukulele playing 1
- youthful 1
- youtube songs 1
musiccaps_names (array) 12 ✖
- Music 3
- Musical instrument 2
- Banjo 1
- Chorus effect 1
- Country 1
- Funk 1
- Guitar 1
- Mandolin 1
- Plucked string instrument 1
- Radio 1
- Soul music 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ROLAND JAZZ CHORUS JC-120 DEMO | Someone is playing an e-guitar with a chorus effect playing a melody. This song may be playing at home practicing guitar. | 2011-04-23T20:29:59Z | slaytanictribute | ["Guitar", "Music", "Musical instrument", "Radio", "Chorus effect"] | ["amateur recording", "e-guitar", "medium tempo"] | 6 | C-NYmja61zE | 1315 | ||
Gypsy - Tyler May & The Kentucky School of Bluegrass and Traditional Music Ensemble | The song is an instrumental. The song is medium fast tempo with a groovy bass line, acoustic guitars strumming rhythm, and a ukulele playing lead. The song is spirited and exciting. The song is an instrumental with country music influences. | 2011-04-23T00:46:35Z | Stewart Tyler May | Gypsy © 2011 by Stewart Tyler May Guitar - Josh Reimen Guitar - Leslie Strong Banjo - Jeremy Moses Mandolin - Isaac May Bass - Tina May Fiddle/Clawhammer Banjo - Tyler May | ["Banjo", "Country", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["ukulele playing", "acoustic guitars strumming", "groovy bass line", "dance rhythm", "home music video", "youtube songs", "music jam", "spirited", "poor audio quality", "guitar band", "country music", "groovy bas slime", "energetic", "youthful", "exciting", "emotional", "dance rhythm", "instrumental music", "medium fast tempo"] | 1 | CudxWnS7ukw | 1413 | |
MITCH RIDER & the DETROIT WHEELS - BREAKOUT | This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. | 2011-04-23T15:20:22Z | PaulGTSE | MITCH RIDER & the DETROIT WHEELS with BREAKOUT on the UK PYE DISCO DEMAND LABEL 100mph NORTHERN SOUL | ["Funk", "Music", "Soul music"] | ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] | 9 | GQbUpJFArKI | 1720 |
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;