musiccaps_details (view)
3 rows where "youtube_published" is on date 2015-05-16 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- 1970's 1
- animated 1
- captivating 1
- chill 1
- electronic music 1
- emotional 1
- emotional punchy bass line 1
- engaging 1
- enthusiastic 1
- female vocal backup 1
- funky drumming 1
- futuristic 1
- groovy 1
- hard rock 1
- impactful 1
- informative 1
- inspirational 1
- instrumental music 1
- intense 1
- intense drumming 1
- keyboard harmony 1
- last tempo heavy metal 1
- male vocalist 1
- male vocals 1
- male voice speaking 1
- medium tempo 1
- melodic 1
- off beat guitar strums 1
- passionate 1
- persuasive 1
- phaser 1
- reggae 1
- reggae drum beat 1
- review 1
- roots reggae 1
- sentimental 1
- simple bassline 1
- soothing 1
- spirited 1
- techno music 1
- tropical 1
- video game music 1
- vigorous 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 3
- Reggae 2
- Angry music 1
- Soul music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Top 10 Robots | This music is an electronic instrumental. The tempo is fast with heavily synthesised arrangements and intense drumming with a male voice speaking over the music. The music is intense, vigorous,animated, futuristic and vital. It sounds like video game music and the male voice seems to be reviewing Video Games. | 2015-05-16T05:12:56Z | GameTrailers | Sometimes, when you need a friend, you have to build one. We assemble all the greatest creations in video games and determine who is the most loyal and effective. | ["Music", "Speech", "Angry music"] | ["instrumental music", "vigorous", "animated", "spirited", "enthusiastic", "intense drumming", "last tempo heavy metal", "hard rock", "electronic music", "video game music", "male voice speaking", "intense", "electronic music", "techno music", "futuristic", "review", "informative"] | 7 | Xn0wIqnt_44 | 3223 | |
Bob Marley & The Wailers - Stir It Up | Chill, tropical roots reggae music from the 1970's featuring a male vocalist, vocal harmonies, off beat guitar strums, phaser effect, a reggae drum beat and a simple bass part. | 2015-05-16T05:12:29Z | doogie Five-Four | Track 1 From Bob Marley & The Wailers - The Very Best of Bob Marley & The Wailers (Limited Edition) (2001) | ["Music", "Reggae", "Soul music"] | ["roots reggae", "chill", "tropical", "male vocals", "vocal harmony", "off beat guitar strums", "phaser", "1970's", "reggae drum beat", "simple bassline"] | 8 | AFWy1qyyMHE | 1092 | |
Bob Marley & The Wailers - One Love / People Get Ready | A male vocalist sings this beautiful Reggae song. The tempo is medium with a keyboard harmony, punchy and infectious bass line and funky drumming with harmonic vocal backup. The song talks about world peace, kindness towards humankind and unity. The song is inspirational, passionate, youthful, emotional,persuasive,impactful, melodic , engaging and captivating. | 2015-05-16T05:31:51Z | doogie Five-Four | Track 12 From Bob Marley & The Wailers - The Very Best of Bob Marley & The Wailers (Limited Edition) (2001) | ["Music", "Reggae"] | ["male vocalist", "medium tempo", "keyboard harmony", "emotional", "youthful", "passionate", "emotional punchy bass line", "funky drumming", "female vocal backup", "reggae", "inspirational", "emotional", "sentimental", "persuasive", "impactful", "soothing", "melodic", "engaging", "captivating", "groovy"] | 7 | opu2tXoVNKU | 4658 |
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;