musiccaps_details (view)
4 rows where "youtube_published" is on date 2010-12-11
This data as json, CSV (advanced)
Suggested facets: musiccaps_author, youtube_published (date)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Dr.House Jazz Music season1 ep.9 "DNR" | The song is an instrumental jazz tune. The tempo is medium with steady drumming with drum brushes and other percussive hits, piano accompaniment, guitar accompaniment, groovy bass line and a muted trumpet playing a cool solo. The song is a jazz improvisation of a romantic melody. | 2010-12-11T17:42:03Z | manonfio | hi here s the jazz song of the oldest episode of house ep9 season 1 "DNR" I DUNNO the album or compositor, simply found it in the web enjoy P.S. if my english is bad sorry about that need study more lol p.s.2.-If someone knows the compositor or album song plz share ur knowledge with the world i want more of this. | ["Jazz", "Music", "Dance music"] | ["jazz music", "instrumental music", "medium tempo", "relaxing playlists", "comfort", "movie soundtrack", "warmth", "drum brushes", "piano accompaniment", "guitar accompaniment", "percussive bass line", "smooth", "jazz hits", "tv show theme", "jazz hits", "lounge jazz hits", "cymbal strikes", "instrumental music", "emotional", "sentimental", "romantic", "passionate", "love song", "muted trumpet solo", "double bass"] | 1 | 1ypKEH2kd7g | 322 | |
| Aleko - Aria Of Zemfira | The low quality recording features a female opera vocalist singing over sustained strings. There is tinny metallic percussive foley at one point in the loop. It is a bit quiet, but it also sounds dynamic, emotional and passionate. | 2010-12-11T22:14:16Z | Joe Fenech | ["Music", "Opera"] | ["low quality", "orchestra", "opera", "female opera vocal", "sustained strings section", "quiet", "metallic percussive foley", "passionate", "emotional", "dynamic"] | 4 | bxoJOfGx3hM | 3668 | ||
| Christmas Remix - Sha-la-la (non-stop mix) | This reggae song features a male voice. He sings the first line and laughs at the end of the first sentence. He continues to sing the melody. The voice is accompanied by programmed percussion playing a simple beat. The bass plays the root notes of the chords. A keyboard plays chords in the background with a reggae feel. Another keyboard plays a fill in between lines. At the end, backing singers sing in harmony. This song has a holiday mood. This song can be played in a holiday movie. | 2010-12-11T06:20:36Z | brYaz 214 | an Christmas remix present "Sha-la-la (non-stop mix)" Remix all 14 songs in just 12:33 minutes All Christmas Remix songs: Christmas Remix - Sha-la-la (radio edit) Christmas Remix - Sha-la-la (non-stop mix) Christmas Remix - Dayang-dayang (radio edit) Christmas Remix - Dayang-dayang (non-stop mix) Download link: http://www.4shared.com/audio/OLTt4F6W/Sha_La_La__Non_Stop_Remix_.html type: Mp3 file name: Sha-la-la (non-stop mix) file size: 11.5mb(11,798kb) Hosting Site: 4shared | ["Christmas music", "Music"] | ["reggae song", "male voice", "holiday mood", "programmed percussion", "keyboard", "shaker", "moderate tempo"] | 0 | gWRfk8nCcPs | 4035 | |
| The Singing Cooke's--Family Circle | The low quality recording features a country song that contains harmonizing vocals singing over electric guitar solo melody, smooth bass guitar, acoustic rhythm guitar, snappy rimshots, shimmering hi hats and soft kick hits. It sounds soulful, emotional and passionate. | 2010-12-11T03:34:48Z | Nexar41834 | ["Gospel music", "Christian music", "Music", "Happy music"] | ["low quality", "country", "harmonizing vocals", "electric guitar solo melody", "smooth bass guitar", "snappy rimshot", "shimmering hi hats", "soft kick hits", "acoustic rhythm guitar", "soulful", "emotional", "passionate"] | 4 | mlpTCec4igo | 4490 |
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;