Talk:Tony Award for Best Lighting Design

From WikiProjectMed
Jump to navigation Jump to search

Convert table to "long" format

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

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

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)

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]