musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- acoustic guitar · 3 ✖
- emotional 3
- keyboard harmony · 3 ✖
- romantic · 3 ✖
- love song 2
- male singer 2
- mandolin 2
- medium tempo 2
- soothing 2
- auto harp 1
- banjo 1
- bass guitar 1
- calm 1
- cello 1
- country love song 1
- country pop 1
- country song 1
- country song hits 1
- duet 1
- electric guitar 1
- fiddle 1
- fingers snapping 1
- first love 1
- fog horn 1
- folk music 1
- folk song 1
- foreign language 1
- funky bass line 1
- groovy bass line 1
- intense drumming 1
- male voice speaking 1
- passionate 1
- pleasant 1
- proposal song 1
- r&b 1
- reggae 1
- slow tempo 1
- soft melodious 1
- song climax 1
- soul 1
- soulfu 1
- soulful 1
- soulfulromantic 1
- sound of horn 1
- steady drumming 1
- super imposed male voice 1
- synthesiser articulation 1
- violins 1
- wedding song 1
- world music 1
musiccaps_names (array) 7 ✖
- Music 3
- Country 1
- Folk music 1
- Reggae 1
- Singing 1
- Song 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Country Top 10 Wedding Slow Songs - Twin Cities Wedding DJs MN | This song is a romantic duet. The tempo is medium with a plethora of instruments like the auto harp, fiddle, acoustic guitar, electric guitar, bass guitar, banjo,intense drumming, cello, violin harmony and vocal harmony. The song is a romantic, charming,emotional, passionate love song. The instrumentation style and music decibels indicate that this is the climax of a country love song. | 2011-07-01T05:49:25Z | TwinCities WeddingDJs | Top Ten Country slow songs. Twin Cities Wedding DJs MN. http://www.twincitiesweddingdjs.com These are the Top Ten Country slow songs for wedding receptions and company parties. *** The edited material is briefly referenced for educational purposes *** | ["Singing", "Country", "Music"] | ["duet", "medium tempo", "country song", "fiddle", "auto harp", "song climax", "country love song", "first love", "wedding song", "proposal song", "banjo", "mandolin", "acoustic guitar", "intense drumming", "keyboard harmony", "cello", "violins", "electric guitar", "bass guitar", "love song", "romantic", "passionate", "emotional", "country song hits", "country pop", "folk music"] | 7 | AagemOzvoZE | 1141 | |
tsehay yohannes - Old music | A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, | 2012-06-02T11:28:06Z | Banchi Avera | This song taking me back to my past ......... | ["Folk music", "Music", "Tender music"] | ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] | 7 | c9h4p6325Xo | 3684 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 |
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;