musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "love song" and musiccaps_names contains "Country" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- emotional 2
- love song · 2 ✖
- romantic 2
- acoustic guitar 1
- ambient hall noise 1
- auto harp 1
- banjo 1
- bass guitar 1
- booming bass line 1
- buzzing tones 1
- cello 1
- classic pop songs 1
- country dance 1
- country love song 1
- country pop 1
- country song 1
- country song hits 1
- couples dancing 1
- dance floor 1
- dance hall 1
- duet 1
- electric guitar 1
- fiddle 1
- fiddle playing 1
- first love 1
- folk music 1
- guitar rhythm 1
- high gain noise 1
- intense drumming 1
- keyboard harmony 1
- love you much 1
- male singer 1
- mandolin 1
- medium tempo 1
- passionate 1
- people dancing 1
- poor audio quality 1
- proposal song 1
- retro dance hits 1
- slow dance music 1
- slow tempo 1
- song climax 1
- steady drumming rhythm 1
- violins 1
- wedding song 1
musiccaps_names (array) 4 ✖
- Country · 2 ✖
- Music 2
- Singing 2
- Tambourine 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 | |
Cowboy Cha Cha (partner dance) by Silver Spurs France | A male singer sings this retro pop melody. The song is medium tempo with a steady drumming rhythm, steady bass line, guitar accompaniment, and fiddler playing. The song is romantic and slow dance-like. The audio quality is very poor. | 2010-07-05T10:34:29Z | Shirley Davidson | Dance.......Cowboy Cha Cha Choreographed by Toshio Suzuki Music .......I Just Wanna Dance With You by George Strait Danced by dancers from Silver Spurs South West France at a social event July 2010. | ["Singing", "Country", "Music", "Tambourine"] | ["slow tempo", "slow dance music", "people dancing", "couples dancing", "dance hall", "dance floor", "ambient hall noise", "poor audio quality", "buzzing tones", "high gain noise", "male singer", "classic pop songs", "retro dance hits", "country dance", "emotional", "romantic", "fiddle playing", "guitar rhythm", "steady drumming rhythm", "love song", "love you much", "booming bass line"] | 1 | B8pesuUc8Ek | 1209 |
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;