Grazie a questo tool di Oracle live si è potuto realizzare una piccolissima parte della base di dati realizzata sul COVID_19
La strutturazione della base di dati è orientata nell'arco temporale 19 Marzo al 25 Marzo, proprio la settimana del picco dell'epidemia.
Attenzione, eseguire il codice passo-passo altrimenti segnalerà errore di inconsistenza dei dati
Attenzione, per inserire gli elementi della base di dati cliccare sul triangolino ▶
Visualizza la documentazione completa del progetto cliccando qui
Il dataset fornito da https://github.com/pcm-dpc/COVID-19 è una rappresentazione della base di dati direzionale (Data WareHouse DWH), si incomincia dunque caricando la tabella master dal 19 Marzo al 25 Marzo
create table MASTER
(
DATA_REG VARCHAR2(19) not null,
STATO VARCHAR2(3) not null,
CODICE_REGIONE NUMBER not null,
DENOMINAZIONE_REGIONE VARCHAR2(21) not null,
CODICE_PROVINCIA NUMBER not null,
DENOMINAZIONE_PROVINCIA VARCHAR2(36) not null,
SIGLA_PROVINCIA VARCHAR2(2),
LATITUDINE NUMBER(11, 8) not null,
LONGITUDINE NUMBER(11, 9) not null,
TOTALE_CASI NUMBER not null,
NOTE_IT VARCHAR2(10),
NOTE_EN VARCHAR2(10),
primary key (DATA_REG, CODICE_REGIONE, CODICE_PROVINCIA)
)
Attraverso il procedimento di normalizzazione discusso nella documentazione si è decomposto la tabella master in più tabelle con l'aggiunta di più tabelle e più informazioni a riguardo.
E' possibile visualizzare il codice completo SQL cliccando qui
Partiamo con la realizzazione della tabella di alcuni stati
Creazione tabella stati
create table STATI
(
STATO VARCHAR2(3) not null
primary key,
DESCRIZIONE VARCHAR2(40),
POPOLAZIONE NUMBER,
CAPITALE VARCHAR2(150)
)
Insert degli stati
INSERT INTO STATI (STATO, DESCRIZIONE, POPOLAZIONE, CAPITALE) VALUES ('ITA', 'Italia', 62246672, 'Roma');
INSERT INTO STATI (STATO, DESCRIZIONE, POPOLAZIONE, CAPITALE) VALUES ('DEU', 'Germania', 80457736, 'Berlino');
INSERT INTO STATI (STATO, DESCRIZIONE, POPOLAZIONE, CAPITALE) VALUES ('ESP', 'Spagna', 49331076, 'Madrid');
INSERT INTO STATI (STATO, DESCRIZIONE, POPOLAZIONE, CAPITALE) VALUES ('FRA', 'Francia', 67364360, 'Parigi');
Creazione tabella Stati_Covid19
create table STATI_COVID19
(
DATA_STATO VARCHAR2(10) not null,
CASI NUMBER not null,
DECEDUTI NUMBER not null,
DENOMINAZIONI_STATO VARCHAR2(42) not null,
STATOID VARCHAR2(8) not null,
STATO VARCHAR2(3)
constraint STATI_COVID19_STATI_FK
references STATI,
CONTINENTE VARCHAR2(7) not null,
primary key (DATA_STATO, STATOID)
)
Resoconto totale_casi in Italia, Germania, Francia e Spagna
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('25/03/2020', 5249, 743, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('24/03/2020', 4789, 601, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('23/03/2020', 5560, 649, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('22/03/2020', 6557, 795, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('21/03/2020', 5986, 625, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('20/03/2020', 5322, 429, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('19/03/2020', 4207, 473, 'Italy', 'IT', 'ITA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('25/03/2020', 2342, 23, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('24/03/2020', 4438, 32, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('23/03/2020', 3311, 27, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('22/03/2020', 3276, 22, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('21/03/2020', 4049, 2, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('20/03/2020', 5940, 30, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('19/03/2020', 1042, 0, 'Germany', 'DE', 'DEU', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('25/03/2020', 2446, 240, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('24/03/2020', 3838, 186, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('23/03/2020', 1559, 112, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('22/03/2020', 1847, 112, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('21/03/2020', 1617, 78, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('20/03/2020', 1861, 128, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('19/03/2020', 1404, 69, 'France', 'FR', 'FRA', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('25/03/2020', 6584, 514, 'Spain', 'ES', 'ESP', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('24/03/2020', 4517, 462, 'Spain', 'ES', 'ESP', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('23/03/2020', 3646, 394, 'Spain', 'ES', 'ESP', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('22/03/2020', 4946, 324, 'Spain', 'ES', 'ESP', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('21/03/2020', 2833, 235, 'Spain', 'ES', 'ESP', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('20/03/2020', 3431, 169, 'Spain', 'ES', 'ESP', 'Europe');
INSERT INTO STATI_COVID19 (DATA_STATO, CASI, DECEDUTI, DENOMINAZIONI_STATO, STATOID, STATO, CONTINENTE) VALUES ('19/03/2020', 2538, 107, 'Spain', 'ES', 'ESP', 'Europe');
Proiezione tabella Stati_Covid19
select * from STATI_COVID19;
Si realizza la tabella Regioni contente le informazioni necessarie che descrivono una regione nel territorio italiano
Creazione tabella REGIONI
create table REGIONI
(
CODICE_REGIONE NUMBER not null,
DENOMINAZIONE_REGIONE VARCHAR2(21) not null,
STATO VARCHAR2(3)
references STATI
on delete set null,
SUPERFICIE NUMBER(8, 2),
DENSITÀ_SUP NUMBER,
NUM_RESIDENTI NUMBER,
NUM_PROVINCIE NUMBER,
PRESIDENTE VARCHAR2(100),
COD_ISTAT NUMBER,
COD_FISCALE NUMBER,
PIVA NUMBER,
PEC VARCHAR2(100),
SITO VARCHAR2(100),
SEDE VARCHAR2(100),
NUM_AEREOPORTI NUMBER,
NUM_STAZIONI NUMBER,
NUM_AUTOSTRADE NUMBER,
NUM_STRADE_STATALI NUMBER,
constraint REGIONI_PK
primary key (CODICE_REGIONE, DENOMINAZIONE_REGIONE)
)
Insert delle Regioni
INSERT INTO REGIONI VALUES (1, 'Piemonte', 'ITA', 25387.07, 172, 4404246, 8, 'Sergio Chiamparino', 1, 80087670016, 2843860012, 'gabinettopresidenza-giunta@cert.regione.piemonte.it', 'www.regione.piemonte.it', 'Regione Piemonte / Piazza Castello 165, 10122 Torino', 10, 293, 1, 23);
INSERT INTO REGIONI VALUES (19, 'Sicilia', 'ITA', 25832.39, 194, 5074261, 9, 'Rosario Crocetta', 19, 80012000826, 2711070827, 'regione.sicilia@certmail.regione.sicilia.it', 'pti.regione.sicilia.it', 'Regione Siciliana / Piazza Indipendenza 21, 90129 Palermo', 24, 220, 10, 71);
INSERT INTO REGIONI VALUES (8, 'Emilia-Romagna', 'ITA', 22452.78, 199, 4448146, 9, 'Stefano Bonaccini', 8, 80062590379, null, 'urp@postacert.regione.emilia-romagna.it', 'www.regione.emilia-romagna.it', 'Regione Emilia-Romagna / Viale Aldo Moro 52, 40127 Bologna', 14, 211, 2, 30);
INSERT INTO REGIONI VALUES (7, 'Liguria', 'ITA', 5416.21, 286, 1571053, 4, 'Giovanni Toti', 7, null, 849050109, 'protocollo@pec.regione.liguria.it', 'www.regione.liguria.it', 'Regione Liguria / Piazza De Ferrari 1, 16121 Genova', 3, 76, null, 31);
INSERT INTO REGIONI VALUES (2, 'Valle d''Aosta', 'ITA', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO REGIONI VALUES (17, 'Basilicata', 'ITA', 10073.32, 56, 573694, 2, 'Marcello Pittella', 17, 80002950766, null, 'presidenza.giunta@cert.regione.basilicata.it', 'www.regione.basilicata.it', 'Regione Basilicata / Via Vincenzo Verrastro 4, 85100 Potenza', null, 43, 2, 30);
INSERT INTO REGIONI VALUES (14, 'Molise', 'ITA', 4460.65, 69, 312027, 2, 'Paolo Di Laura Frattura', 14, 169440708, null, 'regionemolise@pec.regione.molise.it', 'www.regione.molise.it', 'Regione Molise / Via Genova 11, 86100 Campobasso', null, 18, null, 25);
INSERT INTO REGIONI VALUES (15, 'Campania', 'ITA', 13670.95, 424, 5850850, 5, 'Vincenzo De Luca', 15, 80011990639, 3516070632, 'agc02@pec.regione.campania.it', 'www.regione.campania.it', 'Regione Campania / Via Santa Lucia 81, 80132 Napoli', 6, 268, 4, 41);
INSERT INTO REGIONI VALUES (6, 'Friuli Venezia Giulia', 'ITA', 7862.30, 153, 1221218, 4, 'Debora Serracchiani', 6, 80014930327, 526040324, 'regione.friuliveneziagiulia@certregione.fvg.it', 'www.regione.fvg.it', 'Regione autonoma Friuli Venezia Giulia / Piazza Unità d''Italia 1, 34121 Trieste', 6, 49, 3, 11);
INSERT INTO REGIONI VALUES (4, 'P.A. Bolzano', 'ITA', 13605.50, 79, 1059114, 2, 'Ugo Rossi', 4, 80003690221, null, 'regione.taa@regione.taa.legalmail.it', 'www.regione.taa.it', 'Regione autonoma Trentino-Alto Adige / Via Gazzoletti 2, 38122 Trento', 4, 93, null, 23);
INSERT INTO REGIONI VALUES (16, 'Puglia', 'ITA', 19540.90, 206, 4077166, 6, 'Michele Emiliano', 16, 80017210727, null, 'comunicazione.istituzionale@pec.rupar.puglia.it', 'www.regione.puglia.it', 'Regione Puglia / Lungomare Nazario Sauro 33, 70121 Bari', 10, 206, null, 37);
INSERT INTO REGIONI VALUES (20, 'Sardegna', 'ITA', 24100.02, 68, 1658138, 5, 'Francesco Pigliaru', 20, 80002870923, null, 'affari.generali@pec.regione.sardegna.it', 'www.regione.sardegna.it', 'Regione autonoma della Sardegna / Viale Trento 69, 09123 Cagliari', 7, 137, null, 62);
INSERT INTO REGIONI VALUES (12, 'Lazio', 'ITA', 17232.29, 341, 5888472, 5, 'Nicola Zingaretti', 12, 80143490581, null, 'protocollo-istituzionale@regione.lazio.legalmail.it', 'www.regione.lazio.it', 'Regione Lazio / Via Rosa Raimondi Garibaldi 7, 00145 Roma', 11, 292, 2, 35);
INSERT INTO REGIONI VALUES (3, 'Lombardia', 'ITA', 23863.65, 422, 10008349, 12, 'Roberto Maroni', 3, 80050050154, 12874720159, 'presidenza@pec.regione.lombardia.it', 'www.regione.lombardia.it', 'Regione Lombardia / Piazza Città di Lombardia 1, 20124 Milano', 16, 404, 1, 36);
INSERT INTO REGIONI VALUES (11, 'Marche', 'ITA', 9401.38, 162, 1543752, 5, 'Luca Ceriscioli', 11, 80008630420, 481070423, 'regione.marche.protocollogiunta@emarche.it', 'www.regione.marche.it', 'Regione Marche / Via Gentile da Fabriano 9, 60125 Ancona', 3, 43, 1, 36);
INSERT INTO REGIONI VALUES (10, 'Umbria', 'ITA', 8464.33, 104, 891181, 2, 'Catiuscia Marini', 10, null, 1212820540, 'regione.giunta@postacert.umbria.it', 'www.regione.umbria.it', 'Regione Umbria / Palazzo Donini - Corso Vannucci 96, 06121 Perugia', 2, 82, 1, 28);
INSERT INTO REGIONI VALUES (5, 'Veneto', 'ITA', 18407.42, 267, 4915123, 7, 'Luca Zaia', 5, 80007580279, 2392630279, 'protocollo.generale@pec.regione.veneto.it', 'www.regione.veneto.it', 'Regione Veneto / Palazzo Balbi - Dorsoduro 3901, 30123 Venezia', 14, 181, null, 19);
INSERT INTO REGIONI VALUES (13, 'Abruzzo', 'ITA', 10831.84, 121, 1326513, 4, 'Luciano D''Alfonso', 13, 80003170661, null, 'urp@pec.regione.abruzzo.it', 'www.regione.abruzzo.it', 'Regione Abruzzo / Palazzo Silone - Via Leonardo da Vinci 6, 67100 L''Aquila', 2, 81, 1, 48);
INSERT INTO REGIONI VALUES (18, 'Calabria', 'ITA', 15221.90, 128, 1970521, 5, 'Gerardo Mario Oliverio', 18, 2205340793, null, 'dipartimento.presidenza@pec.regione.calabria.it', 'www.regione.calabria.it', 'Regione Calabria / Via Massara 2, 88100 Catanzaro', 5, 87, 3, 49);
INSERT INTO REGIONI VALUES (9, 'Toscana', 'ITA', 22987.04, 162, 3744398, 10, 'Enrico Rossi', 9, 1386030488, null, 'regionetoscana@postacert.toscana.it', 'www.regione.toscana.it', 'Regione Toscana / Palazzo Strozzi Sacrati - Piazza del Duomo 10, 50122 Firenze', 11, 192, 2, 34);
INSERT INTO REGIONI VALUES (4, 'P.A. Trento', 'ITA', 13605.50, 79, 1059114, 2, 'Ugo Rossi', 4, 80003690221, null, 'regione.taa@regione.taa.legalmail.it', 'www.regione.taa.it', 'Regione autonoma Trentino-Alto Adige / Via Gazzoletti 2, 38122 Trento', 4, 93, null, 23);
Proiezione tabella Regioni
select * from REGIONI;
Si crea la tabella Regioni_Covid19
create table REGIONI_COVID19
(
DATA VARCHAR2(19) not null,
CODICE_REGIONE NUMBER not null,
DENOMINAZIONE_REGIONE VARCHAR2(21) not null,
RICOVERATI_CON_SINTOMI NUMBER,
TERAPIA_INTENSIVA NUMBER,
TOTALE_OSPEDALIZZATI NUMBER,
ISOLAMENTO_DOMICILIARE NUMBER,
TOTALE_POSITIVI NUMBER,
VARIAZIONE_TOTALE_POSITIVI NUMBER,
NUOVI_POSITIVI NUMBER,
DIMESSI_GUARITI NUMBER,
DECEDUTI NUMBER,
TOTALE_CASI NUMBER,
TAMPONI NUMBER,
CASI_TESTATI NUMBER,
NOTE_IT VARCHAR2(10),
NOTE_EN VARCHAR2(10),
primary key (DATA, CODICE_REGIONE, DENOMINAZIONE_REGIONE),
foreign key (CODICE_REGIONE, DENOMINAZIONE_REGIONE) references REGIONI
on delete cascade
)
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 1, 'Piemonte', 2279, 257, 2536, 218, 2754, 567, 591, 3, 175, 2932, 8853, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 2, 'Valle d''Aosta', 47, 9, 56, 153, 209, 47, 50, 0, 6, 215, 608, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 3, 'Lombardia', 7387, 1006, 8393, 5545, 13938, 1672, 2171, 3778, 2168, 19884, 52244, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 4, 'P.A. Bolzano', 87, 18, 105, 316, 421, 55, 60, 1, 14, 436, 3568, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 4, 'P.A. Trento', 169, 30, 199, 292, 491, 55, 68, 20, 12, 523, 2203, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 5, 'Veneto', 771, 209, 980, 2189, 3169, 216, 270, 200, 115, 3484, 44658, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 6, 'Friuli Venezia Giulia', 134, 29, 163, 359, 522, 106, 137, 41, 36, 599, 4052, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 7, 'Liguria', 491, 112, 603, 280, 883, 139, 172, 85, 91, 1059, 3348, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 8, 'Emilia-Romagna', 1900, 260, 2160, 2346, 4506, 591, 689, 177, 531, 5214, 18344, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 9, 'Toscana', 501, 178, 679, 743, 1422, 131, 152, 22, 38, 1482, 8873, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 10, 'Umbria', 69, 21, 90, 238, 328, 87, 87, 4, 2, 334, 1954, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 11, 'Marche', 656, 141, 797, 825, 1622, 146, 169, 0, 115, 1737, 4512, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 12, 'Lazio', 426, 45, 471, 270, 741, 91, 99, 44, 38, 823, 11145, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 13, 'Abruzzo', 181, 47, 228, 138, 366, 117, 122, 8, 11, 385, 2409, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 14, 'Molise', 19, 6, 25, 13, 38, 17, 18, 6, 2, 46, 426, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 15, 'Campania', 213, 36, 249, 356, 605, 182, 192, 30, 17, 652, 3544, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 16, 'Puglia', 173, 31, 204, 245, 449, 87, 95, 4, 25, 478, 4046, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 17, 'Basilicata', 8, 5, 13, 24, 37, 10, 10, 0, 0, 37, 353, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 18, 'Calabria', 60, 13, 73, 91, 164, 38, 40, 2, 3, 169, 2342, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 19, 'Sicilia', 143, 36, 179, 142, 321, 54, 58, 15, 4, 340, 3961, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-19T17:00:00', 20, 'Sardegna', 43, 9, 52, 152, 204, 72, 72, 0, 2, 206, 1334, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 1, 'Piemonte', 1541, 280, 1821, 1423, 3244, 490, 529, 8, 209, 3461, 9975, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 2, 'Valle d''Aosta', 54, 9, 63, 194, 257, 48, 49, 0, 7, 264, 814, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 3, 'Lombardia', 7735, 1050, 8785, 6635, 15420, 1482, 2380, 4295, 2549, 22264, 57174, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 4, 'P.A. Bolzano', 99, 24, 123, 407, 530, 109, 112, 1, 17, 548, 4433, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 4, 'P.A. Trento', 198, 34, 232, 368, 600, 109, 119, 29, 13, 642, 2656, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 5, 'Veneto', 843, 236, 1079, 2598, 3677, 508, 547, 223, 131, 4031, 49288, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 6, 'Friuli Venezia Giulia', 143, 32, 175, 380, 555, 33, 57, 63, 38, 656, 4964, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 7, 'Liguria', 573, 121, 694, 307, 1001, 118, 162, 101, 119, 1221, 3794, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 8, 'Emilia-Romagna', 2083, 267, 2350, 2739, 5089, 583, 754, 239, 640, 5968, 20753, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 9, 'Toscana', 601, 189, 790, 923, 1713, 291, 311, 33, 47, 1793, 10405, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 10, 'Umbria', 75, 24, 99, 285, 384, 56, 61, 4, 7, 395, 2303, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 11, 'Marche', 704, 138, 842, 1002, 1844, 222, 244, 0, 137, 1981, 5170, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 12, 'Lazio', 537, 47, 584, 328, 912, 171, 185, 53, 43, 1008, 13889, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 13, 'Abruzzo', 190, 48, 238, 184, 422, 56, 64, 10, 17, 449, 2695, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 14, 'Molise', 20, 6, 26, 13, 39, 1, 4, 6, 5, 50, 426, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 15, 'Campania', 130, 41, 171, 531, 702, 97, 97, 30, 17, 749, 3845, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 16, 'Puglia', 191, 31, 222, 329, 551, 102, 103, 4, 26, 581, 4789, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 17, 'Basilicata', 8, 5, 13, 39, 52, 15, 15, 0, 0, 52, 443, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 18, 'Calabria', 71, 16, 87, 114, 201, 37, 38, 2, 4, 207, 2690, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 19, 'Sicilia', 168, 42, 210, 169, 379, 58, 68, 25, 4, 408, 4468, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-20T17:00:00', 20, 'Sardegna', 56, 15, 71, 217, 288, 84, 87, 3, 2, 293, 1912, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 1, 'Piemonte', 1976, 301, 2277, 1229, 3506, 262, 291, 8, 238, 3752, 10701, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 2, 'Valle d''Aosta', 62, 15, 77, 227, 304, 47, 49, 1, 8, 313, 884, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 3, 'Lombardia', 8258, 1093, 9351, 8019, 17370, 1950, 3251, 5050, 3095, 25515, 66730, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 4, 'P.A. Bolzano', 127, 30, 157, 443, 600, 70, 73, 1, 20, 621, 5179, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 4, 'P.A. Trento', 233, 39, 272, 448, 720, 120, 140, 34, 28, 782, 2656, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 5, 'Veneto', 942, 249, 1191, 3023, 4214, 537, 586, 257, 146, 4617, 53642, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 6, 'Friuli Venezia Giulia', 152, 37, 189, 477, 666, 111, 134, 82, 42, 790, 5955, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 7, 'Liguria', 598, 129, 727, 432, 1159, 158, 215, 125, 152, 1436, 4304, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 8, 'Emilia-Romagna', 2267, 265, 2532, 3129, 5661, 572, 737, 329, 715, 6705, 24620, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 9, 'Toscana', 664, 202, 866, 1039, 1905, 192, 219, 35, 72, 2012, 11909, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 10, 'Umbria', 92, 29, 121, 326, 447, 63, 67, 5, 10, 462, 2712, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 11, 'Marche', 742, 141, 883, 1114, 1997, 153, 172, 2, 154, 2153, 5740, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 12, 'Lazio', 591, 70, 661, 425, 1086, 174, 182, 54, 50, 1190, 13889, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 13, 'Abruzzo', 185, 44, 229, 265, 494, 72, 80, 13, 22, 529, 3035, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 14, 'Molise', 21, 6, 27, 20, 47, 8, 11, 7, 7, 61, 449, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 15, 'Campania', 233, 87, 320, 473, 793, 91, 95, 29, 22, 844, 4448, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 16, 'Puglia', 209, 33, 242, 400, 642, 91, 94, 4, 29, 675, 5617, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 17, 'Basilicata', 12, 7, 19, 47, 66, 14, 14, 0, 0, 66, 522, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 18, 'Calabria', 73, 16, 89, 136, 225, 24, 28, 5, 5, 235, 3050, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 19, 'Sicilia', 206, 48, 254, 204, 458, 79, 82, 26, 6, 490, 4883, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-21T17:00:00', 20, 'Sardegna', 65, 16, 81, 240, 321, 33, 37, 5, 4, 330, 2297, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 1, 'Piemonte', 2118, 308, 2426, 1701, 4127, 621, 668, 10, 283, 4420, 12701, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 2, 'Valle d''Aosta', 63, 21, 84, 270, 354, 50, 51, 1, 9, 364, 950, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 3, 'Lombardia', 9439, 1142, 10581, 7304, 17885, 515, 1691, 5865, 3456, 27206, 70598, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 4, 'P.A. Bolzano', 146, 32, 178, 470, 648, 48, 57, 7, 23, 678, 5718, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 4, 'P.A. Trento', 235, 46, 281, 604, 885, 165, 172, 34, 35, 954, 3050, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 5, 'Veneto', 1113, 255, 1368, 3276, 4644, 430, 505, 309, 169, 5122, 57671, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 6, 'Friuli Venezia Giulia', 163, 47, 210, 528, 738, 72, 84, 89, 47, 874, 6761, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 7, 'Liguria', 736, 132, 868, 483, 1351, 192, 229, 143, 171, 1665, 4995, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 8, 'Emilia-Romagna', 2429, 269, 2698, 3692, 6390, 729, 850, 349, 816, 7555, 28022, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 9, 'Toscana', 706, 215, 921, 1223, 2144, 239, 265, 42, 91, 2277, 13264, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 10, 'Umbria', 97, 35, 132, 368, 500, 53, 59, 5, 16, 521, 3135, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 11, 'Marche', 816, 138, 954, 1277, 2231, 234, 268, 6, 184, 2421, 6391, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 12, 'Lazio', 671, 79, 750, 522, 1272, 186, 193, 58, 53, 1383, 17845, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 13, 'Abruzzo', 218, 49, 267, 272, 539, 45, 58, 15, 33, 587, 3375, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 14, 'Molise', 24, 7, 31, 21, 52, 5, 5, 7, 7, 66, 532, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 15, 'Campania', 243, 99, 342, 524, 866, 73, 92, 41, 29, 936, 4943, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 16, 'Puglia', 252, 37, 289, 459, 748, 106, 111, 7, 31, 786, 6160, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 17, 'Basilicata', 13, 10, 23, 58, 81, 15, 15, 0, 0, 81, 643, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 18, 'Calabria', 77, 17, 94, 166, 260, 35, 38, 5, 8, 273, 3666, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 19, 'Sicilia', 220, 55, 275, 321, 596, 138, 140, 26, 8, 630, 5580, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-22T17:00:00', 20, 'Sardegna', 67, 16, 83, 244, 327, 6, 9, 5, 7, 339, 2402, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 1, 'Piemonte', 2194, 343, 2537, 1992, 4529, 402, 441, 17, 315, 4861, 13560, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 2, 'Valle d''Aosta', 69, 20, 89, 290, 379, 25, 29, 2, 12, 393, 1098, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 3, 'Lombardia', 9266, 1183, 10449, 8461, 18910, 1025, 1555, 6075, 3776, 28761, 73242, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 4, 'P.A. Bolzano', 145, 33, 178, 510, 688, 40, 46, 7, 29, 724, 6084, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 4, 'P.A. Trento', 249, 46, 295, 619, 914, 29, 69, 68, 41, 1023, 3150, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 5, 'Veneto', 1206, 281, 1487, 3499, 4986, 342, 383, 327, 192, 5505, 61115, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 6, 'Friuli Venezia Giulia', 185, 41, 226, 545, 771, 33, 56, 105, 54, 930, 7424, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 7, 'Liguria', 761, 133, 894, 659, 1553, 202, 259, 159, 212, 1924, 5538, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 8, 'Emilia-Romagna', 2846, 276, 3122, 4098, 7220, 830, 980, 423, 892, 8535, 31200, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 9, 'Toscana', 838, 238, 1076, 1225, 2301, 157, 184, 51, 109, 2461, 13851, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 10, 'Umbria', 106, 42, 148, 408, 556, 56, 56, 5, 16, 577, 3561, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 11, 'Marche', 882, 148, 1030, 1328, 2358, 127, 148, 8, 203, 2569, 6782, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 12, 'Lazio', 718, 96, 814, 600, 1414, 142, 157, 63, 63, 1540, 18371, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 13, 'Abruzzo', 228, 52, 280, 325, 605, 66, 76, 20, 38, 663, 3674, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 14, 'Molise', 25, 7, 32, 18, 50, -2, 1, 10, 7, 67, 532, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 15, 'Campania', 266, 110, 376, 553, 929, 63, 90, 48, 49, 1026, 5813, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 16, 'Puglia', 285, 45, 330, 532, 862, 114, 120, 7, 37, 906, 6761, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 17, 'Basilicata', 15, 12, 27, 62, 89, 8, 9, 0, 1, 90, 696, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 18, 'Calabria', 82, 20, 102, 178, 280, 20, 19, 5, 7, 292, 4073, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 19, 'Sicilia', 250, 60, 310, 371, 681, 85, 91, 27, 13, 721, 6375, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-23T17:00:00', 20, 'Sardegna', 76, 18, 94, 249, 343, 16, 20, 5, 11, 359, 2568, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 1, 'Piemonte', 2404, 360, 2764, 2360, 5124, 595, 654, 17, 374, 5515, 15469, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 2, 'Valle d''Aosta', 71, 20, 91, 288, 379, 0, 7, 2, 19, 400, 1180, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 3, 'Lombardia', 9711, 1194, 10905, 8963, 19868, 958, 1942, 6657, 4178, 30703, 76695, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 4, 'P.A. Bolzano', 166, 38, 204, 495, 699, 11, 57, 44, 38, 781, 6509, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 4, 'P.A. Trento', 308, 49, 357, 618, 975, 61, 87, 79, 56, 1110, 3712, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 5, 'Veneto', 1318, 304, 1622, 3729, 5351, 365, 443, 381, 216, 5948, 66178, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 6, 'Friuli Venezia Giulia', 195, 49, 244, 604, 848, 77, 62, 80, 64, 992, 8526, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 7, 'Liguria', 803, 147, 950, 742, 1692, 139, 192, 193, 231, 2116, 5992, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 8, 'Emilia-Romagna', 2974, 291, 3265, 4446, 7711, 491, 719, 558, 985, 9254, 33527, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 9, 'Toscana', 918, 244, 1162, 1357, 2519, 218, 238, 51, 129, 2699, 15701, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 10, 'Umbria', 105, 43, 148, 476, 624, 68, 71, 5, 19, 648, 4108, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 11, 'Marche', 862, 149, 1011, 1486, 2497, 139, 167, 8, 231, 2736, 7229, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 12, 'Lazio', 747, 94, 841, 704, 1545, 131, 188, 103, 80, 1728, 18371, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 13, 'Abruzzo', 234, 57, 291, 331, 622, 17, 26, 21, 46, 689, 4294, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 14, 'Molise', 27, 7, 34, 21, 55, 5, 6, 10, 8, 73, 572, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 15, 'Campania', 345, 181, 526, 466, 992, 63, 75, 53, 56, 1101, 6297, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 16, 'Puglia', 317, 57, 374, 566, 940, 78, 99, 21, 44, 1005, 7345, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 17, 'Basilicata', 14, 12, 26, 65, 91, 2, 2, 0, 1, 92, 744, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 18, 'Calabria', 88, 21, 109, 195, 304, 24, 27, 5, 10, 319, 4486, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 19, 'Sicilia', 250, 60, 310, 489, 799, 118, 125, 27, 20, 846, 7170, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-24T17:00:00', 20, 'Sardegna', 80, 19, 99, 296, 395, 52, 62, 11, 15, 421, 2859, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 1, 'Piemonte', 2544, 381, 2925, 2631, 5556, 432, 509, 19, 449, 6024, 16655, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 2, 'Valle d''Aosta', 70, 25, 95, 280, 375, -4, 1, 2, 24, 401, 1200, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 3, 'Lombardia', 10026, 1236, 11262, 9329, 20591, 723, 1643, 7281, 4474, 32346, 81666, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 4, 'P.A. Bolzano', 190, 40, 230, 518, 748, 49, 77, 67, 43, 858, 6649, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 4, 'P.A. Trento', 308, 65, 373, 685, 1058, 83, 112, 90, 74, 1222, 4114, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 5, 'Veneto', 1407, 316, 1723, 4022, 5745, 394, 494, 439, 258, 6442, 70877, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 6, 'Friuli Venezia Giulia', 200, 52, 252, 659, 911, 63, 147, 158, 70, 1139, 9494, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 7, 'Liguria', 927, 147, 1074, 752, 1826, 134, 189, 225, 254, 2305, 6602, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 8, 'Emilia-Romagna', 3180, 294, 3474, 4782, 8256, 545, 800, 721, 1077, 10054, 38045, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 9, 'Toscana', 999, 251, 1250, 1526, 2776, 257, 273, 54, 142, 2972, 17868, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 10, 'Umbria', 123, 44, 167, 519, 686, 62, 62, 5, 19, 710, 4707, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 11, 'Marche', 938, 148, 1086, 1553, 2639, 142, 198, 8, 287, 2934, 7896, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 12, 'Lazio', 805, 101, 906, 769, 1675, 130, 173, 131, 95, 1901, 20669, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 13, 'Abruzzo', 248, 59, 307, 431, 738, 116, 124, 23, 52, 813, 4982, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 14, 'Molise', 26, 7, 33, 20, 53, -2, 0, 12, 8, 73, 580, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 15, 'Campania', 318, 123, 441, 631, 1072, 80, 98, 53, 74, 1199, 6972, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 16, 'Puglia', 349, 64, 413, 610, 1023, 83, 88, 22, 48, 1093, 8223, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 17, 'Basilicata', 20, 14, 34, 78, 112, 21, 21, 0, 1, 113, 857, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 18, 'Calabria', 93, 23, 116, 217, 333, 29, 32, 7, 11, 351, 5058, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 19, 'Sicilia', 259, 80, 339, 597, 936, 137, 148, 33, 25, 994, 8312, null, null, null);
INSERT INTO REGIONI_COVID19 VALUES ('2020-03-25T17:00:00', 20, 'Sardegna', 82, 19, 101, 311, 412, 17, 21, 12, 18, 442, 3019, null, null, null);
Sulla tabella Regioni_Covid19 si possono analizzare tutti i dati necessari per gli eventuali calcoli dell'andamento del virus.
Proiezione tabella Regione_Covid19
select * from REGIONI_COVID19;
Si passa poi alla creazione della tabella Province
create table PROVINCE
(
CODICE_PROVINCIA NUMBER not null
primary key,
DENOMINAZIONE_PROVINCIA VARCHAR2(36) not null,
SIGLA_PROVINCIA VARCHAR2(2),
LATITUDINE NUMBER(11, 8) not null,
LONGITUDINE NUMBER(11, 9) not null,
CODICE_REGIONE NUMBER not null,
DENOMINAZIONE_REGIONE VARCHAR2(21) not null,
SUPERFICIE NUMBER(7, 2),
DENSITÀ_SUP NUMBER,
RESIDENTI NUMBER,
NUM_COMUNI NUMBER,
NUM_SCUOLE NUMBER,
NUM_ALBERGHI NUMBER,
foreign key (CODICE_REGIONE, DENOMINAZIONE_REGIONE) references REGIONI
)
Si inseriscono tutte le province
INSERT INTO PROVINCE VALUES (21, 'Bolzano', 'BZ', 46.49933453, 11.356624220, 4, 'P.A. Bolzano', 7399.92, 72, 509626, 116, 627, 4067);
INSERT INTO PROVINCE VALUES (33, 'Piacenza', 'PC', 45.05193462, 9.692632596, 8, 'Emilia-Romagna', 2589.47, 111, 286336, 48, 311, 92);
INSERT INTO PROVINCE VALUES (17, 'Brescia', 'BS', 45.53993052, 10.219103230, 3, 'Lombardia', 4784.36, 265, 1247192, 205, 1380, 716);
INSERT INTO PROVINCE VALUES (13, 'Como', 'CO', 45.80999120, 9.085159546, 3, 'Lombardia', 1308.96, 468, 592504, 151, 682, 243);
INSERT INTO PROVINCE VALUES (5, 'Asti', 'AT', 44.89912921, 8.204142547, 1, 'Piemonte', 1510.78, 142, 217978, 118, 281, 65);
INSERT INTO PROVINCE VALUES (96, 'Biella', 'BI', 45.56651120, 8.054082167, 1, 'Piemonte', 917.30, 192, 181426, 78, 260, 33);
INSERT INTO PROVINCE VALUES (3, 'Novara', 'NO', 45.44588506, 8.621915884, 1, 'Piemonte', 1338.12, 275, 367022, 88, 406, 116);
INSERT INTO PROVINCE VALUES (90, 'Sassari', 'SS', 40.72667657, 8.559667131, 20, 'Sardegna', 7692.09, 64, 494471, 92, 484, 117);
INSERT INTO PROVINCE VALUES (48, 'Firenze', 'FI', 43.76923077, 11.255888850, 9, 'Toscana', 3514.38, 288, 987354, 42, 944, 577);
INSERT INTO PROVINCE VALUES (46, 'Lucca', 'LU', 43.84432283, 10.501513660, 9, 'Toscana', 1772.81, 219, 388555, 33, 499, 430);
INSERT INTO PROVINCE VALUES (26, 'Treviso', 'TV', 45.66754571, 12.245073630, 5, 'Veneto', 2476.68, 358, 881245, 95, 1001, 166);
INSERT INTO PROVINCE VALUES (77, 'Matera', 'MT', 40.66751177, 16.597924420, 17, 'Basilicata', 3446.12, 57, 200012, 31, 285, 83);
INSERT INTO PROVINCE VALUES (38, 'Ferrara', 'FE', 44.83599085, 11.618689340, 8, 'Emilia-Romagna', 2631.82, 131, 352723, 23, 345, 107);
INSERT INTO PROVINCE VALUES (108, 'Monza e della Brianza', 'MB', 45.58439043, 9.273582472, 3, 'Lombardia', 405.49, 2156, 850684, 55, 685, 62);
INSERT INTO PROVINCE VALUES (18, 'Pavia', 'PV', 45.18509264, 9.160157191, 3, 'Lombardia', 2964.73, 184, 539569, 188, 577, 107);
INSERT INTO PROVINCE VALUES (42, 'Ancona', 'AN', 43.61675973, 13.518875300, 11, 'Marche', 1940.16, 240, 475495, 47, 554, 227);
INSERT INTO PROVINCE VALUES (44, 'Ascoli Piceno', 'AP', 42.85322304, 13.576911270, 11, 'Marche', 1228.23, 169, 210711, 33, 267, 196);
INSERT INTO PROVINCE VALUES (71, 'Foggia', 'FG', 41.46226865, 15.543050940, 16, 'Puglia', 6966.17, 89, 628221, 61, 879, 317);
INSERT INTO PROVINCE VALUES (82, 'Palermo', 'PA', 38.11569725, 13.362356700, 19, 'Sicilia', 4992.23, 250, 1243638, 82, 1660, 182);
INSERT INTO PROVINCE VALUES (45, 'Massa Carrara', 'MS', 44.03674425, 10.141738290, 9, 'Toscana', 1156.44, 169, 199330, 17, 284, 141);
INSERT INTO PROVINCE VALUES (50, 'Pisa', 'PI', 43.71553206, 10.401272590, 9, 'Toscana', 2445.82, 171, 413602, 37, 461, 174);
INSERT INTO PROVINCE VALUES (47, 'Pistoia', 'PT', 43.93346500, 10.917341460, 9, 'Toscana', 964.98, 303, 287445, 20, 305, 256);
INSERT INTO PROVINCE VALUES (25, 'Belluno', 'BL', 46.13837528, 12.217041670, 5, 'Veneto', 3678.02, 56, 209364, 64, 353, 421);
INSERT INTO PROVINCE VALUES (28, 'Padova', 'PD', 45.40692987, 11.876087180, 5, 'Veneto', 2141.59, 437, 927848, 104, 1004, 248);
INSERT INTO PROVINCE VALUES (24, 'Vicenza', 'VI', 45.54749700, 11.545971090, 5, 'Veneto', 2725.09, 317, 865421, 121, 961, 266);
INSERT INTO PROVINCE VALUES (80, 'Reggio di Calabria', 'RC', 38.10922769, 15.643452700, 18, 'Calabria', 3183.19, 171, 550323, 97, 1116, 110);
INSERT INTO PROVINCE VALUES (61, 'Caserta', 'CE', 41.07465878, 14.332404640, 15, 'Campania', 2639.38, 348, 908784, 104, 1480, 101);
INSERT INTO PROVINCE VALUES (57, 'Rieti', 'RI', 42.40488444, 12.862059390, 12, 'Lazio', 2749.16, 57, 156521, 73, 284, 59);
INSERT INTO PROVINCE VALUES (74, 'Brindisi', 'BR', 40.63848545, 17.946015750, 16, 'Puglia', 1839.53, 211, 399835, 20, 428, 96);
INSERT INTO PROVINCE VALUES (55, 'Terni', 'TR', 42.56071258, 12.646687500, 10, 'Umbria', 2121.95, 106, 228366, 33, 319, 100);
INSERT INTO PROVINCE VALUES (66, 'L''Aquila', 'AQ', 42.35122196, 13.398438230, 13, 'Abruzzo', 5034.46, 59, 300774, 108, 498, 239);
INSERT INTO PROVINCE VALUES (15, 'Milano', 'MI', 45.46679409, 9.190347404, 3, 'Lombardia', 1578.90, 2063, 3075083, 134, 2383, 676);
INSERT INTO PROVINCE VALUES (109, 'Fermo', 'FM', 43.16058534, 13.718395350, 11, 'Marche', 859.50, 201, 175143, 40, 223, 55);
INSERT INTO PROVINCE VALUES (43, 'Macerata', 'MC', 43.30023926, 13.453071820, 11, 'Marche', 2773.75, 113, 320418, 55, 408, 118);
INSERT INTO PROVINCE VALUES (92, 'Cagliari', 'CA', 39.21531192, 9.110616306, 20, 'Sardegna', 1248.68, 345, 431657, 17, 726, 197);
INSERT INTO PROVINCE VALUES (81, 'Trapani', 'TP', 38.01850065, 12.513656840, 19, 'Sicilia', 2461.65, 174, 430478, 24, 644, 178);
INSERT INTO PROVINCE VALUES (101, 'Crotone', 'KR', 39.08036878, 17.125388640, 18, 'Calabria', 1716.58, 101, 171666, 27, 315, 63);
INSERT INTO PROVINCE VALUES (99, 'Rimini', 'RN', 44.06090087, 12.565629500, 8, 'Emilia-Romagna', 861.48, 392, 326926, 25, 335, 2229);
INSERT INTO PROVINCE VALUES (60, 'Frosinone', 'FR', 41.63964569, 13.351171610, 12, 'Lazio', 3243.89, 151, 493229, 91, 750, 242);
INSERT INTO PROVINCE VALUES (16, 'Bergamo', 'BG', 45.69441368, 9.668424528, 3, 'Lombardia', 2722.86, 405, 1094062, 242, 1228, 279);
INSERT INTO PROVINCE VALUES (6, 'Alessandria', 'AL', 44.91297351, 8.615401155, 1, 'Piemonte', 3560.42, 118, 427354, 190, 518, 128);
INSERT INTO PROVINCE VALUES (4, 'Cuneo', 'CN', 44.39329625, 7.551171632, 1, 'Piemonte', 6902.68, 85, 589102, 250, 845, 316);
INSERT INTO PROVINCE VALUES (85, 'Caltanissetta', 'CL', 37.49213171, 14.061849730, 19, 'Sicilia', 2128.45, 123, 272458, 22, 383, 17);
INSERT INTO PROVINCE VALUES (83, 'Messina', 'ME', 38.19395845, 15.555723020, 19, 'Sicilia', 3247.34, 192, 648062, 108, 1237, 427);
INSERT INTO PROVINCE VALUES (54, 'Perugia', 'PG', 43.10675841, 12.388246980, 10, 'Umbria', 6334.09, 104, 657873, 59, 907, 448);
INSERT INTO PROVINCE VALUES (29, 'Rovigo', 'RO', 45.07107289, 11.790070000, 5, 'Veneto', 1790.01, 129, 242543, 50, 324, 65);
INSERT INTO PROVINCE VALUES (69, 'Chieti', 'CH', 42.35103167, 14.167545740, 13, 'Abruzzo', 2588.35, 148, 389053, 104, 604, 155);
INSERT INTO PROVINCE VALUES (76, 'Potenza', 'PZ', 40.63947052, 15.805148340, 17, 'Basilicata', 6548.49, 55, 376182, 100, 785, 144);
INSERT INTO PROVINCE VALUES (79, 'Catanzaro', 'CZ', 38.90597598, 16.594401940, 18, 'Calabria', 2391.35, 148, 359716, 80, 711, 129);
INSERT INTO PROVINCE VALUES (10, 'Genova', 'GE', 44.41149314, 8.932699200, 7, 'Liguria', 1838.47, 459, 851283, 67, 853, 358);
INSERT INTO PROVINCE VALUES (11, 'La Spezia', 'SP', 44.10704991, 9.828189700, 7, 'Liguria', 882.40, 249, 218717, 32, 273, 214);
INSERT INTO PROVINCE VALUES (72, 'Bari', 'BA', 41.12559576, 16.867366890, 16, 'Puglia', 3825.41, 324, 1246297, 41, 1226, 160);
INSERT INTO PROVINCE VALUES (91, 'Nuoro', 'NU', 40.32318834, 9.330296393, 20, 'Sardegna', 5638.02, 37, 213086, 74, 309, 100);
INSERT INTO PROVINCE VALUES (95, 'Oristano', 'OR', 39.90381075, 8.591183151, 20, 'Sardegna', 2990.45, 53, 160766, 87, 298, 60);
INSERT INTO PROVINCE VALUES (84, 'Agrigento', 'AG', 37.30971088, 13.584574900, 19, 'Sicilia', 3044.85, 142, 446081, 43, 628, 114);
INSERT INTO PROVINCE VALUES (87, 'Catania', 'CT', 37.50287803, 15.087046910, 19, 'Sicilia', 3552.20, 310, 1077113, 58, 1525, 132);
INSERT INTO PROVINCE VALUES (86, 'Enna', 'EN', 37.56705701, 14.279093750, 19, 'Sicilia', 2561.86, 64, 172413, 20, 293, 19);
INSERT INTO PROVINCE VALUES (51, 'Arezzo', 'AR', 43.46642752, 11.882288440, 9, 'Toscana', 3235.88, 106, 344437, 37, 454, 172);
INSERT INTO PROVINCE VALUES (49, 'Livorno', 'LI', 43.55234873, 10.308678100, 9, 'Toscana', 1212.43, 276, 335631, 20, 306, 365);
INSERT INTO PROVINCE VALUES (63, 'Napoli', 'NA', 40.83956555, 14.250849840, 15, 'Campania', 1171.13, 2617, 3055339, 92, 3837, 947);
INSERT INTO PROVINCE VALUES (34, 'Parma', 'PR', 44.80107394, 10.328349850, 8, 'Emilia-Romagna', 3449.32, 131, 431049, 45, 441, 210);
INSERT INTO PROVINCE VALUES (59, 'Latina', 'LT', 41.46759465, 12.903684820, 12, 'Lazio', 2250.44, 255, 552090, 33, 601, 202);
INSERT INTO PROVINCE VALUES (8, 'Imperia', 'IM', 43.88570648, 8.027850298, 7, 'Liguria', 1155.91, 185, 214290, 67, 281, 255);
INSERT INTO PROVINCE VALUES (19, 'Cremona', 'CR', 45.13336675, 10.024208650, 3, 'Lombardia', 1770.57, 203, 361812, 115, 417, 43);
INSERT INTO PROVINCE VALUES (20, 'Mantova', 'MN', 45.15726772, 10.792773630, 3, 'Lombardia', 2338.84, 176, 411335, 69, 464, 93);
INSERT INTO PROVINCE VALUES (110, 'Barletta-Andria-Trani', 'BT', 41.22705039, 16.295204320, 16, 'Puglia', 1538.68, 253, 392446, 10, 371, 45);
INSERT INTO PROVINCE VALUES (73, 'Taranto', 'TA', 40.47354739, 17.232371810, 16, 'Puglia', 2428.71, 234, 582814, 29, 628, 95);
INSERT INTO PROVINCE VALUES (111, 'Sud Sardegna', 'SU', 39.16641462, 8.526242676, 20, 'Sardegna', 6530.78, 54, 358158, 107, 195, 52);
INSERT INTO PROVINCE VALUES (88, 'Ragusa', 'RG', 36.92509198, 14.730698910, 19, 'Sicilia', 1614.02, 198, 310220, 12, 447, 98);
INSERT INTO PROVINCE VALUES (53, 'Grosseto', 'GR', 42.76026758, 11.113563980, 9, 'Toscana', 4504.29, 49, 220982, 28, 315, 291);
INSERT INTO PROVINCE VALUES (52, 'Siena', 'SI', 43.31816374, 11.331909880, 9, 'Toscana', 3821.22, 70, 267200, 35, 299, 416);
INSERT INTO PROVINCE VALUES (68, 'Pescara', 'PE', 42.46458398, 14.213648220, 13, 'Abruzzo', 1189.29, 259, 315725, 46, 387, 102);
INSERT INTO PROVINCE VALUES (78, 'Cosenza', 'CS', 39.29308681, 16.256096920, 18, 'Calabria', 6649.96, 105, 714281, 155, 1451, 325);
INSERT INTO PROVINCE VALUES (64, 'Avellino', 'AV', 40.91404699, 14.795288030, 15, 'Campania', 2791.64, 149, 428523, 118, 812, 80);
INSERT INTO PROVINCE VALUES (62, 'Benevento', 'BN', 41.12969987, 14.781516830, 15, 'Campania', 2070.63, 133, 283651, 78, 569, 51);
INSERT INTO PROVINCE VALUES (37, 'Bologna', 'BO', 44.49436681, 11.341720800, 8, 'Emilia-Romagna', 3702.41, 274, 990681, 55, 950, 332);
INSERT INTO PROVINCE VALUES (40, 'Forlì-Cesena', 'FC', 44.22268559, 12.040686080, 8, 'Emilia-Romagna', 2376.80, 166, 392817, 30, 409, 483);
INSERT INTO PROVINCE VALUES (36, 'Modena', 'MO', 44.64600009, 10.926154870, 8, 'Emilia-Romagna', 2682.86, 262, 688376, 47, 625, 234);
INSERT INTO PROVINCE VALUES (31, 'Gorizia', 'GO', 45.94149817, 13.622125020, 6, 'Friuli Venezia Giulia', 466.02, 298, 140650, 25, 194, 124);
INSERT INTO PROVINCE VALUES (93, 'Pordenone', 'PN', 45.95443546, 12.660029090, 6, 'Friuli Venezia Giulia', 2276.30, 137, 312911, 50, 325, 107);
INSERT INTO PROVINCE VALUES (30, 'Udine', 'UD', 46.06255516, 13.234838300, 6, 'Friuli Venezia Giulia', 4904.25, 106, 536622, 135, 698, 422);
INSERT INTO PROVINCE VALUES (56, 'Viterbo', 'VT', 42.41738280, 12.104734160, 12, 'Lazio', 3611.53, 88, 315623, 60, 383, 108);
INSERT INTO PROVINCE VALUES (97, 'Lecco', 'LC', 45.85575781, 9.393392246, 3, 'Lombardia', 816.17, 419, 338425, 88, 423, 100);
INSERT INTO PROVINCE VALUES (98, 'Lodi', 'LO', 45.31440693, 9.503720769, 3, 'Lombardia', 782.20, 294, 225798, 61, 258, 29);
INSERT INTO PROVINCE VALUES (70, 'Campobasso', 'CB', 41.55774754, 14.659160510, 14, 'Molise', 2908.80, 76, 226217, 84, 421, 77);
INSERT INTO PROVINCE VALUES (94, 'Isernia', 'IS', 41.58800826, 14.225754070, 14, 'Molise', 1528.88, 55, 87124, 52, 184, 28);
INSERT INTO PROVINCE VALUES (103, 'Verbano-Cusio-Ossola', 'VB', 45.92144550, 8.551078753, 1, 'Piemonte', 2254.83, 70, 160143, 76, 263, 230);
INSERT INTO PROVINCE VALUES (75, 'Lecce', 'LE', 40.35354285, 18.171897300, 16, 'Puglia', 2759.40, 284, 801190, 97, 1004, 306);
INSERT INTO PROVINCE VALUES (100, 'Prato', 'PO', 43.88062274, 11.097033150, 9, 'Toscana', 365.26, 705, 248292, 7, 219, 22);
INSERT INTO PROVINCE VALUES (22, 'Trento', 'TN', 46.06893511, 11.121230970, 4, 'P.A. Trento', 6206.90, 87, 530308, 177, 466, 1513);
INSERT INTO PROVINCE VALUES (7, 'Aosta', 'AO', 45.73750286, 7.320149366, 2, 'Valle d''Aosta', 3263.24, 39, 127844, 74, 16, 452);
INSERT INTO PROVINCE VALUES (27, 'Venezia', 'VE', 45.43490485, 12.338452130, 5, 'Veneto', 2466.49, 345, 847983, 44, 812, 1196);
INSERT INTO PROVINCE VALUES (41, 'Pesaro e Urbino', 'PU', 43.91014021, 12.913459890, 11, 'Marche', 2563.49, 140, 363388, 54, 485, 288);
INSERT INTO PROVINCE VALUES (39, 'Ravenna', 'RA', 44.41722493, 12.199139360, 8, 'Emilia-Romagna', 1858.49, 209, 386111, 18, 332, 554);
INSERT INTO PROVINCE VALUES (35, 'Reggio nell''Emilia', 'RE', 44.69735289, 10.630079730, 8, 'Emilia-Romagna', 2292.89, 232, 522468, 42, 539, 126);
INSERT INTO PROVINCE VALUES (58, 'Roma', 'RM', 41.89277044, 12.483667220, 12, 'Lazio', 5380.95, 810, 4039813, 121, 3718, 1479);
INSERT INTO PROVINCE VALUES (65, 'Salerno', 'SA', 40.67821961, 14.759402600, 15, 'Campania', 4917.46, 222, 1093453, 158, 1802, 539);
INSERT INTO PROVINCE VALUES (14, 'Sondrio', 'SO', 46.17099261, 9.871474890, 3, 'Lombardia', 3211.90, 57, 181101, 77, 300, 383);
INSERT INTO PROVINCE VALUES (89, 'Siracusa', 'SR', 37.05991687, 15.293331820, 19, 'Sicilia', 2108.80, 188, 399469, 21, 586, 140);
INSERT INTO PROVINCE VALUES (9, 'Savona', 'SV', 44.30750461, 8.481108654, 7, 'Liguria', 1544.77, 179, 280837, 69, 325, 551);
INSERT INTO PROVINCE VALUES (67, 'Teramo', 'TE', 42.65891770, 13.704399710, 13, 'Abruzzo', 1950.61, 158, 306955, 47, 430, 314);
INSERT INTO PROVINCE VALUES (1, 'Torino', 'TO', 45.07327450, 7.680687483, 1, 'Piemonte', 6821.96, 331, 2254720, 315, 2156, 545);
INSERT INTO PROVINCE VALUES (32, 'Trieste', 'TS', 45.64943540, 13.768136490, 6, 'Friuli Venezia Giulia', 211.82, 1103, 231677, 6, 259, 75);
INSERT INTO PROVINCE VALUES (12, 'Varese', 'VA', 45.81701677, 8.822868344, 3, 'Lombardia', 1198.71, 743, 876960, 139, 949, 160);
INSERT INTO PROVINCE VALUES (2, 'Vercelli', 'VC', 45.32398135, 8.423234312, 1, 'Piemonte', 2088.08, 82, 176307, 86, 241, 59);
INSERT INTO PROVINCE VALUES (23, 'Verona', 'VR', 45.43839046, 10.993526850, 5, 'Veneto', 3120.97, 299, 907352, 98, 997, 666);
INSERT INTO PROVINCE VALUES (102, 'Vibo Valentia', 'VV', 38.67624147, 16.101574140, 18, 'Calabria', 1139.47, 139, 162252, 50, 386, 183);
Proiezione tabella Province
select * from PROVINCE;
Si crea la tabella Province_Covid19 normalizzata
create table PROVINCE_COVID_19
(
DATA_REG VARCHAR2(19) not null,
CODICE_PROVINCIA NUMBER not null
constraint MASTER_PROVINCE_FK
references PROVINCE
on delete cascade,
TOTALE_CASI NUMBER not null,
NOTE_IT VARCHAR2(10),
NOTE_EN VARCHAR2(10),
primary key (DATA_REG, CODICE_PROVINCIA)
)
Di seguito il riempimento della tabella Province_Covid_19
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 69, 69, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 66, 25, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 68, 223, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 67, 68, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 77, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 76, 30, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 21, 436, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 79, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 78, 38, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 101, 39, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 80, 57, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 102, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 64, 88, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 62, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 61, 94, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 63, 358, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 65, 92, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 37, 465, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 38, 78, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 40, 227, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 36, 663, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 34, 869, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 33, 1428, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 39, 185, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 35, 608, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 99, 691, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 31, 28, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 93, 97, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 32, 208, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 30, 266, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 60, 48, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 59, 23, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 57, 18, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 58, 678, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 56, 50, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 10, 488, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 8, 117, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 11, 88, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 9, 131, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 16, 4645, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 17, 4247, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 13, 338, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 19, 2286, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 97, 530, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 98, 1528, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 20, 636, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 15, 3278, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 108, 495, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 18, 1011, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 14, 155, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 12, 310, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 42, 447, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 44, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 109, 68, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 43, 186, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 41, 983, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 70, 33, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 6, 374, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 5, 101, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 96, 109, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 4, 149, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 3, 190, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 1, 1042, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 103, 89, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 2, 131, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 72, 137, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 110, 26, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 74, 75, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 71, 134, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 75, 71, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 73, 23, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 92, 41, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 91, 21, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 95, 3, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 90, 134, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 111, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 84, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 85, 12, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 87, 151, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 86, 21, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 83, 16, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 82, 52, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 88, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 89, 33, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 81, 21, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 51, 113, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 48, 349, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 53, 89, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 49, 62, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 46, 230, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 45, 200, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 50, 146, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 47, 145, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 100, 70, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 52, 78, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 22, 523, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 54, 236, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 55, 84, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 7, 215, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 25, 150, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 28, 924, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 29, 52, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 26, 637, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 27, 475, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 23, 686, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-19T17:00:00', 24, 424, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 69, 80, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 66, 29, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 68, 259, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 67, 81, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 77, 9, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 76, 43, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 21, 548, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 79, 34, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 78, 45, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 101, 45, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 80, 73, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 102, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 64, 97, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 62, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 61, 96, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 63, 416, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 65, 115, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 37, 552, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 38, 102, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 40, 250, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 36, 767, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 34, 979, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 33, 1575, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 39, 213, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 35, 773, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 99, 757, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 31, 30, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 93, 114, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 32, 216, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 30, 296, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 60, 52, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 59, 115, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 57, 18, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 58, 755, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 56, 63, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 10, 527, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 8, 145, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 11, 90, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 9, 162, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 16, 5154, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 17, 4648, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 13, 380, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 19, 2392, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 97, 676, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 98, 1597, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 20, 723, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 15, 3804, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 108, 816, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 18, 1105, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 14, 163, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 12, 338, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 42, 513, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 44, 43, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 109, 80, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 43, 215, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 41, 1099, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 70, 39, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 6, 595, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 5, 151, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 96, 175, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 4, 221, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 3, 293, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 1, 1556, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 103, 142, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 2, 203, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 72, 165, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 110, 30, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 74, 84, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 71, 163, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 75, 88, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 73, 33, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 92, 43, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 91, 22, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 95, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 90, 216, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 111, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 84, 31, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 85, 18, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 87, 162, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 86, 25, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 83, 39, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 82, 59, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 88, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 89, 40, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 81, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 51, 124, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 48, 401, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 53, 97, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 49, 117, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 46, 249, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 45, 232, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 50, 180, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 47, 171, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 100, 94, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 52, 128, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 22, 642, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 54, 280, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 55, 97, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 7, 264, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 25, 195, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 28, 1026, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 29, 67, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 26, 719, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 27, 574, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 23, 784, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-20T17:00:00', 24, 518, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 69, 91, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 66, 31, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 68, 302, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 67, 105, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 77, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 76, 58, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 21, 621, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 79, 38, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 78, 50, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 101, 50, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 80, 84, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 102, 11, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 64, 124, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 62, 11, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 61, 106, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 63, 463, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 65, 126, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 37, 610, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 38, 123, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 40, 269, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 36, 906, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 34, 1014, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 33, 1693, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 39, 287, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 35, 977, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 99, 826, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 31, 38, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 93, 144, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 32, 270, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 30, 338, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 60, 59, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 59, 136, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 57, 24, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 58, 893, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 56, 72, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 10, 561, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 8, 155, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 11, 94, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 9, 173, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 16, 5869, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 17, 5028, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 13, 452, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 19, 2733, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 97, 818, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 98, 1693, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 20, 842, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 15, 4672, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 108, 1084, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 18, 1194, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 14, 179, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 12, 359, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 42, 564, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 44, 50, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 109, 82, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 43, 238, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 41, 1186, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 70, 49, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 6, 654, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 5, 166, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 96, 182, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 4, 265, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 3, 330, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 1, 1680, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 103, 149, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 2, 210, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 72, 194, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 110, 32, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 74, 94, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 71, 190, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 75, 103, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 73, 35, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 92, 45, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 91, 22, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 95, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 90, 251, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 111, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 84, 36, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 85, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 87, 189, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 86, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 83, 70, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 82, 63, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 88, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 89, 43, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 81, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 51, 136, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 48, 451, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 53, 106, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 49, 120, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 46, 307, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 45, 256, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 50, 211, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 47, 181, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 100, 111, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 52, 133, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 22, 782, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 54, 329, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 55, 115, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 7, 313, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 25, 212, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 28, 1155, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 29, 68, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 26, 806, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 27, 666, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 23, 954, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-21T17:00:00', 24, 572, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 68, 334, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 67, 113, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 77, 16, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 76, 65, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 21, 678, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 79, 45, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 78, 63, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 101, 61, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 80, 88, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 102, 14, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 64, 132, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 62, 13, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 61, 116, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 63, 504, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 65, 157, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 37, 674, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 38, 150, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 40, 329, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 36, 1010, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 34, 1209, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 33, 1765, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 39, 309, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 35, 1167, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 99, 942, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 31, 44, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 93, 165, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 32, 297, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 30, 361, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 60, 78, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 59, 146, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 57, 24, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 58, 1049, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 56, 82, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 10, 677, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 8, 168, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 11, 99, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 9, 175, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 16, 6216, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 17, 5317, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 13, 512, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 19, 2895, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 97, 872, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 98, 1772, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 20, 905, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 15, 5096, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 108, 1108, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 18, 1306, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 14, 205, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 12, 386, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 42, 676, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 44, 56, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 109, 113, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 43, 293, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 41, 1249, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 70, 53, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 6, 760, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 5, 181, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 96, 243, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 4, 303, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 3, 398, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 1, 1989, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 103, 159, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 2, 242, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 72, 231, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 110, 49, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 74, 100, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 71, 212, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 75, 120, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 73, 41, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 92, 52, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 91, 22, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 95, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 90, 253, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 111, 8, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 84, 41, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 85, 27, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 87, 234, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 86, 34, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 83, 112, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 82, 92, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 88, 9, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 89, 49, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 81, 32, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 51, 154, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 48, 514, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 53, 120, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 49, 130, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 46, 356, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 45, 281, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 50, 234, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 47, 215, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 100, 129, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 52, 144, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 22, 954, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 54, 376, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 55, 128, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 7, 364, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 25, 226, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 28, 1277, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 29, 76, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 26, 935, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 27, 732, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 23, 1046, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-22T17:00:00', 24, 631, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 69, 129, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 66, 40, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 68, 370, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 67, 124, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 77, 18, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 76, 72, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 21, 724, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 79, 46, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 78, 68, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 101, 62, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 80, 94, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 102, 20, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 64, 145, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 62, 13, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 61, 124, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 63, 543, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 65, 179, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 37, 833, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 38, 172, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 40, 380, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 36, 1155, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 34, 1364, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 33, 1885, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 39, 342, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 35, 1369, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 99, 1035, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 31, 55, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 93, 170, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 32, 320, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 30, 385, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 60, 82, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 59, 159, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 57, 31, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 58, 1171, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 56, 93, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 10, 689, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 8, 160, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 11, 110, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 9, 185, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 16, 6471, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 17, 5905, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 13, 581, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 19, 2925, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 97, 934, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 98, 1817, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 20, 985, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 15, 5326, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 108, 1130, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 18, 1444, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 14, 208, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 12, 421, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 42, 702, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 44, 61, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 109, 133, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 43, 326, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 41, 1312, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 70, 54, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 6, 817, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 5, 209, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 96, 253, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 4, 367, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 3, 420, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 1, 2198, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 103, 190, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 2, 263, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 72, 268, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 110, 59, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 74, 102, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 71, 226, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 75, 149, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 73, 46, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 92, 61, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 91, 22, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 95, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 90, 260, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 111, 9, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 84, 45, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 85, 29, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 87, 274, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 86, 44, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 83, 120, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 82, 109, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 88, 9, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 89, 49, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 81, 42, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 51, 201, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 48, 548, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 53, 128, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 49, 140, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 46, 363, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 45, 289, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 50, 266, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 47, 229, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 100, 137, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 52, 160, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 22, 1023, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 54, 424, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 55, 134, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 7, 393, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 25, 254, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 28, 1371, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 29, 80, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 26, 999, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 27, 799, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 23, 1099, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-23T17:00:00', 24, 691, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 69, 133, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 66, 47, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 68, 369, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 67, 140, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 77, 25, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 76, 67, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 21, 781, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 79, 49, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 78, 84, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 101, 66, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 80, 97, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 102, 21, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 64, 155, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 62, 14, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 61, 152, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 63, 588, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 65, 182, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 37, 968, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 38, 190, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 40, 437, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 36, 1354, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 34, 1435, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 33, 1981, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 39, 368, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 35, 1437, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 99, 1084, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 31, 57, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 93, 201, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 32, 329, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 30, 405, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 60, 97, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 59, 182, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 57, 33, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 58, 1287, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 56, 121, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 10, 696, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 8, 186, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 11, 104, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 9, 204, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 16, 6728, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 17, 6298, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 13, 635, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 19, 3061, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 97, 1015, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 98, 1860, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 20, 1093, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 15, 5701, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 108, 1454, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 18, 1499, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 14, 253, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 12, 450, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 42, 751, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 44, 64, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 109, 139, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 43, 368, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 41, 1371, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 70, 60, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 6, 946, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 5, 235, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 96, 280, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 4, 409, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 3, 471, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 1, 2496, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 103, 229, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 2, 290, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 72, 304, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 110, 62, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 74, 103, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 71, 255, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 75, 161, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 73, 51, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 92, 64, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 91, 26, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 95, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 90, 309, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 111, 15, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 84, 47, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 85, 40, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 87, 286, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 86, 63, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 83, 139, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 82, 170, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 88, 9, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 89, 49, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 81, 43, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 51, 211, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 48, 622, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 53, 140, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 49, 162, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 46, 387, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 45, 314, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 50, 285, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 47, 243, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 100, 159, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 52, 176, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 22, 1110, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 54, 472, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 55, 155, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 7, 400, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 25, 273, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 28, 1464, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 29, 82, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 26, 1091, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 27, 837, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 23, 1228, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-24T17:00:00', 24, 744, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 69, 146, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 66, 60, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 68, 412, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 67, 195, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 77, 36, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 76, 70, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 21, 858, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 79, 51, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 78, 99, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 101, 71, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 80, 105, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 102, 23, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 64, 172, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 62, 14, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 61, 165, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 63, 626, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 65, 220, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 37, 1107, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 38, 204, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 40, 454, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 36, 1533, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 34, 1525, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 33, 2122, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 39, 387, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 35, 1586, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 99, 1136, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 31, 65, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 93, 277, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 32, 355, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 30, 431, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 60, 106, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 59, 198, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 57, 39, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 58, 1428, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 56, 122, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 10, 782, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 8, 177, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 11, 137, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 9, 210, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 16, 7072, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 17, 6597, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 13, 706, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 19, 3156, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 97, 1076, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 98, 1884, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 20, 1176, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 15, 6074, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 108, 1587, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 18, 1578, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 14, 284, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 12, 468, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 42, 820, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 44, 80, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 109, 160, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 43, 395, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 41, 1432, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 70, 60, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 94, 4, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 6, 946, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 5, 261, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 96, 327, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 4, 441, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 3, 517, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 1, 2813, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 103, 247, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 2, 308, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 72, 336, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 110, 65, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 74, 116, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 71, 277, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 75, 164, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 73, 56, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 92, 74, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 91, 26, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 95, 7, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 90, 318, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 111, 17, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 84, 50, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 85, 45, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 87, 308, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 86, 90, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 83, 174, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 82, 193, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 88, 22, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 89, 64, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 81, 48, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 51, 229, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 48, 709, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 53, 147, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 49, 179, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 46, 436, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 45, 330, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 50, 317, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 47, 254, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 100, 178, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 52, 193, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 22, 1222, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 54, 523, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 55, 163, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 7, 401, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 25, 298, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 28, 1636, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 29, 87, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 26, 1177, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 27, 874, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 23, 1304, null, null);
INSERT INTO PROVINCE_COVID_19 VALUES ('2020-03-25T17:00:00', 24, 824, null, null);
Proiezione tabella Province_Covid19
select * from PROVINCE_COVID_19;
È possibile visualizzare e provare le seguenti definizioni in SQL, oltre al riempimento completo della base di dati e gli eventuali alter table cliccando qui
Va premesso che questi dati con ogni probabilità sottostimano il numero di contagi (e, ormai è chiaro, anche di decessi), perché alcune persone pur avendo i sintomi di Covid-19 non vengono sottoposte a tampone, e dunque «sfuggono» al conteggio. Ma i dati del database sono importanti in ogni caso: perché indicano una tendenza e, soprattutto, perché ci danno con estrema precisione lo stato di saturazione degli ospedali. Questa è una guida che tenta di spiegare come leggere i dati del nostro database, e soprattutto come estrarre correttamente da lì le risposte ad alcune domande chiave. Ad esempio, quante persone, ufficialmente, si sono contagiate, nelle 24 ore, in un determinato giorno in Italia? Ed il numero di contagiati è salito o no, e di quanto? Altrettanto importante è capire a quali domande può rispondere il nostro database, nonostante le apparenze: ad esempio, quante persone sono state ricoverate in terapia intensiva, in Italia, da un giorno all’ altro? O quante sono guarite? Compilato su base regionale prendiamo, ad esempio, il documento relativo al 25 marzo
Analisi del contagio compilato su base regionale del 25 Marzo
SELECT *
FROM REGIONI_COVID19
WHERE DATA ='2020-03-25T17:00:00'
ORDER BY DENOMINAZIONE_REGIONE ASC ;
Sempre sulla base regionale è possibile visualizzare il numero dei deceduti il 25 marzo 2020
SELECT sum(DECEDUTI) AS TOTALE_DECEDUTI
FROM REGIONI_COVID19
WHERE DATA ='2020-03-25T17:00:00'
ORDER BY DENOMINAZIONE_REGIONE ASC ;
e il numero degli Attualmente Positivi (Totale_Casi)
SELECT sum(TOTALE_POSITIVI) AS TOTALE_ATTUALMENTE_POSITIVI
FROM REGIONI_COVID19
WHERE DATA ='2020-03-25T17:00:00'
ORDER BY DENOMINAZIONE_REGIONE ASC ;
I due dati più rilevanti e purtroppo più preoccupanti del andamento dell’epidemia. La voce «Totale_Casi», indica dunque quante persone, dall’inizio dell’epidemia, hanno di sicuro contratto il virus. Delle persone che hanno contratto il virus, 7.503 sono morte, mentre 9.362 sono state dimesse «o» guarite (Attenzione a questo «o»: è importante). Di qui si giunge a un dato delicato: quello sul «totale attualmente positivi»: 57.521. È il numero delle persone che il 25 Marzo, in Italia, sono positive al Coronavirus, e non sono ancora guarite. Quel dato viene poi «spacchettato» in tre parti: quanti di quei contagiati si trovano a casa, in isolamento domiciliare; quanti sono in ospedale in terapia intensiva; quanti sono in ospedale, con sintomi ma non in terapia intensiva. In particolare, il dato sulle terapie intensive è cruciale: perché i posti in terapia intensiva non sono infiniti, e perché se si arrivasse a «saturare» il sistema sanitario si correrebbero rischi enormi, per tutti.
Andamento completo del COVID dal 19 Marzo al 25 Marzo
SELECT DATA, sum(TOTALE_OSPEDALIZZATI) AS TOT_OSP, sum(TOTALE_POSITIVI) AS Tot_pos, sum(TOTALE_CASI) AS Tot_cas, sum(DECEDUTI) AS Tot_deceduti, sum(DIMESSI_GUARITI) AS Tot_dim
FROM REGIONI_COVID19
GROUP BY DATA
ORDER BY DATA ASC ;
Altre possibili query per il reporting
Contagi per Provincia in un determinato arco temporale (escluse quelle con dicitura 'In fase di definizione/aggiornamento')
SELECT DENOMINAZIONE_PROVINCIA, sum (TOTALE_CASI) AS Totale_Casi
FROM PROVINCE_COVID_19 P JOIN PROVINCE P2 ON P.CODICE_PROVINCIA = P2.CODICE_PROVINCIA
WHERE data_REG <= '2020-03-25T17:00:00' AND data_REG >= '2020-03-19T17:00:00' AND DENOMINAZIONE_PROVINCIA <> 'In fase di definizione/aggiornamento'
GROUP BY DENOMINAZIONE_PROVINCIA
ORDER BY TOTALE_CASI DESC ;
Tamponi giornalieri e contagiati
SELECT DENOMINAZIONE_REGIONE, TAMPONI, TOTALE_POSITIVI
FROM REGIONI_COVID19
WHERE DATA ='2020-03-25T17:00:00' ORDER BY TOTALE_POSITIVI DESC ;
Le 5 Regioni con più decessi fino al 25 Marzo
SELECT * FROM ( SELECT DENOMINAZIONE_REGIONE, DECEDUTI
FROM REGIONI_COVID19
WHERE DATA ='2020-03-25T17:00:00' ORDER BY DECEDUTI DESC )
WHERE ROWNUM <= 5 ;
Le 10 Province con più casi fino al 25 Marzo
SELECT * FROM ( SELECT DENOMINAZIONE_PROVINCIA, R.DENOMINAZIONE_REGIONE, TOTALE_CASI
FROM (PROVINCE_COVID_19 P JOIN PROVINCE P2 ON P.CODICE_PROVINCIA = P2.CODICE_PROVINCIA) JOIN REGIONI R ON P2.CODICE_REGIONE = R.CODICE_REGIONE
WHERE DATA_REG ='2020-03-25T17:00:00' ORDER BY TOTALE_CASI DESC )
WHERE ROWNUM <= 10 ;
Andamento terapia intensiva, ricoverati con sintomi per regioni fino al 25 Marzo
SELECT DENOMINAZIONE_REGIONE, TERAPIA_INTENSIVA, RICOVERATI_CON_SINTOMI
FROM REGIONI_COVID19
WHERE DATA ='2020-03-25T17:00:00'
ORDER BY TERAPIA_INTENSIVA DESC ;
Totale casi in Italia, Spagna, Germania, Francia fino al 25 Marzo
SELECT DENOMINAZIONI_STATO, sum(CASI) AS TOTALE_CASI
FROM STATI_COVID19
GROUP BY DENOMINAZIONI_STATO
ORDER BY TOTALE_CASI DESC ;
È possibile visualizzare e provare le seguenti query in SQL cliccando qui
Un punto molto importante, ora, riguarda la risposta alla domanda: quante persone sono state contagiate, il 25 marzo, in Italia? O, meglio: quante persone sono state trovate positive al coronavirus, il 25 marzo, in Italia?
Ipotizziamo che, il 25 marzo, il numero di persone attualmente positive sia esattamente identico a quello del 24 marzo, 57.521, così come quello dei deceduti (7.503) ma sia cresciuto il numero di dimessi (di 100 unità: da 9.362 a 9.462). La situazione sarebbe la seguente:
Giorno 1: Totale attualmente positivi 57.521; dimessi/guariti 9.362; deceduti 7.503, per un totale di casi di 74.386.
Giorno 2: Totale attualmente positivi 57.521; dimessi/guariti 9.462; deceduti 7.503, per un totale di casi di 74.486.
Quante persone si sono ammalate, tra il 24 marzo e il 25 marzo? La risposta è 100: 100 persone sono uscite dall’ospedale o da casa, e sono guarite, e altrettante sono entrate in ospedale o sono state messe in isolamento domiciliare. Ecco perché il numero di persone attualmente positive è identico a ieri, e quello di guariti è aumentato.
Per trovare quel dato non possiamo fare la differenza tra i «totali attualmente positivi» (darebbe zero, nel caso posto sopra: 57.521-57.521: ma potrebbe anche finire in negativo, ma dobbiamo farla tra i «casi totali» (nel caso sopra: 74.486-74.386=100 persone contagiate).
La Protezione civile fornisce però, in diretta, la differenza tra i «totale attualmente positivi». Perché? Perché è un dato importante. Non risponde alla domanda «Quante persone si sono ammalate ieri?», ma alla domanda: il numero di persone positive, in Italia, è aumentato o no? Questo dato dà dunque una indicazione importante sullo stato di salute del nostro sistema sanitario.
Dunque, quante persone sono state trovate positive al coronavirus, il 25 Marzo, in Italia?
R: Casi totali di oggi - casi totali di ieri
create or replace procedure diff_tot_att_pos IS
--definisco che il cursore che conterrà i casi totali nella data X
cursor totpos is
SELECT DATA, sum(TOTALE_CASI) AS Totale_Casi
FROM REGIONI_COVID19
GROUP BY DATA
HAVING DATA <= '2020-03-25T17:00:00' AND DATA >= '2020-03-24T17:00:00' ;
--definisco tutte le variabili che serviranno per i calcoli
rec_casi totpos%ROWTYPE; --questa variabile è dello stesso tipo del cursore
giorno1 number;
giorno2 number;
diff number;
BEGIN
OPEN totpos; --apro il cursore
FETCH totpos into rec_casi; --inserisco la tupla seguente nella variabile che poi userò per i calcoli dopo
giorno1 := rec_casi.Totale_Casi;
FETCH totpos into rec_casi;
giorno2 := rec_casi.Totale_Casi;
diff := giorno1 - giorno2;
DBMS_OUTPUT.PUT_LINE('Numero di persone colpite dal COVID_19 = ' || diff);
CLOSE totpos; --chiudo il cursore
end;
Eseguiamo la la procedura
call diff_tot_att_pos();
Importantissimo - lo ripetiamo - è il conteggio sulle terapie intensive: più quel dato si alza, di giorno in giorno, e peggio è. Ad esempio, quante persone sono entrate in terapia intensiva il giorno 25 marzo?
create or replace procedure diff_tot_ter_intensiva IS
--definisco il cursore che conterrà il numero dei ricoveri in terapia intensiva nella data X
cursor totint is
SELECT DATA, sum(TERAPIA_INTENSIVA) AS Totale_intensiva
FROM REGIONI_COVID19
GROUP BY DATA
HAVING DATA <= '2020-03-25T17:00:00' AND DATA >= '2020-03-24T17:00:00' ;
--dichiaro le variabili che mi serviranno per i calcoli
rec_casi totint%ROWTYPE; --questa variabile è dello stesso tipo del cursore
giorno1 number;
giorno2 number;
diff number;
BEGIN
OPEN totint; --apro il cursore
FETCH totint into rec_casi; --inserisco la tupla seguente nella variabile che poi userò per i calcoli dopo
giorno1 := rec_casi.Totale_intensiva;
FETCH totint into rec_casi;
giorno2 := rec_casi.Totale_intensiva;
diff := giorno1 - giorno2;
DBMS_OUTPUT.PUT_LINE('Variazione di persone che sono entrate in terapia intensiva a causa del COVID_19 = ' || diff);
CLOSE totint; --chiudo il cursore
end;
Eseguiamo la procedura
call diff_tot_ter_intensiva();
Altro Importantissimo dato è il conteggio sui dimessi guariti, in questo caso, più quel dato si alza, di giorno in giorno, meglio è.
create or replace procedure diff_tot_guariti IS
--definisco il cursore che conterrà i guariti nella data X
cursor totgua is
SELECT DATA, sum(DIMESSI_GUARITI) AS Totale_dimessi
FROM REGIONI_COVID19
GROUP BY DATA
HAVING DATA <= '2020-03-25T17:00:00' AND DATA >= '2020-03-24T17:00:00' ;
--dichiaro le variabili che mi serviranno per i calcoli
rec_casi totgua%ROWTYPE; --questa variabile è dello stesso tipo del cursore
giorno1 number;
giorno2 number;
diff number;
BEGIN
OPEN totgua; --apro il cursore
FETCH totgua into rec_casi; --inserisco la tupla seguente nella variabile che poi userò per i calcoli dopo
giorno1 := rec_casi.Totale_dimessi;
FETCH totgua into rec_casi;
giorno2 := rec_casi.Totale_dimessi;
diff := giorno1 - giorno2;
DBMS_OUTPUT.PUT_LINE('Numero di persone GUARITE dal COVID_19 = ' || diff);
CLOSE totgua; --chiudo il cursore
end;
Eseguiamo la procedura
call diff_tot_guariti();
Dalla base di dati è possibile fare un’analisi più dettagliata del fenomeno effettuando calcoli determinanti che descrivono il comportamento dell’epidemia.
Calcolo percentuale positivi/tamponi in Italia
create or replace procedure diff_tasso_pos_tam IS
--definisco il cursore che conterrà tutti i positivi e tutti i tamponi effettuati alla data X
cursor totpostam is
SELECT DATA, sum(TOTALE_POSITIVI) AS TOTALE_POSITIVI_ITA, sum(TAMPONI) AS TOTALE_TAMPONI
FROM REGIONI_COVID19
GROUP BY DATA
HAVING DATA <= '2020-03-25T17:00:00' AND DATA >= '2020-03-12T17:00:00'
ORDER BY DATA DESC;
--dichiaro le variabili che mi serviranno per i calcoli
rec_casi totpostam%ROWTYPE; --questa variabile è dello stesso tipo del cursore
tot_pos number;
tot_tamp number;
diff number;
BEGIN
OPEN totpostam; --apro il cursore
DBMS_OUTPUT.PUT_LINE('Data : '|| ' | Tasso positivi/popolazione in ITALIA : ');
LOOP
FETCH totpostam into rec_casi; --inserisco la tupla seguente nella variabile che userò per i calcoli dopo
EXIT when totpostam%NOTFOUND; --se non trova una tupla non stampa nulla ed esce dal ciclo
tot_pos := rec_casi.TOTALE_POSITIVI_ITA;
tot_tamp := rec_casi.TOTALE_TAMPONI;
diff := (tot_pos / tot_tamp) * 100;
DBMS_OUTPUT.PUT_LINE(rec_casi.DATA || ' | ' || diff || '%');
END LOOP;
CLOSE totpostam; --chiudo il cursore
end;
Eseguiamo la procedura
call diff_tasso_pos_tam();
Calcolo percentuale positivi/popolazione in Italia
create or replace procedure diff_tasso_pos_pop IS
--definisco il cursore che conterrà la popolazione italiana e tutti i casi di COVID alla data X
cursor totpospop is
SELECT DATA, SUM(NUM_RESIDENTI) AS POPOLOITA, SUM(TOTALE_CASI) AS TOT_POS
FROM REGIONI_COVID19 R JOIN REGIONI R2 on R.DENOMINAZIONE_REGIONE = R2.DENOMINAZIONE_REGIONE
GROUP BY DATA
HAVING DATA <='2020-03-25T17:00:00' AND DATA >= '2020-02-25T18:00:00'
ORDER BY DATA DESC ;
--dichiaro le variabili che mi serviranno per i calcoli
rec_casi totpospop%ROWTYPE; --questa variabile è dello stesso tipo del cursore
tot_pos number;
pop_ita number;
diff number;
BEGIN
OPEN totpospop; --apro il cursore
DBMS_OUTPUT.PUT_LINE('Data : '|| ' | Tasso positivi/popolazione in ITALIA : ');
LOOP
FETCH totpospop into rec_casi; --Inserisco la tupla seguente nella variabile che userò per i calcoli dopo
EXIT when totpospop%NOTFOUND; --se non trova una tupla non stampa nulla ed esce dal ciclo
tot_pos := rec_casi.TOT_POS;
pop_ita := rec_casi.POPOLOITA;
diff := (tot_pos / pop_ita) * 100;
DBMS_OUTPUT.PUT_LINE(rec_casi.DATA || ' | ' || diff || '%');
END LOOP;
CLOSE totpospop; --chiudo il cursore
end;
Eseguiamo la procedura
call diff_tasso_pos_pop();
È possibile visualizzare e provare le procedure PL/SQL della trattazione completa cliccando qui
Per ottimizzare i tempi di accesso alla base di dati e i tempi di esecuzione delle query, procediamo alla realizzazione di viste (View) utili per la analisi dei casi nell'arco di 3 giorni.
Casi regioni dal 23 Marzo al 25 Marzo
CREATE VIEW info_tregiorni_REGIONI AS
SELECT * FROM REGIONI_COVID19
WHERE DATA >='2020-03-23T17:00:00' AND DATA <='2020-03-25T17:00:00' ORDER BY DENOMINAZIONE_REGIONE ASC;
Casi Province dal 23 Marzo al 25 Marzo
CREATE VIEW info_tregiorni_PROVINCE AS
SELECT DATA_REG,DENOMINAZIONE_PROVINCIA,TOTALE_CASI
FROM PROVINCE_COVID_19 P JOIN PROVINCE P2 on P.CODICE_PROVINCIA = P2.CODICE_PROVINCIA
WHERE DATA_REG >='2020-03-23T17:00:00' AND DATA_REG <='2020-03-25T17:00:00' ORDER BY DENOMINAZIONE_PROVINCIA ASC;
Casi Stati dal 23 Marzo al 25 Marzo
CREATE VIEW info_tregiorni_STATI AS
SELECT DATA_STATO,DENOMINAZIONI_STATO,CASI,DECEDUTI
FROM STATI_COVID19
WHERE DATA_STATO like '%03_2020' and DATA_STATO >='23/03/2020' and DATA_STATO <='25/03/2020' ORDER BY DENOMINAZIONI_STATO ASC;
Procedura che estrae dalla vista INFO_TREGIORNI_PROVINCE le informazioni relative alla provincia desiderata
create or replace procedure info_province is
--definisco il cursore che conterrà le informazioni settimanali relative alla provincia che viene fornita in input
cursor info_covid_cursor (provincia in info_tregiorni_PROVINCE.DENOMINAZIONE_PROVINCIA%TYPE)
is SELECT *
FROM info_tregiorni_PROVINCE
WHERE DENOMINAZIONE_PROVINCIA= provincia
ORDER BY DATA_REG ASC;
--dichiaro la variabile che mi servirà per fornire l'output
info_covid info_covid_cursor%ROWTYPE; --questa variabile è dello stesso tipo del cursore
begin
open info_covid_cursor('Napoli'); --apro il cursore e fornisco la provincia di cui voglio le informazioni
fetch info_covid_cursor into info_covid; --inserisco la tupla seguente nella variabile
DBMS_OUTPUT.PUT_LINE('Ecco le informazioni relative alla provincia di ' || info_covid.DENOMINAZIONE_PROVINCIA || ' nella settimana tra il 25 ed il 31 Marzo');
DBMS_OUTPUT.PUT_LINE('Data | Totale casi ');
loop
exit when info_covid_cursor%notfound; --se non trova una tupla non stampa nulla ed esce dal ciclo
DBMS_OUTPUT.PUT_LINE(RPAD(info_covid.DATA_REG,22) || info_covid.TOTALE_CASI);
fetch info_covid_cursor into info_covid; --inserisco la tupla seguente nella variabile
end loop;
close info_covid_cursor; --chiudo il cursore
end;
Eseguiamo la procedura
call info_province();
Procedura che estrae dalla vista INFO_TREGIORNI_REGIONI le informazioni relative alla regione desiderata
create or replace procedure info_regioni is
--definisco il cursore che conterrà le informazioni settimanali relative alla regione che viene fornita in input
cursor info_covid_cursor (regione in info_tregiorni_REGIONI.DENOMINAZIONE_REGIONE%TYPE)
is SELECT *
FROM info_tregiorni_REGIONI
WHERE DENOMINAZIONE_REGIONE= regione
ORDER BY DATA ASC;
--dichiaro la variabile che mi servirà per fornire l'output
info_covid info_covid_cursor%ROWTYPE; --questa variabile è dello stesso tipo del cursore
begin
open info_covid_cursor('Liguria'); --apro il cursore e fornisco la regione di cui voglio le informazioni
fetch info_covid_cursor into info_covid; --inserisco la tupla seguente nella variabile
DBMS_OUTPUT.PUT_LINE('Ecco le informazioni relative alla regione ' || info_covid.DENOMINAZIONE_REGIONE || ' nella settimana tra il 25 ed il 31 Marzo');
DBMS_OUTPUT.PUT_LINE('Data | Deceduti | Totale casi | Terapia intensiva ' ||
'| Dimessi guariti | Nuovi positivi | Tamponi');
loop
exit when info_covid_cursor%notfound; --se non trova una tupla non stampa nulla ed esce dal ciclo
DBMS_OUTPUT.PUT_LINE(RPAD(info_covid.DATA,22) || RPAD(info_covid.DECEDUTI,11) ||
RPAD(info_covid.TOTALE_CASI,14) || RPAD(info_covid.TERAPIA_INTENSIVA,20) ||
RPAD(info_covid.DIMESSI_GUARITI,18) || RPAD(info_covid.NUOVI_POSITIVI,17) ||
info_covid.TAMPONI);
fetch info_covid_cursor into info_covid; --inserisco la tupla seguente nella variabile
end loop;
close info_covid_cursor; --chiudo il cursore
end;
Eseguiamo la procedura
call info_regioni();
Procedura che estrae dalla vista INFO_TREGIORNI_STATI le informazioni relative allo stato desiderato
create or replace procedure info_stati is
--definisco il cursore che conterrà le informazioni settimanali relative allo stato che viene fornito in input
cursor info_covid_cursor (stato in info_tregiorni_STATI.DENOMINAZIONI_STATO%TYPE)
is SELECT *
FROM info_tregiorni_STATI
WHERE DENOMINAZIONI_STATO= stato
order by DATA_STATO;
--dichiaro la variabile che mi servirà per fornire l'output
info_covid info_covid_cursor%ROWTYPE; --questa variabile è dello stesso tipo del cursore
begin
open info_covid_cursor('Germany'); --apro il cursore e fornisco lo stato di cui voglio le informazioni
fetch info_covid_cursor into info_covid; --inserisco la tupla seguente nella variabile
DBMS_OUTPUT.PUT_LINE('Ecco le informazioni relative allo stato ' || info_covid.DENOMINAZIONI_STATO);
DBMS_OUTPUT.PUT_LINE('Data | Totale casi | Deceduti');
loop
exit when info_covid_cursor%notfound; --se non trova una tupla non stampa nulla ed esce dal ciclo
DBMS_OUTPUT.PUT_LINE(RPAD(info_covid.DATA_STATO,13) || RPAD(info_covid.CASI,14) || info_covid.DECEDUTI);
fetch info_covid_cursor into info_covid; --inserisco la tupla seguente nella variabile
end loop;
close info_covid_cursor; --chiudo il cursore
end;
Eseguiamo la procedura
call info_stati();
È possibile visualizzare e provare le viste e le procedure sulle viste complete in PL/SQL cliccando qui
Si fa uso dei Trigger per una appropriata consistenza dei dati ed una regolare gestione della base di dati con regole non esprimibili attraverso i costrutti dichiarativi del linguaggio SQL
Impedire che venga modificata la tabella REGIONI_COVID19
create or replace trigger GEST_MODIFICA_REGIONI
before update
on REGIONI_COVID19
for each row
begin
raise_application_error(-20450,' Non si possono modificare i dati sulle rilevazioni');
end;
Impedire che venga modificata la tabella PROVINCE_COVID_19
create or replace trigger GEST_MODIFICA_PROVINCE
before update
on PROVINCE_COVID_19
for each row
begin
raise_application_error(-20452,' Non si possono modificare i dati sulle rilevazioni');
end;
Impedire che venga modificata la tabella STATI_COVID19
create or replace trigger GEST_MODIFICA_STATI
before update
on STATI_COVID19
for each row
begin
raise_application_error(-20451,' Non si possono modificare i dati sulle rilevazioni');
end;
D'altra parte, l'uso del trigger before insert possiamo automatizzare il calcolo delle variazioni percentuali rispetto al giorno precedente
create or replace trigger var_perc_giornaliere
before insert on REGIONI_COVID19
for each row
declare
regcovid REGIONI_COVID19%ROWTYPE; --questa variabile ha gli stessi campi della tabella REGIONI_COVID19
var_perc_casi NUMBER;
var_perc_terinten NUMBER;
var_perc_positivi NUMBER;
var_perc_deceduti NUMBER;
var_perc_tamponi NUMBER;
begin
--prendo i valori registrati nella Regione il giorno precedente
SELECT * into regcovid FROM ( SELECT *
FROM REGIONI_COVID19
WHERE DENOMINAZIONE_REGIONE = :NEW.DENOMINAZIONE_REGIONE
ORDER BY DATA desc)
WHERE ROWNUM = 1;
var_perc_casi := (:NEW.TOTALE_CASI - regcovid.TOTALE_CASI)/100;
var_perc_terinten := (:NEW.TERAPIA_INTENSIVA - regcovid.TERAPIA_INTENSIVA)/100;
var_perc_positivi := (:NEW.VARIAZIONE_TOTALE_POSITIVI)/100;
var_perc_deceduti := (:NEW.DECEDUTI - regcovid.DECEDUTI)/100;
var_perc_tamponi := (:NEW.TAMPONI - regcovid.TAMPONI)/100;
DBMS_OUTPUT.PUT_LINE('In ' || :NEW.DENOMINAZIONE_REGIONE);
DBMS_OUTPUT.PUT_LINE('La variazione percentuale dei casi rispetto ad ieri e'' stata del: ' || var_perc_casi || '%');
DBMS_OUTPUT.PUT_LINE('La variazione percentuale dei ricoveri in terapia intensiva rispetto ad ieri e'' stata del: ' || var_perc_terinten || '%');
DBMS_OUTPUT.PUT_LINE('La variazione percentuale dei positivi rispetto ad ieri e'' stata del: ' || var_perc_positivi || '%');
DBMS_OUTPUT.PUT_LINE('La variazione percentuale dei deceduti rispetto ad ieri e'' stata del: ' || var_perc_deceduti || '%');
DBMS_OUTPUT.PUT_LINE('La variazione percentuale dei tamponi effettuati rispetto ad ieri e'' stata del: ' || var_perc_tamponi || '%');
end;
Dopo aver eseguito tutto il codice del simulatore si rimanda il lettore alla seguente trattazione completa della base di dati cliccando qui