musiccaps_details (view)
4 rows where "youtube_published" is on date 2008-06-20
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- low quality 2
- punchy snare 2
- acoustic guitar 1
- amateur recording 1
- ambient outdoor sounds 1
- banjo 1
- beep 1
- boomy 1
- boys having fun 1
- celebratory 1
- censored lyrics 1
- country folk 1
- country pop 1
- country song 1
- distorted music 1
- drunk singing 1
- energetic 1
- energetic crash cymbals 1
- epic 1
- fast tempo 1
- festive 1
- giggling 1
- groovy bass 1
- group singing 1
- guiro 1
- guiro accompaniment 1
- happy 1
- hard 808 bass 1
- hip hop 1
- home recording 1
- inferior audio quality 1
- instrumental 1
- joyful 1
- latin dance music 1
- latin music 1
- latin regional music 1
- laughing 1
- live music 1
- live performance 1
- lively acordion 1
- male harmony 1
- medium harmony 1
- merry 1
- muffled 1
- naughty 1
- percussive shoe tapping 1
- powerful 1
- punchy kick 1
- reverberant 1
- rock orchestra 1
- scraper instrument 1
- shimmering shakers 1
- simple strings melody 1
- spirited 1
- spirited congas 1
- static 1
- stifled laughter 1
- suggestive 1
- vocal harmony 1
- wide electric guitar melody 1
- world music 1
musiccaps_names (array) 9 ✖
- Music 4
- Accordion 1
- Beep, bleep 1
- Classical music 1
- Maraca 1
- Musical instrument 1
- Opera 1
- Song 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Solo Thomas Marek Tap Dance | The low quality recording features a percussive shoe tapping over hip hop beat playing in the background. The beat consists of shimmering shakers, hard 808 bass and punchy snare. At one point the shoe tapper gets a little bit sloppy. It sounds a bit muffled, boomy and reverberant. | 2008-06-20T10:12:27Z | Thomas Marek | Thomas Marek´s Solo in his production "about_tap vol no 2" live at Kampnagel Hamburg, Germany 2006 | ["Music", "Tap"] | ["low quality", "hip hop", "shimmering shakers", "hard 808 bass", "punchy snare", "percussive shoe tapping", "reverberant", "muffled", "boomy"] | 4 | We-bFXFjWaM | 3117 | |
Blink 182 "beep beep beep beep bleeping bleep" | This song is a male vocal harmony. The tempo is medium with banjo and guitar accompaniment. The song is merry, naughty, suggestive and harmless fun with the sound of stifled laughter in the background and with the expletives drowned with the sound of a beep. This song is Country pop/Country Folk. | 2008-06-20T19:33:44Z | LeChad256 | It starts out beyond terrible, but gets MUCH more accurate. It's amazing how many beeps you can here in one song, and of course this is NO WHERE NEAR the most vulgar song, it's just the one I chose to do. Anyway, it's followed by the original version without the censors. | ["Beep, bleep", "Music"] | ["male harmony", "country song", "medium harmony", "merry", "boys having fun", "stifled laughter", "giggling", "drunk singing", "banjo", "acoustic guitar", "censored lyrics", "beep", "laughing", "vocal harmony", "group singing", "naughty", "suggestive", "country folk", "country pop", "amateur recording", "home recording"] | 7 | iaDrtIon6FU | 4203 | |
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 | |
not ashamed - boundless worship band | The Rock Orchestra song features energetic crash cymbals, punchy kick and snare hits, groovy bass, wide electric guitar chords and simple strings melody. It sounds epic, powerful and energetic - like a theme song for an opening track of some anime. | 2008-06-20T12:19:31Z | awaefler | not ashamed got very famous in the first weeks. Now we're starting with youtube. | ["Music", "Opera", "Song", "Classical music"] | ["low quality", "rock orchestra", "energetic crash cymbals", "punchy kick", "punchy snare", "groovy bass", "wide electric guitar melody", "simple strings melody", "energetic", "epic", "powerful"] | 4 | qwGT6wvYdLo | 4834 |
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;