Dataset records — daily summary

Daily aggregates of CC0-licensed dataset records.

Data license: CC0-1.0 · Data source: CleanTechHUB platform (cth_platform v1)

✎ View and edit SQL

This data as json

dataset_slug 0

0 records

CREATE TABLE "dataset_records_summary" ("dataset_id" TEXT, "dataset_slug" TEXT, "dataset_kind" TEXT, "site_id" TEXT, "day" TEXT, "n_records" TEXT, "avg_v1" TEXT, "min_v1" TEXT, "max_v1" TEXT, "avg_v2" TEXT, "min_v2" TEXT, "max_v2" TEXT);
CREATE INDEX "idx_dataset_records_summary_dataset_slug" ON "dataset_records_summary" ("dataset_slug");
CREATE INDEX "idx_dataset_records_summary_site_id" ON "dataset_records_summary" ("site_id");
CREATE INDEX "idx_dataset_records_summary_day" ON "dataset_records_summary" ("day");