musiccaps_details (view)
2 rows where "youtube_published" is on date 2008-01-14 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- acoustic guitar 1
- aggressive 1
- animated 1
- auto harp 1
- banjo 1
- cello 1
- cheerful 1
- concert 1
- country folk music 1
- country music 1
- distorted bass guitar 1
- energetic 1
- energetic cymbals 1
- enthusiastic 1
- fast tempo 1
- fiddle 1
- fun 1
- high energy 1
- live audience 1
- live performance 1
- lively backup 1
- lively vocals 1
- male vocalist 1
- manic 1
- merry 1
- metal 1
- punchy kick 1
- punchy snare 1
- regional music 1
- repetitive aggressive male vocals 1
- screaming 1
- vocalisation 1
- wide aggressive electric guitar chords 1
- wide toms roll 1
musiccaps_names (array) 7 ✖
- Music 2
- Angry music 1
- Banjo 1
- Bluegrass 1
- Country 1
- Musical instrument 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 | |
Endo - Suffer (Official Music Video) | The Metal song features a repetitive, aggressive male vocal screaming over wide, aggressive electric guitar chords, distorted bass guitar, punchy snare and kick hits and energetic cymbals. There is a toms roll at the end of the loop. It sounds aggressive, energetic and manic - like something you would jump into a mosh pit at the concert. | 2008-01-14T16:17:42Z | cucuzza21 | This is the official music for Endo's song "Suffer" off their debut album "Evolve". Enjoy! | ["Music", "Angry music"] | ["metal", "wide aggressive electric guitar chords", "repetitive aggressive male vocals", "screaming", "distorted bass guitar", "punchy snare", "wide toms roll", "energetic cymbals", "aggressive", "energetic", "manic", "punchy kick"] | 4 | w6zHc6nRJ0o | 5242 |
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;