About this Dataset

WPRDC Statistics

Data about the usage of the WPRDC site and its various datasets, obtained by combining Google Analytics statistics with information from the WPRDC's data portal.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:58:50.196104
Tags: _etl, statistics, updated-daily, wprdc

Tables

WPRDC Resource Downloads By Month

@usgov.allegheny_county_city_of_pitts_wprdc_statistics.wprdc_resource_downloads_by_month

1.36 MB
155,510 rows
10 columns

CREATE TABLE wprdc_resource_downloads_by_month (
  "n__id" BIGINT  -- Id,
  "year_month" BIGINT,
  "package" VARCHAR,
  "resource" VARCHAR,
  "publisher" VARCHAR,
  "groups" VARCHAR,
  "package_id" VARCHAR,
  "resource_id" VARCHAR,
  "downloads" BIGINT,
  "unique_downloads" BIGINT
);

WPRDC Resource Pageviews By Month

@usgov.allegheny_county_city_of_pitts_wprdc_statistics.wprdc_resource_pageviews_by_month

1.31 MB
162,686 rows
9 columns

CREATE TABLE wprdc_resource_pageviews_by_month (
  "n__id" BIGINT  -- Id,
  "year_month" BIGINT,
  "package" VARCHAR,
  "resource" VARCHAR,
  "publisher" VARCHAR,
  "groups" VARCHAR,
  "package_id" VARCHAR,
  "resource_id" VARCHAR,
  "pageviews" BIGINT
);