In [1]:

    

import json


    

In [4]:

    

#raw data from Andy
actor_code ={
"IGO" : "International inter-governmental organization",
 "IMG" : "International Militarized Group",
 "INT" : "International or transnational actors who cannot be further specified",
 "MNC" : "Multi-national corporations",
 "NGM" : "Non-governmental movements",
 "NGO" : "Non-governmental organizations",
 "UIS" : "Unidentified state actors",
 "AFG":"Afghanistan",
 "ALB":"Albania",
 "DZA":"Algeria",
 "ASM":"American Samoa",
 "AND":"Andorra",
 "AGO":"Angola",
 "AIA":"Anguilla",
 "ATA":"Antarctica",
 "ATG":"Antigua and Barbuda",
 "ARG":"Argentina",
 "ARM":"Armenia",
 "ABW":"Aruba",
 "AUS":"Australia",
 "AUT":"Austria",
 "AZE":"Azerbaijan",
 "BHS":"Bahamas",
 "BHR":"Bahrain",
 "BGD":"Bangladesh",
 "BRB":"Barbados",
 "BLR":"Belarus",
 "BEL":"Belgium",
 "BLZ":"Belize",
 "BEN":"Benin",
 "BMU":"Bermuda",
 "BTN":"Bhutan",
 "BOL":"Bolivia",
 "BES":"Bonaire, Sint Eustatius and Saba",
 "BIH":"Bosnia and Herzegovina",
 "BWA":"Botswana",
 "BVT":"Bouvet Island",
 "BRA":"Brazil",
 "IOT":"British Indian Ocean Territory",
 "BRN":"Brunei",
 "BGR":"Bulgaria",
 "BFA":"Burkina Faso",
 "BDI":"Burundi",
 "KHM":"Cambodia",
 "CMR":"Cameroon",
 "CAN":"Canada",
 "CPV":"Cape Verde",
 "CYM":"Cayman Islands",
 "CAF":"Central African Republic",
 "TCD":"Chad",
 "CHL":"Chile",
 "CHN":"China",
 "CXR":"Christmas Island",
 "CCK":"Cocos (Keeling) Islands",
 "COL":"Colombia",
 "COM":"Comoros",
 "COG":"Congo",
 "COD":"Congo, the Democratic Republic of the",
 "COK":"Cook Islands",
 "CRI":"Costa Rica",
 "HRV":"Croatia",
 "CUB":"Cuba",
 "CUW":"Curaçao",
 "CYP":"Cyprus",
 "CZE":"Czech Republic",
 "CIV":"Cote d\'Ivoire",
 "DNK":"Denmark",
 "DJI":"Djibouti",
 "DMA":"Dominica",
 "DOM":"Dominican Republic",
 "ECU":"Ecuador",
 "EGY":"Egypt",
 "SLV":"El Salvador",
 "GNQ":"Equatorial Guinea",
 "ERI":"Eritrea",
 "EST":"Estonia",
 "ETH":"Ethiopia",
 "FLK":"Falkland Islands (Malvinas)",
 "FRO":"Faroe Islands",
 "FJI":"Fiji",
 "FIN":"Finland",
 "FRA":"France",
 "GUF":"French Guiana",
 "PYF":"French Polynesia",
 "ATF":"French Southern Territories",
 "GAB":"Gabon",
 "GMB":"Gambia",
 "GEO":"Georgia",
 "DEU":"Germany",
 "GHA":"Ghana",
 "GIB":"Gibraltar",
 "GRC":"Greece",
 "GRL":"Greenland",
 "GRD":"Grenada",
 "GLP":"Guadeloupe",
 "GUM":"Guam",
 "GTM":"Guatemala",
 "GGY":"Guernsey",
 "GIN":"Guinea",
 "GNB":"Guinea-Bissau",
 "GUY":"Guyana",
 "HTI":"Haiti",
 "HMD":"Heard Island and McDonald Islands",
 "VAT":"Holy See (Vatican City State)",
 "HND":"Honduras",
 "HKG":"Hong Kong",
 "HUN":"Hungary",
 "ISL":"Iceland",
 "IND":"India",
 "IDN":"Indonesia",
 "IRN":"Iran",
 "IRQ":"Iraq",
 "IRL":"Ireland",
 "IMN":"Isle of Man",
 "ISR":"Israel",
 "ITA":"Italy",
 "JAM":"Jamaica",
 "JPN":"Japan",
 "JEY":"Jersey",
 "JOR":"Jordan",
 "KAZ":"Kazakhstan",
 "KEN":"Kenya",
 "KIR":"Kiribati",
 "PRK":"Korea, Democratic People's Republic of",
 "KOR":"Korea, Republic of",
 "KSV":"Kosovo",
 "KWT":"Kuwait",
 "KGZ":"Kyrgyzstan",
 "LAO":"Laos",
 "LVA":"Latvia",
 "LBN":"Lebanon",
 "LSO":"Lesotho",
 "LBR":"Liberia",
 "LBY":"Libya",
 "LIE":"Liechtenstein",
 "LTU":"Lithuania",
 "LUX":"Luxembourg",
 "MAC":"Macao",
 "MKD":"Macedonia",
 "MDG":"Madagascar",
 "MWI":"Malawi",
 "MYS":"Malaysia",
 "MDV":"Maldives",
 "MLI":"Mali",
 "MLT":"Malta",
 "MHL":"Marshall Islands",
 "MTQ":"Martinique",
 "MRT":"Mauritania",
 "MUS":"Mauritius",
 "MYT":"Mayotte",
 "MEX":"Mexico",
 "FSM":"Micronesia, Federated States of",
 "MDA":"Moldova",
 "MCO":"Monaco",
 "MNG":"Mongolia",
 "MNE":"Montenegro",
 "MSR":"Montserrat",
 "MAR":"Morocco",
 "MOZ":"Mozambique",
 "MMR":"Myanmar",
 "NAM":"Namibia",
 "NRU":"Nauru",
 "NPL":"Nepal",
 "NLD":"Netherlands",
 "NCL":"New Caledonia",
 "NZL":"New Zealand",
 "NIC":"Nicaragua",
 "NER":"Niger",
 "NGA":"Nigeria",
 "NIU":"Niue",
 "NFK":"Norfolk Island",
 "MNP":"Northern Mariana Islands",
 "NOR":"Norway",
 "OMN":"Oman",
 "PAK":"Pakistan",
 "PLW":"Palau",
 "PSE":"Palestine",
 "PAN":"Panama",
 "PNG":"Papua New Guinea",
 "PRY":"Paraguay",
 "PER":"Peru",
 "PHL":"Philippines",
 "PCN":"Pitcairn",
 "POL":"Poland",
 "PRT":"Portugal",
 "PRI":"Puerto Rico",
 "QAT":"Qatar",
 "ROU":"Romania",
 "RUS":"Russian Federation",
 "RWA":"Rwanda",
 "REU":"Reunion",
 "BLM":"Saint Barthelemy",
 "SHN":"Saint Helena, Ascension and Tristan da Cunha",
 "KNA":"Saint Kitts and Nevis",
 "LCA":"Saint Lucia",
 "MAF":"Saint Martin (French part)",
 "SPM":"Saint Pierre and Miquelon",
 "VCT":"Saint Vincent and the Grenadines",
 "WSM":"Samoa",
 "SMR":"San Marino",
 "STP":"Sao Tome and Principe",
 "SAU":"Saudi Arabia",
 "SEN":"Senegal",
 "SRB":"Serbia",
 "SYC":"Seychelles",
 "SLE":"Sierra Leone",
 "SGP":"Singapore",
 "SXM":"Sint Maarten (Dutch part)",
 "SVK":"Slovakia",
 "SVN":"Slovenia",
 "SLB":"Solomon Islands",
 "SOM":"Somalia",
 "ZAF":"South Africa",
 "SGS":"South Georgia and the South Sandwich Islands",
 "SSD":"South Sudan",
 "ESP":"Spain",
 "LKA":"Sri Lanka",
 "SDN":"Sudan",
 "SUR":"Suriname",
 "SJM":"Svalbard and Jan Mayen",
 "SWZ":"Swaziland",
 "SWE":"Sweden",
 "CHE":"Switzerland",
 "SYR":"Syria",
 "TWN":"Taiwan",
 "TJK":"Tajikistan",
 "TZA":"Tanzania",
 "THA":"Thailand",
 "TLS":"Timor-Leste",
 "TGO":"Togo",
 "TKL":"Tokelau",
 "TON":"Tonga",
 "TTO":"Trinidad and Tobago",
 "TUN":"Tunisia",
 "TUR":"Turkey",
 "TKM":"Turkmenistan",
 "TCA":"Turks and Caicos Islands",
 "TUV":"Tuvalu",
 "UGA":"Uganda",
 "UKR":"Ukraine",
 "ARE":"United Arab Emirates",
 "GBR":"United Kingdom",
 "USA":"United States",
 "UMI":"United States Minor Outlying Islands",
 "URY":"Uruguay",
 "UZB":"Uzbekistan",
 "VUT":"Vanuatu",
 "VEN":"Venezuela",
 "VNM":"Vietnam",
 "VGB":"Virgin Islands, British",
 "VIR":"Virgin Islands, U.S.",
 "WLF":"Wallis and Futuna",
 "ESH":"Western Sahara",
 "YEM":"Yemen",
 "ZMB":"Zambia",
 "ZWE":"Zimbabwe"}


    

