id|location_name|utc_datetime_iso_8601|mag_pref_type|mag_pref_value|lat|lon|depth 17769831|3 km E Amatrice (RI)|2017-12-03T23:34:11Z|Mw|4.0|42.624|13.325|8.0 Municipality_lon,Municipality_lat,EMS_intensity,Number_of_reports,Municipality_name 13.288,42.629,5.3,3,Amatrice 13.233,42.193,4.0,1,Borgorose 13.226,43.138,4.0,1,Caldarola 13.713,42.869,4.0,4,Castel di Lama 13.146,43.488,4.0,1,Castelbellino 13.665,42.772,4.0,1,Civitella del Tronto 13.662,42.503,4.0,2,Isola del Gran Sasso d'Italia 13.888,42.750,4.0,7,Mosciano Sant'Angelo 13.772,42.594,4.0,1,Penna Sant'Andrea 13.295,42.436,4.0,1,Pizzoli 13.256,42.371,4.0,3,Scoppito 13.493,42.881,4.0,2,Venarotta 13.660,42.026,3.8,2,Pescina 14.181,42.304,3.5,1,Bucchianico 12.237,41.772,3.5,1,Fiumicino 13.055,42.451,3.5,1,Micigliano 13.631,42.583,3.5,3,Montorio al Vomano 13.580,43.315,3.5,2,Morrovalle 12.661,41.457,3.5,1,Nettuno 13.894,42.659,3.5,2,Notaresco 12.386,42.460,3.5,2,Orte 13.096,42.523,3.5,1,Posta 13.620,43.366,3.5,1,Potenza Picena 13.928,42.245,3.5,3,Torre de' Passeri 12.617,42.237,3.5,2,Torrita Tiberina 12.412,42.559,3.3,2,Amelia 13.739,42.596,3.3,2,Basciano 12.592,42.172,3.3,3,Fiano Romano 12.407,42.782,3.3,4,Todi 14.060,42.261,3.2,3,Manoppello 12.108,42.718,3.2,3,Orvieto 13.969,42.294,3.0,1,Alanno 14.333,42.102,3.0,1,Altino 13.155,41.744,3.0,2,Anagni 12.629,41.448,3.0,1,Anzio 13.577,42.853,3.0,34,Ascoli Piceno 12.549,43.067,3.0,4,Bastia Umbra 13.960,42.217,3.0,1,Bolognano 13.686,42.726,3.0,3,Campli 12.904,42.468,3.0,1,Cantalice 13.013,42.718,3.0,2,Cascia 14.290,42.115,3.0,2,Casoli 12.670,42.338,3.0,1,Casperia 12.869,41.976,3.0,2,Castel Madama 13.030,42.395,3.0,1,Castel Sant'Angelo 13.817,42.675,3.0,2,Castellalto 13.894,42.236,3.0,1,Castiglione a Casauria 13.548,42.085,3.0,1,Celano 14.168,42.351,3.0,15,Chieti 13.160,42.618,3.0,1,Cittareale 12.412,42.289,3.0,3,Civita Castellana 13.748,42.878,3.0,1,Colli del Tronto 13.835,42.828,3.0,4,Corropoli 13.474,43.108,3.0,1,Falerone 11.818,43.252,3.0,1,Foiano della Chiana 13.633,42.821,3.0,1,Folignano 12.595,42.298,3.0,1,Forano 12.805,42.230,3.0,1,Frasso Sabino 8.933,44.411,3.0,1,Genova 13.957,42.753,3.0,4,Giulianova 12.668,41.788,3.0,4,Grottaferrata 13.398,42.351,3.0,48,L'Aquila 13.987,42.432,3.0,1,Loreto Aprutino 13.416,43.166,3.0,2,Loro Piceno 10.502,43.844,3.0,1,Lucca 11.747,43.275,3.0,1,Lucignano 13.453,43.300,3.0,19,Macerata 13.687,42.832,3.0,1,Maltignano 12.807,42.023,3.0,3,Marcellina 13.481,43.186,3.0,1,Mogliano 13.791,42.897,3.0,3,Monsampolo del Tronto 13.469,43.136,3.0,1,Montappone 13.538,43.130,3.0,1,Montegiorgio 13.633,43.233,3.0,2,Montegranaro 13.327,42.899,3.0,1,Montemonaco 13.836,42.920,3.0,1,Monteprandone 12.616,42.051,3.0,17,Monterotondo 12.504,42.143,3.0,3,Morlupo 13.730,42.236,3.0,1,Navelli 13.473,42.284,3.0,1,Ocre 13.692,42.935,3.0,3,Offida 12.889,41.839,3.0,4,Palestrina 12.765,42.067,3.0,2,Palombara Sabina 13.927,42.458,3.0,3,Penne 14.046,42.396,3.0,1,Pianella 12.684,42.265,3.0,5,Poggio Mirteto 12.862,42.405,3.0,28,Rieti 14.012,42.680,3.0,4,Roseto degli Abruzzi 13.561,42.955,3.0,2,Rotella 13.883,42.944,3.0,12,San Benedetto del Tronto 13.317,43.108,3.0,1,San Ginesio 13.716,42.825,3.0,3,Sant'Egidio alla Vibrata 13.803,42.787,3.0,3,Sant'Omero 13.773,42.889,3.0,5,Spinetoli 12.738,42.734,3.0,10,Spoleto 13.704,42.659,3.0,43,Teramo 12.647,42.561,3.0,29,Terni 11.586,43.551,3.0,1,Terranuova Bracciolini 12.798,41.963,3.0,9,Tivoli 13.914,42.218,3.0,3,Tocco da Casauria 13.300,42.291,3.0,1,Tornimparte 13.913,42.804,3.0,4,Tortoreto 13.377,43.197,3.0,1,Urbisaglia 12.892,42.014,3.0,1,Vicovaro 13.975,42.580,2.3,5,Atri 13.549,43.404,2.2,5,Recanati 12.602,41.803,1.4,7,Ciampino 12.905,43.336,1.4,8,Fabriano 13.728,43.307,1.3,8,Civitanova Marche 12.704,42.956,1.3,16,Foligno 14.292,42.418,1.3,7,Francavilla al Mare 14.149,42.514,1.3,7,Montesilvano 12.484,41.893,1.3,393,Roma 13.284,43.209,1.3,6,Tolentino 12.105,42.417,1.3,13,Viterbo 13.718,43.161,1.2,9,Fermo 13.924,42.048,1.2,10,Sulmona 13.519,43.617,1.1,35,Ancona 13.482,43.486,1.1,17,Osimo 12.388,43.107,1.1,28,Perugia 14.214,42.465,1.1,28,Pescara 12.546,42.691,1.0,2,Acquasparta 13.815,42.945,1.0,2,Acquaviva Picena 13.032,41.982,1.0,1,Agosta 13.386,43.543,1.0,2,Agugliano 13.342,41.726,1.0,8,Alatri 13.794,43.107,1.0,1,Altidona 13.743,41.688,1.0,1,Alvito 12.270,42.093,1.0,2,Anguillara Sabazia 13.080,42.418,1.0,1,Antrodoco 13.346,43.364,1.0,2,Appignano 13.666,42.899,1.0,1,Appignano del Tronto 13.574,41.588,1.0,1,Arce 12.940,43.500,1.0,3,Arcevia 14.260,42.291,1.0,1,Ari 13.611,41.648,1.0,5,Arpino 12.615,43.071,1.0,4,Assisi 14.443,42.067,1.0,1,Atessa 13.427,42.031,1.0,10,Avezzano 12.428,42.655,1.0,1,Avigliano Umbro 12.099,42.626,1.0,2,Bagnoregio 13.591,42.327,1.0,2,Barisciano 13.805,42.745,1.0,1,Bellante 12.485,43.013,1.0,1,Bettona 12.609,42.934,1.0,1,Bevagna 11.988,42.645,1.0,1,Bolsena 12.176,42.103,1.0,2,Bracciano 13.861,42.316,1.0,1,Brittoli 13.634,41.704,1.0,2,Broccostella 13.827,42.210,1.0,2,Bussi sul Tirino 12.567,42.401,1.0,1,Calvi dell'Umbria 13.553,43.531,1.0,2,Camerano 12.383,42.141,1.0,2,Campagnano di Roma 12.777,42.820,1.0,2,Campello sul Clitunno 13.815,43.079,1.0,1,Campofilone 13.679,41.738,1.0,1,Campoli Appennino 12.234,42.381,1.0,2,Canepina 12.539,42.141,1.0,1,Capena 13.713,41.631,1.0,1,Casalvieri 12.650,41.747,1.0,1,Castel Gandolfo 12.895,41.846,1.0,1,Castel San Pietro Romano 12.368,42.249,1.0,1,Castel Sant'Elia 13.547,43.465,1.0,3,Castelfidardo 13.550,41.679,1.0,3,Castelliri 13.081,43.495,1.0,1,Castelplanio 13.058,43.210,1.0,1,Castelraimondo 12.932,41.818,1.0,3,Cave 14.073,42.365,1.0,4,Cepagatti 12.985,43.321,1.0,1,Cerreto d'Esi 12.099,41.998,1.0,3,Cerveteri 13.326,43.600,1.0,1,Chiaravalle 13.216,43.374,1.0,4,Cingoli 14.059,42.518,1.0,1,Citta' Sant'Angelo 12.005,42.953,1.0,1,Citta' della Pieve 13.427,41.916,1.0,2,Civitella Roveto 13.006,41.730,1.0,1,Colleferro 9.085,45.810,1.0,1,Como 13.821,42.856,1.0,1,Controguerra 12.286,43.129,1.0,6,Corciano 13.844,42.124,1.0,1,Corfinio 12.913,41.642,1.0,1,Cori 13.048,43.649,1.0,2,Corinaldo 13.509,43.248,1.0,3,Corridonia 13.116,43.446,1.0,2,Cupramontana 12.420,42.982,1.0,1,Deruta 12.946,43.251,1.0,1,Esanatoglia 12.295,42.335,1.0,1,Fabrica di Roma 13.394,43.623,1.0,6,Falconara Marittima 12.443,42.226,1.0,1,Faleria 12.729,42.210,1.0,6,Fara in Sabina 13.253,41.692,1.0,5,Ferentino 13.126,42.265,1.0,1,Fiamignano 13.351,43.436,1.0,2,Filottrano 11.256,43.769,1.0,1,Firenze 13.221,41.804,1.0,2,Fiuggi 13.550,41.611,1.0,2,Fontana Liri 12.619,41.996,1.0,1,Fonte Nuova 12.401,42.080,1.0,2,Formello 13.606,41.256,1.0,1,Formia 13.488,42.293,1.0,1,Fossa 12.762,43.294,1.0,1,Fossato di Vico 12.681,41.806,1.0,4,Frascati 13.351,41.640,1.0,14,Frosinone 13.289,41.728,1.0,1,Fumone 12.994,41.934,1.0,1,Gerano 14.274,42.056,1.0,1,Gessopalena 13.868,42.988,1.0,3,Grottammare 13.338,43.067,1.0,1,Gualdo 12.785,43.231,1.0,3,Gualdo Tadino 14.220,42.191,1.0,2,Guardiagrele 12.579,43.354,1.0,5,Gubbio 12.726,42.000,1.0,10,Guidonia Montecelio 13.899,42.008,1.0,1,Introdacqua 14.226,41.588,1.0,1,Isernia 13.575,41.678,1.0,3,Isola del Liri 13.244,43.523,1.0,12,Jesi 12.070,41.955,1.0,1,Ladispoli 14.390,42.231,1.0,5,Lanciano 12.833,41.728,1.0,3,Lariano 14.036,42.237,1.0,1,Lettomanoppello 13.608,43.440,1.0,2,Loreto 13.469,41.962,1.0,1,Luco dei Marsi 12.205,43.143,1.0,1,Magione 12.436,42.160,1.0,1,Magliano Romano 12.481,42.361,1.0,1,Magliano Sabina 11.933,46.698,1.0,1,Marebbe 12.659,41.770,1.0,6,Marino 12.340,42.910,1.0,1,Marsciano 13.916,42.886,1.0,3,Martinsicuro 13.392,42.109,1.0,1,Massa d'Albe 12.637,42.034,1.0,5,Mentana 12.737,41.808,1.0,2,Monte Compatri 12.717,41.816,1.0,3,Monte Porzio Catone 13.516,41.639,1.0,3,Monte San Giovanni Campano 13.271,43.601,1.0,5,Monte San Vito 13.671,43.206,1.0,1,Monte Urano 13.484,43.121,1.0,1,Monte Vidon Corrado 12.598,42.366,1.0,1,Montebuono 13.436,43.364,1.0,1,Montecassiano 12.488,42.650,1.0,1,Montecastrilli 12.288,42.662,1.0,1,Montecchio 13.635,43.317,1.0,3,Montecosaro 13.751,43.052,1.0,1,Montefiore dell'Aso 13.040,41.650,1.0,1,Montelanico 12.739,42.135,1.0,1,Montelibretti 13.567,43.344,1.0,2,Montelupone 13.310,43.640,1.0,1,Montemarciano 12.310,42.196,1.0,2,Monterosi 13.716,43.085,1.0,1,Monterubbiano 12.327,43.364,1.0,1,Montone 12.692,42.245,1.0,2,Montopoli di Sabina 13.732,43.086,1.0,1,Moresco 13.458,41.865,1.0,1,Morino 13.214,43.601,1.0,1,Morro d'Alba 13.920,42.664,1.0,1,Morro d'Oro 14.251,40.840,1.0,2,Napoli 12.515,42.519,1.0,3,Narni 12.714,41.720,1.0,1,Nemi 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.032,41.861,1.0,1,Olevano Romano 13.830,41.779,1.0,1,Opi 14.403,42.356,1.0,1,Ortona 13.158,43.613,1.0,1,Ostra 13.057,43.604,1.0,1,Ostra Vetere 12.478,42.423,1.0,1,Otricoli 14.499,42.163,1.0,1,Paglieta 14.138,41.983,1.0,2,Palena 13.841,43.098,1.0,1,Pedaso 13.424,43.057,1.0,1,Penna San Giovanni 12.355,42.493,1.0,1,Penna in Teverina 12.836,43.563,1.0,3,Pergola 12.913,43.910,1.0,1,Pesaro 13.789,41.809,1.0,1,Pescasseroli 14.066,41.890,1.0,1,Pescocostanzo 13.466,43.221,1.0,1,Petriolo 13.960,41.973,1.0,1,Pettorano sul Gizio 13.991,42.475,1.0,1,Picciano 13.554,42.523,1.0,1,Pietracamela 13.146,41.830,1.0,1,Piglio 14.067,42.608,1.0,4,Pineto 12.692,42.295,1.0,1,Poggio Catino 12.795,42.216,1.0,1,Poggio Nativo 13.542,42.321,1.0,2,Poggio Picenze 13.348,43.268,1.0,3,Pollenza 13.394,43.525,1.0,3,Polverigi 12.502,41.670,1.0,1,Pomezia 13.833,42.171,1.0,3,Popoli 12.102,42.687,1.0,1,Porano 13.665,43.430,1.0,3,Porto Recanati 13.758,43.258,1.0,2,Porto Sant'Elpidio 13.697,41.693,1.0,2,Posta Fibreno 15.805,40.639,1.0,1,Potenza 13.606,42.278,1.0,2,Prata d'Ansidonia 13.872,42.097,1.0,1,Pratola Peligna 13.808,42.103,1.0,1,Raiano 13.593,43.161,1.0,1,Rapagnano 12.523,42.091,1.0,2,Riano 12.481,42.210,1.0,2,Rignano Flaminio 14.234,42.357,1.0,1,Ripa Teatina 12.708,41.762,1.0,5,Rocca di Papa 14.024,42.214,1.0,2,Roccamorice 12.692,42.321,1.0,1,Roccantica 12.216,42.292,1.0,1,Ronciglione 14.047,42.322,1.0,1,Rosciano 12.448,42.106,1.0,1,Sacrofano 12.801,41.821,1.0,1,San Cesareo 13.814,41.708,1.0,1,San Donato Val di Comino 12.546,42.613,1.0,2,San Gemini 14.187,42.422,1.0,1,San Giovanni Teatino 12.873,41.918,1.0,1,San Gregorio da Sassola 13.206,43.577,1.0,1,San Marcello 13.174,43.455,1.0,1,San Paolo di Jesi 12.840,42.012,1.0,1,San Polo dei Cavalieri 13.177,43.229,1.0,3,San Severino Marche 13.524,41.834,1.0,1,San Vincenzo Valle Roveto 14.446,42.303,1.0,1,San Vito Chietino 13.687,43.229,1.0,1,Sant'Elpidio a Mare 12.520,42.234,1.0,1,Sant'Oreste 13.301,43.035,1.0,2,Sarnano 12.859,43.436,1.0,3,Sassoferrato 13.881,41.902,1.0,1,Scanno 12.831,42.713,1.0,1,Scheggino 13.218,43.715,1.0,1,Senigallia 13.015,43.448,1.0,2,Serra San Quirico 13.038,43.543,1.0,2,Serra de' Conti 12.952,43.072,1.0,1,Serravalle di Chienti 12.741,43.331,1.0,1,Sigillo 13.616,43.526,1.0,3,Sirolo 13.614,41.720,1.0,9,Sora 12.235,42.419,1.0,1,Soriano nel Cimino 12.671,42.993,1.0,1,Spello 14.141,42.456,1.0,3,Spoltore 13.186,43.433,1.0,1,Staffolo 12.663,42.498,1.0,1,Stroncone 13.100,41.925,1.0,6,Subiaco 12.752,42.213,1.0,1,Toffia 12.434,43.026,1.0,1,Torgiano 13.608,43.184,1.0,1,Torre San Patrizio 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 14.425,42.267,1.0,1,Treglio 13.312,43.311,1.0,7,Treia 12.748,42.877,1.0,1,Trevi 12.245,42.156,1.0,1,Trevignano Romano 13.768,45.649,1.0,1,Trieste 12.327,43.306,1.0,1,Umbertide 12.601,43.159,1.0,2,Valfabbrica 8.823,45.817,1.0,1,Varese 12.346,42.418,1.0,1,Vasanello 13.418,41.691,1.0,4,Veroli 13.895,42.340,1.0,2,Vicoli 13.625,41.867,1.0,1,Villavallelonga 13.928,41.777,1.0,1,Villetta Barrea 9.287,45.514,1.0,1,Vimodrone 12.174,42.470,1.0,1,Vitorchiano 12.830,41.840,1.0,1,Zagarolo