musiccaps_details (view)
2 rows where "youtube_published" is on date 2009-02-01 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- adventurous 1
- backing track 1
- bad audio quality 1
- church organ 1
- country music 1
- cymbals crashing 1
- energetic 1
- enthusiastic 1
- exciting 1
- fast tempo 1
- gain issues 1
- great adventure 1
- guitar rhythm 1
- hand percussion 1
- happy 1
- harp melody 1
- instrumental 1
- instrumental music 1
- joyful 1
- latin folk 1
- latin influence music 1
- latin instrumental 1
- lively cheerful 1
- male vocalisation 1
- medium tempo 1
- movie themes 1
- organ accompaniment 1
- passionate 1
- retro classics 1
- romantic 1
- shakers 1
- tambourine percussion 1
- ukelele harmony 1
- vintage hits 1
- vintage pop 1
- vivacious 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Electronic organ 1
- Hammond organ 1
- Harp 1
- Keyboard (musical) 1
- Organ 1
- Piano 1
- Pizzicato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
d85 yamaha organ solo one man band | The song is an instrumental. The tempo is medium with a church organ playing melody, steady drumming rhythm, cymbals crashing, tambourine percussion, steady bass, and guitar playing rhythm. The song is exciting and retro nostalgia. The audio quality is poor. | 2009-02-01T04:39:30Z | fathau | one man band | ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ", "country music", "backing track", "medium tempo", "instrumental music", "tambourine percussion", "cymbals crashing", "guitar rhythm", "organ accompaniment", "vintage hits", "bad audio quality", "gain issues", "exciting", "adventurous", "retro classics", "passionate", "great adventure", "romantic", "movie themes", "vintage pop"] | 1 | A_Yd5huF2Pg | 1136 | |
Carlos Alvarado y José Gregorio López: "Canción Recia" | This music is instrumental. His tempo is fast with a lively ukelele rhythm, melodious harp harmony and shaker beats with male vocalisation. This clip is the beginning of a song with latin music influences. The music is a lively, spirited, happy, cheerful, warm, energetic latin folk song. | 2009-02-01T22:59:40Z | MingaTV | Desde el llano venezolano, la energía de su música, el talento de sus artistas. | ["Harp", "Pizzicato"] | ["instrumental", "fast tempo", "ukelele harmony", "harp melody", "shakers", "hand percussion", "lively cheerful", "happy", "male vocalisation", "latin folk", "latin instrumental", "latin influence music", "vivacious", "happy", "joyful", "enthusiastic", "energetic"] | 7 | SsVc1TAVsSc | 2794 |
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;