User:Ajuanca/COVID-19 in Asturias

Data

edit

The data is stored in Commons, more specific here

Table

edit

The prev. data can be inserted directly as a table. Also some customization can be done.

COVID-19 cases in the Principality of Asturias (Spain)
DateNew casesTotal casesNew deathsTotal deathsTotal ICUNew recoveriesTotal recoveriesTotal test
2020-02-291100000N/A
2020-03-010100000N/A
2020-03-020100000N/A
2020-03-031200000N/A
2020-03-041300100N/A
2020-03-052500200N/A
2020-03-061600200N/A
2020-03-071700200N/A
2020-03-081800200N/A
2020-03-0921000200N/A
2020-03-1071700200N/A
2020-03-11183511211N/A
2020-03-12336801201N/A
2020-03-1357301212N/A
2020-03-1428101012021,863
2020-03-154114201213N/A
2020-03-165119301503N/A
2020-03-174924201504N/A
2020-03-185029201604N/A
2020-03-1952344126812N/A
2020-03-201424863512012N/A
2020-03-21595453815618N/A
2020-03-224959441220321N/A
2020-03-2368662102223930N/A
2020-03-24117779325295356,200
2020-03-2562841227345406,900
2020-03-26599002294812528,000
2020-03-271041,0044335113658,550
2020-03-28841,0888415711769,300
2020-03-29701,158849572789,779
2020-03-30781,23665561129010,476
2020-03-31861,322863721910911,265
2020-04-01621,384669762613512,519
2020-04-02491,433170821915413,385
2020-04-03891,522676813619014,530
2020-04-04831,605480832621615,831
2020-04-05411,64668676622216,631
2020-04-06331,6791096742224417,243
2020-04-07261,7056102705029418,110
2020-04-08321,7378110654634019,096
2020-04-09621,79911121653237220,409
2020-04-10281,8277128624241421,231
2020-04-11621,89212140611643022,007
2020-04-12211,937914961443423,046
2020-04-13732,0107156632445824,356
2020-04-14392,04910166602948725,538
2020-04-15322,0812168613552227,095
2020-04-16432,1246174612354528,595
2020-04-17292,15313187583057530,752
2020-04-18192,1729196562159633,111
2020-04-1992,181420056359934,525
2020-04-20112,1922202531761637,012
2020-04-21262,2189211562664239,164
2020-04-22112,22912223532366541,696
2020-04-2352,2348231502368843,927
2020-04-2442,2388239482871646,949
2020-04-25112,24910249463374948,902
2020-04-2652,2544253451075950,143
2020-04-2712,2558261432178053,548
2020-04-28112,26652663829809N/A
2020-04-29172,2837273342683559,472
2020-04-30152,2980273362586063,302
2020-05-0152,3036279373089067,213
2020-05-0222,3051280351890869,213
2020-05-0312,306428435991770,640
2020-05-0422,3080284331993674,830
2020-05-0522,3103287291795378,139
2020-05-06162,3265292301897181,431
2020-05-07102,3360292301298386,070
2020-05-0862,342129331291,01290,257
2020-05-0912,343229530101,02292,578
2020-05-1032,34642992941,02694,478
2020-05-1142,35053042651,03198,710
2020-05-1252,35533072571,038102,706
2020-05-1302,35533082481,046N/A
2020-05-1432,35823102371,053110,744
2020-05-1572,36533132221,055116,711
2020-05-1602,36523152361,061118,380
2020-05-1732,36823172321,063121,020
2020-05-1842,372−14303192511,314125,604
2020-05-1912,37313041601,314129,477
2020-05-2002,373330715611,375132,950
2020-05-2122,37503071341,379133,425
2020-05-2212,37603071301,379136,569
2020-05-2312,396130813181,397138,838
2020-05-2422,398130913431,440140,908
2020-05-2502,398031013511,491144,159
2020-05-2612,399031013521,543147,192
2020-05-2702,399131110401,583150,347
2020-05-2832,402031110681,651153,916
2020-05-29182,420131210271,678156,726
2020-05-3032,42303129431,721158,644
2020-05-3112,42433159−11,720159,839
2020-06-0102,42463219151,735162,245
2020-06-0202,4240321961,741164,892
2020-06-0302,42413229111,752166,840
2020-06-0402,42413239231,775170,261
2020-06-0522,42613249251,800172,634
2020-06-0612,4273327911,801174,400
2020-06-0722,4290327921,803175,288
2020-06-0822,4311328941,807177,342
2020-06-0902,43103289201,827179,685
2020-06-1002,43113299561,883182,362
2020-06-1142,43523311091,892184,302
2020-06-1222,437033110141,906186,352
2020-06-1302,43703311101,906187,434
2020-06-1402,43713321231,909188,848
2020-06-1502,438033212311,940190,888
2020-06-16−22,436033211431,983193,246
2020-06-17−12,4350332711,984195,837
2020-06-1802,43513339131,997198,078
2020-06-1902,4351334972,004199,981
2020-06-2002,4350334802,004201,356
2020-06-2102,4350334842,008203,409
2020-06-2202,43503348202,028204,161
2020-06-2302,43513357182,046206,241
2020-06-2402,4350335602,046208,170
2020-06-2502,4350335632,049210,214
2020-06-2602,4350335532,052212,026
2020-06-2702,4350335502,052213,749
2020-06-2802,4350335532,055214,677
2020-06-2902,4350335502,055216,245
2020-06-3002,4352337422,057218,291
2020-07-0102,4350337462,063220,033
2020-07-0202,4351338402,063221,155
2020-07-0302,4350338402,063223,060
2020-07-0402,4350338402,063224,161
2020-07-0502,43513394−22,061224,990
2020-07-0612,4360339312,062226,608
2020-07-0702,43603393−12,061228,394
2020-07-0802,4360339322,063230,252
2020-07-0912,43703393152,078232,158
2020-07-1002,4370339302,078N/A
2020-07-1102,4370339302,078N/A
2020-07-1202,4370339302,078235,409
2020-07-1352,44203393−12,077236,960
2020-07-1402,4420339302,077238,832
2020-07-1502,4420339302,077240,262
2020-07-1602,4420339302,077241,955
2020-07-1712,4430339302,077N/A
2020-07-1822,4450339302,077N/A
2020-07-1912,4460339302,077245,238
2020-07-2022,4480339302,077247,108
2020-07-2122,4500339302,077248,974
2020-07-2222,4520339302,077251,255
2020-07-2322,4540339302,077253,006
2020-07-2452,4590339302,077N/A
2020-07-2532,4620339302,077N/A
2020-07-2652,4670339302,077257,127
2020-07-2732,4701340302,077259,124
2020-07-28142,4840340352,082261,776
2020-07-29142,5030340302,082264,599
2020-07-30262,5290340302,082267,207
2020-07-3132,53203403N/AN/AN/A
2020-08-01152,54703404N/AN/AN/A
2020-08-0282,5550340412,083273,522
2020-08-0392,5640340402,083276,464
2020-08-04242,5880340402,083279,479
2020-08-05322,6200340402,083282,318
2020-08-06312,6510340452,088284,784
2020-08-07152,6660340402,088N/A
2020-08-08212,6870340402,088N/A
2020-08-09202,7070340402,088291,560
2020-08-10112,7180340372,095293,497
2020-08-11232,74103403122,107295,920
2020-08-12332,7740340302,107297,975
2020-08-13242,79803402152,122300,155
2020-08-14322,83003402152,122N/A
2020-08-15152,84503402152,122N/A
2020-08-16292,87403402152,122305,218
2020-08-1752,8790340222,124307,600
2020-08-18312,9100340212,125310,458
2020-08-19232,9330340202,125313,031
2020-08-20402,9730340202,125315,406
2020-08-21313,00403402N/AN/AN/A
2020-08-22263,03013413N/AN/AN/A
2020-08-23183,04803413142,139320,413
2020-08-24523,1000341212,140322,738
2020-08-25483,1480341202,140324,835
2020-08-26363,18403412122,152327,324
2020-08-27353,2190341202,152329,579
2020-08-28443,2630341N/AN/AN/AN/A
2020-08-29313,2940341N/AN/AN/AN/A
2020-08-30273,32103414422,194335,313
2020-08-31333,3540341402,194337,468
2020-09-01303,3840341502,194340,116
2020-09-02493,4330341402,194342,811
2020-09-03443,4770341502,194345,818
2020-09-04653,5422343N/AN/AN/AN/A
2020-09-05513,5930343N/AN/AN/AN/A
2020-09-06843,6770343702,194353,610
2020-09-07163,6931344702,194355,276
2020-09-08653,7580344802,194357,760
2020-09-09223,78003449−12,193359,486
2020-09-10473,8270344802,193362,712
2020-09-11853,91213459N/AN/AN/A
2020-09-12663,978034510N/AN/AN/A
2020-09-13644,04203451022,195370,054
2020-09-14524,09413461112,196372,538
2020-09-15724,16603461142,200375,970
2020-09-16794,24513471002,200379,751
OpenData Portal of the Asturias Goverment
Data available under Creative Commons Zero.

