Design overall data schema

[ejaxon]

The schema should certainly be guided by data source schemas, but the goal here is to think long-term about how we want to represent this data for maximum flexibility and usability. This will guide the preparation of each individual dataset from its source form.

[ChrisTheDBA]

I'd recommend looking into Adam Damico's census/survey work - https://github.com/ajdamico. He favors a schema-at-read method

[LauraMB12]

ryan thornburg said he might can refer some students to help- for their data visualization portfolios.

[LauraMB12]

ryan shared this article / visualizations on residents v. police https://www.nytimes.com/interactive/2014/09/03/us/the-race-gap-in-americas-police-departments.html

[ejaxon]

I think we need to look at this as a more traditional schema since our next phase will be to build a web app that reads it. To my mind, we basically need the following tables (based largely on the fact that the data sources are quite different):

• community_demographics
• voter_demographics
• candidate_demographics
• elected_body_demographics

I've created a schema file to think through columns.