musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2008-09-28
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- ambient street noise 1
- arabic folk singer 1
- cowbell 1
- crowd noise 1
- digital drums 1
- excited vocals 1
- folk singer 1
- groovy bass line 1
- instrumental 1
- live audience 1
- live band 1
- live performance 1
- male singer 1
- male voices singing/rapping 1
- medium tempo 1
- no melody 1
- no other instrument 1
- no percussion 1
- no voice 1
- one note 1
- one string 1
- piano 1
- poor audio quality 1
- positive vibes 1
- salsa/hiphop 1
- screaming 1
- steady drumming rhythm 1
- trumped sample 1
- ukulele music 1
- uptempo 1
- violin playing solo 1
- wedding music 1
musiccaps_names (array) 12 ✖
- Music · 3 ✖
- Guitar 1
- Jazz 1
- Music of Africa 1
- Musical instrument 1
- Orchestra 1
- Plucked string instrument 1
- Rapping 1
- Rhythm and blues 1
- Soul music 1
- Speech 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CORREA BROTHERS INC, ESCOBAR MUSIC, MIXTER ED, PBM,AMY BELL | This song is a classical flamenco mixed with a HipHop groove drums playing a digital set along with a cowbell sound. A piano is playing a salsa melody in the low to high range. A trumpet sample is playing a short melody every fourth beat. A male voice is singing in a higher pitch along with backing vocals spread across both sides of the speakers. Then another male voice takes over rapping over the instrumental. This song may be playing with a speaker sitting on the bike cruising. | 2008-09-28T09:12:17Z | Ed Correa | CORREA BROTHERS INC, ESCOBAR MUSIC, MIXTER ED, PBM,AMY BELL | ["Music of Africa", "Music", "Rapping", "Rhythm and blues", "Soul music"] | ["salsa/hiphop", "digital drums", "cowbell", "trumped sample", "piano", "male voices singing/rapping", "uptempo", "positive vibes"] | 6 | LF-5BAUGvWI | 2166 | |
salam- pentru cristofor la udi | A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. | 2008-09-28T14:54:29Z | elicsir0515 | talent:X | ["Jazz", "Music", "Orchestra", "Speech"] | ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] | 1 | bZJoTauRldE | 3634 | |
Stimmen | This music features a ukulele being played. Only one string is played for tuning. This clip can be used to tune the G string of the ukulele. There are no voices in this clip. There are no other instruments in this clip. | 2008-09-28T14:10:27Z | Ukulehrer | so kannst du deine Ukulele stimmen. Am Schluss vom Video zeige ich, wie du dich selbst kontrollieren kannst. | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["ukulele music", "no other instrument", "no percussion", "no voice", "instrumental", "one string", "one note", "no melody"] | 0 | hZfCziBaGTI | 4119 |
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;