musiccaps_details (view)
3 rows where musiccaps_author = 8 and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Noel Gallagher - Everybody Is On The Run (Unreleased Material From Sound Check) | low fidelity audio from a live performance featuring a solo direct input acoustic guitar strumming airy, suspended open chords. Also present are occasional ambient sounds, perhaps papers being shuffled. | 2011-04-15T12:03:37Z | themaddarevillo | Noel Gallagher - Everybody Is On The Run (Unreleased Material From Sound Check) | ["Music", "Wedding music", "Classical music"] | ["solo live direct input acoustic guitar strumming", "airy suspended open chords", "low fidelity", "ambient sounds", "paper shuffling"] | 8 | -4SYC2YgzL8 | 10 | |
| Euphonium Solo | Quick, forceful wind ensemble music featuring a horn solo with brass, tuba, bass drum and snare drum accompanying. | 2007-09-17T18:54:27Z | tubajs | Barry Morrison playing with Imperial Brass (Jeff Schultz-Conductor) "A Better World | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra", "Trumpet", "Classical music"] | ["horn solo", "wind ensemble", "brass", "bass drum", "snare drum", "tuba", "quick tempo", "forceful"] | 8 | DTkKGYCRMlc | 1478 | |
| Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990 | Dramatic female opera singer accompanied by orchestra and brass and cymbal crash. | 2010-06-23T02:57:11Z | tapesalvage | Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990 | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"] | 8 | XUzaEsoOlWQ | 3187 |
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;