In [2]:

    

temp=json.dumps(actor_code)
jsonObject=json.loads(temp)


    

    




---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-2-c91ecaf3eb4f> in <module>()
----> 1 temp=json.dumps(actor_code)
      2 jsonObject=json.loads(temp)

NameError: name 'actor_code' is not defined

In [3]:

    

import pymongo
from pymongo import MongoClient
client=MongoClient()


    

In [7]:

    

client = MongoClient('localhost', 27017)


    

In [4]:

    

client = MongoClient('dalab.ou.edu', 27017)


    

In [8]:

    

db=client.eventData


    

In [5]:

    

db=client.lexisnexis


    

In [13]:

    

actors=db.actors


    

In [14]:

    

for k,v in jsonObject.iteritems():
    tempDictionary={};
    tempDictionary['id']=k;
    tempDictionary['name']=k+":"+v;
    actors.insert_one(tempDictionary);


    

In [1]:

    

verb_list={"010":"Make statement, not specified below",
"011":"Decline comment",
"012":"Make pessimistic comment",
"013":"Make optimistic comment",
"014":"Consider policy option",
"015":"Acknowledge or claim responsibility",
"016":"Make empathetic comment",
"017":"Engage in symbolic act",
"018":"Express accord",
"020":"Appeal, not specified below",
"021":"Appeal for cooperation, not specified below",
"0211":"Appeal for diplomatic cooperation",
"0212":"Appeal for material cooperation",
"022":"Appeal for policy support",
"023":"Appeal for aid, not specified below",
"0231":"Appeal for economic aid",
"0232":"Appeal for military aid",
"0233":"Appeal for humanitarian aid",
"0234":"Appeal for military protection or peacekeeping",
"024":"Appeal for political reform, not specified below",
"0241":"Appeal for change in leadership",
"0242":"Appeal for policy change",
"0243":"Appeal for rights",
"0244":"Appeal for change in institutions, regime",
"025":"Appeal to yield",
"026":"Appeal to others to meet or negotiate",
"027":"Appeal to others to settle dispute",
"028":"Appeal to others to engage in mediation",
"030":"Express intent to cooperate, not specified below",
"031":"Express intent to engage in material cooperation,  not specified below",
"0311":"Express intent to cooperate economically",
"0312":"Express intent to cooperate militarily",
"032":"Express intent to provide policy support",
"033":"Express intent to provide aid, not specified below",
"0331":"Express intent to provide economic aid",
"0332":"Express intent to provide military aid",
"0333":"Express intent to provide humanitarian aid",
"0334":"Express intent to provide military protection or peacekeeping",
"034":"Express intent to bring political reform, not specified below",
"0341":"Express intent to change leadership",
"0342":"Express intent to change policy",
"0343":"Express intent to provide rights",
"0344":"Express intent to change institutions, regime",
"035":"Express intent to yield, not specified below",
"0351":"Express intent to ease administrative sanctions",
"0352":"Express intent to stop protests",
"0353":"Express intent to accede to political demands",
"0354":"Express intent to release persons or property",
"0355":"Express intent to ease economic sanctions, boycott, or embargo",
"0356":"Express intent allow international involvement (not mediation)",
"0357":"Express intent to de-escalate military engagement ",
"036":"Express intent to meet or negotiate",
"037":"Express intent to settle dispute",
"038":"Express intent to accept mediation",
"039":"Express intent to mediate",
"040":"Consult, not specified below",
"041":"Discuss by telephone",
"042":"Make a visit",
"043":"Host a visit",
"044":"Meet at a “third” location",
"045":"Mediate",
"046":"Engage in negotiation",
"050":"Engage in diplomatic cooperation, not specified below",
"051":"Praise or endorse",
"052":"Defend verbally",
"053":"Rally support on behalf of",
"054":"Grant diplomatic recognition",
"055":"Apologize",
"056":"Forgive",
"057":"Sign formal agreement",
"060":"Engage in material cooperation, not spec below",
"061":"Cooperate economically",
"062":"Cooperate militarily",
"063":"Engage in judicial cooperation",
"064":"Share intelligence or information",
"070":"Provide aid, not specified below",
"071":"Provide economic aid",
"072":"Provide military aid",
"073":"Provide humanitarian aid",
"074":"Provide military protection or peacekeeping",
"075":"Grant asylum",
"080":"Yield, not specified below ",
"081":"Ease administrative sanctions, not specified below",
"0811":"Ease restrictions on freedoms of speech and expression ",
"0812":"Ease ban on political parties or politicians",
"0813":"Ease curfew",
"0814":"Ease state of emergency or martial law",
"082":"Ease popular protest ",
"083":"Accede to demands for political reform ",
"0831":"Accede to demands for change in leadership",
"0832":"Accede to demands for change in policy",
"0833":"Accede to demands for rights",
"0834":"Accede to demands for change in institutions, regime",
"084":"Return, release, not specified below",
"0841":"Return, release person(s)",
"0842":"Return, release property",
"085":"Ease economic sanctions, boycott, embargo",
"086":"Allow international involvement",
"0861":"Receive deployment of peacekeepers",
"0862":"Receive inspectors",
"0863":"Allow delivery of humanitarian aid",
"087":"De-escalate military engagement",
"0871":"Declare truce, ceasefire",
"0872":"Ease military blockade",
"0873":"Demobilize armed forces",
"0874":"Retreat or surrender militarily",
"090":"Investigate, not specified below",
"091":"Investigate crime, corruption",
"092":"Investigate human rights abuses",
"093":"Investigate military action",
"094":"Investigate war crimes",
"100":"Demand, not specified below",
"101":"Demand information, investigation",
"102":"Demand policy support",
"103":"Demand aid, protection, or peacekeeping",
"104":"Demand political reform, not specified below",
"1041":"Demand change in leadership",
"1042":"Demand policy change",
"1043":"Demand rights",
"1044":"Demand change in institutions, regime",
"105":"Demand mediation",
"106":"Demand withdrawal",
"107":"Demand ceasefire",
"108":"Demand meeting, negotiation",
"110":"Disapprove, not specified below",
"111":"Criticize or denounce ",
"112":"Accuse, not specified below",
"1121":"Accuse of crime, corruption",
"1122":"Accuse of human rights abuses",
"1123":"Accuse of aggression",
"1124":"Accuse of war crimes",
"1125":"Accuse of espionage, treason",
"113":"Rally opposition against",
"114":"Complain officially ",
"115":"Bring lawsuit against ",
"120":"Reject, not specified below",
"121":"Reject proposal, not specified below",
"1211":"Reject ceasefire, withdrawal",
"1212":"Reject peacekeeping",
"1213":"Reject settlement",
"122":"Reject request for material aid",
"123":"Reject demands for political reform ",
"1231":"Reject demands for change in leadership",
"1232":"Reject demands for policy change",
"1233":"Reject demand for rights",
"1234":"Reject demand change in institutions, regime",
"124":"Reject proposal to meet, discuss, or negotiate",
"125":"Reject mediation",
"126":"Defy norms, law",
"127":"Reject accusation, deny responsibility",
"128":"Veto ",
"130":"Threaten, not specified below",
"131":"Threaten non-force, not specified below",
"1311":"Threaten to reduce or stop aid",
"1312":"Threaten to boycott, embargo, or sanction",
"1313":"Threaten to reduce or break relations",
"132":"Threaten with administrative sanctions, not specified below",
"1321":"Threaten to impose restrictions on freedoms of speech and expression ",
"1322":"Threaten to ban political parties or politicians",
"1323":"Threaten to impose curfew",
"1324":"Threaten to impose state of emergency or martial law",
"133":"Threaten collective dissent",
"134":"Threaten to halt negotiations",
"135":"Threaten to halt mediation",
"136":"Threaten to expel or withdraw peacekeepers",
"137":"Threaten with violent repression",
"138":"Threaten to use military force, not specified below",
"1381":"Threaten blockade",
"1382":"Threaten occupation ",
"1383":"Threaten unconventional violence ",
"1384":"Threaten conventional attack  ",
"1385":"Threaten attack with WMD",
"139":"Give ultimatum",
"140":"Engage in popular protest, not specified below",
"141":"Demonstrate or rally",
"1411":"Demonstrate for change in leadership",
"1412":"Demonstrate for policy change",
"1413":"Demonstrate for rights",
"1414":"Demonstrate for change in institutions, regime",
"142":"Conduct hunger strike, not specified below",
"1421":"Conduct hunger strike for change in leadership",
"1422":"Conduct hunger strike for policy change",
"1423":"Conduct hunger strike for rights",
"1424":"Conduct hunger strike for change in institutions, regime ",
"143":"Conduct strike or boycott, not specified below",
"1431":"Conduct strike or boycott for change in leadership   ",
"1432":"Conduct strike or boycott for policy change",
"1433":"Conduct strike or boycott for rights",
"1434":"Conduct strike or boycott for change in institutions, regime",
"144":"Obstruct passage, block",
"1441":"Obstruct passage to demand change in  leadership   ",
"1442":"Obstruct passage to demand policy change",
"1443":"Obstruct passage to demand rights",
"1444":"Obstruct passage to demand change in institutions, regime",
"145":"Protest violently, riot",
"1451":"Obstruct passage to demand change in  leadership   ",
"1452":"Obstruct passage to demand policy change",
"1453":"Obstruct passage to demand rights",
"1454":"Obstruct passage to demand change in institutions, regime",
"150":"Demonstrate military or police power, not specified below",
"151":"Increase police alert status",
"152":"Increase military alert status",
"153":"Mobilize or increase police power",
"154":"Mobilize or increase armed forces ",
"160":"Reduce relations, not specified below",
"161":"Reduce or break diplomatic relations",
"162":"Reduce or stop aid, not specified below",
"1621":"Reduce or stop economic assistance",
"1622":"Reduce or stop military assistance",
"1623":"Reduce or stop humanitarian assistance",
"163":"Halt negotiations",
"164":"Expel or withdraw, not specified below",
"1641":"Expel or withdraw peacekeepers",
"1642":"Expel or withdraw inspectors, observers",
"1643":"Expel or withdraw aid agencies",
"165":"Halt mediation",
"166":"Impose embargo, boycott, or sanctions",
"170":"Coerce, not specified below ",
"171":"Seize or damage property, not specified below",
"1711":"Confiscate property",
"1712":"Destroy property",
"172":"Impose administrative sanctions, not specified below",
"1721":"Impose restrictions on freedoms of speech and expression ",
"1722":"Ban political parties or politicians",
"1723":"Impose curfew",
"1724":"Impose state of emergency or martial law",
"173":"Arrest, detain, or charge with legal action ",
"174":"Expel or deport individuals",
"175":"Use violent repression  ",
"180":"Use unconventional violence, not specified below",
"181":"Abduct, hijack, or take hostage ",
"182":"Physically assault, not specified below",
"1821":"Sexually assault",
"1822":"Torture",
"1823":"Kill by physical assault",
"183":"Conduct suicide, car, or other non-military bombing, not spec below",
"1831":"Carry out suicide bombing",
"1832":"Carry out car bombing",
"1833":"Carry out roadside bombing ",
"184":"Use as human shield ",
"185":"Attempt to assassinate",
"186":"Assassinate ",
"190":"Use conventional military force, not specified below",
"191":"Impose blockade, restrict movement ",
"192":"Occupy territory",
"193":"Fight with small arms and light weapons",
"194":"Fight with artillery and tanks",
"195":"Employ aerial weapons",
"196":"Violate ceasefire ",
"200":"Engage in unconventional mass violence, not specified below",
"201":"Engage in mass expulsion",
"202":"Engage in mass killings",
"203":"Engage in ethnic cleansing",
"204":"Use weapons of mass destruction, not specified below",
"2041":"Use chemical, biological, or radiological weapons",
"2042":"Detonate nuclear weapons"}


    

