UnicaSpa is the back-office and reporting database for an Italian energy retailer that sells electricity and gas to end customers. The data goes back to 2018-2026 and covers how the business actually runs day to day: finding customers through a field sales team, signing them up to supply contracts, tracking their meter consumption, billing them, paying commission to the sales agents...
thanks to: DaOnlySpark
What's in the database:
Customers, their contacts, and credit ratings (clienti, contatti_clienti, clienti_punti, rating_clienti). The supply contracts that connect a customer to their service, including full status history (contratti_siti_punti, gestione_contratti, venditori_contratti, contratti_stati, an_contratti_stati). Electricity and gas supply points tied to meter codes (punti_fornitura_ee, punti_fornitura_ee_sii, punti_fornitura_gas, punti_fornitura_r). Consumption readings and forecasts (consumi_fatture_r, previsione_consumo_ee, previsione_consumo_gas, traffico_aggregato_verdi).
The whole billing side is here too. Invoices sent to customers (fatture, fatture_contratti), invoices received from suppliers (fatture_passive, fatture_passive_dettaglio), balance checks (check_ft), and payment plans for people paying in installments (accordi_dilazione, accordi_dilazione_fatture). There's proper accounting in movimenti_contabili.
On the sales side you've got the agents, area managers and commission rules (dati_base_provvigioni, amministratori) plus a log of every call, appointment and outcome (refresh_pivot_stats). The debt collection side has recovery calls (chiamate_recupero_crediti), formal legal notices (formal_notice, about 36,500 rows) and a call-center IVR log (ivr_log_bi). There's also a big customer communications archive of around 1.18 million rows (comunicazioni), and a few pre-built summary tables the BI system uses (acquisto_vendita_totale and the refresh_ stats tables).
Sample:
Code:
id,id_cliente,address,email1,email2,email3,email4,landline1,landline2,landline3,landline4,mobile1,mobile2,mobile3,mobile4,pec1,pec2,pec3,pec4,sdib2b,sdipa,sdipec,city,zipcode,district,addressName,countryCode,municipality,addressNumber,municipalityId [align=center][align=left]3869,4452,"Via Delle Madonnelle, 11 - 80055 - Portici (NA)",,,,,0815109004,,,,3356964440,,,,,,,,,,,Portici,80055,NA,Via Delle Madonnelle,IT,Portici,11,4372 31521,8125,"Via Cesare Beccaria, 128 Bis - 30175 - Venezia (VE)",,,,,041921635,,,,3687253555,,,,,,,,,,,Venezia,30175,VE,Via Cesare Beccaria,IT,Venezia,128 Bis,7604 289,1569,"Localita' Falco, Snc - 89843 - Maierato (VV)",,,,,0963253059,,,,3202724240,,,,,,,,,,,Maierato,89843,VV,Localita' Falco,IT,Maierato,Snc,7904 288,1566,"Via Di Castel Di Leva, 371 - 00134 - Roma (RM)",massimiliano.ciofi@live.it,,,,0671354203,,,,3932198345,,,,,,,,,,,Roma,00134,RM,Via Di Castel Di Leva,IT,Roma,371,5852 6199,7120,"Piazza Giovanni Bernardino Tafuri, 16 - 80145 - Napoli (NA)",lagioiosa.servizi@libero.it,,,,,,,,3317888559,,,,cooplagioiosa@pec.it,,,,,,,Napoli,80145,NA,Piazza Giovanni Bernardino Tafuri,IT,Napoli,16,4362 284,1552,"Piazzetta Mondragone, 4 - 80132 - Napoli (NA)",siratsrl@agkgroup.it,,,,,,,,336855903,,,,sirat@pec.it,,,,,,,Napoli,80132,NA,Piazzetta Mondragone,IT,Napoli,4,4362 7,168,"Piazza Barbaria, 1 - 80100 - Napoli (NA)",f.comite@gmail.com,,,,081660261,,,,,,,,,,,,,,,Napoli,80100,NA,Piazza Barbaria,IT,Napoli,1,4362 1777,2467,"Corso Risorgimento, 2 - 86170 - Isernia (IS)",mairacol72@gmail.com,,,,0865235079,,,,3451652513,,,,,,,,,,,Isernia,86170,IS,Corso Risorgimento,IT,Isernia,2,3411 3005,3117,"Via Enrico De Gennaro, 4 - 80058 - Torre Annunziata (NA)",saitorrecentrale@alice.it,,,,,,,,3382742389,,,,,,,,,,,Torre Annunziata,80058,NA,Via Enrico De Gennaro,IT,Torre Annunziata,4,4396 280,1538,"Via Aldo Moro, 5 - 53017 - Radda In Chianti (SI)",monica.rosini@libero.it,,,,,,,,3478893288,,,,,,,,,,,Radda In Chianti,53017,SI,Via Aldo Moro,IT,Radda In Chianti,5,6123 1988661,10960,"Via Enrico De Nicola, 31 - 70019 - Triggiano (BA)",framagiuga@gmail.com,,,,,,,,3289083799,,,,,,,,,,,Triggiano,70019,BA,Via Enrico De Nicola,IT,Triggiano,31,850 34125,8831,"Via San Benedetto, 23 - 84013 - Cava De' Tirreni (SA)",santorielloassunta6@gmail.com,,,,,,,,3497174626,,,,,,,,,,,Cava De' Tirreni,84013,SA,Via San Benedetto,IT,Cava De' Tirreni,23,5980 4227,5364,"Via Dell' Amicizia, 12 - 80077 - Ischia (NA)",alessandro.pipolo@libero.it,,,,,,,,3807070673,,,,,,,,,,,Ischia,80077,NA,Via Dell' Amicizia,IT,Ischia,12,4349 2299,2536,"Via Benedetto Croce, 3 - 80020 - Casavatore (NA)",fulviodepiro@hotmail.it,,,,0815734116,,,,3347662718,,,,depirofulvio@legalmail.it,,,,,,,Casavatore,80020,NA,Via Benedetto Croce,IT,Casavatore,3,4332 1781,2475,"Via Squillace, 1 - 80022 - Arzano (NA)",ingmetaldesign@gmail.com,,,,0815736830,,,,3318724534,,,,,,,,m5uxcr1,,,Arzano,80022,NA,Via Squillace,IT,Arzano,1,4316 34,297,"Parco Mergellina, 3 - 80100 - Napoli (NA)",viragh@libero.it,fra.viragh@gmail.com,,,,,,,3298386679,,,,,,,,,,,Napoli,80100,NA,Parco Mergellina,IT,Napoli,3,4362 2178937,11018,"Via Roma, 14 - 24050 - Mozzanica (BG)",elisa958@gmail.com,,,,,,,,3498094055,,,,,,,,,,,Mozzanica,24050,BG,Via Roma,IT,Mozzanica,14,991 3609882,14145,"VIA Gramsci, 5 - 84025 - Eboli (SA)",mariocerullo@alice.it,mariocerullo@tim.it,,,,,,,3342680642,,,,,,,,,,,Salerno,84025,SA,VIA Gramsci,IT,Eboli,5,5993 19,210,"Via Medina, 40 - 80100 - Napoli (NA)",amministrazione@advert.it,segreteria@advert.it,,,,,,,3358398990,,,,,,,,,,,Napoli,80100,NA,Via Medina,IT,Napoli,40,4362 28,245,"Viale A.Gramsci, 15 - 80100 - Napoli (NA)",daniele.volpe@gmail.com,,,,0818195384,,,,,,,,comunicazioni@pec.maya.it,,,,,,,Napoli,80100,NA,Viale A.Gramsci,IT,Napoli,15,4362 2030,3318,"Via Guglielmo Marconi, 26 - 80030 - Mariglianella (NA)",csmasa@tim.it,,,,,,,,3335856000,,,,,,,,,,,Mariglianella,80030,NA,Via Guglielmo Marconi,IT,Mariglianella,26,4354 2178935,11021,"Via Caldarola, 41/B - 70126 - Bari (BA)",leonardo.guasco@libero.it,,,,,,,,3928799000,,,,,,,,,,,Bari,70126,BA,Via Caldarola,IT,Bari,41/B,810 2958804,13519,"VIA BRESCIA, 19 - 25032 - Chiari (BS)",clelia.mandrella@gmail.com,,,,,,,,3883636388,,,,,,,,,,,Brescia,25032,BS,VIA BRESCIA,IT,Chiari,19,1432 31608,8296,"Via Giuseppe Vitale, 68 - 84013 - Cava De' Tirreni (SA)",,,,,,,,,3896076590,,,,,,,,,,,Cava De' Tirreni,84013,SA,Via Giuseppe Vitale,IT,Cava De' Tirreni,68,5980 30937,8110,"Via Faleriense, 41 - 62026 - San Ginesio (MC)",,,,,,,,,3476769441,,,,,,,,,,,San Ginesio,62026,MC,Via Faleriense,IT,San Ginesio,41,3841 34179,8945,"Via Dante Alighieri, 12 B - 80040 - Pollena Trocchia (NA)",enrico.novizio@libero.it,enriconovizio@hotmail.com,,,,,,,3498289843,,,,,,,,,,,Pollena Trocchia,80040,NA,Via Dante Alighieri,IT,Pollena Trocchia,12 B,4369 34025,8860,"Via Italo Marchi, 11 - 38066 - Riva Del Garda (TN)",,,,,,,,,3493925616,,,,,,,,,,,Riva Del Garda,38066,TN,Via Italo Marchi,IT,Riva Del Garda,11,6608 14,189,"Via Nuova Poggioreale, 45a - 80100 - Napoli (NA)",amministrazione@nsone.it,,,,08119172002,,,,3939390976,,,,numberspec@pec.it,,,,subm70n,,,Napoli,80100,NA,Via Nuova Poggioreale,IT,Napoli,45a,4362 2189036,11035,"Via Roma, 33 - 80013 - Casalnuovo Di Napoli (NA)",s.dimaso@adc.campania.it,,,,,,,,3397651813,,,,,,,,m5uxcr1,,,Casalnuovo Di Napoli,80013,NA,Via Roma,IT,Casalnuovo Di Napoli,33,4328
