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
下载地址
用户评论