musiccaps_details (view)
2 rows where "youtube_published" is on date 2006-06-16
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- adventurous 1
- bad audio quality 1
- blue band 1
- blues harmonica 1
- blues harp 1
- blues legends 1
- blues progression 1
- blues turn around 1
- club music 1
- dance song 1
- exciting 1
- groovy 1
- groovy bass line 1
- guitar rhythm 1
- harmonica player 1
- harpist 1
- instrumental 1
- instrumental music 1
- medium tempo 1
- moderate tempo 1
- no voices 1
- passionate 1
- programmed percussion 1
- slow dance 1
- soaring melody 1
- spirited 1
- steady drumming 1
- synth 1
- techno song 1
- the blues 1
- trance music 1
- walking bass line 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Combichrist "Get Your Body Beat" Music Video | This techno song features programmed percussion. The kick is played on every count of the beat. A cymbal or shaker is played in sixteenth note patterns. This is accompanied by a synth playing a repetitive sequence. Another synth sound is played in bursts which has a warped sound effect. This song is an instrumental and has no voices. This song can be played in a club. | 2006-06-16T01:22:36Z | Pearry Teo | Get Your Body Beat, Combichrist's new single released in the summer of 6/6/06 following the music video containing clips from the movie "The Gene Generation" | ["Disco", "Music"] | ["techno song", "no voices", "instrumental", "trance music", "programmed percussion", "synth", "moderate tempo", "dance song", "club music"] | 0 | 10dur7jhFQM | 228 | |
American Folk Blues Festival 1983 feat. Carey Bell | The song is an instrumental blues song. The song is medium tempo with a blues harmonica playing a cool melody, walking bass line, guitar accompaniment , steady drumming rhythm and other percussion hits. The song is exciting and groovy. The song has a bad audio quality. | 2006-06-16T20:47:21Z | Harpsucker | Carey Bell-voc/harmonica Louisiana Red-git Jimmy Rodgers-git Lovie Lee-piano Queen Sylvia Embry-bass Charles"Honey Boy"Otis-drums rec-live in germany 1983 | ["Blues", "Music"] | ["blues harmonica", "blues harp", "harpist", "instrumental music", "harmonica player", "groovy bass line", "guitar rhythm", "steady drumming", "the blues", "blues progression", "instrumental music", "soaring melody", "bad audio quality", "blue band", "walking bass line", "blues turn around", "blues legends", "medium tempo", "adventurous", "exciting", "groovy", "slow dance", "passionate", "spirited"] | 1 | GT9g4uqK9G8 | 1725 |
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;