Name: Seattle Business License
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Seattle Business License

Provides a geographic representation of active businesses licensed in DEA's Seattle Licensing Information System (SLIM).
Organization: City of Seattle
Last updated: 2025-02-28T23:49:29.052938
Tags: business, dea, fas, seattle-gis-open-data, slim

Tables

Table 1

@usgov.city_of_seattle_seattle_business_license.table_1

7.05 MB
53974 rows
34 columns


CREATE TABLE table_1 (
  "objectid" DOUBLE,
  "buslic_id" VARCHAR,
  "buslic_location_id" VARCHAR,
  "buslic_year_num" VARCHAR,
  "buslic_expiration_date" VARCHAR,
  "buslic_legal_name" VARCHAR,
  "buslic_trade_name" VARCHAR,
  "buslic_location_type" VARCHAR,
  "buslic_status_type" VARCHAR,
  "buslic_contact_name" VARCHAR,
  "buslic_phone_num" VARCHAR,
  "buslic_sic_code" DOUBLE,
  "buslic_sic_desc" VARCHAR,
  "buslic_naics_code" DOUBLE,
  "naics_desc" VARCHAR,
  "address" VARCHAR,
  "buslic_dap_id" DOUBLE,
  "buslic_maf_id" DOUBLE,
  "buslic_cpn_id" DOUBLE,
  "buslic_snd_id" DOUBLE,
  "buslic_mail_adrs_text" VARCHAR,
  "buslic_mailing_dap_id" VARCHAR,
  "buslic_mailing_maf_id" VARCHAR,
  "buslic_mailing_cpn_id" VARCHAR,
  "buslic_mailing_snd_id" DOUBLE,
  "buslic_symbol_num" DOUBLE,
  "buslic_prkstall_num" DOUBLE,
  "buslic_pubprk_flag" VARCHAR,
  "buslic_opendate" TIMESTAMP,
  "se_anno_cad_data" VARCHAR,
  "buslic_business_id" DOUBLE,
  "buslic_cityacctnum" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);