In [6]:

    

import json

json.dumps(verb_list, sort_keys=True)


    

    
Out[6]:





'{"010": "Make statement, not specified below", "011": "Decline comment", "012": "Make pessimistic comment", "013": "Make optimistic comment", "014": "Consider policy option", "015": "Acknowledge or claim responsibility", "016": "Make empathetic comment", "017": "Engage in symbolic act", "018": "Express accord", "020": "Appeal, not specified below", "021": "Appeal for cooperation, not specified below", "0211": "Appeal for diplomatic cooperation", "0212": "Appeal for material cooperation", "022": "Appeal for policy support", "023": "Appeal for aid, not specified below", "0231": "Appeal for economic aid", "0232": "Appeal for military aid", "0233": "Appeal for humanitarian aid", "0234": "Appeal for military protection or peacekeeping", "024": "Appeal for political reform, not specified below", "0241": "Appeal for change in leadership", "0242": "Appeal for policy change", "0243": "Appeal for rights", "0244": "Appeal for change in institutions, regime", "025": "Appeal to yield", "026": "Appeal to others to meet or negotiate", "027": "Appeal to others to settle dispute", "028": "Appeal to others to engage in mediation", "030": "Express intent to cooperate, not specified below", "031": "Express intent to engage in material cooperation,  not specified below", "0311": "Express intent to cooperate economically", "0312": "Express intent to cooperate militarily", "032": "Express intent to provide policy support", "033": "Express intent to provide aid, not specified below", "0331": "Express intent to provide economic aid", "0332": "Express intent to provide military aid", "0333": "Express intent to provide humanitarian aid", "0334": "Express intent to provide military protection or peacekeeping", "034": "Express intent to bring political reform, not specified below", "0341": "Express intent to change leadership", "0342": "Express intent to change policy", "0343": "Express intent to provide rights", "0344": "Express intent to change institutions, regime", "035": "Express intent to yield, not specified below", "0351": "Express intent to ease administrative sanctions", "0352": "Express intent to stop protests", "0353": "Express intent to accede to political demands", "0354": "Express intent to release persons or property", "0355": "Express intent to ease economic sanctions, boycott, or embargo", "0356": "Express intent allow international involvement (not mediation)", "0357": "Express intent to de-escalate military engagement ", "036": "Express intent to meet or negotiate", "037": "Express intent to settle dispute", "038": "Express intent to accept mediation", "039": "Express intent to mediate", "040": "Consult, not specified below", "041": "Discuss by telephone", "042": "Make a visit", "043": "Host a visit", "044": "Meet at a \\u00e2\\u20ac\\u0153third\\u00e2\\u20ac\\u009d location", "045": "Mediate", "046": "Engage in negotiation", "050": "Engage in diplomatic cooperation, not specified below", "051": "Praise or endorse", "052": "Defend verbally", "053": "Rally support on behalf of", "054": "Grant diplomatic recognition", "055": "Apologize", "056": "Forgive", "057": "Sign formal agreement", "060": "Engage in material cooperation, not spec below", "061": "Cooperate economically", "062": "Cooperate militarily", "063": "Engage in judicial cooperation", "064": "Share intelligence or information", "070": "Provide aid, not specified below", "071": "Provide economic aid", "072": "Provide military aid", "073": "Provide humanitarian aid", "074": "Provide military protection or peacekeeping", "075": "Grant asylum", "080": "Yield, not specified below ", "081": "Ease administrative sanctions, not specified below", "0811": "Ease restrictions on freedoms of speech and expression ", "0812": "Ease ban on political parties or politicians", "0813": "Ease curfew", "0814": "Ease state of emergency or martial law", "082": "Ease popular protest ", "083": "Accede to demands for political reform ", "0831": "Accede to demands for change in leadership", "0832": "Accede to demands for change in policy", "0833": "Accede to demands for rights", "0834": "Accede to demands for change in institutions, regime", "084": "Return, release, not specified below", "0841": "Return, release person(s)", "0842": "Return, release property", "085": "Ease economic sanctions, boycott, embargo", "086": "Allow international involvement", "0861": "Receive deployment of peacekeepers", "0862": "Receive inspectors", "0863": "Allow delivery of humanitarian aid", "087": "De-escalate military engagement", "0871": "Declare truce, ceasefire", "0872": "Ease military blockade", "0873": "Demobilize armed forces", "0874": "Retreat or surrender militarily", "090": "Investigate, not specified below", "091": "Investigate crime, corruption", "092": "Investigate human rights abuses", "093": "Investigate military action", "094": "Investigate war crimes", "100": "Demand, not specified below", "101": "Demand information, investigation", "102": "Demand policy support", "103": "Demand aid, protection, or peacekeeping", "104": "Demand political reform, not specified below", "1041": "Demand change in leadership", "1042": "Demand policy change", "1043": "Demand rights", "1044": "Demand change in institutions, regime", "105": "Demand mediation", "106": "Demand withdrawal", "107": "Demand ceasefire", "108": "Demand meeting, negotiation", "110": "Disapprove, not specified below", "111": "Criticize or denounce ", "112": "Accuse, not specified below", "1121": "Accuse of crime, corruption", "1122": "Accuse of human rights abuses", "1123": "Accuse of aggression", "1124": "Accuse of war crimes", "1125": "Accuse of espionage, treason", "113": "Rally opposition against", "114": "Complain officially ", "115": "Bring lawsuit against ", "120": "Reject, not specified below", "121": "Reject proposal, not specified below", "1211": "Reject ceasefire, withdrawal", "1212": "Reject peacekeeping", "1213": "Reject settlement", "122": "Reject request for material aid", "123": "Reject demands for political reform ", "1231": "Reject demands for change in leadership", "1232": "Reject demands for policy change", "1233": "Reject demand for rights", "1234": "Reject demand change in institutions, regime", "124": "Reject proposal to meet, discuss, or negotiate", "125": "Reject mediation", "126": "Defy norms, law", "127": "Reject accusation, deny responsibility", "128": "Veto ", "130": "Threaten, not specified below", "131": "Threaten non-force, not specified below", "1311": "Threaten to reduce or stop aid", "1312": "Threaten to boycott, embargo, or sanction", "1313": "Threaten to reduce or break relations", "132": "Threaten with administrative sanctions, not specified below", "1321": "Threaten to impose restrictions on freedoms of speech and expression ", "1322": "Threaten to ban political parties or politicians", "1323": "Threaten to impose curfew", "1324": "Threaten to impose state of emergency or martial law", "133": "Threaten collective dissent", "134": "Threaten to halt negotiations", "135": "Threaten to halt mediation", "136": "Threaten to expel or withdraw peacekeepers", "137": "Threaten with violent repression", "138": "Threaten to use military force, not specified below", "1381": "Threaten blockade", "1382": "Threaten occupation ", "1383": "Threaten unconventional violence ", "1384": "Threaten conventional attack  ", "1385": "Threaten attack with WMD", "139": "Give ultimatum", "140": "Engage in popular protest, not specified below", "141": "Demonstrate or rally", "1411": "Demonstrate for change in leadership", "1412": "Demonstrate for policy change", "1413": "Demonstrate for rights", "1414": "Demonstrate for change in institutions, regime", "142": "Conduct hunger strike, not specified below", "1421": "Conduct hunger strike for change in leadership", "1422": "Conduct hunger strike for policy change", "1423": "Conduct hunger strike for rights", "1424": "Conduct hunger strike for change in institutions, regime ", "143": "Conduct strike or boycott, not specified below", "1431": "Conduct strike or boycott for change in leadership   ", "1432": "Conduct strike or boycott for policy change", "1433": "Conduct strike or boycott for rights", "1434": "Conduct strike or boycott for change in institutions, regime", "144": "Obstruct passage, block", "1441": "Obstruct passage to demand change in  leadership   ", "1442": "Obstruct passage to demand policy change", "1443": "Obstruct passage to demand rights", "1444": "Obstruct passage to demand change in institutions, regime", "145": "Protest violently, riot", "1451": "Obstruct passage to demand change in  leadership   ", "1452": "Obstruct passage to demand policy change", "1453": "Obstruct passage to demand rights", "1454": "Obstruct passage to demand change in institutions, regime", "150": "Demonstrate military or police power, not specified below", "151": "Increase police alert status", "152": "Increase military alert status", "153": "Mobilize or increase police power", "154": "Mobilize or increase armed forces ", "160": "Reduce relations, not specified below", "161": "Reduce or break diplomatic relations", "162": "Reduce or stop aid, not specified below", "1621": "Reduce or stop economic assistance", "1622": "Reduce or stop military assistance", "1623": "Reduce or stop humanitarian assistance", "163": "Halt negotiations", "164": "Expel or withdraw, not specified below", "1641": "Expel or withdraw peacekeepers", "1642": "Expel or withdraw inspectors, observers", "1643": "Expel or withdraw aid agencies", "165": "Halt mediation", "166": "Impose embargo, boycott, or sanctions", "170": "Coerce, not specified below ", "171": "Seize or damage property, not specified below", "1711": "Confiscate property", "1712": "Destroy property", "172": "Impose administrative sanctions, not specified below", "1721": "Impose restrictions on freedoms of speech and expression ", "1722": "Ban political parties or politicians", "1723": "Impose curfew", "1724": "Impose state of emergency or martial law", "173": "Arrest, detain, or charge with legal action ", "174": "Expel or deport individuals", "175": "Use violent repression  ", "180": "Use unconventional violence, not specified below", "181": "Abduct, hijack, or take hostage ", "182": "Physically assault, not specified below", "1821": "Sexually assault", "1822": "Torture", "1823": "Kill by physical assault", "183": "Conduct suicide, car, or other non-military bombing, not spec below", "1831": "Carry out suicide bombing", "1832": "Carry out car bombing", "1833": "Carry out roadside bombing ", "184": "Use as human shield ", "185": "Attempt to assassinate", "186": "Assassinate ", "190": "Use conventional military force, not specified below", "191": "Impose blockade, restrict movement ", "192": "Occupy territory", "193": "Fight with small arms and light weapons", "194": "Fight with artillery and tanks", "195": "Employ aerial weapons", "196": "Violate ceasefire ", "200": "Engage in unconventional mass violence, not specified below", "201": "Engage in mass expulsion", "202": "Engage in mass killings", "203": "Engage in ethnic cleansing", "204": "Use weapons of mass destruction, not specified below", "2041": "Use chemical, biological, or radiological weapons", "2042": "Detonate nuclear weapons"}'

