Monthly Rainfall And Temperatures (UK)
Met Office Climate District
@kaggle.thedevastator_monthly_average_rainfall_and_temperature_in_nort
Met Office Climate District
@kaggle.thedevastator_monthly_average_rainfall_and_temperature_in_nort
CREATE TABLE average_rainfall_temperature_1 (
"index" BIGINT,
"organisationname" VARCHAR,
"organisationcode" VARCHAR,
"publisheddate" TIMESTAMP,
"durationfrom" TIMESTAMP,
"durationto" TIMESTAMP,
"latestdata" BOOLEAN,
"geoname" VARCHAR,
"reportingperiodtype" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"rainfallmm" DOUBLE,
"temp" DOUBLE,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" DOUBLE,
"unnamed_19" DOUBLE,
"unnamed_20" DOUBLE,
"unnamed_21" DOUBLE,
"unnamed_22" DOUBLE,
"unnamed_23" DOUBLE,
"unnamed_24" DOUBLE,
"unnamed_25" DOUBLE,
"unnamed_26" DOUBLE,
"unnamed_27" DOUBLE,
"unnamed_28" DOUBLE,
"unnamed_29" DOUBLE,
"unnamed_30" DOUBLE,
"unnamed_31" DOUBLE,
"unnamed_32" DOUBLE,
"unnamed_33" DOUBLE,
"unnamed_34" DOUBLE,
"unnamed_35" DOUBLE
);
CREATE TABLE average_rainfall_temperature_metatdata_2 (
"index" BIGINT,
"dataset_id_dsid" BIGINT,
"dataset_name" VARCHAR,
"field" VARCHAR,
"type" VARCHAR,
"mandatory_or_optional_requirement_mor" VARCHAR,
"field_description" VARCHAR,
"schema" VARCHAR,
"lcc_mapping" VARCHAR,
"schema_comments" VARCHAR,
"schema_data_rules_comment" VARCHAR,
"formatreference" VARCHAR,
"example" VARCHAR
);
Anyone who has the link will be able to view this.