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
By data.world's Admin [source]
For more datasets, click here.
- 🚨 Your notebook can be here! 🚨!
To use this dataset, start by making sure you are familiar with the following fields: OrganisationName, OrganisationCode, PublishedDate, DurationFrom (start date of reported period), DurationTo (end date of reported period), LatestData (indicating if latest available data is provided or not), GeoName (name of geographical area being reported on), ReportingPeriodType (type of reporting period i.e monthly/yearly/seasonal etc.), Year, Rainfallmm(average rainfall in millimeters), Temp(average temperature in centigrade), Dataset Name(name of the dataset provided). These are all important pieces of information that must be known before delving into the other columns.
- Developing predictive models for drought and flooding with the help of average temperature and rainfall data
- Producing reports to inform farmers on various farming activities that need to be done depending on the climate conditions in the region
- Creating visualizations which can compare historical trends of average temperature and rainfall in different regions
If you use this dataset in your research, please credit the original authors.
Data Source
License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.
File: average-rainfall-temperature-1.csv
| Column name | Description |
|---|---|
| OrganisationName | Name of the organisation providing the data. (String) |
| OrganisationCode | Code associated with the name of the organisation providing the data. (String) |
| PublishedDate | Date when that particular set of data was published. (Date) |
| DurationFrom | Start date of that respective period. (Date) |
| DurationTo | End date of the respective period. (Date) |
| LatestData | It specifies whether or not that particular set is available to you. (Boolean) |
| GeoName | Place/location where these climatic conditions exists. (String) |
| ReportingPeriodType | Specifies whether it is a monthly/yearly report. (String) |
| Year | Indicates year for which these statistical values have been obtained. (Integer) |
| Rainfallmm | Average rainfall in millimetres during specified period. (Float) |
| Temp | Average temperature in centigrade during specified period. (Float) |
File: average-rainfall-temperature-metatdata-2.csv
| Column name | Description |
|---|---|
| Dataset Name | Name of the dataset. (String) |
| Field | Details a certain aspect or parameter amongst numerous parameters present within a resultset. (String) |
| Type | Whether its Numerical value or DoT notation. (String) |
| Mandatory or Optional requirement (MOR) | This field tells us if we require anything specific while submitting our queries. (String) |
| Field Description | A brief overview about how one should interpret those statistical values specified within field column. (String) |
| Schema | Structure designed upon which several databases operate accordingly. (String) |
| LCC Mapping | It helps us connect our localised climate change schema with predefined rules laid down through international organisations according to their framework. (String) |
| Schema Comments | These help out users inquire further about concerning issues having no clarification on user manual / forum so crated by enterprise itself. (String) |
| Schema Data Rules Comment | Comments discussing any changes made into existing methods adopted between alterations in datasets. (String) |
| FormatReference | Reference to the format of the data. (String) |
| Example | Example of the data. (String) |
If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit data.world's Admin.
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: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" DOUBLE -- Unnamed: 18,
"unnamed_19" DOUBLE -- Unnamed: 19,
"unnamed_20" DOUBLE -- Unnamed: 20,
"unnamed_21" DOUBLE -- Unnamed: 21,
"unnamed_22" DOUBLE -- Unnamed: 22,
"unnamed_23" DOUBLE -- Unnamed: 23,
"unnamed_24" DOUBLE -- Unnamed: 24,
"unnamed_25" DOUBLE -- Unnamed: 25,
"unnamed_26" DOUBLE -- Unnamed: 26,
"unnamed_27" DOUBLE -- Unnamed: 27,
"unnamed_28" DOUBLE -- Unnamed: 28,
"unnamed_29" DOUBLE -- Unnamed: 29,
"unnamed_30" DOUBLE -- Unnamed: 30,
"unnamed_31" DOUBLE -- Unnamed: 31,
"unnamed_32" DOUBLE -- Unnamed: 32,
"unnamed_33" DOUBLE -- Unnamed: 33,
"unnamed_34" DOUBLE -- Unnamed: 34,
"unnamed_35" DOUBLE -- Unnamed: 35
);CREATE TABLE average_rainfall_temperature_metatdata_2 (
"index" BIGINT,
"dataset_id_dsid" BIGINT -- Dataset ID (DSID),
"dataset_name" VARCHAR,
"field" VARCHAR,
"type" VARCHAR,
"mandatory_or_optional_requirement_mor" VARCHAR -- Mandatory Or Optional Requirement (MOR),
"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.