notebook.community

Edit and run 





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 [17]:



    


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 [22]:



    


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



    











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 [11]:



    


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



    











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 [ ]:

Content source: oudalab/fajita

Similar notebooks:

notebook.community | gallery | about