musiccaps_details (view)
4 rows where musiccaps_aspects contains "high spirits" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 67 ✖
- high spirits · 4 ✖
- backup singers 2
- groovy bass line 2
- memdium tempo 2
- poor audio quality 2
- slow tempo 2
- adventurous 1
- asian stringed instruments 1
- bad audio quality 1
- classic rock instrumental 1
- classic rock playlist 1
- cymbals crashing 1
- deteriorated audio quality 1
- devotional 1
- disco music 1
- distortion guitar accompaniment 1
- driving song 1
- drunken stupor 1
- electric guitar rhythm 1
- emotional 1
- female singer 1
- flower power 1
- groovy rhythm 1
- guitar lead 1
- high on adrenaline 1
- hip hop dance music 1
- hip hop music 1
- hippie generation 1
- hissing sounds 1
- home music video 1
- inspiring 1
- instrumental music 1
- keyboard accompaniment 1
- love song 1
- male singer 1
- male singer chanting 1
- meditational 1
- medium tempo 1
- modern hip hop hits 1
- motivational 1
- never give up 1
- passionate 1
- peace 1
- prayer chanting 1
- psychedelic chanting 1
- psychedelic rock 1
- rebellious 1
- relaxing 1
- repeated vocal phrasing 1
- rhythm guitar 1
- romantic 1
- self discovery 1
- song cover 1
- spirited 1
- steady bass line 1
- steady percussive rhythm 1
- steady rock drumming 1
- story telling 1
- strong rock drumming 1
- teen age spirit 1
- the sixties 1
- trance 1
- trippy music 1
- vocal chanting 1
- vocal harmony 1
- warbled string harmony 1
- youthful retro rock 1
musiccaps_names (array) 10 ✖
- Music 3
- Heavy metal 2
- Progressive rock 2
- Punk rock 2
- Rock music 2
- Blues 1
- Grunge 1
- Psychedelic rock 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 | |
My Grandfather's Clock with tabs | The song is an instrumental. The song is medium tempo with an electric guitar playing lead and distorted guitar rhythm, along with groovy bass line and rock drumming rhythm. The song is exciting and spirited. The song is a classic rock instrumental with poor quality audio. | 2007-08-16T21:36:56Z | Rockaholick1 | This video got mirrored when I recordet it! I do not play a left-handed guitar in this video!! Sponsored by Dean Markley inc.: http://www.deanmarkley.com/ If you like what you hear then SUBSCRIBE, as I probably will be releasing more material soon! For tabs and backing track, go here: http://kabudono01.s344.xrea.com/download_ookina/ A SPECIAL THANKS TO ALL WHO LEAVE A COMMENT AND RATING! A pure Rock N' Roll song for all the Rockaholics out there! Played with the amazing Gibson Custom EDS-1275! | ["Blues", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["instrumental music", "guitar lead", "spirited", "song cover", "passionate", "home music video", "high spirits", "never give up", "adventurous", "classic rock playlist", "relaxing", "driving song", "distortion guitar accompaniment", "rhythm guitar", "classic rock instrumental", "memdium tempo", "groovy bass line", "steady rock drumming", "high on adrenaline", "poor audio quality"] | 1 | Lrhy2auO6hY | 2226 | |
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 | ||
Haymarket Riot-Trip On Out | A male singer sings this melody with a backup singer in vocal harmony. The song is medium tempo with a strong rock drumming rhythm, steady bass line and a guitar playing a groovy rhythm. The song is youthful and spirited. The audio quality is poor with hissing noises. The song is a sixties psychedelic rock song. | 2009-01-29T23:06:39Z | scrambledheadz | U.S Psychedelic Garage Fuzz,1968. | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "disco music", "medium tempo", "hippie generation", "backup singers", "vocal harmony", "psychedelic rock", "the sixties", "peace", "memdium tempo", "electric guitar rhythm", "steady bass line", "strong rock drumming", "poor audio quality", "hissing sounds", "cymbals crashing", "youthful retro rock", "high spirits", "teen age spirit", "rebellious", "flower power", "repeated vocal phrasing"] | 1 | Qz2PIXM60iE | 2654 |
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;