Loading...Loading chart...
1FROM (SUMMARIZE @owid.compact.owid_compact)
2SELECT
3 column_name,
4 column_type,
5 count,
6 null_percentage,
7 min,
8 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 |