Catálogo De Dados Dos Dados.gov.pt
Agência para a Modernização Administrativa
@ptgov.n_67c5a3b3b50fe67ba7aa1905
Agência para a Modernização Administrativa
@ptgov.n_67c5a3b3b50fe67ba7aa1905
CREATE TABLE export_dataset_20250824_021058 (
"id" VARCHAR,
"title" VARCHAR,
"slug" VARCHAR,
"acronym" VARCHAR,
"url" VARCHAR,
"organization" VARCHAR,
"organization_id" VARCHAR,
"owner" VARCHAR,
"owner_id" VARCHAR,
"description" VARCHAR,
"frequency" VARCHAR,
"license" VARCHAR,
"temporal_coverage_start" TIMESTAMP,
"temporal_coverage_end" TIMESTAMP,
"spatial_granularity" VARCHAR,
"spatial_zones" VARCHAR,
"featured" BOOLEAN,
"created_at" TIMESTAMP,
"last_modified" TIMESTAMP,
"tags" VARCHAR,
"archived" VARCHAR,
"resources_count" BIGINT,
"main_resources_count" BIGINT,
"resources_formats" VARCHAR,
"harvest_backend" VARCHAR,
"harvest_domain" VARCHAR,
"harvest_created_at" TIMESTAMP,
"harvest_modified_at" TIMESTAMP,
"harvest_remote_url" VARCHAR,
"quality_score" DOUBLE,
"metric_discussions" BIGINT,
"metric_reuses" BIGINT,
"metric_followers" BIGINT,
"metric_views" BIGINT,
"metric_resources_downloads" BIGINT
);
CREATE TABLE export_discussion_20250824_021214 (
"id" VARCHAR,
"user" VARCHAR,
"subject" VARCHAR,
"subject_class" VARCHAR,
"subject_id" VARCHAR,
"title" VARCHAR,
"size" BIGINT,
"participants" VARCHAR,
"messages" VARCHAR,
"created" TIMESTAMP,
"closed" TIMESTAMP,
"closed_by" VARCHAR,
"closed_by_id" VARCHAR,
"closed_by_organization" VARCHAR,
"closed_by_organization_id" VARCHAR
);
CREATE TABLE export_harvest_20250824_021251 (
"id" VARCHAR,
"name" VARCHAR,
"url" VARCHAR,
"organization" VARCHAR,
"organization_id" VARCHAR,
"backend" VARCHAR,
"created_at" TIMESTAMP,
"validation" VARCHAR
);
CREATE TABLE export_organization_20250824_021251 (
"id" VARCHAR,
"name" VARCHAR,
"acronym" VARCHAR,
"slug" VARCHAR,
"url" VARCHAR,
"description" VARCHAR,
"logo" VARCHAR,
"badges" VARCHAR,
"created_at" TIMESTAMP,
"last_modified" TIMESTAMP,
"business_number_id" VARCHAR,
"members_count" BIGINT,
"metric_datasets" BIGINT,
"metric_members" BIGINT,
"metric_reuses" BIGINT,
"metric_dataservices" BIGINT,
"metric_followers" BIGINT,
"metric_views" BIGINT,
"downloads" BIGINT
);
CREATE TABLE export_resource_20250824_021213 (
"dataset_id" VARCHAR,
"dataset_title" VARCHAR,
"dataset_slug" VARCHAR,
"dataset_url" VARCHAR,
"dataset_organization" VARCHAR,
"dataset_organization_id" VARCHAR,
"dataset_license" VARCHAR,
"dataset_private" BOOLEAN,
"dataset_archived" VARCHAR,
"id" VARCHAR,
"url" VARCHAR,
"title" VARCHAR,
"description" VARCHAR,
"filetype" VARCHAR,
"type" VARCHAR,
"format" VARCHAR,
"mime" VARCHAR,
"filesize" DOUBLE,
"checksum_type" VARCHAR,
"checksum_value" VARCHAR,
"created_at" TIMESTAMP,
"modified" TIMESTAMP,
"downloads" BIGINT,
"harvest_created_at" VARCHAR,
"harvest_modified_at" VARCHAR,
"schema_name" VARCHAR,
"schema_version" VARCHAR,
"preview_url" VARCHAR,
"extras" VARCHAR
);
CREATE TABLE export_reuse_20250824_021251 (
"id" VARCHAR,
"title" VARCHAR,
"slug" VARCHAR,
"url" VARCHAR,
"type" VARCHAR,
"description" VARCHAR,
"remote_url" VARCHAR,
"organization" VARCHAR,
"organization_id" VARCHAR,
"owner" VARCHAR,
"owner_id" VARCHAR,
"image" VARCHAR,
"featured" BOOLEAN,
"created_at" TIMESTAMP,
"last_modified" TIMESTAMP,
"archived" BOOLEAN,
"topic" VARCHAR,
"tags" VARCHAR,
"datasets" VARCHAR,
"metric_discussions" BIGINT,
"metric_datasets" BIGINT,
"metric_followers" BIGINT,
"metric_views" BIGINT
);
CREATE TABLE export_tag_20250824_021251 (
"name" VARCHAR,
"datasets" BIGINT,
"reuses" BIGINT,
"total" BIGINT
);
Anyone who has the link will be able to view this.