musiccaps_details (view)
6 rows where musiccaps_aspects contains "happy" and musiccaps_author = 5
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- happy · 6 ✖
- positive 5
- no vocals 3
- danceable 2
- rock&roll 2
- upbeat 2
- upbeat drum kit 2
- bells 1
- blues 1
- blues drum kit 1
- bouncy bass 1
- bouncy melody 1
- bright male vocals 1
- cello 1
- christmas music 1
- clarinets 1
- classical music 1
- clean electric guitar strumms 1
- distorted electric guitar 1
- electric guitar solo 1
- energetic 1
- falsetto male vocals 1
- fast tempo 1
- hi-hats 1
- holidays 1
- jingles 1
- kick 1
- mid tempo 1
- mid-pitched male vocals 1
- nasal male vocals 1
- orchestral 1
- out of key vocals 1
- powerfull 1
- r&b 1
- raspy male vocals 1
- schoenhut piano 1
- snare 1
- soft piano synth 1
- strings 1
- subtle strings 1
- violins 1
musiccaps_names (array) 15 ✖
- Music 6
- /m/05zppz 1
- /t/dd00003 1
- Bell 1
- Classical music 1
- Grunge 1
- Independent music 1
- Music of Asia 1
- Rock and roll 1
- Singing 1
- Ska 1
- Song 1
- Soul music 1
- Tick-tock 1
- Whoop 1
youtube_published (date) 6 ✖
- 2007-05-03 1
- 2007-12-28 1
- 2008-05-09 1
- 2010-03-23 1
- 2010-11-14 1
- 2011-12-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stickwitu - Male Version, Me Singing | The music contains an erotic male voice which is out of key and clearly in the foreground. In the background there's a sustained soft piano synth and a drum kit playing a mid pitch beat. The atmosphere is sexual and seductive. | 2010-11-14T12:44:11Z | 抵死仔 | I'm Kelmen...I'm from HK. I hope U all like this song !! Thanks !! Download this song:: http://www.box.net/shared/y7gythrrym | ["Music", "/m/05zppz", "Soul music", "/t/dd00003"] | ["r&b", "happy", "mid-pitched male vocals", "soft piano synth", "kick", "snare", "hi-hats", "upbeat", "out of key vocals", "mid tempo"] | 5 | DB38NRSHw9A | 1450 | |
ICEBERG FULL OF PENGUINS | The track features a Christmas song with no vocals. The melody is very simple and it's played by a Schoenhut Piano that's accompanied by subtle strings. The atmosphere is positive and very Christmas-like. | 2007-12-28T23:18:22Z | Kitty B | the iceberg was full of penguin with rudolph antlers ,to tip the iceberg and to protect the tree. | ["Bell", "Music"] | ["christmas music", "jingles", "subtle strings", "holidays", "positive", "happy", "bells", "schoenhut piano", "no vocals"] | 5 | JCsuOzlwJqA | 1978 | |
Schubert - Marche Militaire Nr 1 (arr P Breiner) - Best-of Classical Music | Classical music features a variety of string instruments that play a bright melody. The sound is big and orchestral. A clarinet plays a high-pitched melody in the foreground. The atmosphere of the song is positive and happy. | 2010-03-23T15:55:12Z | TheFbiFilesRepeat | The audio is under "Public Domain" The public domain is an intellectual property designation for the range of content that is not owned or controlled by anyone. These materials are public property, and available for anyone to use freely (the "right to copy") for any purpose. ...50 years from creation year or 70 years after his death http://en.wikipedia.org/wiki/Public_domain | ["Music", "Classical music"] | ["classical music", "strings", "violins", "clarinets", "cello", "happy", "positive", "orchestral", "no vocals"] | 5 | axb48YrvRmw | 3589 | |
Ticking of the Clock | The rock music features a nasal male voice. The voice follows a strummed electric guitar with a clean sound. The bass is backing the guitar strumms. The beat is made first with ticking sounds but then it's played by a drum kit. | 2011-12-07T15:49:23Z | Amygdalaindiemusic | Song about time pressures | ["Music", "Independent music", "Song", "Tick-tock"] | ["rock&roll", "nasal male vocals", "clean electric guitar strumms", "upbeat drum kit", "bouncy melody", "danceable", "happy", "positive"] | 5 | fsTVRca31nI | 3983 | |
Whip Ass Gaming: Twisted Metal Gameplay Demo | The song is a rock track that features distorted and energetic guitar strumming chords. A secondary guitar does a solo melody in the foreground. A drum kit plays a typical upbeat rock pattern with an energetic mood. A bass adds deepness to the track while playing the same progression as the strummed guitar. | 2008-05-09T21:11:29Z | Belpowerslave | The video gameplay demo showing off various levels and cars. Please note that this is *video* of gameplay footage, and most of the issues you'll see with the graphics are the fault of the low quality encode on the disc. | ["Music", "Grunge"] | ["rock&roll", "no vocals", "distorted electric guitar", "energetic", "electric guitar solo", "upbeat drum kit", "danceable", "happy", "positive", "powerfull"] | 5 | fxdWwzdeY_o | 3994 | |
The Blues Willies - Shout | The track is an upbeat blues song that features falsetto and raspy male vocals. A drum kit plays an energetic and happy beat. A bass guitar follows the rhythm and adds a bouncy vibe to the song. The overall sound of the instruments is bright and happy. A guitar follows the bass and the drum kit. | 2007-05-03T10:44:42Z | Alfredo | I Blues Willies al concertone del primo Maggio 2007 a S. Giovanni. A parte il mitico Chuck Berry, l'unico vero gruppo che c'entrava qualcosa con il rock'n'roll! www.blueswillies.it | ["Singing", "Music of Asia", "Music", "Ska", "Whoop", "Rock and roll"] | ["blues", "upbeat", "falsetto male vocals", "raspy male vocals", "fast tempo", "blues drum kit", "positive", "happy", "bright male vocals", "bouncy bass"] | 5 | vtVfl5Ff5lw | 5216 |
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;