Talk:Tony Award for Best Lighting Design

Latest comment: 3 years ago by Yaakov bressler in topic Convert table to "long" format

Convert table to "long" format

edit

Most Tony Awards are split into separate wikipedia pages for their different categories/genres (musical vs. play). In this case, the award is condensed to a single page. Being that this might be confusing for data ingestion / data pipelines, I'm going to suggest we convert the data from wide to long, like as is done for Tony Award for Best Sound Design.

Current data state

edit
Year Designer Production
2010
64th Tony Awards
Lighting Design for a Play
Neil Austin Red
Neil Austin Hamlet
Mark Henderson ENRON
Brian MacDevitt Fences
Lighting Design for a Musical
Kevin Adams American Idiot
Donald Holder Ragtime
Nick Richings La Cage aux Folles
Robert Wierzel Fela!

Suggested data state

edit
Year Designer Production Award Type
2010
64th Tony Awards
Neil Austin Red Best Lighting Design for a Play
Neil Austin Hamlet Best Lighting Design for a Play
Mark Henderson ENRON Best Lighting Design for a Play
Brian MacDevitt Fences Best Lighting Design for a Play
Kevin Adams American Idiot Best Lighting Design for a Musical
Donald Holder Ragtime Best Lighting Design for a Musical
Nick Richings La Cage aux Folles Best Lighting Design for a Musical
Robert Wierzel Fela! Best Lighting Design for a Musical

Yaakov bressler (talk) 19:00, 3 January 2021 (UTC)Reply


Work in Progress: Variants of explicit Tony Award categorization (with long format)

edit

Below are 2 variants of a wide + explicit table format. Which format does the community prefer? (Note: I've included them as screenshots instead of code.)

Yaakov bressler (talk) 15:46, 5 January 2021 (UTC)Reply