Road traffic accidents

Information on accidents across Leeds. Data includes location, number of people and vehicles involved, road surface, weather conditions and severity of any casualties.

Please note
-----------

* The Eastings and Northings are generated at the roadside where the accident occurred. Sometimes due to poor internet connectivity this data is may not be as accurate as it could be. If you notice any errors please contact [e-mail].

Due to the format of the report a number of figures in the columns are repeated, these are:

* Reference Number
* Easting
* Northing
* Number of Vehicles
* Accident Date
* Time (24hr)
* 1st Road Class
* Road Surface
* Lighting Conditions
* Weather Conditions

Reference Number

Grid Ref: Easting

Grid Ref: Northing

Number of vehicles

Accident Date

Time (24hr)

21G0539

427798

426248

5

16/01/2015

1205

21G0539

427798

426248

5

16/01/2015

1205

21G1108

431142

430087

1

16/01/2015

1732

21H0565

434602

436699>

1

17/01/2015

930

21H0638

434254

434318

2

17/01/2015

1315

21H0638

434254

434318

2

17/01/2015

1315

Therefore the number of vehicles involved in accident 21G0539 were 5, and in accident 21H0638 were 2. Overall in the example above a total of 9 vehicles were involved in accidents

A useful tool to analyse the data is Excel pivot tables, these help summarise large amounts of data in a easy to view table, for further information on pivot table visit [here](https://support.office.com/en-gb/article/Overview-of-PivotTable-and-PivotChart-reports-00a5bf71-65cb-49f9-b321-85bb7b0b06c2). 

Further Information
-------------------

* Please see the guidance document for further information on categories.

利兹市各类交通事故相关数据集。数据涵盖事故发生地点、涉事人员与车辆数量、路面状况、天气条件以及人员伤亡严重程度。

重要提示
-----------
* 事故发生路段生成的东向坐标（Eastings）与北向坐标（Northings）可能因网络连接不佳存在精度偏差。如您发现数据存在错误，请联系邮箱 [e-mail]。

由于报告格式限制，部分列数据存在重复，具体重复项如下：
* 事故编号（Reference Number）
* 东向坐标（Easting）
* 北向坐标（Northing）
* 涉事车辆数（Number of Vehicles）
* 事故日期（Accident Date）
* 时间（24小时制）（Time (24hr)）
* 一级道路等级（1st Road Class）
* 路面状况（Road Surface）
* 光照条件（Lighting Conditions）
* 天气状况（Weather Conditions）

事故编号
坐标参考：东向坐标
坐标参考：北向坐标
涉事车辆数
事故日期
时间（24小时制）
21G0539
427798
426248
5
2015/01/16
1205
21G0539
427798
426248
5
2015/01/16
1205
21G1108
431142
430087
1
2015/01/16
1732
21H0565
434602
436699
1
2015/01/17
930
21H0638
434254
434318
2
2015/01/17
1315
21H0638
434254
434318
2
2015/01/17
1315

由此可知，事故21G0539涉事车辆共计5台，事故21H0638涉事车辆共计2台。上述示例中所有事故累计涉事车辆总数为9台。

可用于数据分析的实用工具为Excel数据透视表（Excel pivot tables），该工具可将海量数据汇总为直观易懂的表格。如需了解数据透视表的更多信息，请访问[此处](https://support.office.com/en-gb/article/Overview-of-PivotTable-and-PivotChart-reports-00a5bf71-65cb-49f9-b321-85bb7b0b06c2)。

更多信息
-------------------
* 如需了解各类分类项的详细说明，请参阅配套指导文档。