Graph

edit

The implementation of the graphs is done automatically - much more easier and without repeated data.

COVID-19 cases in Asturias, Spain  ()
     Deaths        Recoveries        Active cases
FebFebMarMarAprAprMayMayJunJunJulJulAugAugSepSep
Last 15 daysLast 15 days
Date
# of cases
# of deaths
2020-02-29
1(n.a.) 0
2020-03-01
1(=) 0
2020-03-02
1(=) 0
2020-03-03
2(+100%) 0
2020-03-04
3(+50%) 0
2020-03-05
5(+67%) 0
2020-03-06
6(+20%) 0
2020-03-07
7(+17%) 0
2020-03-08
8(+14%) 0
2020-03-09
10(+25%) 0
2020-03-10
17(+70%) 0
2020-03-11
35(+106%) 1(n.a.)
2020-03-12
68(+94%) 1(=)
2020-03-13
73(+7.35%) 1(=)
2020-03-14
101(+38%) 1(=)
2020-03-15
142(+41%) 1(=)
2020-03-16
193(+36%) 1(=)
2020-03-17
242(+25%) 1(=)
2020-03-18
292(+21%) 1(=)
2020-03-19
344(+18%) 2(+100%)
2020-03-20
486(+41%) 5(+150%)
2020-03-21
545(+12%) 8(+60%)
2020-03-22
594(+8.99%) 12(+50%)
2020-03-23
662(+11%) 22(+83%)
2020-03-24
779(+18%) 25(+14%)
2020-03-25
841(+7.96%) 27(+8.00%)
2020-03-26
900(+7.02%) 29(+7.41%)
2020-03-27
1,004(+12%) 33(+14%)
2020-03-28
1,088(+8.37%) 41(+24%)
2020-03-29
1,158(+6.43%) 49(+20%)
2020-03-30
1,236(+6.74%) 55(+12%)
2020-03-31
1,322(+6.96%) 63(+15%)
2020-04-01
1,384(+4.69%) 69(+9.52%)
2020-04-02
1,433(+3.54%) 70(+1.45%)
2020-04-03
1,522(+6.21%) 76(+8.57%)
2020-04-04
1,605(+5.45%) 80(+5.26%)
2020-04-05
1,646(+2.55%) 86(+7.50%)
2020-04-06
1,679(+2.00%) 96(+12%)
2020-04-07
1,705(+1.55%) 102(+6.25%)
2020-04-08
1,737(+1.88%) 110(+7.84%)
2020-04-09
1,799(+3.57%) 121(+10%)
2020-04-10
1,827(+1.56%) 128(+5.79%)
2020-04-11
1,892(+3.56%) 140(+9.38%)
2020-04-12
1,937(+2.38%) 149(+6.43%)
2020-04-13
2,010(+3.77%) 156(+4.70%)
2020-04-14
2,049(+1.94%) 166(+6.41%)
2020-04-15
2,081(+1.56%) 168(+1.20%)
2020-04-16
2,124(+2.07%) 174(+3.57%)
2020-04-17
2,153(+1.37%) 187(+7.47%)
2020-04-18
2,172(+0.882%) 196(+4.81%)
2020-04-19
2,181(+0.414%) 200(+2.04%)
2020-04-20
2,192(+0.504%) 202(+1.00%)
2020-04-21
2,218(+1.19%) 211(+4.46%)
2020-04-22
2,229(+0.496%) 223(+5.69%)
2020-04-23
2,234(+0.224%) 231(+3.59%)
2020-04-24
2,238(+0.179%) 239(+3.46%)
2020-04-25
2,249(+0.492%) 249(+4.18%)
2020-04-26
2,254(+0.222%) 253(+1.61%)
2020-04-27
2,255(+0.044%) 261(+3.16%)
2020-04-28
2,266(+0.488%) 266(+1.92%)
2020-04-29
2,283(+0.750%) 273(+2.63%)
2020-04-30
2,298(+0.657%) 273(=)
2020-05-01
2,303(+0.218%) 279(+2.20%)
2020-05-02
2,305(+0.087%) 280(+0.358%)
2020-05-03
2,306(+0.043%) 284(+1.43%)
2020-05-04
2,308(+0.087%) 284(=)
2020-05-05
2,310(+0.087%) 287(+1.06%)
2020-05-06
2,326(+0.693%) 292(+1.74%)
2020-05-07
2,336(+0.430%) 292(=)
2020-05-08
2,342(+0.257%) 293(+0.342%)
2020-05-09
2,343(+0.043%) 295(+0.683%)
2020-05-10
2,346(+0.128%) 299(+1.36%)
2020-05-11
2,350(+0.171%) 304(+1.67%)
2020-05-12
2,355(+0.213%) 307(+0.987%)
2020-05-13
2,355(=) 308(+0.326%)
2020-05-14
2,358(+0.127%) 310(+0.649%)
2020-05-15
2,365(+0.297%) 313(+0.968%)
2020-05-16
2,365(=) 315(+0.639%)
2020-05-17
2,368(+0.127%) 317(+0.635%)
2020-05-18
2,372(+0.169%) 303(−4.42%)
2020-05-19
2,373(+0.042%) 304(+0.330%)
2020-05-20
2,373(=) 307(+0.987%)
2020-05-21
2,375(+0.084%) 307(=)
2020-05-22
2,376(+0.042%) 307(=)
2020-05-23
2,396(+0.842%) 308(+0.326%)
2020-05-24
2,398(+0.083%) 309(+0.325%)
2020-05-25
2,398(=) 310(+0.324%)
2020-05-26
2,399(+0.042%) 310(=)
2020-05-27
2,399(=) 311(+0.323%)
2020-05-28
2,402(+0.125%) 311(=)
2020-05-29
2,420(+0.749%) 312(+0.322%)
2020-05-30
2,423(+0.124%) 312(=)
2020-05-31
2,424(+0.041%) 315(+0.962%)
2020-06-01
2,424(=) 321(+1.90%)
2020-06-02
2,424(=) 321(=)
2020-06-03
2,424(=) 322(+0.312%)
2020-06-04
2,424(=) 323(+0.311%)
2020-06-05
2,426(+0.083%) 324(+0.310%)
2020-06-06
2,427(+0.041%) 327(+0.926%)
2020-06-07
2,429(+0.082%) 327(=)
2020-06-08
2,431(+0.082%) 328(+0.306%)
2020-06-09
2,431(=) 328(=)
2020-06-10
2,431(=) 329(+0.305%)
2020-06-11
2,435(+0.165%) 331(+0.608%)
2020-06-12
2,437(+0.082%) 331(=)
2020-06-13
2,437(=) 331(=)
2020-06-14
2,437(=) 332(+0.302%)
2020-06-15
2,438(+0.041%) 332(=)
2020-06-16
2,436(−0.082%) 332(=)
2020-06-17
2,435(−0.041%) 332(=)
2020-06-18
2,435(=) 333(+0.301%)
2020-06-19
2,435(=) 334(+0.300%)
2020-06-20
2,435(=) 334(=)
2020-06-21
2,435(=) 334(=)
2020-06-22
2,435(=) 334(=)
2020-06-23
2,435(=) 335(+0.299%)
2020-06-24
2,435(=) 335(=)
2020-06-25
2,435(=) 335(=)
2020-06-26
2,435(=) 335(=)
2020-06-27
2,435(=) 335(=)
2020-06-28
2,435(=) 335(=)
2020-06-29
2,435(=) 335(=)
2020-06-30
2,435(=) 337(+0.597%)
2020-07-01
2,435(=) 337(=)
2020-07-02
2,435(=) 338(+0.297%)
2020-07-03
2,435(=) 338(=)
2020-07-04
2,435(=) 338(=)
2020-07-05
2,435(=) 339(+0.296%)
2020-07-06
2,436(+0.041%) 339(=)
2020-07-07
2,436(=) 339(=)
2020-07-08
2,436(=) 339(=)
2020-07-09
2,437(+0.041%) 339(=)
2,437(=) 339(=)
2020-07-13
2,442(+0.205%) 339(=)
2,442(=) 339(=)
2020-07-17
2,443(+0.041%) 339(=)
2020-07-18
2,445(+0.082%) 339(=)
2020-07-19
2,446(+0.041%) 339(=)
2020-07-20
2,448(+0.082%) 339(=)
2020-07-21
2,450(+0.082%) 339(=)
2020-07-22
2,452(+0.082%) 339(=)
2020-07-23
2,454(+0.082%) 339(=)
2020-07-24
2,459(+0.204%) 339(=)
2020-07-25
2,462(+0.122%) 339(=)
2020-07-26
2,467(+0.203%) 339(=)
2020-07-27
2,470(+0.122%) 340(+0.295%)
2020-07-28
2,484(+0.567%) 340(=)
2020-07-29
2,503(+0.765%) 340(=)
2020-07-30
2,529(+1.04%) 340(=)
2020-07-31
2,532(+0.119%) 340(=)
2020-08-01
2,547(+0.592%) 340(=)
2020-08-02
2,555(+0.314%) 340(=)
2020-08-03
2,564(+0.352%) 340(=)
2020-08-04
2,588(+0.936%) 340(=)
2020-08-05
2,620(+1.24%) 340(=)
2020-08-06
2,651(+1.18%) 340(=)
2020-08-07
2,666(+0.566%) 340(=)
2020-08-08
2,687(+0.788%) 340(=)
2020-08-09
2,707(+0.744%) 340(=)
2020-08-10
2,718(+0.406%) 340(=)
2020-08-11
2,741(+0.846%) 340(=)
2020-08-12
2,774(+1.20%) 340(=)
2020-08-13
2,798(+0.865%) 340(=)
2020-08-14
2,830(+1.14%) 340(=)
2020-08-15
2,845(+0.530%) 340(=)
2020-08-16
2,874(+1.02%) 340(=)
2020-08-17
2,879(+0.174%) 340(=)
2020-08-18
2,910(+1.08%) 340(=)
2020-08-19
2,933(+0.790%) 340(=)
2020-08-20
2,973(+1.36%) 340(=)
2020-08-21
3,004(+1.04%) 340(=)
2020-08-22
3,030(+0.866%) 341(+0.294%)
2020-08-23
3,048(+0.594%) 341(=)
2020-08-24
3,100(+1.71%) 341(=)
2020-08-25
3,148(+1.55%) 341(=)
2020-08-26
3,184(+1.14%) 341(=)
2020-08-27
3,219(+1.10%) 341(=)
2020-08-28
3,263(+1.37%) 341(=)
2020-08-29
3,294(+0.950%) 341(=)
2020-08-30
3,321(+0.820%) 341(=)
2020-08-31
3,354(+0.994%) 341(=)
2020-09-01
3,384(+0.894%) 341(=)
2020-09-02
3,433(+1.45%) 341(=)
2020-09-03
3,477(+1.28%) 341(=)
2020-09-04
3,542(+1.87%) 343(+0.587%)
2020-09-05
3,593(+1.44%) 343(=)
2020-09-06
3,677(+2.34%) 343(=)
2020-09-07
3,693(+0.435%) 344(+0.292%)
2020-09-08
3,758(+1.76%) 344(=)
2020-09-09
3,780(+0.585%) 344(=)
2020-09-10
3,827(+1.24%) 344(=)
2020-09-11
3,912(+2.22%) 345(+0.291%)
2020-09-12
3,978(+1.69%) 345(=)
2020-09-13
4,042(+1.61%) 345(=)
2020-09-14
4,094(+1.29%) 346(+0.290%)
2020-09-15
4,166(+1.76%) 346(=)
2020-09-16
4,245(+1.90%) 347(+0.289%)
Source: Wikimedia Commons
COVID-19 cases in Asturias, Spain. See or edit source data.

Cases per 100.000 inhabitants.

edit

Cases per 100.000 inhabitants (by using _get_all_incidence)

edit

Graphs on article translated

edit

Meaning graphs located in the wiki but using the Commons info. Just a compatibility check. This is one of the final touches!

Todo list:

  • [ ] Add exceptions (footnotes)
  • [ ] Add in-plant hospitalized (daily and cumulative)
  • [ ] Add ICU (cumulative)
  • [ ] Set color
  • [✓] Calculation per 100k

General graph

edit

Similar to the previous. (pending of adding inplant hospitalized, this value will be added with "new_icu" so total daily will be obtained)

New cases

edit

(the calculation is pending)

COVID-19 daily reported cases in Asturias, Spain. See or edit source data.

Recoveries

edit

This is done!

COVID-19 daily recoveries in Asturias, Spain. See or edit source data.

Deaths per day

edit

This is done!

COVID-19 daily reported deaths in Asturias, Spain. See or edit source data.

Hospitalized (daily)

edit

The last graph: (pending of adding in-plant hospitalized)

Hospital daily COVID-19 cases in Asturias, Spain. See or edit source data.