musiccaps_details (view)
3 rows where "youtube_published" is on date 2013-01-24 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- accordion player 1
- ambient crowd noise 1
- bass notes 1
- bowed string bass 1
- concert bass drum 1
- dance music 1
- eerie 1
- electric piano 1
- electronic cymbal roll 1
- enthusiastic 1
- ethnic instruments 1
- flute playing 1
- folk music 1
- guitar playing 1
- gypsy music 1
- held strings 1
- home studio 1
- instrumental 1
- instrumental harmony 1
- instrumental music 1
- jam session 1
- jazz tone 1
- life is good 1
- live jam 1
- live performance 1
- medium tempo 1
- melancholic 1
- no other instruments 1
- no voices 1
- nostalgic moments 1
- ominous 1
- orchestral 1
- panned hard right 1
- people enjoying the music 1
- relaxing 1
- sound testing 1
- synth song 1
- treble notes 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pretty little liars - Alison visits the girls | Ominous orchestral music with long held string notes, bowed string bass, electronic cymbal roll and concert bass drum. The mood is eerie. | 2013-01-24T18:04:03Z | PLLlover | Alison visits Hanna, Emily, Spencer and Aria. Are they just dreaming or it is real? That is the question I want to have answered... Episodes when Ali visited the liars: Hanna: 01x11 Emily: 02x12 Spencer: 02x24 Aria: 03x16 | ["Music", "Speech", "Scary music", "Inside, small room"] | ["ominous", "orchestral", "panned hard right", "eerie", "held strings", "bowed string bass", "electronic cymbal roll", "concert bass drum"] | 8 | GAoGADilmV8 | 1696 | |
Yamaha MOX8 vs Korg Krome 88 | This clip features a synth being played. The tone is that of an electric piano. This synth plays the bass notes as well as the treble notes. This song has no other instruments. This is an instrumental song with no voices. This song can be played in an instructional video for synthesizers. | 2013-01-24T18:54:05Z | A&C Hamilton Musical Instruments | Stuart Smythe at instruments2go plays a bunch of tunes on the mighty MOX8 and Krome 88 side by side. Which do you like best? Let us know in the comments! | ["Electric piano", "Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["synth song", "jazz tone", "electric piano", "no other instruments", "no voices", "instrumental", "bass notes", "treble notes", "sound testing"] | 0 | g8XTU3OalGs | 4009 | |
"Eu Quero é Sossego", de K-Ximbinho, com Nonato Lima e Grupo Murmurando.mp4 | The song is an instrumental. The tempo is medium with an accordion player, guitar rhythm, flute player and other percussion playing in harmony. The song is groovy and has gypsy flavour to it. The song audio quality is poor with ambient crowd noises. | 2013-01-24T15:01:39Z | claudeide | Programa Brasileirinho, 20 de Janeiro de 2013 - Acordeonista Nonato Lima toca a música "Eu Quero é sossego", de K-Ximbinho, acompanhado pelo Quinteto Murmurando. | ["Wind instrument, woodwind instrument", "Accordion"] | ["accordion player", "life is good", "relaxing", "jam session", "home studio", "melancholic", "nostalgic moments", "people enjoying the music", "instrumental harmony", "folk music", "flute playing", "guitar playing", "live jam", "instrumental music", "medium tempo", "ambient crowd noise", "enthusiastic", "dance music", "gypsy music", "folk music", "ethnic instruments", "dance music", "live performance"] | 1 | tbovKStEnME | 5051 |
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;