Germany City Rainfall Data
Weather Patterns Rainfall and Climate German Cities
@kaggle.heidarmirhajisadati_germany_city_rainfall_data
Weather Patterns Rainfall and Climate German Cities
@kaggle.heidarmirhajisadati_germany_city_rainfall_data
This dataset, provides detailed weather and climate statistics for major cities in Germany from 2015 to 2023.
It includes rainfall amounts, temperatures, humidity levels, and other geographical and climatic details, making it ideal for analyzing weather patterns, climate change, and their impacts across different regions.
City: Name of the city.
Latitude: City's latitude in degrees.
Longitude: City's longitude in degrees.
Month: The month number (1-12).
Year: The year of the data.
Rainfall (mm): Rainfall amount in millimeters.
Elevation (m): City’s elevation above sea level in meters.
Climate_Type: The climate classification of the city.
Temperature (°C): Average temperature for the month in Celsius.
Humidity (%): Average humidity level for the month in percentage.
CREATE TABLE rainfall_data_germany_complete (
"city" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"month" BIGINT,
"year" BIGINT,
"rainfall_mm" DOUBLE -- Rainfall (mm),
"elevation_m" BIGINT -- Elevation (m),
"climate_type" VARCHAR,
"temperature_c" DOUBLE -- Temperature (°C),
"humidity" BIGINT -- Humidity (%)
);Anyone who has the link will be able to view this.