In [14]:

    

verb_list


    

    
Out[14]:





{'010': 'Make statement, not specified below',
 '011': 'Decline comment',
 '012': 'Make pessimistic comment',
 '013': 'Make optimistic comment',
 '014': 'Consider policy option',
 '015': 'Acknowledge or claim responsibility',
 '016': 'Make empathetic comment',
 '017': 'Engage in symbolic act',
 '018': 'Express accord',
 '020': 'Appeal, not specified below',
 '021': 'Appeal for cooperation, not specified below',
 '0211': 'Appeal for diplomatic cooperation',
 '0212': 'Appeal for material cooperation',
 '022': 'Appeal for policy support',
 '023': 'Appeal for aid, not specified below',
 '0231': 'Appeal for economic aid',
 '0232': 'Appeal for military aid',
 '0233': 'Appeal for humanitarian aid',
 '0234': 'Appeal for military protection or peacekeeping',
 '024': 'Appeal for political reform, not specified below',
 '0241': 'Appeal for change in leadership',
 '0242': 'Appeal for policy change',
 '0243': 'Appeal for rights',
 '0244': 'Appeal for change in institutions, regime',
 '025': 'Appeal to yield',
 '026': 'Appeal to others to meet or negotiate',
 '027': 'Appeal to others to settle dispute',
 '028': 'Appeal to others to engage in mediation',
 '030': 'Express intent to cooperate, not specified below',
 '031': 'Express intent to engage in material cooperation,  not specified below',
 '0311': 'Express intent to cooperate economically',
 '0312': 'Express intent to cooperate militarily',
 '032': 'Express intent to provide policy support',
 '033': 'Express intent to provide aid, not specified below',
 '0331': 'Express intent to provide economic aid',
 '0332': 'Express intent to provide military aid',
 '0333': 'Express intent to provide humanitarian aid',
 '0334': 'Express intent to provide military protection or peacekeeping',
 '034': 'Express intent to bring political reform, not specified below',
 '0341': 'Express intent to change leadership',
 '0342': 'Express intent to change policy',
 '0343': 'Express intent to provide rights',
 '0344': 'Express intent to change institutions, regime',
 '035': 'Express intent to yield, not specified below',
 '0351': 'Express intent to ease administrative sanctions',
 '0352': 'Express intent to stop protests',
 '0353': 'Express intent to accede to political demands',
 '0354': 'Express intent to release persons or property',
 '0355': 'Express intent to ease economic sanctions, boycott, or embargo',
 '0356': 'Express intent allow international involvement (not mediation)',
 '0357': 'Express intent to de-escalate military engagement ',
 '036': 'Express intent to meet or negotiate',
 '037': 'Express intent to settle dispute',
 '038': 'Express intent to accept mediation',
 '039': 'Express intent to mediate',
 '040': 'Consult, not specified below',
 '041': 'Discuss by telephone',
 '042': 'Make a visit',
 '043': 'Host a visit',
 '044': 'Meet at a \xc3\xa2\xe2\x82\xac\xc5\x93third\xc3\xa2\xe2\x82\xac\xc2\x9d location',
 '045': 'Mediate',
 '046': 'Engage in negotiation',
 '050': 'Engage in diplomatic cooperation, not specified below',
 '051': 'Praise or endorse',
 '052': 'Defend verbally',
 '053': 'Rally support on behalf of',
 '054': 'Grant diplomatic recognition',
 '055': 'Apologize',
 '056': 'Forgive',
 '057': 'Sign formal agreement',
 '060': 'Engage in material cooperation, not spec below',
 '061': 'Cooperate economically',
 '062': 'Cooperate militarily',
 '063': 'Engage in judicial cooperation',
 '064': 'Share intelligence or information',
 '070': 'Provide aid, not specified below',
 '071': 'Provide economic aid',
 '072': 'Provide military aid',
 '073': 'Provide humanitarian aid',
 '074': 'Provide military protection or peacekeeping',
 '075': 'Grant asylum',
 '080': 'Yield, not specified below ',
 '081': 'Ease administrative sanctions, not specified below',
 '0811': 'Ease restrictions on freedoms of speech and expression ',
 '0812': 'Ease ban on political parties or politicians',
 '0813': 'Ease curfew',
 '0814': 'Ease state of emergency or martial law',
 '082': 'Ease popular protest ',
 '083': 'Accede to demands for political reform ',
 '0831': 'Accede to demands for change in leadership',
 '0832': 'Accede to demands for change in policy',
 '0833': 'Accede to demands for rights',
 '0834': 'Accede to demands for change in institutions, regime',
 '084': 'Return, release, not specified below',
 '0841': 'Return, release person(s)',
 '0842': 'Return, release property',
 '085': 'Ease economic sanctions, boycott, embargo',
 '086': 'Allow international involvement',
 '0861': 'Receive deployment of peacekeepers',
 '0862': 'Receive inspectors',
 '0863': 'Allow delivery of humanitarian aid',
 '087': 'De-escalate military engagement',
 '0871': 'Declare truce, ceasefire',
 '0872': 'Ease military blockade',
 '0873': 'Demobilize armed forces',
 '0874': 'Retreat or surrender militarily',
 '090': 'Investigate, not specified below',
 '091': 'Investigate crime, corruption',
 '092': 'Investigate human rights abuses',
 '093': 'Investigate military action',
 '094': 'Investigate war crimes',
 '100': 'Demand, not specified below',
 '101': 'Demand information, investigation',
 '102': 'Demand policy support',
 '103': 'Demand aid, protection, or peacekeeping',
 '104': 'Demand political reform, not specified below',
 '1041': 'Demand change in leadership',
 '1042': 'Demand policy change',
 '1043': 'Demand rights',
 '1044': 'Demand change in institutions, regime',
 '105': 'Demand mediation',
 '106': 'Demand withdrawal',
 '107': 'Demand ceasefire',
 '108': 'Demand meeting, negotiation',
 '110': 'Disapprove, not specified below',
 '111': 'Criticize or denounce ',
 '112': 'Accuse, not specified below',
 '1121': 'Accuse of crime, corruption',
 '1122': 'Accuse of human rights abuses',
 '1123': 'Accuse of aggression',
 '1124': 'Accuse of war crimes',
 '1125': 'Accuse of espionage, treason',
 '113': 'Rally opposition against',
 '114': 'Complain officially ',
 '115': 'Bring lawsuit against ',
 '120': 'Reject, not specified below',
 '121': 'Reject proposal, not specified below',
 '1211': 'Reject ceasefire, withdrawal',
 '1212': 'Reject peacekeeping',
 '1213': 'Reject settlement',
 '122': 'Reject request for material aid',
 '123': 'Reject demands for political reform ',
 '1231': 'Reject demands for change in leadership',
 '1232': 'Reject demands for policy change',
 '1233': 'Reject demand for rights',
 '1234': 'Reject demand change in institutions, regime',
 '124': 'Reject proposal to meet, discuss, or negotiate',
 '125': 'Reject mediation',
 '126': 'Defy norms, law',
 '127': 'Reject accusation, deny responsibility',
 '128': 'Veto ',
 '130': 'Threaten, not specified below',
 '131': 'Threaten non-force, not specified below',
 '1311': 'Threaten to reduce or stop aid',
 '1312': 'Threaten to boycott, embargo, or sanction',
 '1313': 'Threaten to reduce or break relations',
 '132': 'Threaten with administrative sanctions, not specified below',
 '1321': 'Threaten to impose restrictions on freedoms of speech and expression ',
 '1322': 'Threaten to ban political parties or politicians',
 '1323': 'Threaten to impose curfew',
 '1324': 'Threaten to impose state of emergency or martial law',
 '133': 'Threaten collective dissent',
 '134': 'Threaten to halt negotiations',
 '135': 'Threaten to halt mediation',
 '136': 'Threaten to expel or withdraw peacekeepers',
 '137': 'Threaten with violent repression',
 '138': 'Threaten to use military force, not specified below',
 '1381': 'Threaten blockade',
 '1382': 'Threaten occupation ',
 '1383': 'Threaten unconventional violence ',
 '1384': 'Threaten conventional attack  ',
 '1385': 'Threaten attack with WMD',
 '139': 'Give ultimatum',
 '140': 'Engage in popular protest, not specified below',
 '141': 'Demonstrate or rally',
 '1411': 'Demonstrate for change in leadership',
 '1412': 'Demonstrate for policy change',
 '1413': 'Demonstrate for rights',
 '1414': 'Demonstrate for change in institutions, regime',
 '142': 'Conduct hunger strike, not specified below',
 '1421': 'Conduct hunger strike for change in leadership',
 '1422': 'Conduct hunger strike for policy change',
 '1423': 'Conduct hunger strike for rights',
 '1424': 'Conduct hunger strike for change in institutions, regime ',
 '143': 'Conduct strike or boycott, not specified below',
 '1431': 'Conduct strike or boycott for change in leadership   ',
 '1432': 'Conduct strike or boycott for policy change',
 '1433': 'Conduct strike or boycott for rights',
 '1434': 'Conduct strike or boycott for change in institutions, regime',
 '144': 'Obstruct passage, block',
 '1441': 'Obstruct passage to demand change in  leadership   ',
 '1442': 'Obstruct passage to demand policy change',
 '1443': 'Obstruct passage to demand rights',
 '1444': 'Obstruct passage to demand change in institutions, regime',
 '145': 'Protest violently, riot',
 '1451': 'Obstruct passage to demand change in  leadership   ',
 '1452': 'Obstruct passage to demand policy change',
 '1453': 'Obstruct passage to demand rights',
 '1454': 'Obstruct passage to demand change in institutions, regime',
 '150': 'Demonstrate military or police power, not specified below',
 '151': 'Increase police alert status',
 '152': 'Increase military alert status',
 '153': 'Mobilize or increase police power',
 '154': 'Mobilize or increase armed forces ',
 '160': 'Reduce relations, not specified below',
 '161': 'Reduce or break diplomatic relations',
 '162': 'Reduce or stop aid, not specified below',
 '1621': 'Reduce or stop economic assistance',
 '1622': 'Reduce or stop military assistance',
 '1623': 'Reduce or stop humanitarian assistance',
 '163': 'Halt negotiations',
 '164': 'Expel or withdraw, not specified below',
 '1641': 'Expel or withdraw peacekeepers',
 '1642': 'Expel or withdraw inspectors, observers',
 '1643': 'Expel or withdraw aid agencies',
 '165': 'Halt mediation',
 '166': 'Impose embargo, boycott, or sanctions',
 '170': 'Coerce, not specified below ',
 '171': 'Seize or damage property, not specified below',
 '1711': 'Confiscate property',
 '1712': 'Destroy property',
 '172': 'Impose administrative sanctions, not specified below',
 '1721': 'Impose restrictions on freedoms of speech and expression ',
 '1722': 'Ban political parties or politicians',
 '1723': 'Impose curfew',
 '1724': 'Impose state of emergency or martial law',
 '173': 'Arrest, detain, or charge with legal action ',
 '174': 'Expel or deport individuals',
 '175': 'Use violent repression  ',
 '180': 'Use unconventional violence, not specified below',
 '181': 'Abduct, hijack, or take hostage ',
 '182': 'Physically assault, not specified below',
 '1821': 'Sexually assault',
 '1822': 'Torture',
 '1823': 'Kill by physical assault',
 '183': 'Conduct suicide, car, or other non-military bombing, not spec below',
 '1831': 'Carry out suicide bombing',
 '1832': 'Carry out car bombing',
 '1833': 'Carry out roadside bombing ',
 '184': 'Use as human shield ',
 '185': 'Attempt to assassinate',
 '186': 'Assassinate ',
 '190': 'Use conventional military force, not specified below',
 '191': 'Impose blockade, restrict movement ',
 '192': 'Occupy territory',
 '193': 'Fight with small arms and light weapons',
 '194': 'Fight with artillery and tanks',
 '195': 'Employ aerial weapons',
 '196': 'Violate ceasefire ',
 '200': 'Engage in unconventional mass violence, not specified below',
 '201': 'Engage in mass expulsion',
 '202': 'Engage in mass killings',
 '203': 'Engage in ethnic cleansing',
 '204': 'Use weapons of mass destruction, not specified below',
 '2041': 'Use chemical, biological, or radiological weapons',
 '2042': 'Detonate nuclear weapons'}

