Data license: ODbL · Data source: our world in data github owid/covid-19-data repository

53,316 rows sorted by date

View and edit SQL

Link rowid iso_code continent location date ▼ total_cases new_cases new_cases_smoothed total_deaths new_deaths new_deaths_smoothed total_cases_per_million new_cases_per_million new_cases_smoothed_per_million total_deaths_per_million new_deaths_per_million new_deaths_smoothed_per_million icu_patients icu_patients_per_million hosp_patients hosp_patients_per_million weekly_icu_admissions weekly_icu_admissions_per_million weekly_hosp_admissions weekly_hosp_admissions_per_million total_tests new_tests total_tests_per_thousand new_tests_per_thousand new_tests_smoothed new_tests_smoothed_per_thousand tests_per_case positive_rate tests_units stringency_index population population_density median_age aged_65_older aged_70_older gdp_per_capita extreme_poverty cardiovasc_death_rate diabetes_prevalence female_smokers male_smokers handwashing_facilities hospital_beds_per_thousand life_expectancy human_development_index
1 AFG Asia Afghanistan 2019-12-31   0     0     0.0     0.0                                       38928341 54.422 18.6 2.5810000000000004 1.337 1803.987   597.029 9.59     37.746 0.5 64.83 0.498
540 DZA Africa Algeria 2019-12-31   0     0     0.0     0.0                                       43851043 17.348 29.1 6.211 3.8569999999999998 13913.839 0.5 278.36400000000003 6.73 0.7 30.4 83.741 1.9 76.88 0.754
1982 ARM Asia Armenia 2019-12-31   0     0     0.0     0.0                                       2963234 102.931 35.7 11.232000000000001 7.571000000000001 8787.58 1.8 341.01 7.11 1.5 52.1 94.04299999999999 4.2 75.09 0.755
2512 AUS Oceania Australia 2019-12-31   0     0     0.0     0.0                                       25499881 3.202 37.9 15.504000000000001 10.129 44648.71 0.5 107.791 5.07 13.0 16.5   3.84 83.44 0.9390000000000001
2816 AUT Europe Austria 2019-12-31   0     0     0.0     0.0                                       9006400 106.749 44.4 19.202 13.748 45436.685999999994 0.7 145.183 6.35 28.4 30.9   7.37 81.54 0.9079999999999999
3120 AZE Asia Azerbaijan 2019-12-31   0     0     0.0     0.0                                       10139175 119.309 32.4 6.018 3.8710000000000004 15847.419   559.812 7.11 0.3 42.5 83.241 4.7 73.0 0.757
3650 BHR Asia Bahrain 2019-12-31   0     0     0.0     0.0                                       1701583 1935.9070000000002 32.4 2.372 1.3869999999999998 43290.705   151.689 16.52 5.8 37.6   2.0 77.29 0.846
4421 BLR Europe Belarus 2019-12-31   0     0     0.0     0.0                                       9449321 46.858000000000004 40.3 14.799000000000001 9.788 17167.967   443.129 5.18 10.5 46.1   11.0 74.79 0.8079999999999999
4725 BEL Europe Belgium 2019-12-31   0     0     0.0     0.0                                       11589616 375.564 41.8 18.570999999999998 12.849 42658.575999999994 0.2 114.898 4.29 25.1 31.4   5.64 81.63 0.9159999999999999
6819 BRA South America Brazil 2019-12-31   0     0     0.0     0.0                                       212559409 25.04 33.5 8.552 5.06 14103.452 3.4 177.96099999999998 8.11 10.1 17.9   2.2 75.88 0.759
8250 KHM Asia Cambodia 2019-12-31   0     0     0.0     0.0                                       16718971 90.67200000000001 25.6 4.412 2.385 3645.07   270.892 4.0 2.0 33.7 66.229 0.8 69.82 0.5820000000000001
8787 CAN North America Canada 2019-12-31   0     0     0.0     0.0                                       37742157 4.037 41.4 16.984 10.797 44017.59099999999 0.5 105.59899999999999 7.37 12.0 16.6   2.5 82.43 0.9259999999999999
10229 CHN Asia China 2019-12-31 27 27     0   0.019 0.019     0.0                                       1439323774 147.674 38.7 10.640999999999998 5.928999999999999 15308.712 0.7 261.899 9.74 1.9 48.4   4.34 76.91 0.752
11645 HRV Europe Croatia 2019-12-31   0     0     0.0     0.0                                       4105268 73.726 44.0 19.724 13.052999999999999 22669.797000000002 0.7 253.782 5.59 34.3 39.9   5.54 78.49 0.831
12638 CZE Europe Czech Republic 2019-12-31   0     0     0.0     0.0                                       10708982 137.17600000000002 43.3 19.027 11.58 32605.906000000003   227.485 6.82 30.5 38.3   6.63 79.38 0.888
13173 DNK Europe Denmark 2019-12-31   0     0     0.0     0.0                                       5792203 136.52 42.3 19.677 12.325 46682.515 0.2 114.76700000000001 6.41 19.3 18.8   2.5 80.9 0.929
13923 DOM North America Dominican Republic 2019-12-31   0     0     0.0     0.0                                       10847904 222.873 27.6 6.981 4.419 14600.861 1.6 266.653 8.2 8.5 19.1 55.181999999999995 1.6 74.08 0.736
14227 ECU South America Ecuador 2019-12-31   0     0     0.0     0.0                                       17643060 66.939 28.1 7.104 4.458 10581.936000000002 3.6 140.44799999999998 5.55 2.0 12.3 80.635 1.5 77.01 0.752
14531 EGY Africa Egypt 2019-12-31   0     0     0.0     0.0                                       102334403 97.999 25.3 5.159 2.891 10550.206 1.3 525.432 17.31 0.2 50.1 89.82700000000001 1.6 71.99 0.696
15511 EST Europe Estonia 2019-12-31   0     0     0.0     0.0                                       1326539 31.033 42.7 19.452 13.491 29481.252 0.5 255.56900000000002 4.02 24.5 39.3   4.69 78.74 0.871
16767 FIN Europe Finland 2019-12-31   0     0     0.0     0.0                                       5540718 18.136 42.8 21.228 13.264000000000001 40585.721   153.507 5.76 18.3 22.6   3.28 81.91 0.92
17071 FRA Europe France 2019-12-31   0     0     0.0     0.0                                       65273512 122.57799999999999 42.0 19.718 13.079 38605.671   86.06 4.77 30.1 35.6   5.98 82.66 0.9009999999999999
18056 GEO Asia Georgia 2019-12-31   0     0     0.0     0.0                                       3989175 65.032 38.7 14.864 10.244000000000002 9745.079 4.2 496.218 7.11 5.3 55.5   2.6 73.77 0.78
18360 DEU Europe Germany 2019-12-31   0     0     0.0     0.0                                       83783945 237.016 46.6 21.453000000000003 15.957 45229.245   156.139 8.31 28.2 33.1   8.0 81.33 0.9359999999999999
19118 GRC Europe Greece 2019-12-31   0     0     0.0     0.0                                       10423056 83.479 45.3 20.396 14.524000000000001 24574.382 1.5 175.695 4.55 35.3 52.0   4.21 82.24 0.87
21999 ISL Europe Iceland 2019-12-31   0     0     0.0     0.0                                       341250 3.404 37.3 14.431 9.207 46482.958 0.2 117.992 5.31 14.3 15.2   2.91 82.99 0.935
22303 IND Asia India 2019-12-31   0     0     0.0     0.0                                       1380004385 450.41900000000004 28.2 5.989 3.4139999999999997 6426.674 21.2 282.28 10.39 1.9 20.6 59.55 0.53 69.66 0.64
22607 IDN Asia Indonesia 2019-12-31   0     0     0.0     0.0                                       273523621 145.725 29.3 5.319 3.053 11188.743999999999 5.7 342.86400000000003 6.32 2.8 76.1 64.204 1.04 71.72 0.6940000000000001
22911 IRN Asia Iran 2019-12-31   0     0     0.0     0.0                                       83992953 49.831 32.4 5.44 3.182 19082.62 0.2 270.308 9.59 0.8 21.1   1.5 76.68 0.7979999999999999
23215 IRQ Asia Iraq 2019-12-31   0     0     0.0     0.0                                       40222503 88.125 20.0 3.1860000000000004 1.9569999999999999 15663.986 2.5 218.612 8.83     94.57600000000001 1.4 70.6 0.685
23519 IRL Europe Ireland 2019-12-31   0     0     0.0     0.0                                       4937796 69.874 38.7 13.927999999999999 8.677999999999999 67335.293 0.2 126.459 3.28 23.0 25.7   2.96 82.3 0.938
24046 ISR Asia Israel 2019-12-31   0     0     0.0     0.0                                       8655541 402.606 30.6 11.732999999999999 7.359 33132.32 0.5 93.32 6.74 15.4 35.4   2.99 82.97 0.903
24350 ITA Europe Italy 2019-12-31   0     0     0.0     0.0                                       60461828 205.859 47.9 23.021 16.24 35220.084 2.0 113.15100000000001 4.78 19.8 27.8   3.18 83.51 0.88
24885 JPN Asia Japan 2019-12-31   0     0     0.0     0.0                                       126476458 347.778 48.2 27.049 18.493 39002.223   79.37 5.72 11.2 33.7   13.05 84.63 0.909
26349 KWT Asia Kuwait 2019-12-31   0     0     0.0     0.0                                       4270563 232.128 33.7 2.345 1.114 65530.537000000004   132.235 15.84 2.7 37.0   2.0 75.49 0.8029999999999999
27345 LBN Asia Lebanon 2019-12-31   0     0     0.0     0.0                                       6825442 594.561 31.1 8.514 5.43 13367.565   266.591 12.71 26.9 40.7   2.9 78.93 0.757
28518 LTU Europe Lithuania 2019-12-31   0     0     0.0     0.0                                       2722291 45.135 43.5 19.002 13.777999999999999 29524.265 0.7 342.98900000000003 3.67 21.3 38.0   6.56 75.93 0.858
28822 LUX Europe Luxembourg 2019-12-31   0     0     0.0     0.0                                       625976 231.447 39.7 14.312000000000001 9.842 94277.965 0.2 128.275 4.42 20.9 26.0   4.51 82.25 0.904
29126 MKD Europe Macedonia 2019-12-31   0     0     0.0     0.0                                       2083380 82.6 39.1 13.26 8.16 13111.214 5.0 322.688 10.08       4.28 75.8 0.757
29868 MYS Asia Malaysia 2019-12-31   0     0     0.0     0.0                                       32365998 96.25399999999999 29.9 6.292999999999999 3.407 26808.164 0.1 260.942 16.74 1.0 42.4   1.9 76.16 0.802
31345 MEX North America Mexico 2019-12-31   0     0     0.0     0.0                                       128932753 66.444 29.3 6.857 4.321000000000001 17336.468999999997 2.5 152.783 13.06 6.9 21.4 87.84700000000001 1.38 75.05 0.774
31883 MCO Europe Monaco 2019-12-31   0     0     0.0     0.0                                       39244 19347.5             5.46       13.8 86.75  
33804 NPL Asia Nepal 2019-12-31   0     0     0.0     0.0                                       29136808 204.43 25.0 5.809 3.2119999999999997 2442.804 15.0 260.797 7.26 9.5 37.8 47.782 0.3 70.78 0.574
34108 NLD Europe Netherlands 2019-12-31   0     0     0.0     0.0                                       17134873 508.54400000000004 43.2 18.779 11.880999999999998 48472.545   109.361 5.29 24.4 27.3   3.32 82.28 0.9309999999999999
34635 NZL Oceania New Zealand 2019-12-31   0     0     0.0     0.0                                       4822233 18.206 37.9 15.322000000000001 9.72 36085.843   128.797 8.08 14.8 17.2   2.61 82.29 0.917
35387 NGA Africa Nigeria 2019-12-31   0     0     0.0     0.0                                       206139587 209.588 18.1 2.7510000000000003 1.4469999999999998 5338.454000000001   181.013 2.42 0.6 10.8 41.949   54.69 0.532
35904 NOR Europe Norway 2019-12-31   0     0     0.0     0.0                                       5421242 14.462 39.7 16.820999999999998 10.812999999999999 64800.057 0.2 114.316 5.31 19.6 20.7   3.6 82.4 0.953
36208 OMN Asia Oman 2019-12-31   0     0     0.0     0.0                                       5106622 14.98 30.7 2.355 1.53 37960.709   266.342 12.61 0.5 15.6 97.4 1.6 77.86 0.821
36512 PAK Asia Pakistan 2019-12-31   0     0     0.0     0.0                                       220892331 255.57299999999998 23.5 4.495 2.78 5034.708 4.0 423.031 8.35 2.8 36.7 59.607 0.6 67.27 0.562
37993 PHL Asia Philippines 2019-12-31   0     0     0.0     0.0                                       109581085 351.87300000000005 25.2 4.803 2.661 7599.188   370.43699999999995 7.07 7.8 40.8 78.46300000000001 1.0 71.23 0.6990000000000001
38998 QAT Asia Qatar 2019-12-31   0     0     0.0     0.0                                       2881060 227.322 31.9 1.307 0.617 116935.6   176.69 16.52 0.8 26.9   1.2 80.23 0.856
39302 ROU Europe Romania 2019-12-31   0     0     0.0     0.0                                       19237682 85.12899999999999 43.0 17.85 11.69 23313.199 5.7 370.94599999999997 9.74 22.9 37.1   6.892 76.05 0.8109999999999999
39606 RUS Europe Russia 2019-12-31   0     0     0.0     0.0                                       145934460 8.823 39.6 14.177999999999999 9.392999999999999 24765.953999999998 0.1 431.29699999999997 6.18 23.4 58.3   8.05 72.58 0.816
40812 SMR Europe San Marino 2019-12-31   0     0     0.0     0.0                                       33938 556.6669999999999       56861.47     5.64       3.8 84.97  
42495 SGP Asia Singapore 2019-12-31   0     0     0.0     0.0                                       5850343 7915.731 42.4 12.922 7.0489999999999995 85535.383   92.243 10.99 5.2 28.3   2.4 83.62 0.932
44023 KOR Asia South Korea 2019-12-31   0     0     0.0     0.0                                       51269183 527.967 43.4 13.914000000000001 8.622 35938.373999999996 0.2 85.99799999999999 6.8 6.2 40.9   12.27 83.03 0.903
44534 ESP Europe Spain 2019-12-31   0     0     0.0     0.0                                       46754783 93.105 45.5 19.436 13.799000000000001 34272.36 1.0 99.40299999999999 7.17 27.4 31.4   2.97 83.56 0.8909999999999999
44837 LKA Asia Sri Lanka 2019-12-31   0     0     0.0     0.0                                       21413250 341.955 34.1 10.068999999999999 5.331 11669.077 0.7 197.093 10.68 0.3 27.0   3.6 76.98 0.77
45824 SWE Europe Sweden 2019-12-31   0     0     0.0     0.0                                       10099270 24.718000000000004 41.0 19.985 13.433 46949.282999999996 0.5 133.982 4.79 18.8 18.9   2.22 82.8 0.9329999999999999
46127 CHE Europe Switzerland 2019-12-31   0     0     0.0     0.0                                       8654618 214.243 43.1 18.436 12.644 57410.166   99.73899999999999 5.59 22.6 28.9   4.53 83.78 0.9440000000000001
46652 TWN Asia Taiwan 2019-12-31   0     0     0.0     0.0                                       23816775   42.2   8.353     103.95700000000001           80.46  
47365 THA Asia Thailand 2019-12-31   0     0     0.0     0.0                                       69799978 135.132 40.1 11.373 6.89 16277.671 0.1 109.861 7.04 1.9 38.8 90.67 2.1 77.15 0.755
49504 ARE Asia United Arab Emirates 2019-12-31   0     0     0.0     0.0                                       9890400 112.44200000000001 34.0 1.1440000000000001 0.526 67293.483   317.84 17.26 1.2 37.4   1.2 77.97 0.863
49808 GBR Europe United Kingdom 2019-12-31   0     0     0.0     0.0                                       67886004 272.89799999999997 40.8 18.517 12.527000000000001 39753.244 0.2 122.137 4.28 20.0 24.7   2.54 81.32 0.922
50112 USA North America United States 2019-12-31   0     0     0.0     0.0                                       331002647 35.608000000000004 38.3 15.413 9.732000000000001 54225.445999999996 1.2 151.089 10.79 19.1 24.6   2.77 78.86 0.924
51554 VNM Asia Vietnam 2019-12-31   0     0     0.0     0.0                                       97338583 308.127 32.6 7.15 4.718 6171.884 2.0 245.465 6.0 1.0 45.9 85.84700000000001 2.6 75.4 0.6940000000000001
52709 OWID_WRL   World 2019-12-31 27 27     0   0.003 0.003     0.0                                       7794798729 58.045 30.9 8.696 5.355 15469.207 10.0 233.07 8.51 6.434 34.635 60.13 2.705 72.58  
53013     International 2019-12-31   0     0                                                                                
2 AFG Asia Afghanistan 2020-01-01   0     0     0.0     0.0                                     0.0 38928341 54.422 18.6 2.5810000000000004 1.337 1803.987   597.029 9.59     37.746 0.5 64.83 0.498
541 DZA Africa Algeria 2020-01-01   0     0     0.0     0.0                                     0.0 43851043 17.348 29.1 6.211 3.8569999999999998 13913.839 0.5 278.36400000000003 6.73 0.7 30.4 83.741 1.9 76.88 0.754
1983 ARM Asia Armenia 2020-01-01   0     0     0.0     0.0                                       2963234 102.931 35.7 11.232000000000001 7.571000000000001 8787.58 1.8 341.01 7.11 1.5 52.1 94.04299999999999 4.2 75.09 0.755
2513 AUS Oceania Australia 2020-01-01   0     0     0.0     0.0                                     0.0 25499881 3.202 37.9 15.504000000000001 10.129 44648.71 0.5 107.791 5.07 13.0 16.5   3.84 83.44 0.9390000000000001
2817 AUT Europe Austria 2020-01-01   0     0     0.0     0.0                                     0.0 9006400 106.749 44.4 19.202 13.748 45436.685999999994 0.7 145.183 6.35 28.4 30.9   7.37 81.54 0.9079999999999999
3121 AZE Asia Azerbaijan 2020-01-01   0     0     0.0     0.0                                     0.0 10139175 119.309 32.4 6.018 3.8710000000000004 15847.419   559.812 7.11 0.3 42.5 83.241 4.7 73.0 0.757
3651 BHR Asia Bahrain 2020-01-01   0     0     0.0     0.0                                     0.0 1701583 1935.9070000000002 32.4 2.372 1.3869999999999998 43290.705   151.689 16.52 5.8 37.6   2.0 77.29 0.846
4422 BLR Europe Belarus 2020-01-01   0     0     0.0     0.0                                     0.0 9449321 46.858000000000004 40.3 14.799000000000001 9.788 17167.967   443.129 5.18 10.5 46.1   11.0 74.79 0.8079999999999999
4726 BEL Europe Belgium 2020-01-01   0     0     0.0     0.0                                     0.0 11589616 375.564 41.8 18.570999999999998 12.849 42658.575999999994 0.2 114.898 4.29 25.1 31.4   5.64 81.63 0.9159999999999999
6820 BRA South America Brazil 2020-01-01   0     0     0.0     0.0                                     0.0 212559409 25.04 33.5 8.552 5.06 14103.452 3.4 177.96099999999998 8.11 10.1 17.9   2.2 75.88 0.759
8251 KHM Asia Cambodia 2020-01-01   0     0     0.0     0.0                                     0.0 16718971 90.67200000000001 25.6 4.412 2.385 3645.07   270.892 4.0 2.0 33.7 66.229 0.8 69.82 0.5820000000000001
8788 CAN North America Canada 2020-01-01   0     0     0.0     0.0                                     0.0 37742157 4.037 41.4 16.984 10.797 44017.59099999999 0.5 105.59899999999999 7.37 12.0 16.6   2.5 82.43 0.9259999999999999
10230 CHN Asia China 2020-01-01 27 0     0   0.019 0.0     0.0                                     0.0 1439323774 147.674 38.7 10.640999999999998 5.928999999999999 15308.712 0.7 261.899 9.74 1.9 48.4   4.34 76.91 0.752
11646 HRV Europe Croatia 2020-01-01   0     0     0.0     0.0                                     0.0 4105268 73.726 44.0 19.724 13.052999999999999 22669.797000000002 0.7 253.782 5.59 34.3 39.9   5.54 78.49 0.831
12639 CZE Europe Czech Republic 2020-01-01   0     0     0.0     0.0                                     0.0 10708982 137.17600000000002 43.3 19.027 11.58 32605.906000000003   227.485 6.82 30.5 38.3   6.63 79.38 0.888
13174 DNK Europe Denmark 2020-01-01   0     0     0.0     0.0                                     0.0 5792203 136.52 42.3 19.677 12.325 46682.515 0.2 114.76700000000001 6.41 19.3 18.8   2.5 80.9 0.929
13924 DOM North America Dominican Republic 2020-01-01   0     0     0.0     0.0                                     0.0 10847904 222.873 27.6 6.981 4.419 14600.861 1.6 266.653 8.2 8.5 19.1 55.181999999999995 1.6 74.08 0.736
14228 ECU South America Ecuador 2020-01-01   0     0     0.0     0.0                                     0.0 17643060 66.939 28.1 7.104 4.458 10581.936000000002 3.6 140.44799999999998 5.55 2.0 12.3 80.635 1.5 77.01 0.752
14532 EGY Africa Egypt 2020-01-01   0     0     0.0     0.0                                     0.0 102334403 97.999 25.3 5.159 2.891 10550.206 1.3 525.432 17.31 0.2 50.1 89.82700000000001 1.6 71.99 0.696
15512 EST Europe Estonia 2020-01-01   0     0     0.0     0.0                                     0.0 1326539 31.033 42.7 19.452 13.491 29481.252 0.5 255.56900000000002 4.02 24.5 39.3   4.69 78.74 0.871
16768 FIN Europe Finland 2020-01-01   0     0     0.0     0.0                                     0.0 5540718 18.136 42.8 21.228 13.264000000000001 40585.721   153.507 5.76 18.3 22.6   3.28 81.91 0.92
17072 FRA Europe France 2020-01-01   0     0     0.0     0.0                                     0.0 65273512 122.57799999999999 42.0 19.718 13.079 38605.671   86.06 4.77 30.1 35.6   5.98 82.66 0.9009999999999999
18057 GEO Asia Georgia 2020-01-01   0     0     0.0     0.0                                     0.0 3989175 65.032 38.7 14.864 10.244000000000002 9745.079 4.2 496.218 7.11 5.3 55.5   2.6 73.77 0.78
18361 DEU Europe Germany 2020-01-01   0     0     0.0     0.0                                     0.0 83783945 237.016 46.6 21.453000000000003 15.957 45229.245   156.139 8.31 28.2 33.1   8.0 81.33 0.9359999999999999
19119 GRC Europe Greece 2020-01-01   0     0     0.0     0.0                                     0.0 10423056 83.479 45.3 20.396 14.524000000000001 24574.382 1.5 175.695 4.55 35.3 52.0   4.21 82.24 0.87
22000 ISL Europe Iceland 2020-01-01   0     0     0.0     0.0                                     0.0 341250 3.404 37.3 14.431 9.207 46482.958 0.2 117.992 5.31 14.3 15.2   2.91 82.99 0.935
22304 IND Asia India 2020-01-01   0     0     0.0     0.0                                     0.0 1380004385 450.41900000000004 28.2 5.989 3.4139999999999997 6426.674 21.2 282.28 10.39 1.9 20.6 59.55 0.53 69.66 0.64
22608 IDN Asia Indonesia 2020-01-01   0     0     0.0     0.0                                     0.0 273523621 145.725 29.3 5.319 3.053 11188.743999999999 5.7 342.86400000000003 6.32 2.8 76.1 64.204 1.04 71.72 0.6940000000000001
22912 IRN Asia Iran 2020-01-01   0     0     0.0     0.0                                     0.0 83992953 49.831 32.4 5.44 3.182 19082.62 0.2 270.308 9.59 0.8 21.1   1.5 76.68 0.7979999999999999
23216 IRQ Asia Iraq 2020-01-01   0     0     0.0     0.0                                     0.0 40222503 88.125 20.0 3.1860000000000004 1.9569999999999999 15663.986 2.5 218.612 8.83     94.57600000000001 1.4 70.6 0.685
23520 IRL Europe Ireland 2020-01-01   0     0     0.0     0.0                                     0.0 4937796 69.874 38.7 13.927999999999999 8.677999999999999 67335.293 0.2 126.459 3.28 23.0 25.7   2.96 82.3 0.938
24047 ISR Asia Israel 2020-01-01   0     0     0.0     0.0                                     0.0 8655541 402.606 30.6 11.732999999999999 7.359 33132.32 0.5 93.32 6.74 15.4 35.4   2.99 82.97 0.903

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "owid-covid-data" (
"iso_code" TEXT,
  "continent" TEXT,
  "location" TEXT,
  "date" TEXT,
  "total_cases" INTEGER,
  "new_cases" INTEGER,
  "new_cases_smoothed" REAL,
  "total_deaths" INTEGER,
  "new_deaths" INTEGER,
  "new_deaths_smoothed" REAL,
  "total_cases_per_million" REAL,
  "new_cases_per_million" REAL,
  "new_cases_smoothed_per_million" REAL,
  "total_deaths_per_million" REAL,
  "new_deaths_per_million" REAL,
  "new_deaths_smoothed_per_million" REAL,
  "icu_patients" INTEGER,
  "icu_patients_per_million" REAL,
  "hosp_patients" INTEGER,
  "hosp_patients_per_million" REAL,
  "weekly_icu_admissions" REAL,
  "weekly_icu_admissions_per_million" REAL,
  "weekly_hosp_admissions" REAL,
  "weekly_hosp_admissions_per_million" REAL,
  "total_tests" INTEGER,
  "new_tests" INTEGER,
  "total_tests_per_thousand" REAL,
  "new_tests_per_thousand" REAL,
  "new_tests_smoothed" INTEGER,
  "new_tests_smoothed_per_thousand" REAL,
  "tests_per_case" REAL,
  "positive_rate" REAL,
  "tests_units" TEXT,
  "stringency_index" REAL,
  "population" INTEGER,
  "population_density" REAL,
  "median_age" REAL,
  "aged_65_older" REAL,
  "aged_70_older" REAL,
  "gdp_per_capita" REAL,
  "extreme_poverty" REAL,
  "cardiovasc_death_rate" REAL,
  "diabetes_prevalence" REAL,
  "female_smokers" REAL,
  "male_smokers" REAL,
  "handwashing_facilities" REAL,
  "hospital_beds_per_thousand" REAL,
  "life_expectancy" REAL,
  "human_development_index" REAL
);