Road Traffic Injuries In California

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

@kaggle.thedevastator_road_traffic_injuries_in_california

Roadtrafficinjuries Dd

@kaggle.thedevastator_road_traffic_injuries_in_california.roadtrafficinjuries_dd

index Index	column_name COLUMN NAME	definition DEFINITION	format FORMAT	coding CODING
	ind_id	Indicator ID	Numeric	753
1	ind_definition	Definition of indicator in plain language	String	Free text
2	reportyear	Year(s) that the indicator was reported	String	2002 to 2010; 2002-2004, 2005-2007, and 2008-2010 3 year averages; 2006-2010 5 year average
3	race_eth_code	numeric code for a race/ethnicity group	Numeric	9=Total
4	race_eth_name	Name of race/ethnic group	String	Total
5	geotype	Type of geographic unit	String	CT=Census tract; PL=Place (includes cities, towns, and census designated places -CDP-. It does not include unincorporated communities); CO=County; CD=County division; R4=Consolidated Statistical Metropolitan Area; RE=region; CA=State
6	geotypevalue	Value of geographic unit	String	11 digit FIPS census tract code; 5-digit FIPS place code; 10-digit FIPS county division code; 5-digit FIPS county code; 4-digit consolidated statistical metropolitan area ID; 2-digit region ID; 2-digit FIPS state code. The geotypevalues 99999 for PL and 99999999999 for CT indicate injury data that d…
7	geoname	Name of geographic unit	String	census tract name, place name, county division, county name, consolidated statistical metropolitan area name, region name, or state name
8	county_name	Name of county that geotype is in	String	Not available for geotypes R4, RE and CA
9	county_fips	FIPS code of county that geotype is in	String	2-digit census state code (06) plus 3-digit census county code


CREATE TABLE roadtrafficinjuries_dd (
  "index" BIGINT,
  "column_name" VARCHAR,
  "definition" VARCHAR,
  "format" VARCHAR,
  "coding" VARCHAR
);