In [15]:

    

tempVerb=json.dumps(verb_list)
jsonObjectVerb=json.loads(tempVerb)


    

In [16]:

    

jsonObjectVerb


    

    
Out[16]:





{u'010': u'Make statement, not specified below',
 u'011': u'Decline comment',
 u'012': u'Make pessimistic comment',
 u'013': u'Make optimistic comment',
 u'014': u'Consider policy option',
 u'015': u'Acknowledge or claim responsibility',
 u'016': u'Make empathetic comment',
 u'017': u'Engage in symbolic act',
 u'018': u'Express accord',
 u'020': u'Appeal, not specified below',
 u'021': u'Appeal for cooperation, not specified below',
 u'0211': u'Appeal for diplomatic cooperation',
 u'0212': u'Appeal for material cooperation',
 u'022': u'Appeal for policy support',
 u'023': u'Appeal for aid, not specified below',
 u'0231': u'Appeal for economic aid',
 u'0232': u'Appeal for military aid',
 u'0233': u'Appeal for humanitarian aid',
 u'0234': u'Appeal for military protection or peacekeeping',
 u'024': u'Appeal for political reform, not specified below',
 u'0241': u'Appeal for change in leadership',
 u'0242': u'Appeal for policy change',
 u'0243': u'Appeal for rights',
 u'0244': u'Appeal for change in institutions, regime',
 u'025': u'Appeal to yield',
 u'026': u'Appeal to others to meet or negotiate',
 u'027': u'Appeal to others to settle dispute',
 u'028': u'Appeal to others to engage in mediation',
 u'030': u'Express intent to cooperate, not specified below',
 u'031': u'Express intent to engage in material cooperation,  not specified below',
 u'0311': u'Express intent to cooperate economically',
 u'0312': u'Express intent to cooperate militarily',
 u'032': u'Express intent to provide policy support',
 u'033': u'Express intent to provide aid, not specified below',
 u'0331': u'Express intent to provide economic aid',
 u'0332': u'Express intent to provide military aid',
 u'0333': u'Express intent to provide humanitarian aid',
 u'0334': u'Express intent to provide military protection or peacekeeping',
 u'034': u'Express intent to bring political reform, not specified below',
 u'0341': u'Express intent to change leadership',
 u'0342': u'Express intent to change policy',
 u'0343': u'Express intent to provide rights',
 u'0344': u'Express intent to change institutions, regime',
 u'035': u'Express intent to yield, not specified below',
 u'0351': u'Express intent to ease administrative sanctions',
 u'0352': u'Express intent to stop protests',
 u'0353': u'Express intent to accede to political demands',
 u'0354': u'Express intent to release persons or property',
 u'0355': u'Express intent to ease economic sanctions, boycott, or embargo',
 u'0356': u'Express intent allow international involvement (not mediation)',
 u'0357': u'Express intent to de-escalate military engagement ',
 u'036': u'Express intent to meet or negotiate',
 u'037': u'Express intent to settle dispute',
 u'038': u'Express intent to accept mediation',
 u'039': u'Express intent to mediate',
 u'040': u'Consult, not specified below',
 u'041': u'Discuss by telephone',
 u'042': u'Make a visit',
 u'043': u'Host a visit',
 u'044': u'Meet at a \xe2\u20ac\u0153third\xe2\u20ac\x9d location',
 u'045': u'Mediate',
 u'046': u'Engage in negotiation',
 u'050': u'Engage in diplomatic cooperation, not specified below',
 u'051': u'Praise or endorse',
 u'052': u'Defend verbally',
 u'053': u'Rally support on behalf of',
 u'054': u'Grant diplomatic recognition',
 u'055': u'Apologize',
 u'056': u'Forgive',
 u'057': u'Sign formal agreement',
 u'060': u'Engage in material cooperation, not spec below',
 u'061': u'Cooperate economically',
 u'062': u'Cooperate militarily',
 u'063': u'Engage in judicial cooperation',
 u'064': u'Share intelligence or information',
 u'070': u'Provide aid, not specified below',
 u'071': u'Provide economic aid',
 u'072': u'Provide military aid',
 u'073': u'Provide humanitarian aid',
 u'074': u'Provide military protection or peacekeeping',
 u'075': u'Grant asylum',
 u'080': u'Yield, not specified below ',
 u'081': u'Ease administrative sanctions, not specified below',
 u'0811': u'Ease restrictions on freedoms of speech and expression ',
 u'0812': u'Ease ban on political parties or politicians',
 u'0813': u'Ease curfew',
 u'0814': u'Ease state of emergency or martial law',
 u'082': u'Ease popular protest ',
 u'083': u'Accede to demands for political reform ',
 u'0831': u'Accede to demands for change in leadership',
 u'0832': u'Accede to demands for change in policy',
 u'0833': u'Accede to demands for rights',
 u'0834': u'Accede to demands for change in institutions, regime',
 u'084': u'Return, release, not specified below',
 u'0841': u'Return, release person(s)',
 u'0842': u'Return, release property',
 u'085': u'Ease economic sanctions, boycott, embargo',
 u'086': u'Allow international involvement',
 u'0861': u'Receive deployment of peacekeepers',
 u'0862': u'Receive inspectors',
 u'0863': u'Allow delivery of humanitarian aid',
 u'087': u'De-escalate military engagement',
 u'0871': u'Declare truce, ceasefire',
 u'0872': u'Ease military blockade',
 u'0873': u'Demobilize armed forces',
 u'0874': u'Retreat or surrender militarily',
 u'090': u'Investigate, not specified below',
 u'091': u'Investigate crime, corruption',
 u'092': u'Investigate human rights abuses',
 u'093': u'Investigate military action',
 u'094': u'Investigate war crimes',
 u'100': u'Demand, not specified below',
 u'101': u'Demand information, investigation',
 u'102': u'Demand policy support',
 u'103': u'Demand aid, protection, or peacekeeping',
 u'104': u'Demand political reform, not specified below',
 u'1041': u'Demand change in leadership',
 u'1042': u'Demand policy change',
 u'1043': u'Demand rights',
 u'1044': u'Demand change in institutions, regime',
 u'105': u'Demand mediation',
 u'106': u'Demand withdrawal',
 u'107': u'Demand ceasefire',
 u'108': u'Demand meeting, negotiation',
 u'110': u'Disapprove, not specified below',
 u'111': u'Criticize or denounce ',
 u'112': u'Accuse, not specified below',
 u'1121': u'Accuse of crime, corruption',
 u'1122': u'Accuse of human rights abuses',
 u'1123': u'Accuse of aggression',
 u'1124': u'Accuse of war crimes',
 u'1125': u'Accuse of espionage, treason',
 u'113': u'Rally opposition against',
 u'114': u'Complain officially ',
 u'115': u'Bring lawsuit against ',
 u'120': u'Reject, not specified below',
 u'121': u'Reject proposal, not specified below',
 u'1211': u'Reject ceasefire, withdrawal',
 u'1212': u'Reject peacekeeping',
 u'1213': u'Reject settlement',
 u'122': u'Reject request for material aid',
 u'123': u'Reject demands for political reform ',
 u'1231': u'Reject demands for change in leadership',
 u'1232': u'Reject demands for policy change',
 u'1233': u'Reject demand for rights',
 u'1234': u'Reject demand change in institutions, regime',
 u'124': u'Reject proposal to meet, discuss, or negotiate',
 u'125': u'Reject mediation',
 u'126': u'Defy norms, law',
 u'127': u'Reject accusation, deny responsibility',
 u'128': u'Veto ',
 u'130': u'Threaten, not specified below',
 u'131': u'Threaten non-force, not specified below',
 u'1311': u'Threaten to reduce or stop aid',
 u'1312': u'Threaten to boycott, embargo, or sanction',
 u'1313': u'Threaten to reduce or break relations',
 u'132': u'Threaten with administrative sanctions, not specified below',
 u'1321': u'Threaten to impose restrictions on freedoms of speech and expression ',
 u'1322': u'Threaten to ban political parties or politicians',
 u'1323': u'Threaten to impose curfew',
 u'1324': u'Threaten to impose state of emergency or martial law',
 u'133': u'Threaten collective dissent',
 u'134': u'Threaten to halt negotiations',
 u'135': u'Threaten to halt mediation',
 u'136': u'Threaten to expel or withdraw peacekeepers',
 u'137': u'Threaten with violent repression',
 u'138': u'Threaten to use military force, not specified below',
 u'1381': u'Threaten blockade',
 u'1382': u'Threaten occupation ',
 u'1383': u'Threaten unconventional violence ',
 u'1384': u'Threaten conventional attack  ',
 u'1385': u'Threaten attack with WMD',
 u'139': u'Give ultimatum',
 u'140': u'Engage in popular protest, not specified below',
 u'141': u'Demonstrate or rally',
 u'1411': u'Demonstrate for change in leadership',
 u'1412': u'Demonstrate for policy change',
 u'1413': u'Demonstrate for rights',
 u'1414': u'Demonstrate for change in institutions, regime',
 u'142': u'Conduct hunger strike, not specified below',
 u'1421': u'Conduct hunger strike for change in leadership',
 u'1422': u'Conduct hunger strike for policy change',
 u'1423': u'Conduct hunger strike for rights',
 u'1424': u'Conduct hunger strike for change in institutions, regime ',
 u'143': u'Conduct strike or boycott, not specified below',
 u'1431': u'Conduct strike or boycott for change in leadership   ',
 u'1432': u'Conduct strike or boycott for policy change',
 u'1433': u'Conduct strike or boycott for rights',
 u'1434': u'Conduct strike or boycott for change in institutions, regime',
 u'144': u'Obstruct passage, block',
 u'1441': u'Obstruct passage to demand change in  leadership   ',
 u'1442': u'Obstruct passage to demand policy change',
 u'1443': u'Obstruct passage to demand rights',
 u'1444': u'Obstruct passage to demand change in institutions, regime',
 u'145': u'Protest violently, riot',
 u'1451': u'Obstruct passage to demand change in  leadership   ',
 u'1452': u'Obstruct passage to demand policy change',
 u'1453': u'Obstruct passage to demand rights',
 u'1454': u'Obstruct passage to demand change in institutions, regime',
 u'150': u'Demonstrate military or police power, not specified below',
 u'151': u'Increase police alert status',
 u'152': u'Increase military alert status',
 u'153': u'Mobilize or increase police power',
 u'154': u'Mobilize or increase armed forces ',
 u'160': u'Reduce relations, not specified below',
 u'161': u'Reduce or break diplomatic relations',
 u'162': u'Reduce or stop aid, not specified below',
 u'1621': u'Reduce or stop economic assistance',
 u'1622': u'Reduce or stop military assistance',
 u'1623': u'Reduce or stop humanitarian assistance',
 u'163': u'Halt negotiations',
 u'164': u'Expel or withdraw, not specified below',
 u'1641': u'Expel or withdraw peacekeepers',
 u'1642': u'Expel or withdraw inspectors, observers',
 u'1643': u'Expel or withdraw aid agencies',
 u'165': u'Halt mediation',
 u'166': u'Impose embargo, boycott, or sanctions',
 u'170': u'Coerce, not specified below ',
 u'171': u'Seize or damage property, not specified below',
 u'1711': u'Confiscate property',
 u'1712': u'Destroy property',
 u'172': u'Impose administrative sanctions, not specified below',
 u'1721': u'Impose restrictions on freedoms of speech and expression ',
 u'1722': u'Ban political parties or politicians',
 u'1723': u'Impose curfew',
 u'1724': u'Impose state of emergency or martial law',
 u'173': u'Arrest, detain, or charge with legal action ',
 u'174': u'Expel or deport individuals',
 u'175': u'Use violent repression  ',
 u'180': u'Use unconventional violence, not specified below',
 u'181': u'Abduct, hijack, or take hostage ',
 u'182': u'Physically assault, not specified below',
 u'1821': u'Sexually assault',
 u'1822': u'Torture',
 u'1823': u'Kill by physical assault',
 u'183': u'Conduct suicide, car, or other non-military bombing, not spec below',
 u'1831': u'Carry out suicide bombing',
 u'1832': u'Carry out car bombing',
 u'1833': u'Carry out roadside bombing ',
 u'184': u'Use as human shield ',
 u'185': u'Attempt to assassinate',
 u'186': u'Assassinate ',
 u'190': u'Use conventional military force, not specified below',
 u'191': u'Impose blockade, restrict movement ',
 u'192': u'Occupy territory',
 u'193': u'Fight with small arms and light weapons',
 u'194': u'Fight with artillery and tanks',
 u'195': u'Employ aerial weapons',
 u'196': u'Violate ceasefire ',
 u'200': u'Engage in unconventional mass violence, not specified below',
 u'201': u'Engage in mass expulsion',
 u'202': u'Engage in mass killings',
 u'203': u'Engage in ethnic cleansing',
 u'204': u'Use weapons of mass destruction, not specified below',
 u'2041': u'Use chemical, biological, or radiological weapons',
 u'2042': u'Detonate nuclear weapons'}

