musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-04-29
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| tribute to Oi, ska & Punk | This punk rock song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat. A distortion guitar plays power chords using downstrokes. The bass plays the root notes of the chords. This song is played at a moderate tempo. This song can be played at the end credits of an action movie. | 2009-04-29T02:58:40Z | skinbash69 | This is the tribute to all of my friends in the Oi, Ska & Punk Scene in the asian countries such as Singapore, Malaysia, Indonesia, Philippines & Brunei. Keep the scene alive...CHEER. | ["Heavy metal", "Music", "Punk rock", "Ska", "Progressive rock"] | ["punk rock", "male voice", "distortion guitar", "percussion", "bass", "moderate tempo", "upbeat song"] | 0 | PP3kNqPM434 | 2532 | |
| Possibility - Sierra Noble [OFFICIAL MUSIC VIDEO] (cc) | The Country song features a soft female vocal singing over repetitive arpeggiated acoustic guitar melody. It sounds heartfelt, emotional, passionate and hopeful, like something you would listen to when having a tough time. | 2009-04-29T06:57:28Z | sierranoblemusic | Official music video for Sierra Noble's "Possibility" - April 2009 www.sierranoble.ca Directed by: Jeth Weinrich www.redworldeditions.com www.myspace.com/jethweinrich Maple Music Recordings, Canada | ["Music", "Sad music"] | ["emotional", "soft female vocal", "country", "repetitive arpeggiated acoustic guitar", "passionate", "heartfelt", "hopeful"] | 4 | UIOnnpaqBy8 | 2904 | |
| Fromel Seraph Chorus Pedal Demo by Bobby DeVito Boss Dimension C DC-2 clone | This is an amateur low-resolution recording of an electric guitar with the chorus pedal effect. The player keeps on strumming chords to show the effect of the pedal. This piece could be used as an old-fashioned rock guitar sample for a beat. | 2009-04-29T20:41:48Z | Robert DeVito | A quick video demo of the AMAZING Seraph Chorus by John Fromel -- this is a clone of the sought after and long discontinued analog DC-2 Dimension C chorus from BOSS -- a chorus pedal for people who don't like chorus pedals! Also using the Catalinbread DLS pedal and the Fromel GO! pedal for a little dirt, as well as the Mad Professor Deep Blue Delay for some ambience. | ["Effects unit", "Music", "Chorus effect", "Plucked string instrument"] | ["jam", "electric guitar", "chorus pedal", "strumming", "lo-res"] | 9 | uoee1ikakWY | 5137 |
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;