expected_mexico_db = {'01': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2007, 2010],
        'state_code': '01',
        'state_name': 'Aguascalientes'},
 '02': {'attacks': [1, 0, 1, 1, 0, 0],
        'local_election_years': [2007, 2010],
        'state_code': '02',
        'state_name': 'Baja California'},
 '03': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2008, 2011],
        'state_code': '03',
        'state_name': 'Baja California Sur'},
 '04': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2009, 2012],
        'state_code': '04',
        'state_name': 'Campeche'},
 '05': {'attacks': [0, 1, 0, 0, 1, 0],
        'local_election_years': [2009, 2011],
        'state_code': '05',
        'state_name': 'Coahuila'},
 '06': {'attacks': [0, 0, 0, 1, 0, 0],
        'local_election_years': [2009, 2012],
        'state_code': '06',
        'state_name': 'Colima'},
 '07': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2007, 2010, 2012],
        'state_code': '07',
        'state_name': 'Chiapas'},
 '08': {'attacks': [0, 5, 7, 12, 7, 2],
        'local_election_years': [2007, 2010],
        'state_code': '08',
        'state_name': 'Chihuahua'},
 '10': {'attacks': [2, 2, 6, 7, 3, 1],
        'local_election_years': [2007, 2010],
        'state_code': '10',
        'state_name': 'Durango'},
 '11': {'attacks': [0, 0, 2, 0, 0, 0],
        'local_election_years': [2009, 2012],
        'state_code': '11',
        'state_name': 'Guanajuato'},
 '12': {'attacks': [4, 11, 11, 9, 3, 10],
        'local_election_years': [2008, 2011, 2012],
        'state_code': '12',
        'state_name': 'Guerrero'},
 '13': {'attacks': [1, 0, 0, 0, 0, 0],
        'local_election_years': [2008, 2010, 2011],
        'state_code': '13',
        'state_name': 'Hidalgo'},
 '14': {'attacks': [0, 2, 0, 0, 1, 5],
        'local_election_years': [2009, 2012],
        'state_code': '14',
        'state_name': 'Jalisco'},
 '15': {'attacks': [2, 1, 2, 0, 2, 1],
        'local_election_years': [2009, 2011, 2012],
        'state_code': '15',
        'state_name': 'Mexico'},
 '16': {'attacks': [0, 10, 10, 5, 39, 5],
        'local_election_years': [2007, 2011],
        'state_code': '16',
        'state_name': 'Michoacan'},
 '17': {'attacks': [0, 0, 0, 1, 3, 1],
        'local_election_years': [2009, 2012],
        'state_code': '17',
        'state_name': 'Morelos'},
 '18': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2008, 2011],
        'state_code': '18',
        'state_name': 'Nayarit'},
 '19': {'attacks': [3, 0, 0, 4, 6, 8],
        'local_election_years': [2009, 2012],
        'state_code': '19',
        'state_name': 'Nuevo Leon'},
 '20': {'attacks': [0, 1, 0, 1, 1, 0],
        'local_election_years': [2007, 2010],
        'state_code': '20',
        'state_name': 'Oaxaca'},
 '21': {'attacks': [0, 0, 0, 0, 2, 0],
        'local_election_years': [2007, 2010],
        'state_code': '21',
        'state_name': 'Puebla'},
 '22': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2009, 2012],
        'state_code': '22',
        'state_name': 'Queretaro'},
 '23': {'attacks': [0, 0, 0, 0, 1, 0],
        'local_election_years': [2008, 2010],
        'state_code': '23',
        'state_name': 'Quintana Roo'},
 '24': {'attacks': [0, 0, 0, 1, 3, 5],
        'local_election_years': [2009, 2012],
        'state_code': '24',
        'state_name': 'San Luis Potosi'},
 '25': {'attacks': [2, 2, 1, 3, 3, 0],
        'local_election_years': [2007, 2010],
        'state_code': '25',
        'state_name': 'Sinaloa'},
 '26': {'attacks': [1, 0, 1, 2, 1, 1],
        'local_election_years': [2009, 2012],
        'state_code': '26',
        'state_name': 'Sonora'},
 '27': {'attacks': [0, 2, 1, 0, 2, 0],
        'local_election_years': [2009, 2012],
        'state_code': '27',
        'state_name': 'Tabasco'},
 '28': {'attacks': [11, 1, 0, 14, 3, 2],
        'local_election_years': [2007, 2010],
        'state_code': '28',
        'state_name': 'Tamaulipas'},
 '29': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2007, 2010],
        'state_code': '29',
        'state_name': 'Tlaxcala'},
 '30': {'attacks': [1, 2, 0, 3, 6, 4],
        'local_election_years': [2007, 2010],
        'state_code': '30',
        'state_name': 'Veracruz'},
 '31': {'attacks': [0, 0, 0, 0, 0, 0],
        'local_election_years': [2007, 2010, 2012],
        'state_code': '31',
        'state_name': 'Yucatan'},
 '32': {'attacks': [0, 1, 1, 1, 2, 0],
        'local_election_years': [2007, 2010],
        'state_code': '32',
        'state_name': 'Zacatecas'}}