Tunisia Precipitation 2014 -2022
Rainfall Patterns in Tunisia
@kaggle.alimekni_tunisia_precipitation_2014_2022
Rainfall Patterns in Tunisia
@kaggle.alimekni_tunisia_precipitation_2014_2022
CREATE TABLE n_03_08_2015 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_08_2020 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_08_2021 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_09_2014 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_09_2015 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_09_2019 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2014 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2015 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2016 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2019 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2020 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2021 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_10_2022 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_11_2015 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_11_2016 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2014 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2015 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2016 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2017 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2019 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2020 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_03_12_2021 (
"percentage" VARCHAR,
"yearly_average" DOUBLE,
"seasonal_comparison_percentage" VARCHAR,
"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_04_01_2018 (
"percentage" VARCHAR,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR,
"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_04_01_2020 (
"percentage" VARCHAR,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR,
"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_04_01_2021 (
"percentage" VARCHAR,
"yearly_average" BIGINT,
"seasonal_comparison_percentage" VARCHAR,
"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.