Uber And Urban Crime
Uber and Urban Crime Dataset
@kaggle.saurabhshahane_uber_and_urban_crime
Uber and Urban Crime Dataset
@kaggle.saurabhshahane_uber_and_urban_crime
CREATE TABLE uberdata_9_3 (
"unnamed_0" BIGINT,
"inc_month" BIGINT,
"identifier" VARCHAR,
"inc_year" BIGINT,
"city_cat" VARCHAR,
"homicide" BIGINT,
"kidnapping" BIGINT,
"sex_forcible" BIGINT,
"robbery" BIGINT,
"assault" BIGINT,
"arson" BIGINT,
"extortion_blackmail" BIGINT,
"burglary_bne" BIGINT,
"larceny_theft" BIGINT,
"motor_vehicle_theft" BIGINT,
"counterfit_forge" BIGINT,
"fraud" BIGINT,
"embezzelment" BIGINT,
"stolen_property" BIGINT,
"destruction_property" BIGINT,
"drug_offenses" BIGINT,
"sex_nonforcible" BIGINT,
"porn" BIGINT,
"gambling" BIGINT,
"prostitution" BIGINT,
"bribery" BIGINT,
"weapon_violations" BIGINT,
"human_traffic" BIGINT,
"offense_count" BIGINT,
"date_nibrs" VARCHAR,
"date_uber" VARCHAR,
"uber" BOOLEAN,
"treated_month" BIGINT,
"totalworkers" BIGINT,
"drovealone" DOUBLE,
"carpool" DOUBLE,
"public" DOUBLE,
"age" DOUBLE,
"male" DOUBLE,
"skin_white" DOUBLE,
"skin_black" DOUBLE,
"nonlatino_white" DOUBLE,
"income" BIGINT,
"poverty" DOUBLE,
"commute_time" DOUBLE,
"owner_occupied" DOUBLE,
"rental" DOUBLE,
"vehicle_0" DOUBLE,
"vehicle_1" DOUBLE,
"vehicle_2" DOUBLE,
"vehicle_3_plus" DOUBLE,
"pop" BIGINT,
"car_to_work" DOUBLE,
"drovealone_dup" DOUBLE,
"carpooled_dup" DOUBLE,
"carpool_2" DOUBLE,
"carpool_3" DOUBLE,
"carpool_4_plus" DOUBLE,
"workers_per_van" DOUBLE,
"public_transit" DOUBLE,
"walk" DOUBLE,
"bike" DOUBLE,
"cab_other" DOUBLE,
"work_home" DOUBLE,
"work_in_state_in_county" DOUBLE,
"work_in_state_out_county" DOUBLE,
"work_out_state" DOUBLE,
"work_in_place" DOUBLE,
"com_10_less" DOUBLE,
"com_15" DOUBLE,
"com_20" DOUBLE,
"com_25" DOUBLE,
"com_30" DOUBLE,
"com_35" DOUBLE,
"com_40" DOUBLE,
"com_45_to_60" DOUBLE,
"com_60_plus" DOUBLE,
"high_school_below" DOUBLE,
"high_school" DOUBLE,
"some_college" DOUBLE,
"bachelors_degree" DOUBLE,
"married" DOUBLE,
"widowed" DOUBLE,
"divorced" DOUBLE,
"seperated" DOUBLE,
"never_married" DOUBLE,
"land_area" BIGINT,
"water_area" BIGINT,
"city_name" VARCHAR,
"state" VARCHAR,
"treated" BIGINT,
"measure_change" BIGINT,
"density" DOUBLE,
"t" BIGINT,
"t_sq" BIGINT,
"edu_highschool_up" DOUBLE,
"water_proportion" DOUBLE,
"against_persons" BIGINT,
"major_violent" BIGINT,
"other_violent" BIGINT
);
Anyone who has the link will be able to view this.