NIBRS Group A Offense Crimes
City of Austin
@usgov.city_of_austin_nibrs_group_a_offense_crimes
City of Austin
@usgov.city_of_austin_nibrs_group_a_offense_crimes
CREATE TABLE table_1 (
"offense_id" VARCHAR,
"case_report_number" BIGINT,
"occurred_date" VARCHAR,
"occurred_time" BIGINT,
"sector" VARCHAR,
"council_district" VARCHAR,
"nibrs_category" VARCHAR,
"nibrs_description" VARCHAR,
"nibrs_group" VARCHAR,
"occurred_year" BIGINT,
"occurred_month" VARCHAR,
"census_block_group" VARCHAR,
"reported_date" VARCHAR,
"occurred_day_of_week" VARCHAR,
"zip_code" VARCHAR,
"location_description" VARCHAR,
"victim_gender" VARCHAR,
"victim_age_range" VARCHAR,
"victim_race_ethnicity" VARCHAR,
"nibrs_offense_code_and_extension_description" VARCHAR,
"internal_clearance_status" VARCHAR
);
Anyone who has the link will be able to view this.