In [24]:

    

import pymongo
from pymongo import MongoClient
client=MongoClient()
client = MongoClient('dalab.ou.edu', 27017)
db=client.lexisnexis
verbs=db.verbs


    

In [20]:

    

type(jsonObjectVerb)


    

    
Out[20]:





dict

In [29]:

    

i=1;
for k in sorted(verb_list):
    if i<=150:
        tempDictionary={};
        tempDictionary['id']=k;
        tempDictionary['name']=k+":"+verb_list[k];
        verbs.insert_one(tempDictionary);
        i=i+1;


    

In [31]:

    

i=1;
for k in sorted(verb_list):
    if i<=150:
        i=i+1;
        continue;
    else:
        tempDictionary={};
        tempDictionary['id']=k;
        tempDictionary['name']=k+":"+verb_list[k];
        verbs.insert_one(tempDictionary);
        i=i+1;


    

In [11]:

    

import json
primary_role_list = {
 "COP" : "Police forces",
 "GOV" : "Government: the executive, governing parties",
 "REB" : "Rebels: armed and violent opposition groups, individuals",
 "JUD" : "Judiciary: judges, courts",
 "OPP" : "Political opposition",
 "SPY" : "State intelligence services",
 "UAF" : "Armed forces aligned neither with nor against their government"
}


    

