Query: global health estimates - summarize by Paulo Sousa

FROM (SUMMARIZE @owid.compact.owid_compact)
SELECT
    column_name,
    column_type,
    count,
    null_percentage,
    min,
    max

column_name	column_type	count	null_percentage	min	max
country	VARCHAR	520288	0.00	Afghanistan	Zimbabwe
date	TIMESTAMP_NS	520288	0.00	2020-01-01 00:00:00	2025-12-31 00:00:00
total_cases	UINTEGER	520288	2.75	0	778368577
new_cases	UINTEGER	520288	3.35	0	8401906
new_cases_smoothed	FLOAT	520288	3.58	0.0	6402033.0
total_cases_per_million	FLOAT	520288	2.75	0.0	769887.94
new_cases_per_million	FLOAT	520288	3.35	0.0	231770.16
new_cases_smoothed_per_million	FLOAT	520288	3.58	0.0	37737.87
total_deaths	UINTEGER	520288	2.75	0	7098527
new_deaths	USMALLINT	520288	3.19	0	57167
new_deaths_smoothed	FLOAT	520288	3.42	0.0	14820.714
total_deaths_per_million	FLOAT	520288	2.75	0.0	6603.599
new_deaths_per_million	FLOAT	520288	3.19	0.0	611.3003
new_deaths_smoothed_per_million	FLOAT	520288	3.42	0.0	129.2137
excess_mortality	FLOAT	520288	97.38	-95.92102	378.5531
excess_mortality_cumulative	FLOAT	520288	97.38	-44.228275	78.07746
excess_mortality_cumulative_absolute	FLOAT	520288	97.38	-37726.1	1349776.25
excess_mortality_cumulative_per_million	FLOAT	520288	97.39	-2918.8062	10293.515
hosp_patients	UINTEGER	520288	92.19	0	154497
hosp_patients_per_million	FLOAT	520288	92.19	0.0	1526.846
weekly_hosp_admissions	UINTEGER	520288	95.29	0	153977
weekly_hosp_admissions_per_million	FLOAT	520288	95.29	0.0	717.077
icu_patients	USMALLINT	520288	92.48	0	28891
icu_patients_per_million	FLOAT	520288	92.48	0.0	180.675
weekly_icu_admissions	USMALLINT	520288	97.89	0	4838
weekly_icu_admissions_per_million	FLOAT	520288	97.89	0.0	224.976
stringency_index	FLOAT	520288	61.03	0.0	100.0
reproduction_rate	FLOAT	520288	64.31	-0.0686	5.8715
total_tests	BIGINT	520288	84.74	0	9214000000
new_tests	UINTEGER	520288	85.51	1	35855632
total_tests_per_thousand	FLOAT	520288	84.74	0.0	32925.824
new_tests_per_thousand	FLOAT	520288	85.51	0.0	531.062
new_tests_smoothed	UINTEGER	520288	80.02	0	14769984
new_tests_smoothed_per_thousand	FLOAT	520288	80.02	0.0	147.603
positive_rate	FLOAT	520288	80.48	0.0	94.50549
tests_per_case	FLOAT	520288	80.66	0.0	789603.8
total_vaccinations	FLOAT	520288	84.00	0.0	13724514000.0
people_vaccinated	FLOAT	520288	84.81	0.0	5645247500.0
people_fully_vaccinated	FLOAT	520288	85.20	0.0	5197972500.0
total_boosters	UINTEGER	520288	88.70	0	2840532201
new_vaccinations	FLOAT	520288	86.76	0.0	49673200.0
new_vaccinations_smoothed	FLOAT	520288	61.01	0.0	43691812.0
total_vaccinations_per_hundred	FLOAT	520288	84.00	0.0	415.88333
people_vaccinated_per_hundred	FLOAT	520288	84.81	0.0	112.197395
people_fully_vaccinated_per_hundred	FLOAT	520288	85.20	0.0	110.30859
total_boosters_per_hundred	FLOAT	520288	88.70	0.0	140.53258
new_vaccinations_smoothed_per_million	FLOAT	520288	61.01	0.0	117350.82
new_people_vaccinated_smoothed	FLOAT	520288	61.01	0.0	21071264.0
new_people_vaccinated_smoothed_per_hundred	FLOAT	520288	61.01	0.0	11.735082
code	VARCHAR	520288	4.40	ABW	ZWE
continent	VARCHAR	520288	7.54	Africa	South America
population	BIGINT	520288	3.25	501	8021407128
population_density	FLOAT	520288	4.81	0.1363601	21342.697
median_age	FLOAT	520288	4.42	14.298	59.875
life_expectancy	FLOAT	520288	4.03	18.8177	85.7464
gdp_per_capita	FLOAT	520288	21.91	708.1783	117746.99
extreme_poverty	FLOAT	520288	35.91	0.0	87.739555
diabetes_prevalence	FLOAT	520288	15.65	1.1	30.8
handwashing_facilities	FLOAT	520288	54.75	3.440189	100.0
hospital_beds_per_thousand	FLOAT	520288	39.52	0.3	13.8
human_development_index	TINYINT	520288	100.00	null	null