Name: Downtown Activation Plan Dashboard Data
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Downtown Activation Plan Dashboard Data

This data powers the Downtown Activation Plan Dashboard.
Organization: City of Seattle
Last updated: 2024-12-16T22:25:11.499411
Tags: downtown, downtown-activation-plan, oed, office-of-economic-development, seattle-downtown-revitalization

Tables

Table 1

@usgov.city_of_seattle_downtown_activation_plan_dashboard_data.table_1

33.35 kB
25 rows
35 columns

CREATE TABLE table_1 (
  "period" VARCHAR,
  "inventory_units" BIGINT,
  "n__occupied_units" BIGINT  -- # Occupied Units,
  "residential_occupancy" DOUBLE,
  "effective_rent_unit" BIGINT,
  "residential_foot_traffic" BIGINT,
  "residential_recovery" DOUBLE  -- Residential Recovery %,
  "resident_average_stay_duration_in_minutes" BIGINT  -- Resident Average Stay (duration In Minutes),
  "office_occupancy_rate" DOUBLE,
  "n__occupied_sqft" BIGINT  -- # Occupied Sqft,
  "average_office_rent_sqft" DOUBLE,
  "worker_foot_traffic" BIGINT,
  "worker_recovery" DOUBLE  -- Worker Recovery %,
  "worker_average_stay_duration_in_minutes" BIGINT  -- Worker Average Stay (duration In Minutes),
  "visitor_foot_traffic" BIGINT,
  "visitor_recovery" DOUBLE  -- Visitor Recovery %,
  "visitor_average_stay_duration_in_minutes" BIGINT  -- Visitor Average Stay (duration In Minutes),
  "hotel_revenue_trailing_3_months" DOUBLE  -- Hotel Revenue (trailing 3 Months),
  "hotel_occupancy_rate_trailing_3_months" DOUBLE  -- Hotel Occupancy Rate (trailing 3 Months),
  "transit_ridership" DOUBLE,
  "n__new_business_licenses_issued" BIGINT  -- # New Business Licenses Issued,
  "license_activation_fee_food_service" DOUBLE  -- License Activation Fee - Food Service,
  "dining_recovery_us" DOUBLE  -- Dining Recovery - US,
  "dining_recovery_washington" DOUBLE  -- Dining Recovery - Washington,
  "dining_recovery_seattle" DOUBLE  -- Dining Recovery - Seattle,
  "retail_occupancy" DOUBLE,
  "minority_owned_businesses" DOUBLE,
  "women_owned_businesses" DOUBLE,
  "weekend_foot_traffic" BIGINT,
  "weeknight_foot_traffic" BIGINT,
  "license_activation_fee_arts_entertainment" DOUBLE  -- License Activation Fee - Arts & Entertainment,
  "foot_traffic_in_downtown_parks" BIGINT,
  "parks_average_stay_length" BIGINT  -- Parks Average Stay (length),
  "parks_median_stay_length" BIGINT  -- Parks Median Stay (length),
  "tree_canopy_cover" DOUBLE
);