musiccaps_details (view)
3 rows where "youtube_published" is on date 2012-03-05 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- acoustic drums 1
- aggressive percussion 1
- aggressive voice 1
- amateur recording 1
- bassline 1
- crickets chirping 1
- defiant mood 1
- distortion guitar 1
- e-bass saxophones/brass 1
- e-guitars 1
- flute 1
- guitar fills 1
- guzheng 1
- heavy metal song 1
- male voices 1
- male voices singing/shouting 1
- medium tempo 1
- piano 1
- rock&roll 1
- screaming vocals 1
- string instruments 1
- traditional 1
- uplifting energy 1
- uptempo 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kid Rock - American Badass (DIRTY) HQ | This heavy metal song features a male voice singing the main melody. The song starts with male voices singing 'hey, hey'. This is accompanied by aggressive percussion playing a rock beat. A distortion guitar is playing lead fills and another distortion guitar playing power chords. The bass plays the root notes of the chords. Another voice comes in and is screaming at a high pitch. This is accompanied by continuous snare hits for 8 bars. The main voice starts singing at this time and is accompanied by rock percussion. The bass plays the same root notes once again and the distortion guitar plays a riff in the background. The other guitar continues to play lead fills. The mood of this song is defiant. This song can be played in a rebel themed movie. | 2012-03-05T16:54:46Z | SickRockMusic | Wallpaper made by me. Song: American Badass Artist: Kid Rock Album: History of rock | ["Music", "Angry music"] | ["heavy metal song", "aggressive percussion", "male voices", "screaming vocals", "distortion guitar", "bassline", "guitar fills", "aggressive voice", "defiant mood"] | 0 | sHbGsZUsisE | 4938 | |
06. KISS - Do You Remember Rock and Roll Radio ( A tribute to Ramones) | This song contains male voices singing/shouting while an acoustic drum is playing an elevating pattern on the toms. You can hear hands clapping to the beat. A brass section/saxophones are playing a repeating melody creating tension. Then the song breaks into the next part with a piano playing along with the melody. This song may be playing at a live concert. | 2012-03-05T19:29:37Z | shunandro | I do not own the rights of the music | ["Music", "Roll", "Rock and roll"] | ["rock&roll", "e-guitars", "piano", "e-bass saxophones/brass", "acoustic drums", "male voices singing/shouting", "uplifting energy", "uptempo"] | 6 | U6SYfguaJtk | 2887 | |
ทยอยใน เถา วงเครื่องสาย คณะศิลปกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย | This song contains string instruments being played with a bow playing the main melody. Coming in after a flute starts playing the melody. An acoustic instrument is providing the rhythm. A guzheng is playing the same melody in a lower register. In the background you can hear crickets chirping. This song may be playing as a live performance from a music school. | 2012-03-05T21:28:19Z | Saisaw | ทยอยใน เถา จุฬาวาทิต ครั้งที่ ๑๗๐ วงเครื่องสาย คณะศิลปกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย ควบคุมการบรรเลงโดย ศาสตราภิชานปกรณ์ รอดช้างเผื่อน และคณะ วันศุกร์ที่ ๒ มีนาคม ๒๕๕๕ เวลา ๑๗.๓๐ น. | ["Music", "Rattle (instrument)", "Bowed string instrument"] | ["traditional", "string instruments", "guzheng", "flute", "crickets chirping", "amateur recording", "medium tempo"] | 6 | 9m0tNvskmTc | 1039 |
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;