id|location_name|utc_datetime_iso_8601|mag_pref_type|mag_pref_value|lat|lon|depth 18562301|6 Km E L'aquila (AQ)|2018-03-31T01:18:44Z|Mw|3.8|42.353|13.47|18.8 Municipality_lon,Municipality_lat,EMS_intensity,Number_of_reports,Municipality_name 13.623,42.006,4.5,1,San Benedetto dei Marsi 13.649,42.546,4.5,1,Tossicia 13.960,42.217,4.0,4,Bolognano 13.233,42.193,4.0,2,Borgorose 13.686,42.726,4.0,2,Campli 13.301,42.520,4.0,2,Capitignano 13.671,42.252,4.0,1,Caporciano 13.488,42.293,4.0,1,Fossa 13.662,42.503,4.0,3,Isola del Gran Sasso d'Italia 13.398,42.351,4.0,86,L'Aquila 13.338,42.291,4.0,3,Lucoli 13.473,42.284,4.0,1,Ocre 13.148,42.206,4.0,3,Pescorocchiano 13.295,42.436,4.0,3,Pizzoli 13.542,42.321,4.0,2,Poggio Picenze 13.489,42.237,4.0,2,Rocca di Cambio 13.959,42.177,4.0,1,Salle 13.559,42.288,4.0,2,San Demetrio ne' Vestini 13.203,42.103,4.0,1,Sante Marie 13.256,42.371,4.0,1,Scoppito 14.010,42.224,3.5,1,Abbateggio 13.969,42.294,3.5,1,Alanno 12.990,42.009,3.5,1,Anticoli Corrado 13.827,42.210,3.5,2,Bussi sul Tirino 13.390,41.966,3.5,2,Capistrello 13.894,42.236,3.5,1,Castiglione a Casauria 13.548,42.085,3.5,10,Celano 13.679,42.540,3.5,1,Colledara 13.126,42.265,3.5,2,Fiamignano 12.692,42.245,3.5,2,Montopoli di Sabina 13.894,42.659,3.5,2,Notaresco 12.692,42.295,3.5,2,Poggio Catino 13.519,42.208,3.5,8,Rocca di Mezzo 13.817,42.675,3.3,2,Castellalto 13.920,42.664,3.3,2,Morro d'Oro 13.872,42.097,3.2,3,Pratola Peligna 13.665,42.772,3.1,4,Civitella del Tronto 13.577,42.853,3.0,14,Ascoli Piceno 13.427,42.031,3.0,25,Avezzano 13.281,42.451,3.0,1,Barete 13.861,42.316,3.0,1,Brittoli 13.083,42.096,3.0,2,Carsoli 13.933,42.308,3.0,1,Cugnoli 13.633,42.821,3.0,1,Folignano 13.575,41.678,3.0,4,Isola del Liri 13.453,43.300,3.0,1,Macerata 13.392,42.109,3.0,1,Massa d'Albe 13.631,42.583,3.0,4,Montorio al Vomano 13.730,42.236,3.0,1,Navelli 13.518,42.133,3.0,3,Ovindoli 13.927,42.458,3.0,2,Penne 13.660,42.026,3.0,1,Pescina 14.046,42.396,3.0,1,Pianella 13.911,42.276,3.0,1,Pietranico 13.833,42.171,3.0,6,Popoli 13.808,42.103,3.0,2,Raiano 14.024,42.214,3.0,2,Roccamorice 13.987,42.233,3.0,2,San Valentino in Abruzzo Citeriore 13.716,42.825,3.0,2,Sant'Egidio alla Vibrata 13.803,42.787,3.0,1,Sant'Omero 13.342,42.064,3.0,4,Scurcola Marsicana 13.100,41.925,3.0,8,Subiaco 13.924,42.048,3.0,21,Sulmona 13.704,42.659,3.0,25,Teramo 13.928,42.245,3.0,4,Torre de' Passeri 13.975,42.580,2.2,5,Atri 12.862,42.405,1.3,22,Rieti 13.614,41.720,1.3,8,Sora 12.738,42.734,1.3,9,Spoleto 14.168,42.351,1.2,11,Chieti 13.351,41.640,1.2,14,Frosinone 12.726,42.000,1.2,11,Guidonia Montecelio 12.616,42.051,1.2,13,Monterotondo 14.214,42.465,1.2,22,Pescara 12.647,42.561,1.2,21,Terni 13.815,42.945,1.0,1,Acquaviva Picena 13.032,41.982,1.0,1,Agosta 13.342,41.726,1.0,4,Alatri 13.921,42.835,1.0,2,Alba Adriatica 13.743,41.688,1.0,1,Alvito 13.288,42.629,1.0,1,Amatrice 13.155,41.744,1.0,1,Anagni 13.666,42.899,1.0,1,Appignano del Tronto 13.611,41.648,1.0,4,Arpino 13.563,41.804,1.0,1,Balsorano 13.591,42.327,1.0,1,Barisciano 13.805,42.745,1.0,1,Bellante 13.634,41.704,1.0,3,Broccostella 14.181,42.304,1.0,1,Bucchianico 12.567,42.401,1.0,1,Calvi dell'Umbria 12.777,42.820,1.0,1,Campello sul Clitunno 13.679,41.738,1.0,1,Campoli Appennino 12.904,42.468,1.0,1,Cantalice 12.539,42.141,1.0,2,Capena 14.132,42.286,1.0,1,Casalincontrada 13.013,42.718,1.0,2,Cascia 14.290,42.115,1.0,2,Casoli 12.869,41.976,1.0,2,Castel Madama 13.713,42.869,1.0,1,Castel di Lama 13.550,41.679,1.0,2,Castelliri 12.743,42.232,1.0,1,Castelnuovo di Farfa 12.932,41.818,1.0,3,Cave 13.860,42.586,1.0,1,Cellino Attanasio 14.073,42.365,1.0,3,Cepagatti 13.601,42.064,1.0,1,Cerchio 14.059,42.518,1.0,2,Citta' Sant'Angelo 13.427,41.916,1.0,2,Civitella Roveto 13.006,41.730,1.0,2,Colleferro 13.868,42.872,1.0,1,Colonnella 13.821,42.856,1.0,1,Controguerra 13.844,42.124,1.0,1,Corfinio 13.835,42.828,1.0,2,Corropoli 11.985,43.275,1.0,1,Cortona 12.729,42.210,1.0,3,Fara in Sabina 12.592,42.172,1.0,1,Fiano Romano 13.351,43.436,1.0,1,Filottrano 13.221,41.804,1.0,2,Fiuggi 11.170,45.917,1.0,1,Folgaria 12.619,41.996,1.0,3,Fonte Nuova 14.292,42.418,1.0,8,Francavilla al Mare 12.805,42.230,1.0,1,Frasso Sabino 13.289,41.728,1.0,2,Fumone 12.823,41.870,1.0,1,Gallicano nel Lazio 12.994,41.934,1.0,1,Gerano 14.274,42.056,1.0,1,Gessopalena 13.957,42.753,1.0,2,Giulianova 12.668,41.788,1.0,1,Grottaferrata 13.868,42.988,1.0,2,Grottammare 14.220,42.191,1.0,1,Guardiagrele 13.168,41.887,1.0,1,Jenne 14.390,42.231,1.0,6,Lanciano 10.309,43.552,1.0,1,Livorno 13.469,41.962,1.0,1,Luco dei Marsi 13.365,42.092,1.0,1,Magliano de' Marsi 12.807,42.023,1.0,1,Marcellina 13.916,42.886,1.0,2,Martinsicuro 16.598,40.668,1.0,1,Matera 12.637,42.034,1.0,4,Mentana 13.556,43.068,1.0,1,Monsampietro Morico 13.607,42.987,1.0,1,Montalto delle Marche 13.516,41.639,1.0,1,Monte San Giovanni Campano 13.751,43.052,1.0,1,Montefiore dell'Aso 12.767,42.597,1.0,1,Montefranco 12.859,42.233,1.0,1,Monteleone Sabino 12.739,42.135,1.0,1,Montelibretti 13.836,42.920,1.0,1,Monteprandone 14.149,42.514,1.0,7,Montesilvano 13.458,41.865,1.0,1,Morino 13.888,42.750,1.0,3,Mosciano Sant'Angelo 14.055,42.429,1.0,1,Moscufo 14.251,40.840,1.0,1,Napoli 12.515,42.519,1.0,4,Narni 13.818,42.820,1.0,1,Nereto 12.787,42.162,1.0,1,Nerola 13.984,42.334,1.0,1,Nocciano 13.692,42.935,1.0,1,Offida 13.032,41.861,1.0,2,Olevano Romano 14.403,42.356,1.0,1,Ortona 14.138,41.983,1.0,1,Palena 12.889,41.839,1.0,3,Palestrina 12.765,42.067,1.0,1,Palombara Sabina 13.424,43.057,1.0,1,Penna San Giovanni 12.355,42.493,1.0,1,Penna in Teverina 14.195,42.152,1.0,1,Pennapiedimonte 12.388,43.107,1.0,1,Perugia 13.789,41.809,1.0,1,Pescasseroli 14.066,41.890,1.0,1,Pescocostanzo 13.656,43.067,1.0,1,Petritoli 13.960,41.973,1.0,1,Pettorano sul Gizio 13.991,42.475,1.0,1,Picciano 13.146,41.830,1.0,1,Piglio 14.067,42.608,1.0,3,Pineto 12.684,42.265,1.0,5,Poggio Mirteto 12.572,42.258,1.0,1,Ponzano Romano 14.354,40.824,1.0,1,Portici 13.697,41.693,1.0,2,Posta Fibreno 13.606,42.278,1.0,1,Prata d'Ansidonia 13.549,43.404,1.0,1,Recanati 14.234,42.357,1.0,1,Ripa Teatina 12.855,42.516,1.0,1,Rivodutri 12.484,41.893,1.0,4,Roma 14.047,42.322,1.0,1,Rosciano 14.012,42.680,1.0,2,Roseto degli Abruzzi 15.591,40.403,1.0,1,Sala Consilina 13.883,42.944,1.0,4,San Benedetto del Tronto 13.814,41.708,1.0,1,San Donato Val di Comino 14.187,42.422,1.0,2,San Giovanni Teatino 14.446,42.303,1.0,1,San Vito Chietino 12.983,41.883,1.0,1,San Vito Romano 12.520,42.234,1.0,1,Sant'Oreste 13.301,43.035,1.0,2,Sarnano 13.881,41.902,1.0,1,Scanno 12.831,42.713,1.0,1,Scheggino 13.023,41.691,1.0,1,Segni 14.114,42.557,1.0,2,Silvi 14.379,40.628,1.0,1,Sorrento 13.773,42.889,1.0,3,Spinetoli 14.141,42.456,1.0,3,Spoltore 12.663,42.498,1.0,2,Stroncone 13.255,42.069,1.0,1,Tagliacozzo 12.798,41.963,1.0,5,Tivoli 13.914,42.218,1.0,2,Tocco da Casauria 12.752,42.213,1.0,1,Toffia 7.681,45.073,1.0,1,Torino 14.206,42.380,1.0,1,Torrevecchia Teatina 13.655,42.657,1.0,1,Torricella Sicura 12.870,42.261,1.0,1,Torricella in Sabina 13.913,42.804,1.0,1,Tortoreto 13.539,41.958,1.0,1,Trasacco 14.425,42.267,1.0,1,Treglio 13.418,41.691,1.0,4,Veroli 13.895,42.340,1.0,2,Vicoli 13.625,41.867,1.0,2,Villavallelonga 13.928,41.777,1.0,1,Villetta Barrea 13.816,42.125,1.0,1,Vittorito