In [6]:

    

import json
primary_role_list = {
 "CRM" : "Criminals",
 "MIL" : "Military: troops, soldiers, all state-military personnel/equipment",
 "BUS" : "Business: businesspeople, companies, and enterprises, not including MNCs",
 "EDU" : "Education: educators, schools, students, or organizations",
 "PTY" : "Political party",
 "CVL" : "Civilian individuals or groups; catch-all",
 "MED" : "Media: journalists, newspapers, television stations"
}


    

In [7]:

    

tempVerb=json.dumps(primary_role_list)
jsonObjectVerb=json.loads(tempVerb)


    

In [10]:

    

import pymongo
from pymongo import MongoClient
client=MongoClient()
client = MongoClient('dalab.ou.edu', 27017)
db=client.lexisnexis
agents=db.agents


    

In [23]:

    

for k,v in jsonObjectVerb.iteritems():
    tempDictionary={};
    tempDictionary['id']=k;
    print(k);
    tempDictionary['name']=k+":"+v;
    agents.insert_one(tempDictionary);


    

    




126
0233
0232
0231
093
094
0234
010
0834
012
013
014
015
016
134
018
139
138
1832
1833
1831
137
090
1444
091
092
1313
1312
1311
1622
025
024
027
026
021
020
023
127
128
028
133
011
135
1821
131
1823
1822
130
106
0332
0333
1412
0331
1414
1381
0334
136
1322
1323
1321
0833
1324
195
1121
1122
017
1124
1125
193
192
115
054
038
039
111
110
113
112
032
033
030
031
036
037
034
035
1712
1711
057
050
051
0842
052
1044
0242
053
1234
0343
1231
1232
1233
0341
0861
1384
108
1123
102
046
045
044
043
042
041
105
0351
0352
1413
0354
0355
0356
2041
1724
1722
1723
1721
0211
0212
1382
1411
1383
074
144
075
103
0871
055
0873
0872
173
0874
171
170
1421
0342
1423
1422
1424
0344
0862
175
145
0863
182
183
180
181
186
104
184
194
040
1212
1213
063
196
064
0244
1042
174
191
1211
185
0831
1434
190
0243
0353
1385
164
1432
166
160
161
162
163
1623
022
1621
1643
114
143
1642
1454
1451
1452
1453
151
150
153
152
072
073
070
071
2042
0241
100
061
165
1641
0814
0813
0812
0811
1433
1443
1442
101
0832
060
0357
201
200
203
202
142
204
140
141
083
082
081
080
087
086
085
084
132
056
1441
154
1043
120
1041
121
122
1431
172
107
123
0841
124
062
0311
0312
125

