Dataset Open Access

California Traffic Collision Data from SWITRS

Gude, Alexander


DataCite XML Export

<?xml version='1.0' encoding='utf-8'?>
<resource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://datacite.org/schema/kernel-4" xsi:schemaLocation="http://datacite.org/schema/kernel-4 http://schema.datacite.org/meta/kernel-4.1/metadata.xsd">
  <identifier identifierType="URL">https://zenodo.org/record/4284843</identifier>
  <creators>
    <creator>
      <creatorName>Gude, Alexander</creatorName>
      <givenName>Alexander</givenName>
      <familyName>Gude</familyName>
      <nameIdentifier nameIdentifierScheme="ORCID" schemeURI="http://orcid.org/">0000-0002-6935-6094</nameIdentifier>
    </creator>
  </creators>
  <titles>
    <title>California Traffic Collision Data from SWITRS</title>
  </titles>
  <publisher>Zenodo</publisher>
  <publicationYear>2020</publicationYear>
  <subjects>
    <subject>california</subject>
    <subject>SWITRS</subject>
    <subject>California Highway Patrol</subject>
    <subject>Automobile Crashes</subject>
    <subject>Traffic Accidents</subject>
  </subjects>
  <dates>
    <date dateType="Issued">2020-11-22</date>
  </dates>
  <resourceType resourceTypeGeneral="Dataset"/>
  <alternateIdentifiers>
    <alternateIdentifier alternateIdentifierType="url">https://zenodo.org/record/4284843</alternateIdentifier>
  </alternateIdentifiers>
  <relatedIdentifiers>
    <relatedIdentifier relatedIdentifierType="DOI" relationType="IsIdenticalTo">10.34740/kaggle/dsv/1671261</relatedIdentifier>
  </relatedIdentifiers>
  <version>v3.0.0-generated.with.20201024</version>
  <rightsList>
    <rights rightsURI="info:eu-repo/semantics/openAccess">Open Access</rights>
  </rightsList>
  <descriptions>
    <description descriptionType="Abstract">&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;</description>
  </descriptions>
</resource>
188
49
views
downloads
Views 188
Downloads 49
Data volume 62.5 GB
Unique views 173
Unique downloads 39

Share

Cite as