About this Dataset

Buyout Agreements

Contains buyout declarations and buyout agreements filed at the Rent Board. Rent Ordinance Section 37.9E, effective March 7, 2015, is a provision that regulates "buyout agreements" between landlords and tenants under which landlords pay tenants money or other consideration to vacate their rent-controlled rental units. For more information, please see: https://www.sf.gov/information/buyout-agreements
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:03.514926
Tags: buyouts, rent-control

Tables

Table 1

@usgov.city_of_san_francisco_buyout_agreements.table_1

366.3 kB
7,646 rows
29 columns

CREATE TABLE table_1 (
  "case_number" VARCHAR,
  "pre_buyout_disclosure_declaration_date" TIMESTAMP,
  "buyout_agreement_date" TIMESTAMP,
  "buyout_amount" DOUBLE,
  "unknown_amount" VARCHAR,
  "other_consideration" VARCHAR,
  "number_of_tenants" DOUBLE,
  "address" VARCHAR,
  "zip_code" BIGINT,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "point" VARCHAR,
  "geocoding_confidence" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "delete_neighborhoods" DOUBLE  -- DELETE - Neighborhoods,
  "delete_police_districts" DOUBLE  -- DELETE - Police Districts,
  "delete_supervisor_districts" DOUBLE  -- DELETE - Supervisor Districts,
  "delete_fire_prevention_districts" DOUBLE  -- DELETE - Fire Prevention Districts,
  "delete_zip_codes" DOUBLE  -- DELETE - Zip Codes,
  "areas_of_vulnerability_2016" DOUBLE  -- Areas Of Vulnerability, 2016,
  "central_market_tenderloin_boundary" DOUBLE,
  "invest_in_neighborhoods_iin_areas" DOUBLE  -- Invest In Neighborhoods (IIN) Areas,
  "civic_center_harm_reduction_project_boundary" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE
);