musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "strings"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- acoustic drums · 6 ✖
- acoustic guitar · 6 ✖
- strings · 6 ✖
- bass guitar 2
- e-bass 2
- female vocal 2
- female voice singing 2
- generic 2
- gospel 2
- melodic singing 2
- 2 separate songs 1
- backing song 1
- bland 1
- castanets 1
- devotional 1
- educational 1
- emotional 1
- flamenco/ballad 1
- jewish 1
- jingle 1
- longing 1
- male vocal 1
- medium to uptempo 1
- minor key 1
- monotonous 1
- out-of-tune singing 1
- people shouting 1
- pingpong 1
- pop 1
- pop rock 1
- pulse effect 1
- religious 1
- sad atmosphere 1
- sensual 1
- sentimental 1
- tension 1
musiccaps_names (array) 11 ✖
- Music 5
- Christian music 1
- Flamenco 1
- Gospel music 1
- Independent music 1
- Jingle (music) 1
- Music of Latin America 1
- Ping 1
- Singing 1
- Swing music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Dota heroes sexy | This is a pop rock piece. There is a female vocalist singing melodically at the forefront. The melody is being played by a wide-sounding strings section and an acoustic guitar. The bass guitar is playing the root notes in the background. The rhythmic structure is provided by a simple acoustic drum beat. The song is in minor key. The atmosphere is sentimental and filled with longing. This piece could be included in the soundtrack of a teenage drama movie or TV series. | 2010-02-13T16:45:07Z | elbertjann benitez | the best hero and my favorite hero my favorite is mirana the best hero of me ^^ | ["Christian music"] | ["pop rock", "female vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "longing", "minor key"] | 9 | 5P5XAclO8ko | 659 | |
MINUTE MAID NUTRIBOOST - #DuelDuet Adu Ping Pong | This is a jingle piece in the background of an advertisement video. There is an acoustic guitar playing a generic tune while medium-pitched strings can be heard accompanying it. There is a slightly fast-paced acoustic drum beat as the rhythmic background. Sounds can be heard related to the ad such as a blood pulse sound effect, a pingpong ball bouncing and people shouting. The overall atmosphere is generic. | 2014-12-18T08:48:17Z | Nutriboost Indonesia | Final Battle antara The Dandees VS Cow & Orange nih! Lihat gokilnya aksi mereka adu ping pong. | ["Music", "Ping"] | ["jingle", "strings", "acoustic guitar", "acoustic drums", "pulse effect", "pingpong", "people shouting", "tension", "generic"] | 9 | A2NtJ12KIuU | 1059 | |
80 MÚSICAS GOSPEL EM UM SÓ VÍDEO -VÍDEO 1/4 | A female voice is singing a ballad with some reverb on her voice while an acoustic guitar is finger-picking chords on the left side of the speakers. A string section is playing harmonies along with the singer. A e,bass is played along with shakers and ride hits from a drummer. A piano is playing along with the melody. The elements are spread across the sides of the speakers. | 2011-05-29T15:39:46Z | Raquel Lerbach | 80 Músicas Gospel em apenas um vídeo LOUVORES MÚSICA CRISTÃ HINO EVANGÉLICO HINOS LOUVOR ADORAÇÃO MUSIC GOSPEL GOSPEL MÚSICAS ESPIRITUAIS | ["Gospel music", "Music", "Tender music"] | ["gospel", "2 separate songs", "strings", "acoustic guitar", "acoustic drums", "e-bass", "female voice singing", "medium to uptempo"] | 6 | DA8lw6Mq0DY | 1447 | |
אברימי רוט - אלבום 'אמת ויציב' ♫ Rote&Green Sampler | This is a Jewish gospel music piece. There is a male vocalist singing melodically in the Hebrew language. A strings section is playing the melody with the acoustic guitar and the bass guitar in the backing. In the rhythmic background, the acoustic drums are playing a simple 4/4 beat. The atmosphere of this piece is religious/devotional. It could be used in Jewish religious events or related social media content. | 2013-09-16T12:16:05Z | אברימי רוט Avremi Roth | אברימי בפייסבוק: https://Facebook.com/AvremiR אברימי באינסטגרם: https://instagram.com/avremiroth אברימי בטוויטר: https://Twitter.com/avremi_roth אברימי ביוטיוב: https://YouTube.com/ybaudio להזמנת אירועים ומופעים: נייד: 054-8087150 דוא"ל: Avremiroth@gmail.com | ["Swing music", "Music", "Independent music"] | ["jewish", "gospel", "male vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "religious", "emotional", "devotional"] | 9 | JU4CZ-GApu4 | 2010 | |
Science Jingle (Today Innovation Begins) | This is an educational pop music piece. There is a female vocalist singing out-of-tune. The strings and the acoustic guitar are playing a simple tune while the rhythmic background is provided by a basic acoustic drum beat. The aura of the piece is generic and monotonous. The quality of the recording is subpar. It might be useful in the class setting. | 2014-09-18T13:42:20Z | Anna Clarissa Regala | My very own Science Jingle with the theme, "Strengthening Innovation." (dedicated to Grade 3 Pupils Batch 2014-2015 of Ms. Anna Liza Campo) | ["Jingle (music)", "Music"] | ["pop", "educational", "female vocal", "out-of-tune singing", "strings", "acoustic guitar", "acoustic drums", "generic", "bland", "monotonous"] | 9 | PQrYV7hJWDg | 2535 | |
山口かおる♪『哀愁フラメンコ』 | This song contains a female voice singing in the mid to higher register sounding sensual and sad. She is singing along to a backing track containing acoustic drums playing along with an e-bass. Castanets typical for latin music, an acoustic guitar, plucked and long notes being played by strings giving the song a feeling of flamenco music. In the background you can hear the crowd giving applause. This song may be playing as a live concert. | 2008-11-15T08:18:47Z | kakiuchi takeo | テレビ画面より | ["Singing", "Flamenco", "Music", "Music of Latin America"] | ["flamenco/ballad", "female voice singing", "backing song", "e-bass", "castanets", "acoustic drums", "strings", "acoustic guitar", "sensual", "sad atmosphere"] | 6 | nvrMO6TDu2g | 4593 |
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;