Just thinking out-loud: a service that collects and aggregates publicly available data, then allows the customer to choose from a series of visualizations or charts (map, graph, tabular, etc.) with a set of query options (geographical area, date range, etc.) that can be embedded in a web page (i.e. on the customer's website). Terms of the service would allow the sharing and aggregation of all supplied data (the entire data set would be publicly available).
ETL is a challenging problem, often doing something constructive with the end result is just as difficult. Providing one place to send this data might help motivate organizations to sink in the time and money to do the work, as well as providing a structure for their ETL processes to target. Perhaps the company that provides this service might also provide consulting services to help customers setup a reliable ETL process.
Maybe another idea for a @CodeForAmerica project?