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_01_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_01_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_01_01_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_01_01_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_01_01_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_01_01_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_01_02_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_01_02_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_01_02_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_01_02_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_01_02_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_01_02_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_01_02_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_01_02_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_01_03_2015 (
"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_01_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_01_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_01_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_01_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_01_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_01_04_2015 (
"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_01_04_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_01_04_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_01_04_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_01_04_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
);
Anyone who has the link will be able to view this.