traffic California Traffic Accident Data Visualization

加州交通事故可视化2003年至2012年加利福尼亚州交通事故数据的简单24x7图表。数据来源于由创建要创建csv，请在包含来自上述SWITRS链接的数据的目录中的sqlite3命令行会话中运行以下命令： .mode csv .import collisions_2003to2012.csv collisions .headers on .output csv SELECT CAST(TIME_ AS INTEGER) / 100 AS HOUR, DAYWEEK, COUNT() AS TOTAL, SUM(CAST(ETOH == 'Y' AS INTEGER)) AS ALCOHOLRELATED, SUM(CAST(CRASHSEV == 1 AS INTEGER)) AS FATAL*, S