musiccaps_details (view)
4 rows where "youtube_published" is on date 2007-11-11
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| AGK Angry German Kid vs Stacey Hedger-Star Wars Trumpet Solo | This audio contains an acoustic drum playing a groove along with a simple bassline. Trumpets are playing a melody that sounds out of tune and all over the place while a kids voice is streaming and you can hear some aggressive clicking sounds. This song may be playing for a parody video. | 2007-11-11T13:53:01Z | nexiva | Angry German Kid takes on his most talentless opponent yet: Stacey Hedger, from the infamous "Star Wars Trumpet Solo" pageant video. This continues the tradition of the AGK videos where fake english subtitles are overlayed the original vision, and intercut with a cult internet video. | ["Brass instrument", "Trumpet"] | ["amateur recording", "kids voice streaming", "trumpets", "acoustic drums", "e-bass", "out of tune", "parody", "medium to uptempo"] | 6 | -mB_XLq6g1g | 84 | |
| A shofar "TeddYYYYYy el SHOFAR" | Someone is playing a shofar in a high frequency blowing overtones in the higher register before dropping into the high-mid range. At the end you can hear a backing track playing. This song may be playing at home while enjoying your instrument. | 2007-11-11T14:29:57Z | silverdet | shofar at church | ["Wind instrument, woodwind instrument", "Shofar"] | ["amateur recording", "shofar"] | 6 | 91Qp8XUskXo | 971 | |
| Roger Sanchez Feat. Lisa Pure - Lost - Original Mix (Video) | This song contains digital drums playing a four on the floor groove with a kick on every beat along to an e-bass. In the background you can hear additional bongo rhythms. A synth string sound is playing long chord notes in the background. An e-guitar is finger picking a chord melody. A female voice is singing in a higher key and with backing vocals. This song may be playing while cleaning the kitchen. | 2007-11-11T12:52:18Z | Zarmk (Mike Alcazar) | Vocal House track from the S-Man, a new house classic. Copyright belongs to the Record label Stealth Records and the artist | ["Music of Asia", "Music"] | ["pop", "synth strings", "e-guitar", "e-bass", "digital drums", "bongos", "female voice singing", "fast tempo", "melancholic"] | 6 | Hp-lgcs4VXY | 1836 | |
| I Am the Very Model of a Modern Major-General | A male choir is at the end of a phrase before a single male voice takes over singing with a mid ranged opera voice along to a piano and an accordion. In the background the crowd is cheering,laughing and clapping. This song may be playing in a theater. | 2007-11-11T09:03:29Z | ThePenzancePirate | Gilbert and Sullivan's raucous operatic tale is captured in all its fun and glory in this production, recorded live at Central Park's Delacorte Theater. Kevin Kline sparkles as the swashbuckling and libidinous Pirate King while Linda Ronstadt makes her theatrical debut as the lovely and virginal Mabel. When Mabel and Frederic, a young pirate bound to serve the Pirate King, fall in love, complications arise and high spirited antics ensue. The incomparable cast offers the best in this boisterous romp. Despite some of the technical shortcomings of the DVD I found it more rewarding than the 1983 movie. I would thoroughly recommend adding a copy of this DVD to your library. | ["Applause", "Music"] | ["musical/opera", "male mid range voice singing", "acoustic piano", "accordion", "male choir", "background cheering and clapping", "uptempo", "comedic"] | 6 | zSGWoXDFM64 | 5477 |
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;