About this Dataset

Public Assets On Data.ct.gov

This dataset provides information about public assets on the CT Open Data Portal. It includes datasets that meet the following criteria:

-Published on the data.ct.gov domain
-Public
-Official (ie published by a registered user)
-Not a derived view

It includes assets that are currently published on the Open Data Portal and does not include assets that have been retired.
Organization: State of Connecticut
Last updated: 2022-09-02T19:36:49.601819
Tags: open-data, site-analytics

Tables

Table 1

@usgov.state_of_connecticut_public_assets_on_data_ct_gov.table_1

733.1 kB
1,680 rows
29 columns

CREATE TABLE table_1 (
  "asset_id" VARCHAR,
  "asset_name" VARCHAR,
  "description" VARCHAR,
  "owner" VARCHAR,
  "owner_id" VARCHAR,
  "type" VARCHAR,
  "category" VARCHAR,
  "tags" VARCHAR,
  "url" VARCHAR,
  "api_endpoint" VARCHAR,
  "creation_date" TIMESTAMP,
  "last_metadata_update_date" TIMESTAMP,
  "last_data_update_date" TIMESTAMP,
  "update_frequency" VARCHAR,
  "days_since_last_data_update" BIGINT,
  "target_days_since_last_update" DOUBLE,
  "is_dataset_up_to_date" VARCHAR  -- Is Dataset Up-to-date?,
  "visits" BIGINT,
  "downloads" BIGINT,
  "row_count" DOUBLE,
  "column_count" DOUBLE,
  "contact_email" VARCHAR,
  "license" VARCHAR,
  "attribution" VARCHAR,
  "attribution_link" VARCHAR,
  "agency" VARCHAR,
  "geographic_unit" VARCHAR,
  "temporal_coverage" VARCHAR,
  "common_core_homepage" VARCHAR
);