musiccaps_details (view)
2 rows where musiccaps_aspects contains "high spirits" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- high spirits · 2 ✖
- slow tempo · 2 ✖
- asian stringed instruments 1
- backup singers 1
- bad audio quality 1
- deteriorated audio quality 1
- devotional 1
- drunken stupor 1
- emotional 1
- female singer 1
- groovy bass line 1
- groovy rhythm 1
- hip hop dance music 1
- hip hop music 1
- inspiring 1
- keyboard accompaniment 1
- love song 1
- male singer chanting 1
- meditational 1
- modern hip hop hits 1
- motivational 1
- prayer chanting 1
- psychedelic chanting 1
- romantic 1
- self discovery 1
- steady percussive rhythm 1
- story telling 1
- trance 1
- trippy music 1
- vocal chanting 1
- warbled string harmony 1
musiccaps_names (array) 3 ✖
- Music 1
- Rhythm and blues 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nhạc Ru Bé Ngủ Dân Ca Nam Bộ | A male singer sings this chanting vocals. The song is slow tempo with stringed instrument harmony that warbles and creates a psychedelic effect with no percussion. The song is trance and probably a prayer chant. The song is poor in audio quality. | 2015-03-21T14:12:10Z | Đặng Hoàng Phúc | Cho bé giấc ngủ ngon. | ["Music", "Sitar"] | ["bad audio quality", "warbled string harmony", "male singer chanting", "slow tempo", "psychedelic chanting", "trippy music", "trance", "asian stringed instruments", "meditational", "high spirits", "drunken stupor", "vocal chanting", "devotional", "prayer chanting", "deteriorated audio quality"] | 1 | BSe5J0KlN3k | 1241 | |
Won-G feat. Rick Ross and Dwyntercold "Rich Together" OFFICIAL VIDEO | A female singer sings this passionate melody backed up by singers in vocal harmony. The tempo is slow with a strong bass line, steady percussive rhythm and keyboard accompaniment. The song is emotional and spirited. The song is a modern hip hop hit. | 2015-10-10T14:09:19Z | officialwong | ["Rhythm and blues"] | ["female singer", "hip hop music", "backup singers", "modern hip hop hits", "slow tempo", "groovy bass line", "steady percussive rhythm", "keyboard accompaniment", "story telling", "emotional", "motivational", "inspiring", "groovy rhythm", "hip hop dance music", "emotional", "romantic", "love song", "high spirits", "self discovery"] | 1 | PBMfPDei93s | 2516 |
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;