Dataset Open Access

California Traffic Collision Data from SWITRS

Gude, Alexander


MARC21 XML Export

<?xml version='1.0' encoding='UTF-8'?>
<record xmlns="http://www.loc.gov/MARC21/slim">
  <leader>00000nmm##2200000uu#4500</leader>
  <datafield tag="540" ind1=" " ind2=" ">
    <subfield code="a">Other (Public Domain)</subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="c">2020-11-22</subfield>
  </datafield>
  <controlfield tag="005">20201123122711.0</controlfield>
  <controlfield tag="001">4284843</controlfield>
  <datafield tag="909" ind1="C" ind2="O">
    <subfield code="p">openaire_data</subfield>
    <subfield code="o">oai:zenodo.org:4284843</subfield>
  </datafield>
  <datafield tag="520" ind1=" " ind2=" ">
    <subfield code="a">&lt;p&gt;This data comes from the California Highway Patrol and covers collisions from January 1st, 2001 until mid-October, 2020. I have requested full database dumps from the CHP four times, once in 2016, 2017, 2018, and 2020. I have combined these datasets into the one presented here. For additional details, see my post: &lt;a href="https://alexgude.com/blog/switrs-sqlite-hosted-dataset/"&gt;&lt;strong&gt;Introducing the SWITRS SQLite Hosted Dataset&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;There are three main tables:&lt;/p&gt;

&lt;p&gt;- `&lt;strong&gt;collisions&lt;/strong&gt;`: Contains information about the collision, where it happened, what vehicles were involved.&lt;br&gt;
- `&lt;strong&gt;parties&lt;/strong&gt;`: Contains information about the groups people involved in the collision including age, sex, and sobriety.&lt;br&gt;
- `&lt;strong&gt;victims&lt;/strong&gt;`: Contains information about the injuries of specific people involved in the collision.&lt;/p&gt;

&lt;p&gt;There is also a table called `&lt;em&gt;case_ids&lt;/em&gt;` which I used to build the other tables. It tells you which of the four original datasets each row came from.&lt;/p&gt;</subfield>
  </datafield>
  <datafield tag="856" ind1="4" ind2=" ">
    <subfield code="s">1275320599</subfield>
    <subfield code="z">md5:aae412990926fe70320600b2f2dee8a4</subfield>
    <subfield code="u">https://zenodo.org/record/4284843/files/switrs.sqlite.gz</subfield>
  </datafield>
  <datafield tag="542" ind1=" " ind2=" ">
    <subfield code="l">open</subfield>
  </datafield>
  <datafield tag="980" ind1=" " ind2=" ">
    <subfield code="a">dataset</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="0">(orcid)0000-0002-6935-6094</subfield>
    <subfield code="a">Gude, Alexander</subfield>
  </datafield>
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">california</subfield>
  </datafield>
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">SWITRS</subfield>
  </datafield>
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">California Highway Patrol</subfield>
  </datafield>
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">Automobile Crashes</subfield>
  </datafield>
  <datafield tag="653" ind1=" " ind2=" ">
    <subfield code="a">Traffic Accidents</subfield>
  </datafield>
  <datafield tag="024" ind1=" " ind2=" ">
    <subfield code="a">10.34740/kaggle/dsv/1671261</subfield>
    <subfield code="2">doi</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">California Traffic Collision Data from SWITRS</subfield>
  </datafield>
  <datafield tag="650" ind1="1" ind2="7">
    <subfield code="a">cc-by</subfield>
    <subfield code="2">opendefinition.org</subfield>
  </datafield>
</record>
188
49
views
downloads
Views 188
Downloads 49
Data volume 62.5 GB
Unique views 173
Unique downloads 39

Share

Cite as