Building Code Scofflaw List
City of Chicago
@usgov.city_of_chicago_building_code_scofflaw_list
City of Chicago
@usgov.city_of_chicago_building_code_scofflaw_list
CREATE TABLE table_1 (
"defendant_owner" VARCHAR,
"address" VARCHAR,
"secondary_address" VARCHAR,
"tertiary_address" VARCHAR,
"circuit_court_case_number" VARCHAR,
"building_list_date" TIMESTAMP,
"owner_list_date" TIMESTAMP,
"community_area" VARCHAR,
"community_area_number" BIGINT,
"ward" BIGINT,
"x_coordinate" DOUBLE,
"y_coordinate" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"location" VARCHAR,
"record_id" VARCHAR
);
Anyone who has the link will be able to view this.