In [17]:

    

secondary_role_list= {
 "AGR" : "Agriculture: cultivators or gov. agencies",
 "BUS" : "Business: businesspeople, companies, and enterprises, not including MNCs",
 "CRM" : "Criminals",
 "CVL" : "Civilian individuals or groups; catch-all",
 "DEV" : "Development: people and agencies dealing with infrastructure creation, democratization etc.",
 "EDU" : "Education: educators, schools, students, or organizations",
 "ELI" : "Elites: former government officials, celebrities",
 "ENV" : "Environmental: entities for whom environmental and ecological issues",
 "HLH" : "Health: individuals and groups working on health and social welfare",
 "HRI" : "Human Rights: actors documenting and/or correcting human rights concerns",
 "LAB" : "Labor: organized labor, organizations concerned with labor issues",
 "LEG" : "Legislature: parliaments, assemblies, lawmakers",
 "MED" : "Media: journalists, newspapers, television stations",
 "REF" : "Refugees: also refers to agencies dealing with population migration"
}


    

In [13]:

    

secondary_role_list= {
 "MOD" : "Moderates (tertiary code)",
 "RAD" : "Radicals (tertiary code)"
}


    

In [14]:

    

tempVerb=json.dumps(secondary_role_list)
jsonObjectVerb=json.loads(tempVerb)
import pymongo
from pymongo import MongoClient
client=MongoClient()
client = MongoClient('dalab.ou.edu', 27017)
db=client.lexisnexis
secondroles=db.secondroles
for k,v in jsonObjectVerb.iteritems():
    tempDictionary={};
    tempDictionary['id']=k;
    tempDictionary['name']=k+":"+v;
    secondroles.insert_one(tempDictionary);


    

In [ ]: