Road Traffic Injuries In California

Pedestrian Fatalities and Injury Rates By Transport Mode, 2002-2010

@kaggle.thedevastator_road_traffic_injuries_in_california

Table List

2 tables(10.35 MB)

Rows

@kaggle.thedevastator_road_traffic_injuries_in_california.rows

10.34 MB
494226 rows
34 columns

index Index	ind_id Ind Id	ind_definition Ind Definition	reportyear Reportyear	race_eth_code Race Eth Code	race_eth_name Race Eth Name	geotype Geotype	geotypevalue Geotypevalue	geoname Geoname	county_name County Name	region_name Region Name	mode Mode	severity Severity	injuries Injuries	totalpop Totalpop	poprate Poprate	ll95ci_poprate LL95CI Poprate	ul95ci_poprate UL95CI Poprate	poprate_se Poprate Se	poprate_rse Poprate Rse	ca_rr_poprate CA RR Poprate	avmttotal Avmttotal	avmtrate Avmtrate	ll95ci_avmtrate LL95CI Avmtrate	ul95ci_avmtrate UL95CI Avmtrate	avmtrate_se Avmtrate Se	avmtrate_rse Avmtrate Rse	ca_rr_avmtrate CA RR Avmtrate	groupquarters Groupquarters	version Version
	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	All modes	Killed	4089	34944563	11.701391143452	11.3427294350043	12.0600528518997	0.182990667575361	1.56383685778901	1	326842416135.706	12.5106161199782	12.1271506929776	12.8940815469788	0.195645626020713	1.56383685778901	1	823151	10/10/2014 12:00:00 AM
1	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	All modes	Severe Injury	13443	34944563	38.4695038252446	37.8191876490928	39.1198200013963	0.331793967424364	0.862485694984798	1	326842416135.706	41.1299125705227	40.434622930452896	41.8252022105926	0.354739612280513	0.862485694984798	1	823151	10/10/2014 12:00:00 AM
2	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Bicyclist	Killed	85	33493643.6205317	0.253779496082937	0.199828043858083	0.307730948307791	0.02752625113513	10.8465228909328	1	1214809885.19756	69.9697961267219	45.9916424874948	93.947949765949	12.2337518567485	17.4843325748614	1		10/10/2014 12:00:00 AM
3	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Bicyclist	Severe Injury	550	33493643.6205317	1.64210262171312	1.50486441924388	1.77934082418236	0.070019491055733	4.26401432711221	1	1214809885.19756	452.745739643495	325.309378756655	580.182100530335	65.01855147287752	14.3609416455415	1		10/10/2014 12:00:00 AM
4	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Bus	Killed	9	34944563	0.025755079552719	0.008928427578276	0.042581731527162	0.008585026517573	33.3333333333333	1								823151	10/10/2014 12:00:00 AM
5	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Bus	Severe Injury	22	34944563	0.062956861128869	0.036648863260205	0.089264858997533	0.013422447892176	21.320071635561	1								823151	10/10/2014 12:00:00 AM
6	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Car/Pickup	Killed	3178	34944563	9.094404757615647	8.7782109182326	9.41059859699871	0.161323387440334	1.77387516544436	1								823151	10/10/2014 12:00:00 AM
7	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Car/Pickup	Severe Injury	9665	34944563	27.658093764114305	27.1066802739611	28.2095072542675	0.281333413343457	1.01718294739632	1								823151	10/10/2014 12:00:00 AM
8	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Motorcycle	Killed	318	34944563	0.910012810862737	0.809992081399762	1.01003354032571	0.051030984419885	5.60772154092044	1								823151	10/10/2014 12:00:00 AM
9	753	Annual number of fatal and severe road traffic injuries per population and per miles traveled by transport mode	2002	9	Total	CA	6	California	nan	nan	Motorcycle	Severe Injury	1563	34944563	4.47279881565553	4.25105273798667	4.69454489332438	0.11313575391268	2.52941745371347	1								823151	10/10/2014 12:00:00 AM


CREATE TABLE rows (
  "index" BIGINT,
  "ind_id" BIGINT,
  "ind_definition" VARCHAR,
  "reportyear" VARCHAR,
  "race_eth_code" BIGINT,
  "race_eth_name" VARCHAR,
  "geotype" VARCHAR,
  "geotypevalue" BIGINT,
  "geoname" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" DOUBLE,
  "region_name" VARCHAR,
  "region_code" DOUBLE,
  "mode" VARCHAR,
  "severity" VARCHAR,
  "injuries" DOUBLE,
  "totalpop" DOUBLE,
  "poprate" DOUBLE,
  "ll95ci_poprate" DOUBLE,
  "ul95ci_poprate" DOUBLE,
  "poprate_se" DOUBLE,
  "poprate_rse" DOUBLE,
  "ca_decile_pop" DOUBLE,
  "ca_rr_poprate" DOUBLE,
  "avmttotal" DOUBLE,
  "avmtrate" DOUBLE,
  "ll95ci_avmtrate" DOUBLE,
  "ul95ci_avmtrate" DOUBLE,
  "avmtrate_se" DOUBLE,
  "avmtrate_rse" DOUBLE,
  "ca_decile_avmt" DOUBLE,
  "ca_rr_avmtrate" DOUBLE,
  "groupquarters" DOUBLE,
  "version" VARCHAR
);