musiccaps_details (view)
10 rows where musiccaps_aspects contains "acoustic drums", musiccaps_author = 9 and musiccaps_names contains "Song"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Auguri di Capodanno divertenti! Felice anno nuovo con canzoni e un video Disney divertente.Buon 2020 | This is a festive music piece used as a theme for a cartoon. It is a slow tempo piece. There is a female vocalist singing melodically. The keyboard is playing the melody while the bass guitar is following in the background. The rhythm consists of a calm acoustic drum beat. The atmosphere is serene. This piece could be playing in the background at a slow dance event. | 2012-12-28T23:51:31Z | EmporioGenova | Auguri di Buon Capodanno 2020 con un video divertente! Auguri di Felice Anno Nuovo con questo video divertente ispirato ai personaggi più famosi delle fiabe Disney, da Biancaneve e i sette nani a Cenerentola, dalla Sirenetta alla Bella e la Bestia, senza dimenticare i Tre Porcellini e gli animali della fattoria! La colonna sonora è l'intramontabile "Happy New Year" degli Abba, mixata con l'altrettanto intramontabile "Happy Days" sigla della nota serie TV anni '70. All'interno del canale youtube Emporio Genova puoi trovare altri video per gli auguri di Natale, Capodanno ed Epifania.... e molto altro ancora, condividili con i tuoi amici su facebook o tramite whatsapp e twitter. ************************************************* SEGUICI SUI SOCIAL: iscriviti al canale youtube: http://www.youtube.com/user/EmporioGenova?sub_confirmation=1 pagina facebook: https://www.facebook.com/emporiogenova/ negozio online: https://emporiogenova.com/ | ["Music", "Music for children", "Song"] | ["cartoon theme", "festive music", "female vocal", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "calm", "serene", "easygoing", "slow tempo"] | 9 | 8fibq2VXibw | 934 | |
| Invencible/Music Club de Vázquez Sounds | This is a live performance of a pop music piece. There is a teenage female vocalist singing melodically in the Spanish language. An acoustic guitar plays the main tune while there is a slow tempo acoustic drum beat in the rhythmic background. The spectators are joining the song at a volume that is sometimes higher than the song itself and it creates an irritating aura. | 2014-09-29T02:14:40Z | Vázquez Sounds Support Mexico | Nuestras redes sociales: Facebook: http://bitly.com/1rW5VpV Youtube: http://bitly.com/1vpC2gw Instagram: http://bit.ly/1oHYlJB Twitter: http://bitly.com/1yEsrar Ask: http://bit.ly/1CKk6AM {Grabado por nosotros} Club de fans oficial. Vazquez Sounds en vivo (Live) | ["Singing", "Music", "Song", "A capella"] | ["live performance", "pop music", "ballad", "teen female vocal", "melodic singing", "acoustic guitar", "acoustic drums", "crowd singing", "emotional", "slow tempo", "spanish"] | 9 | BaMBwXQwK3g | 1263 | |
| MUSICA CRISTIANA Ayudame Señor Jose Felipe | This is a Christian gospel music piece. The male vocalist is singing melodically in the Spanish language. There is an acoustic guitar playing the main melody while a bass guitar plays in the background. In the rhythmic background, the acoustic drums are playing a calm beat. The atmosphere is religious. This music would suit well in Christian religious events in Spanish speaking countries. | 2009-08-18T23:55:02Z | YETSEL | ["Music of Asia", "Christian music", "Music", "Song"] | ["christian", "gospel", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "religious", "devotional"] | 9 | CdgQIiMdBa4 | 1387 | ||
| รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music | This is a Valentine's ballad. The male vocalist is singing gently in the Thai language. There is an acoustic guitar, a piano and a flute playing the melody interchangeably. There is a simple acoustic drum beat in the rhythmic background. The atmosphere of this piece is romantic. It could be used in romantic social media content in Thailand. It could also be used in romantic movies and TV shows that take place in Thailand. | 2016-02-05T05:56:27Z | ป.ฉลาดใหญ่ | รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music ฝากกดติดตามช่อง ป.ฉลาดใหญ่ บันเทิงศิลป์ ด้วยนะครับ คลิกที่ลิ้งค์เลย https://www.youtube.com/channel/UC98T... แสลงใจ อ้ายมีเขา แต่เจ้ามีอ้าย กลิ่นไฟเก่า บ่ฮักกะส่าง อยู่กับอ้ายน้อยใจบ่ ผัวสำรอง เมียสำรอง ฮัก คารม ซ่อยข่อยแหน่ | ["Music of Asia", "Music", "Song", "Happy music"] | ["ballad", "male vocal", "gentle singing", "acoustic guitar", "piano", "flute", "acoustic drums", "sentimental", "romantic", "valentines", "thai"] | 9 | L0oun9F67tg | 2142 | |
| Christian Music Mix #2, 19 songs!! | This is a poor quality Christian pop music compilation. There are many pieces sung by male and female voices melodically. The usual theme of the instrumental backing consists of a tune played in major key by an electric guitar and a bass guitar alongside a simple acoustic drum beat. The overall atmosphere is uplifting. This mix could be used in a movie to imply the sounds coming from a gospel radio station in passing. | 2009-04-13T01:50:06Z | AudioMan62 | This is The second installment of my christian music mix. be sure to listen my first one! enjoy! Made about 2002. | ["Christian music", "Guitar", "Music", "Musical instrument", "Pop music", "Song"] | ["compilation", "poor quality", "christian pop", "male vocal", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "major key", "positive", "uplifting", "religious"] | 9 | RPqz3vJYMLQ | 2697 | |
| Whose Uncle Is This On The Tambourine??? | This is a live Christian gospel music performance. There is male lead vocal singing melodically and passionately with the backing of a male choir. The melody is being played by a church organ and a bass guitar. The acoustic drums and the tambourine played in a very eccentric manner are the elements of the rhythmic background. The atmosphere is religious. This piece could be played at Christian religious events or in the background of Christian social media content. | 2012-04-02T03:09:21Z | Thebookoffunny dotcom | Check Out this Wonderful Black Youtube Family based on Faith, Family,Film! www.Youtube.com/thefamilyoyoutube ► Subscribe to their Channel Here: http://www.youtube.com/subscription_center?add_user=blessedfilmsinc | ["Music", "Song", "Tambourine"] | ["gospel", "preach", "live performance", "male vocal", "melodic singing", "male choir", "organ", "bass guitar", "acoustic drums", "tambourine", "groovy", "religious", "christian church"] | 9 | XvtL_TTLXHY | 3236 | |
| Strawfoot - churchyard cough live | This is a country music piece. There is a male vocalist singing in a preaching manner. The melody is being played by a violin, a banjo and an electric guitar while an upright bass is playing in the background. The rhythmic background consists of an accentuated acoustic drum beat. The atmosphere is lively and hard-hitting. This piece could be used in the soundtrack of a historical crime movie taking place in the US. | 2009-06-01T06:07:26Z | Word Smith | Dirge-Country pioneers, Strawfoot, bring a dark sound of candy-coated salvation and eternal hellfire and damnation to the public with haunting cautionary tales of outlaw scarecrows, wayward preachers, falling pianos, and the devil. Strawfoot creates an original sound steeped in the rich, dark history of America and beyond. Fronted by a crazed and angry preacher, Strawfoot is a seven-piece band consisting of violin, banjo, harmonica, upright bass, guitar, percussion and the occasional mandolin and accordian. Strawfoot has quickly become a fan favorite wherever they take the stage, gaining fans across America and abroad. | ["Music", "Ska", "Song", "Rock and roll"] | ["country music", "male vocal", "preach-like singing", "violin", "banjo", "electric guitar", "upright bass", "acoustic drums", "lively", "hard-hitting"] | 9 | adYFXYPqo2M | 3562 | |
| ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 | ||
| wa love songs (ai yawn rai ) | This is a hmong pop music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the piano, the acoustic guitar and the bass guitar. The rhythm is being played on the acoustic drums. There is a sentimental, romantic feel to it. The piece could be used in a romantic movie/TV show with a Hmong-language speaking setting. | 2012-12-06T21:05:00Z | ainapyawn hopang saniex hopang | wa love songs (ai yawn rai) | ["Music", "Independent music", "Song"] | ["hmong pop", "male vocal", "melodic singing", "piano", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "emotional", "romantic", "normal tempo", "simple tune"] | 9 | jhgX0OOoytQ | 4274 | |
| Jim Reeves on the Grand Ole Opry This May Well Be The Best Jim Reeves Video on Youtube www keepvid com | This is a country/western swing music piece. There is a male vocalist singing melodically in the lead with a story-telling attitude. The main tune is being played by the electric guitar with a bass guitar backing. The rhythm is being played by the acoustic drums. The atmosphere is easygoing. This piece could be playing in the background at an American roadside diner. | 2010-06-16T20:31:33Z | petedrakemusic | ["Singing", "Country", "Music", "Ska", "Song"] | ["country music", "western swing", "male vocal", "melodic singing", "story-telling mood", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "groovy"] | 9 | ymGg5TA2YfM | 5437 |
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;