About this Dataset

[Historical Only] 311 Top Articles Referenced (current, From Nov. 2017 Forward)

This report tracks the name and source/website of the articles referenced for each month shown. Titles with a department name at the end reflect information provided from the department website. The other articles are maintained by SF311 to supplement department data. Articles used by 311 in the course of creating service requests (such as graffiti handling processes) are not included. Metrics of knowledge use from September and October 2017 was inconsistent following the migration to a new system in September 2017. Additionally, the names of articles is different than article names prior to the upgrade. This dataset is updated monthly.

Note - This is not up-to-date as of June 2023. We are working to fully load the full data in the near future.
For historical data (Top Articles Referenced through Aug. 2017), go to:
https://data.sfgov.org/City-Infrastructure/311-Top-Articles-Referenced-historical-through-Aug/hrr4-hjc6/data
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:07.953112

Tables

Table 1

@usgov.city_of_san_francisco_311_top_articles_referenced_curr_4e5b9cf5.table_1

1.04 MB
20,469 rows
69 columns

CREATE TABLE table_1 (
  "top_articles_referenced" VARCHAR,
  "june_2023" BIGINT,
  "may_2023" BIGINT,
  "april_2023" BIGINT,
  "march_2023" BIGINT,
  "february_2023" BIGINT,
  "january_2023" BIGINT,
  "december_2022" BIGINT,
  "november_2022" BIGINT,
  "october_2022" BIGINT,
  "september_2022" BIGINT,
  "august_2022" BIGINT,
  "july_2022" BIGINT,
  "june_2022" BIGINT,
  "may_2022" BIGINT,
  "april_2022" BIGINT,
  "march_2022" BIGINT,
  "february_2022" BIGINT,
  "january_2022" BIGINT,
  "december_2021" BIGINT,
  "november_2021" BIGINT,
  "october_2021" BIGINT,
  "september_2021" BIGINT,
  "august_2021" BIGINT,
  "july_2021" BIGINT,
  "june_2021" BIGINT,
  "may_2021" BIGINT,
  "april_2021" BIGINT,
  "march_2021" BIGINT,
  "february_2021" BIGINT,
  "january_2021" BIGINT,
  "december_2020" BIGINT,
  "november_2020" BIGINT,
  "october_2020" BIGINT,
  "september_2020" BIGINT,
  "august_2020" BIGINT,
  "july_2020" BIGINT,
  "june_2020" BIGINT,
  "may_2020" BIGINT,
  "april_2020" BIGINT,
  "march_2020" BIGINT,
  "february_2020" BIGINT,
  "january_2020" BIGINT,
  "december_2019" BIGINT,
  "november_2019" BIGINT,
  "october_2019" BIGINT,
  "september_2019" BIGINT,
  "august_2019" BIGINT,
  "july_2019" BIGINT,
  "june_2019" BIGINT,
  "may_2019" BIGINT,
  "april_2019" BIGINT,
  "march_2019" BIGINT,
  "february_2019" BIGINT,
  "january_2019" BIGINT,
  "december_2018" BIGINT,
  "november_2018" BIGINT,
  "october_2018" BIGINT,
  "september_2018" BIGINT,
  "august_2018" BIGINT,
  "july_2018" BIGINT,
  "june_2018" BIGINT,
  "april_2018" BIGINT,
  "may_2018" BIGINT,
  "march_2018" BIGINT,
  "february_2018" BIGINT,
  "january_2018" BIGINT,
  "december_2017" BIGINT,
  "november_2017" BIGINT
);