About this Dataset

Petitions To The Rent Board

Petitions may be filed for a variety of reasons, most commonly to have the Rent Board determine the rent. Some of the other common petition filing grounds include: decrease in housing services, unlawful rent increase, failure to repair and maintain, roommate proportional share of the rent, general obligation bond passthrough challenge, utility passthrough challenge, water revenue bond passthrough challenge, violation of the Residential Hotel Visitor Policy, capital improvement passthroughs, operating and maintenance expense increases, extension of time (to perform capital improvement work), comparable rents, intent to withdraw (Ellis), utility passthrough petition and worksheet, Costa-Hawkins determination, Rules and Regulations §1.21, hardship applications, and Alternative Dispute Resolution (ADR). Petitions are also accepted on “other” grounds. For more information, please see: https://www.sf.gov/landlord-petitions-and-passthroughs and https://www.sf.gov/tenant-petitions
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:14.786984

Tables

Table 1

@usgov.city_of_san_francisco_petitions_to_the_rent_board.table_1

1.12 MB
57,220 rows
45 columns

CREATE TABLE table_1 (
  "petition_id" VARCHAR,
  "date_filed" TIMESTAMP,
  "priority" VARCHAR,
  "appeal_id" VARCHAR,
  "filing_party" VARCHAR,
  "prop_i_petition" VARCHAR,
  "ground_landlord_capital_improvement" BOOLEAN  -- Ground (landlord): Capital Improvement,
  "ground_landlord_comparable_rents" BOOLEAN  -- Ground (landlord): Comparable Rents,
  "ground_landlord_extension_of_time_for_capital_improvements" BOOLEAN  -- Ground (landlord): Extension Of Time For Capital Improvements,
  "ground_landlord_intent_to_withdraw_ellis" BOOLEAN  -- Ground (landlord): Intent To Withdraw (Ellis),
  "ground_landlord_other" BOOLEAN  -- Ground (landlord): Other,
  "ground_landlord_operating_maintenance" BOOLEAN  -- Ground (landlord): Operating & Maintenance,
  "ground_landlord_substantial_rehabilitation" BOOLEAN  -- Ground (landlord): Substantial Rehabilitation,
  "ground_landlord_costa_hawkins" BOOLEAN  -- Ground (landlord): Costa-Hawkins,
  "ground_landlord_exemption" BOOLEAN  -- Ground (landlord): Exemption,
  "ground_landlord_rules_and_regulations_section_1_21" BOOLEAN  -- Ground (landlord): Rules And Regulations Section 1.21,
  "ground_landlord_rules_and_regulations_section_6_14" BOOLEAN  -- Ground (landlord): Rules And Regulations Section 6.14,
  "ground_landlord_rules_and_regulations_section_6_15" BOOLEAN  -- Ground (landlord): Rules And Regulations Section 6.15,
  "ground_landlord_sro_hotel_vistor_policy_petition" BOOLEAN  -- Ground (landlord): SRO Hotel Vistor Policy Petition,
  "ground_landlord_utility_passthrough_petition" BOOLEAN  -- Ground (landlord): Utility Passthrough Petition,
  "ground_landlord_owner_move_in_disability_determination" BOOLEAN  -- Ground (landlord): Owner Move-In Disability Determination,
  "ground_landlord_utility_passthrough_worksheet" BOOLEAN  -- Ground (landlord): Utility Passthrough Worksheet,
  "ground_landlord_non_comparable_rents" BOOLEAN  -- Ground (landlord): Non-Comparable Rents,
  "ground_tenant_decrease_in_housing_services" BOOLEAN  -- Ground (tenant): Decrease In Housing Services,
  "ground_tenant_failure_to_repair_and_maintain" BOOLEAN  -- Ground (tenant): Failure To Repair And Maintain,
  "ground_tenant_passthrough_challenge" BOOLEAN  -- Ground (tenant): Passthrough Challenge,
  "ground_tenant_summary_petition" BOOLEAN  -- Ground (tenant): Summary Petition,
  "ground_tenant_unlawful_rent_increase" BOOLEAN  -- Ground (tenant): Unlawful Rent Increase,
  "ground_tenant_wrongful_eviction_report" BOOLEAN  -- Ground (tenant): Wrongful Eviction Report,
  "ground_tenant_section_8_tenancy" BOOLEAN  -- Ground (tenant): Section 8 Tenancy,
  "ground_tenant_sro_hotel_vistor_policy_petition" BOOLEAN  -- Ground (tenant): SRO Hotel Vistor Policy Petition,
  "ground_tenant_rules_and_regulations_section_6_15" BOOLEAN  -- Ground (tenant): Rules And Regulations Section 6.15,
  "ground_tenant_other" BOOLEAN  -- Ground (tenant): Other,
  "ground_tenant_utility_passhtrough_hardship" BOOLEAN  -- Ground (tenant): Utility Passhtrough Hardship,
  "ground_tenant_water_revenue_bond_passthrough_hardship" BOOLEAN  -- Ground (tenant): Water Revenue Bond Passthrough Hardship,
  "ground_tenant_capital_improvement_passthrough_hardship_petition" BOOLEAN  -- Ground (tenant): Capital Improvement Passthrough Hardship Petition,
  "ground_tenant_wrongful_severance_of_housing_service" BOOLEAN  -- Ground (tenant): Wrongful Severance Of Housing Service,
  "ground_alternative_dispute_resolution" BOOLEAN  -- Ground: Alternative Dispute Resolution,
  "address" VARCHAR,
  "petition_source_zipcode" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhoods_analysis_boundaries" VARCHAR  -- Neighborhoods - Analysis Boundaries,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);