Ethics Commission Advice Letters by US Government | Demographics and Population Studies

About this Dataset

Ethics Commission Advice Letters

A. SUMMARY This dataset contains historical records of formal advice issued by the Ethics Commission. The San Francisco Charter gives the Ethics Commission the authority to provide written formal opinions. Written formal opinions are available to individuals who request advice about their responsibilities under local law. Formal opinions provide the requester immunity from subsequent enforcement action if the material facts are as stated in the request for advice, and if the District Attorney and City Attorney concur in the advice. Formal opinions prepared by staff must be approved by the full Commission. B. HOW THE DATASET IS CREATED This dataset is created from a data import of formal advice issued by the Ethics Commission. C. UPDATE PROCESS This dataset will not be regularly updated because it contains historical records. D. HOW TO USE THIS DATASET Advice records may be filtered by section of law or category of law. The same advice letter may be listed more than once if it's related to multiple code sections of law. Use the filter on the "Section" column to find advice by code section. Use the search bar to find advice by relevant search terms. Click on "View Advice" to access the full advice letter on the commission's website.
Organization: City of San Francisco
Last updated: 2025-06-07T18:31:17.013970

Tables

Table 1

@usgov.city_of_san_francisco_ethics_commission_advice_letters.table_1

39.31 KB
80 rows
14 columns


CREATE TABLE table_1 (
  "description" VARCHAR,
  "body_of_law" VARCHAR,
  "section" VARCHAR,
  "category" VARCHAR,
  "advice_letter_url" VARCHAR,
  "date" VARCHAR,
  "year_of_date" BIGINT,
  "month_of_date" VARCHAR,
  "day_of_date" BIGINT,
  "search" VARCHAR,
  "code_section" VARCHAR,
  "issues_discussed" VARCHAR,
  "requester" VARCHAR,
  "subject" VARCHAR
);