musiccaps_details (view)
2 rows where "youtube_published" is on date 2008-07-11
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- animated 1
- bass 1
- busy music 1
- club music 1
- dance hits 1
- dance music 1
- electro pop 1
- electronic instrumentation 1
- emphatic vocals 1
- fast tempo 1
- female singer 1
- foreign language 1
- groovy bass line 1
- hand claps 1
- keyboard harmony 1
- male voice 1
- programmed percussion 1
- reggae song 1
- repetitive melody 1
- saxophone 1
- slow tempo 1
- spirited 1
- spirited drumming 1
- synthesiser arrangements 1
- upbeat electronic riff 1
- vibrant 1
- vivacious 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Reggae 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chaka Demus & Half Pint - Hold On (Hold On Riddim) | This reggae song features a male voice singing the main melody. The vocal melody is repetitive. This is accompanied by programmed percussion playing a reggae beat. Hand claps are played at regular intervals. The bass plays a groovy bassline. A saxophone plays fills in between lines. This song has a reggae feel. This song can be played in a Caribbean style party. | 2008-07-11T16:51:53Z | *Clanccy* | Chaka Demus & Half Pint - Hold On (Hold On Riddim) | ["Music", "Reggae"] | ["reggae song", "male voice", "saxophone", "programmed percussion", "bass", "hand claps", "repetitive melody", "slow tempo"] | 0 | 30tNWUyJCog | 431 | |
I Say Yes (Zero no Tsukaima - Futatsuki no Kishi) | A female vocalist sings this energetic song. The tempo is fast with enthusiastic drumming, funky bass line, keyboard harmony and synthesiser arrangements. The song is youthful, vibrant, vivacious, hyper, spirited, passionate, bright and has a dance groove. This song is an Electro Pop song. | 2008-07-11T15:03:54Z | Aiath86 | Album: Exit Trance Presents Speed Anime Trance Best 4 | ["Music", "Trance music"] | ["female singer", "fast tempo", "foreign language", "dance music", "dance hits", "club music", "dance music", "electronic instrumentation", "synthesiser arrangements", "spirited drumming", "keyboard harmony", "groovy bass line", "busy music", "electro pop", "animated", "spirited", "emphatic vocals", "youthful", "upbeat electronic riff", "vibrant", "vivacious"] | 7 | BkoCi-IZccI | 1287 |
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;