About this Dataset

Public Dataset Access And Usage

A. SUMMARY This dataset is used to report on public dataset access and usage within the open data portal. Each row sums the amount of users who access a dataset each day, grouped by access type (API Read, Download, Page View, etc). B. HOW THE DATASET IS CREATED This dataset is created by joining two internal analytics datasets generated by the SF Open Data Portal. We remove non-public information during the process. C. UPDATE PROCESS This dataset is scheduled to update every 7 days via ETL. D. HOW TO USE THIS DATASET This dataset can help you identify stale datasets, highlight the most popular datasets and calculate other metrics around the performance and usage in the open data portal. Please note a special call-out for two fields: - "derived": This field shows if an asset is an original source (derived = "False") or if it is made from another asset though filtering (derived = "True"). Essentially, if it is derived from another source or not. - "provenance": This field shows if an asset is "official" (created by someone in the city of San Francisco) or "community" (created by a member of the community, not official). All community assets are derived as members of the community cannot add data to the open data portal.
Organization: City of San Francisco
Last updated: 2023-02-04T00:33:06.280104

Tables

Table 1

@usgov.city_of_san_francisco_public_dataset_access_and_usage.table_1

8.17 MB
1563392 rows
8 columns


CREATE TABLE table_1 (
  "event_time" TIMESTAMP,
  "access_count" BIGINT,
  "asset_uid" VARCHAR,
  "access_type" VARCHAR,
  "asset_type" VARCHAR,
  "department" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);