musiccaps_details (view)
4 rows where musiccaps_aspects contains "home video" and youtube_description = " "
This data as json, CSV (advanced)
Suggested facets: musiccaps_author, youtube_published (date), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Homer Simpson singing poker face | A male vocalist sings this animated song. The tempo is medium fast with keyboard harmony, acoustic guitar , steady drumming and simple bass lines. The song is simple, catchy, funny, spirited, animated and easy to sing along. The lyrics are funny. | 2012-05-22T09:02:36Z | Mindaugas Paskauskas | ["Music", "/t/dd00003", "Synthetic singing"] | ["male vocalist", "medium fast tempo", "off key singing", "relatable", "simple melody", "funny", "homer simpson cover", "home video", "amateur singing", "animated", "childish lyrics", "keyboard harmony", "steady drumming", "simple bass lines", "auto tune", "rhythmic acoustic", "guitar"] | 7 | 4W8IZxn3nEI | 581 | ||
jamie and millie couple shuffle | This is Electronic Dance music. The tempo is fast with synthesiser arrangements, punchy Digital drum rhythm, electronic sounds and a recurring, catchy vocal riff with the sound of talking in the background.The music is obscure as it is an amateur recording . It is buoyant, youthful, energetic, enthusiastic, and pulsating with a dance groove. | 2009-05-03T12:50:31Z | Carnesy | ["Music", "Shuffle"] | ["instrumental", "fast tempo", "electronic music", "obscure audio", "thumping sounds", "vocalisation", "punchy beats", "robotic voice", "background chatter", "electronically arranged music", "home video", "home recording", "muffled audio", "psychedelic", "dance music", "edm", "catchy vocal riff"] | 7 | K2h6UiZSoZ4 | 2054 | ||
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 | ||
Harmonic Brothers - I'll Fly Away | Male singers sing this gospel tune in vocal harmony. The song is medium tempo with a guitar accompaniment . The song is devotional amid inspiring. The song is a black gospel acapella recorded live in a church with poor quality audio. | 2010-05-17T07:00:46Z | anewbeginning2009 | ["Music", "Harmonic"] | ["acapella singers", "male singers", "home video", "devotional", "inspiring", "motivational", "gospel hits", "sunday morning", "guitar accompaniment", "live audience", "church music", "gospel music", "medium tempo", "steady rhythm", "vocal harmony", "poor audio recording", "congressional music", "audience cheering", "black gospel music"] | 1 | yAqznhOhoIk | 5389 |
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;