Short Term Rental License
City of Seattle
@usgov.city_of_seattle_short_term_rental_license
City of Seattle
@usgov.city_of_seattle_short_term_rental_license
CREATE TABLE table_1 (
"licenseid" VARCHAR,
"licensestatus" VARCHAR,
"licenseexpirationdate" VARCHAR,
"seattlebusinesslicensenumber" DOUBLE,
"legacystatus" VARCHAR,
"unitid" VARCHAR,
"unitstatus" VARCHAR,
"addressline" VARCHAR,
"housenumber" DOUBLE,
"housenumbermodifier" VARCHAR,
"prefixdirection" VARCHAR,
"streetname" VARCHAR,
"suffixdirection" VARCHAR,
"suffix" VARCHAR,
"zipcode" DOUBLE,
"city" VARCHAR,
"state" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"propertytype" VARCHAR,
"unitnumber" VARCHAR,
"bedroomcount" VARCHAR,
"unitlegacy" VARCHAR,
"geographicregion" VARCHAR,
"primaryresidence" VARCHAR,
"rrioregistration" VARCHAR,
"wastatetransientaccommodation" VARCHAR
);
Anyone who has the link will be able to view this.