Tunisia Precipitation 2014 -2022
Rainfall Patterns in Tunisia
@kaggle.alimekni_tunisia_precipitation_2014_2022
Rainfall Patterns in Tunisia
@kaggle.alimekni_tunisia_precipitation_2014_2022
This dataset provides rainfall data from multiple meteorological stations across Tunisia. From 2014-07-02, to 2023-02-26 this dataset is invaluable for climatologists and researchers aiming to analyze precipitation patterns, forecast future rainfall, and study the effects of climate on water resources in Tunisia.
The dataset includes daily rainfall measurements from various stations in Tunisia. Each entry contains information about the amount of rainfall recorded, comparisons with historical data, and other relevant statistics. The dataset is structured to facilitate easy analysis and comparison across different time periods and locations.
CREATE TABLE n_30_12_2014 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2016 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2017 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2018 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2019 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2020 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2021 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_30_12_2022 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2016 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2017 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2018 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2019 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2020 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2021 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2022 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_01_2023 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2016 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2017 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2018 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2019 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2020 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2021 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_03_2022 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_05_2016 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
CREATE TABLE n_31_05_2017 (
"percentage" VARCHAR -- Percentage %,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR -- Seasonal Comparison Percentage %,
"seasonal_comparison_monthly_difference" BIGINT,
"last_year_rainy_period" BIGINT,
"last_year_monthly_rain_fall" BIGINT,
"percentage_current_year" VARCHAR,
"accumulated_daily_averages_current_year" BIGINT,
"daily_accumulated_current_year" BIGINT,
"percentage_monthly_rain_current_year" VARCHAR,
"average_monthly_rain" BIGINT,
"accumulated_monthly_rain_current_year" BIGINT,
"rainfall_today" BIGINT,
"station" VARCHAR
);
Anyone who has the link will be able to view this.