Baselight

Uber And Urban Crime

Uber and Urban Crime Dataset

@kaggle.saurabhshahane_uber_and_urban_crime

Loading...
Loading...

About this Dataset

Uber And Urban Crime

Context

This provides information about Crime (as measured by NIBRS) and Uber entry by city.

Acknowledgements

Weber, Bryan (2019), “Data for: Uber and Urban Crime”, Mendeley Data, V1, doi: 10.17632/4vfygpw58y.1

Tables

Uberdata 9–3

@kaggle.saurabhshahane_uber_and_urban_crime.uberdata_9_3
  • 250.33 KB
  • 1080 rows
  • 147 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.