Repeat Offender Violation Cases With Notice Of Violation Link
City of Austin
@usgov.city_of_austin_repeat_offender_violation_cases_with_no_c9873c2f
City of Austin
@usgov.city_of_austin_repeat_offender_violation_cases_with_no_c9873c2f
City of Austin Open Data Terms of Use
https://data.austintexas.gov/stories/s/ranj-cccq
This is a list of Repeat Offender Property violation cases which includes a link to the Austin Build + Connect portal. Notice of Violation documents can be accessed for each case if issued.
All violations (open and closed) for active ROP properties two years prior to license issuance to present. This captures code violations that met the criteria for the property to be registered in ROP and any violations since the property was registered.
Organization: City of Austin
Last updated: 2020-11-12T13:25:19.448248
Tags: austin-build-connect, notice-of-violation, repeat-offender, repeat-violations, violation-case
CREATE TABLE table_1 (
"license_number" VARCHAR,
"license_address" VARCHAR,
"license_status" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"number_of_units" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"violation_case_number" VARCHAR,
"violation_case_date" TIMESTAMP,
"violation_case_link" VARCHAR,
"location" VARCHAR,
"parcelid" VARCHAR
);Anyone who has the link will be able to view this.