queries.txt

Show all crises with the same type. ex) natural disaster

name                                       | kind                                 |
+--------------------------------------------+--------------------------------------+
| Northern Mali Conflict                     | Armed Conflict                       |
| Boston Marathon Bombings                   | Bombing                              |
| Savar Building Collapse                    | Building collapse                    |
| NSA Wiretapping                            | Civil Liberties                      |
| War in Darfur                              | Civil War                            |
| Libyan Civil War                           | Civil War                            |
| Syrian Civil War                           | Civil War Crisis                     |
| LGBT Issues in Russia                      | Civil/Human Rights                   |
| US Drone Attacks in Pakistan               | Civilian Casualties of War           |
| Human trafficking                          | Crimes against humanity              |
| South China Maritime Conflicts             | Crimes among nations                 |
| 2008 Sichuan earthquake                    | Earthquake                           |
| Naples trash crisis                        | Environmental                        |
| Bee Colony Collapse Disorder               | Environmental                        |
| Fresh Water Scarcity                       | Environmental                        |
| Deforestation                              | Environmental                        |
| Deepwater Horizon Oil Spill                | Environmental Disaster               |
| AIDS                                       | Epidemic                             |
| Malaria                                    | Epidemic                             |
| Space Shuttle Challenger Disaster          | Equipment malfunction, disaster      |
| Columbia Space Shuttle Disaster            | Equipment malfunction, disaster      |
| Global financial crisis                    | Financial crisis                     |
| Exxon Valdez Oil Spill                     | Human-caused environmental disasters |
| North Korean Conflict                      | International tension                |
| 2012 Aurora Shooting                       | Mass Shooting                        |
| 2013 Alabama bunker hostage crisis         | Mass Shooting                        |
| 2011 Tohoku Earthquake and Tsunami         | Megathrust Earthquake                |
| LRA Conflict                               | Military/Human Rights                |
| Democracy in China                         | National movement                    |
| Hurricane Ike                              | Natural Disaster                     |
| Water Scarcity in Africa                   | Natural Disaster                     |
| Katrina                                    | Natural Disaster                     |
| Hurricane Sandy                            | natural disaster                     |
| 2010 Copiago mining accident               | Natural Disaster                     |
| Arizona Wildfires                          | Natural disaster                     |
| Texas Wild Fires                           | Natural disaster                     |
| Moore, Oklahoma Tornado                    | Natural Disaster                     |
| 2010 Haiti Earthquake                      | Natural Disaster                     |
| 2013 Northern India Floods                 | Natural Disaster                     |
| Cyclone Nargis                             | Natural Disaster                     |
| Indian Ocean Tsunami and Earthquake (2004) | Natural Disaster                     |
| Fukushima Daiichi Nuclear Disaster         | Nuclear Power Plant Failure          |
| Influenza A virus subtype H1N1             | Pandemic                             |
| Piracy in Somalia                          | Piracy                               |
| West Fertilizer Plant Explosion            | Plant explosion                      |
| Political Unrest in Egypt                  | Political Revolution                 |
| KKK in Memphis                             | Political Unrest                     |
| 2013 protests in Turkey                    | Protests                             |
| Nuclear Disasters                          | Radioactive                          |
| 2008 Raid on Religious Compound            | Raid                                 |
| Debt in Europe                             | Recession                            |
| Brazilian Protests                         | Socioeconomic Crisis                 |
| Sandy Hook Elementary School Shooting      | Spree Shooting                       |
| Zimbabwe Conflict Diamonds                 | Systemic Exploitation                |
| Oslo Shootings                             | Terrorism                            |
| September 11th                             | Terrorism                            |
| 2008 Mumbai attacks                        | Terrorist attack                     |
| 2011 Norway attacks                        | Terrorist Attack                     |
| Oklahoma City Bombings                     | Terrorist attack, national tragedy   |
| Mexican Drug Violence                      | Violent Conflict                     |
| Baghdad Airstrike                          | War                                  |
| Iraq War                                   | War                             



Show all organizations with three or more people



+-------------------------------------+--------------------------------------------+
| name                                | people                                     |
+-------------------------------------+--------------------------------------------+
| Federal Emergency Management Agency | ['PER_RPERRY', 'PER_GWBUSH', 'PER_KATBLA'] |
+-------------------------------------+--------------------------------------------+







Show all organizations founded within the last half century (since 1963).


name                                                       |
+------------------------------------------------------------+
| African Union                                              |
| BNP Paribas                                                |
| Child Protective Services                                  |
| Department of Homeland Security                            |
| Egyptian Government                                        |
| Federal Emergency Management Agency                        |
| Fundamentalist Church of Jesus Christ of Latter Day Saints |
| General Electric                                           |
| Government of Mexico                                       |
| IndustriALL Global Union                                   |
| International Union for Conservation of Nature             |
| Invisible Children                                         |
| Iraq and Afghanistan Veterans of America                   |
| Ku Klux Klan                                               |
| Lashkar-e-Taiba                                            |
| LGBT Human Rights Project GayRussia.Ru                     |
| Morton-Thiokol                                             |
| National Oceanic and Atmospheric Administration            |
| National Security Agency                                   |
| National Transitional Council                              |
| Nothing But Nets                                           |
| Oklahoma City National Memorial Foundation                 |
| Pink Ribbon Red Ribbon                                     |
| Polaris Project                                            |
| Salvation Army                                             |
| San Estaban Mining Company                                 |
| Sichuan Quake Relief                                       |
| Supreme Council of the Armed Forces                        |
| Texas Commission on Environmental Quality                  |
| The Community First Foundation                             |
| The Global Fund                                            |
| Twitter                                                    |
| United Nations                                             |
| United Way                                                 |
| Valve                                                      |
| Water.org                                                  |
| Wikileaks                                                  |
+---------------------------------------------------




show citations and external links associated with crisis




name                                       | href                                                                                                                                                                                                                                                                                                    |
+--------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2008 Mumbai attacks                        | http://en.wikipedia.org/wiki/Ajmal_Kasab                                                                                                                                                                                                                                                                |
| 2008 Mumbai attacks                        | http://en.wikipedia.org/wiki/Lashkar-e-Taiba                                                                                                                                                                                                                                                            |
| 2008 Raid on Religious Compound            | http://en.wikipedia.org/wiki/Fundamentalist_Church_of_Jesus_Christ_of_Latter-Day_Saints                                                                                                                                                                                                                 |
| 2008 Sichuan earthquake                    | http://en.wikipedia.org/wiki/2008_Sichuan_earthquake                                                                                                                                                                                                                                                    |
| 2010 Copiago mining accident               | http://www.guardian.co.uk/world/2010/sep/05/luis-urzua-chile-trapped-miners                                                                                                                                                                                                                             |
| 2010 Copiago mining accident               | http://en.wikipedia.org/wiki/Compa%C3%B1%C3%ADa_Minera_San_Esteban_Primera                                                                                                                                                                                                                              |
| 2010 Haiti Earthquake                      | http://en.wikipedia.org/wiki/2010_Haiti_earthquake                                                                                                                                                                                                                                                      |
| 2010 Haiti Earthquake                      | http://news.nationalgeographic.com/news/2010/01/100113-haiti-earthquake-red-cross/                                                                                                                                                                                                                      |
| 2010 Haiti Earthquake                      | http://www.trust.org/spotlight/Haiti-earthquake-2010                                                                                                                                                                                                                                                    |
| 2010 Haiti Earthquake                      | http://insidedisaster.com/haiti/                                                                                                                                                                                                                                                                        |
| 2010 Haiti Earthquake                      | http://haitiearthquake.web.unc.edu/economic-impact-of-the-earthquake/                                                                                                                                                                                                                                   |
| 2010 Haiti Earthquake                      | http://www.rdp.sg/film/haiti/                                                                                                                                                                                                                                                                           |
| 2010 Haiti Earthquake                      | http://www.nj.com/news/index.ssf/2010/04/haitis_ambassador_to_us_says_e.html                                                                                                                                                                                                                            |
| 2010 Haiti Earthquake                      | http://www.telegraph.co.uk/news/worldnews/centralamericaandthecaribbean/haiti/7022556/Haiti-earthquake-Wyclef-Jean-calls-for-evacuation-of-Port-au-Prince.html                                                                                                                                          |
| 2010 Haiti Earthquake                      | http://www.canada.com/news/Hard+power+needed+Haiti+Harper/2572453/story.html                                                                                                                                                                                                                            |
| 2010 Haiti Earthquake                      | https://en.wikipedia.org/wiki/2010_Haiti_earthquake                                                                                                                                                                                                                                                     |
| 2011 Norway attacks                        | http://en.wikipedia.org/wiki/2011_Norway_attacks                                                                                                                                                                                                                                                        |
| 2011 Tohoku Earthquake and Tsunami         | http://en.wikipedia.org/wiki/2011_T%C5%8Dhoku_earthquake_and_tsunami                                                                                                                                                                                                                                    |
| 2012 Aurora Shooting                       | http://www.communityfirstfoundation.org/index.cfm                                                                                                                                                                                                                                                       |
| 2012 Aurora Shooting                       | http://en.wikipedia.org/wiki/James_Eagan_Holmes                                                                                                                                                                                                                                                         |
| 2013 Northern India Floods                 | http://uttarakhandfloodrelief.org/                                                                                                                                                                                                                                                                      |
| 2013 Northern India Floods                 | http://en.wikipedia.org/wiki/2013_North_India_floods                                                                                                                                                                                                                                                    |
| 2013 protests in Turkey                    | https://en.wikipedia.org/wiki/2013_protests_in_Turkey                                                                                                                                                                                                                                                   |
| AIDS                                       | http://www.un.org/millenniumgoals/                                                                                                                                                                                                                                                                      |
| AIDS                                       | http://www.avert.org/testing.htm                                                                                                                                                                                                                                                                        |
| AIDS                                       | http://en.wikipedia.org/wiki/HIV/AIDS                                                                                                                                                                                                                                                                   |
| AIDS                                       | http://en.wikipedia.org/wiki/Economic_impact_of_HIV/AIDS                                                                                                                                                                                                                                                |
| AIDS                                       | http://www.prezista.com/patients/hiv-background-treatment/hiv-can-be-treated?utm_source=google&utm_medium=cpc&utm_campaign=2013+HIV+Exact&utm_term=hiv&utm_content=HIV|mkwid|sSvTL7NiZ_dc|pcrid|26371199230                                                                                             |
| AIDS                                       | http://www.isentress.com/raltegravir/isentress/consumer/what_is_hiv/index.jsp?utm_source=google&utm_medium=cpc&utm_campaign=about_hiv&sctp=ppc&scvn=google&scsrc=google_search&sckw=hiv%20info&MTD=2&ENG=1&CPN=1&CAMP=3&utm_content=svukqQ1y0|pcrid|25844449620|pmt|b|kw|hiv%20info&utm_term=hiv%20info |
| AIDS                                       | https://en.wikipedia.org/wiki/AIDS/HIV                                                                                                                                                                                                                                                                  |
| Arizona Wildfires                          | http://www.abc15.com/subindex/news/wildfires                                                                                                                                                                                                                                                            |
| Bee Colony Collapse Disorder               | http://thebeephotographer.photoshelter.com/gallery/Hand-Pollination-in-China/G0000M46TBQX4Odc/                                                                                                                                                                                                          |
| Bee Colony Collapse Disorder               | https://en.wikipedia.org/wiki/List_of_crop_plants_pollinated_by_bees                                                                                                                                                                                                                                    |
| Brazilian Protests                         | http://en.wikipedia.org/wiki/2013_protests_in_Brazil                                                                                                                                                                                                                                                    |
| Brazilian Protests                         | http://brazilprotestsguide.blogspot.ch/                                                                                                                                                                                                                                                                 |
| Columbia Space Shuttle Disaster            | http://www.space.com/19436-columbia-disaster.html                                                                                                                                                                                                                                                       |
| Columbia Space Shuttle Disaster            | http://www.space.com/19526-columbia-shuttle-disaster-explained-infographic.html                                                                                                                                                                                                                         |
| Debt in Europe                             | http://en.wikipedia.org/wiki/European_sovereign-debt_crisis                                                                                                                                                                                                                                             |
| Debt in Europe                             | http://www.imf.org/external/index.htm                                                                                                                                                                                                                                                                   |
| Debt in Europe                             | http://en.wikipedia.org/wiki/European_Central_Bank                                                                                                                                                                                                                                                      |
| Deepwater Horizon Oil Spill                | http://en.wikipedia.org/wiki/Deepwater_Horizon_oil_spill                                                                                                                                                                                                                                                |
| Democracy in China                         | http://goo.gl/maps/GOc2U                                                                                                                                                                                                                                                                                |
| Exxon Valdez Oil Spill                     | http://en.wikipedia.org/wiki/Exxon_Valdez_oil_spill                                                                                                                                                                                                                                                     |
| Exxon Valdez Oil Spill                     | http://www.epa.gov/osweroe1/content/learning/exxon.htm                                                                                                                                                                                                                                                  |
| Exxon Valdez Oil Spill                     | http://www.alaskadispatch.com/article/former-gov-cowper-exxon-valdez-we-couldn-t-just-throw-towel                                                                                                                                                                                                       |
| Exxon Valdez Oil Spill                     | http://www.nola.com/news/gulf-oil-spill/index.ssf/2010/06/alaskas_present_after_1989_exxon_valdez_oil_spill_might_be_gulf_coast_future.html                                                                                                                                                             |
| Exxon Valdez Oil Spill                     | http://arcticcircle.uconn.edu/SEEJ/Alaska/miller2.htm                                                                                                                                                                                                                                                   |
| Exxon Valdez Oil Spill                     | https://en.wikipedia.org/wiki/Exxon_Valdez_oil_spill                                                                                                                                                                                                                                                    |
| Fresh Water Scarcity                       | http://en.wikipedia.org/wiki/Water_crisis                                                                                                                                                                                                                                                               |
| Fresh Water Scarcity                       | http://www.unicef.org/specialsession/about/sgreport-pdf/03_SafeDrinkingWater_D7341Insert_English.pdf                                                                                                                                                                                                    |
| Fresh Water Scarcity                       | http://www.fao.org/english/newsroom/news/2003/15254-en.html                                                                                                                                                                                                                                             |
| Fresh Water Scarcity                       | http://www.redorbit.com/news/science/1367352/desalination_is_the_solution_to_water_shortages/                                                                                                                                                                                                           |
| Fresh Water Scarcity                       | http://www.utexas.edu/news/2008/07/22/desalination/                                                                                                                                                                                                                                                     |
| Fukushima Daiichi Nuclear Disaster         | http://www.who.int/mediacentre/news/releases/2013/fukushima_report_20130228/en/                                                                                                                                                                                                                         |
| Fukushima Daiichi Nuclear Disaster         | http://en.wikipedia.org/wiki/Fukushima_Daiichi_nuclear_disaster#Response                                                                                                                                                                                                                                |
| Fukushima Daiichi Nuclear Disaster         | http://upload.wikimedia.org/wikipedia/commons/thumb/0/04/Nuclear_plants_Japan_in_2011.svg/600px-Nuclear_plants_Japan_in_2011.svg.png                                                                                                                                                                    |
| Fukushima Daiichi Nuclear Disaster         | http://en.wikipedia.org/wiki/Masataka_Shimizu                                                                                                                                                                                                                                                           |
| Human trafficking                          | http://www.somaly.org/sites/default/files/logo.gif                                                                                                                                                                                                                                                      |
| Human trafficking                          | http://en.wikipedia.org/wiki/Invisible_Children,_Inc.                                                                                                                                                                                                                                                   |
| Hurricane Sandy                            | http://en.wikipedia.org/wiki/Hurricane_Sandy                                                                                                                                                                                                                                                            |
| Hurricane Sandy                            | http://crisiswiki.org/2012_Hurricane_Sandy                                                                                                                                                                                                                                                              |
| Indian Ocean Tsunami and Earthquake (2004) | http://news.nationalgeographic.com/news/2004/12/1227_041226_tsunami.html                                                                                                                                                                                                                                |
| Indian Ocean Tsunami and Earthquake (2004) | http://en.wikipedia.org/wiki/2004_Indian_Ocean_earthquake_and_tsunami                                                                                                                                                                                                                                   |
| Katrina                                    | http://en.wikipedia.org/wiki/Hurricane_Katrina                                                                                                                                                                                                                                                          |
| KKK in Memphis                             | http://www.foxnews.com/us/2013/03/31/klan-protests-in-memphis-over-renaming-confederate-parks/                                                                                                                                                                                                          |
| LGBT Issues in Russia                      | http://en.wikipedia.org/wiki/LGBT_rights_in_Russia                                                                                                                                                                                                                                                      |
| Libyan Civil War                           | en.wikipedia.org/wiki/Libyan_civil_war                                                                                                                                                                                                                                                                  |
| Malaria                                    | http://www.malarianomore.org/pages/the-solution                                                                                                                                                                                                                                                         |
| Mexican Drug Violence                      | http://www.bbc.co.uk/news/world-latin-america-10681249                                                                                                                                                                                                                                                  |
| Mexican Drug Violence                      | http://www.borderlandbeat.com/2011/03/report-230000-displaced-by-mexicos-drug.html                                                                                                                                                                                                                      |
| Mexican Drug Violence                      | http://www.nbcnews.com/id/42232161/ns/us_news-crime_and_courts/t/more-will-die-mexico-drug-wars-claim-us-lives/#.UdiLBRX1Mak                                                                                                                                                                            |
| Mexican Drug Violence                      | http://www.state.gov/j/tip/rls/tiprpt/2012/192367.htm                                                                                                                                                                                                                                                   |
| Mexican Drug Violence                      | http://www.bbc.co.uk/news/business-13120598                                                                                                                                                                                                                                                             |
| Mexican Drug Violence                      | http://www.gov.harvard.edu/files/Rios2008_MexicanDrugMarket.pdf                                                                                                                                                                                                                                         |
| Mexican Drug Violence                      | http://www.rand.org/news/press/2010/10/12.html                                                                                                                                                                                                                                                          |
| Naples trash crisis                        | https://en.wikipedia.org/wiki/Naples_waste_management_issue                                                                                                                                                                                                                                             |
| Northern Mali Conflict                     | http://en.wikipedia.org/wiki/Northern_Mali_conflict                                                                                                                                                                                                                                                     |
| NSA Wiretapping                            | http://en.wikipedia.org/wiki/PRISM_(surveillance_program)                                                                                                                                                                                                                                               |
| NSA Wiretapping                            | http://www.businessweek.com/news/2013-06-30/europe-shocked-as-spiegel-publishes-report-of-nsa-wiretapping                                                                                                                                                                                               |
| NSA Wiretapping                            | http://en.wikipedia.org/wiki/NSA_warrantless_surveillance_controversy                                                                                                                                                                                                                                   |
| NSA Wiretapping                            | http://en.wikipedia.org/wiki/NSA_call_database                                                                                                                                                                                                                                                          |
| NSA Wiretapping                            | http://www.huffingtonpost.com/peter-h-schuck/national-security_b_3543312.html                                                                                                                                                                                                                           |
| NSA Wiretapping                            | http://www.guardian.co.uk/world/2013/jun/06/nsa-phone-records-verizon-court-order                                                                                                                                                                                                                       |
| NSA Wiretapping                            | http://www.washingtonpost.com/www.washingtonpost.com/investigations/us-intelligence-mining-data-from-nine-us-internet-companies-in-broad-secret-program/2013/06/06/3a0c0da8-cebf-11e2-8845-d970ccb04497_story.html                                                                                      |
| NSA Wiretapping                            | https://www.eff.org/deeplinks/2012/08/ny-times-reminds-us-nsa-still-warrantlessly-wiretapping-americans-and-congress-has                                                                                                                                                                                |
| NSA Wiretapping                            | http://www.nytimes.com/2013/06/28/opinion/the-criminal-nsa.html?pagewanted=all&_r=0                                                                                                                                                                                                                     |
| NSA Wiretapping                            | http://www.guardian.co.uk/world/2013/jul/04/european-us-internet-providers-nsa                                                                                                                                                                                                                          |
| Nuclear Disasters                          | https://en.wikipedia.org/wiki/Chernobyl_disaster                                                                                                                                                                                                                                                        |
| Nuclear Disasters                          | http://en.wikipedia.org/wiki/List_of_nuclear_power_accidents_by_country                                                                                                                                                                                                                                 |
| Oklahoma City Bombings                     | http://web.archive.org/web/20080110063748/http://www.health.state.ok.us/PROGRAM/injury/Summary/bomb/OKCbomb.htm                                                                                                                                                                                         |
| Political Unrest in Egypt                  | https://en.wikipedia.org/wiki/2011_Egyptian_revolution#cite_note-autogenerated3-16                                                                                                                                                                                                                      |
| Political Unrest in Egypt                  | http://www.livescience.com/38023-protecting-egypt-artifacts-during-crisis.html                                                                                                                                                                                                                          |
| Political Unrest in Egypt                  | https://en.wikipedia.org/wiki/2011_Egyptian_revolution                                                                                                                                                                                                                                                  |
| Political Unrest in Egypt                  | http://www.bbc.co.uk/news/world-middle-east-23228297                                                                                                                                                                                                                                                    |
| Political Unrest in Egypt                  | http://en.wikipedia.org/wiki/2012%E2%80%9313_Egyptian_protests                                                                                                                                                                                                                                          |
| Political Unrest in Egypt                  | https://en.wikipedia.org/wiki/2012%E2%80%9313_Egyptian_protests                                                                                                                                                                                                                                         |
| Sandy Hook Elementary School Shooting      | http://en.wikipedia.org/wiki/Newtown_shooting                                                                                                                                                                                                                                                           |
| Savar Building Collapse                    | http://www.nytimes.com/2013/05/23/world/asia/report-on-bangladesh-building-collapse-finds-widespread-blame.html?_r=0                                                                                                                                                                                    |
| Savar Building Collapse                    | http://www.cnn.com/2013/05/14/world/asia/bangladesh-building-collapse-aftermath                                                                                                                                                                                                                         |
| September 11th                             | http://en.wikipedia.org/wiki/Rescue_and_recovery_effort_after_the_September_11_attacks                                                                                                                                                                                                                  |
| September 11th                             | http://en.wikipedia.org/wiki/September_11_attacks                                                                                                                                                                                                                                                       |
| September 11th                             | https://en.wikipedia.org/wiki/September_11_Attacks                                                                                                                                                                                                                                                      |
| Texas Wild Fires                           | http://en.wikipedia.org/wiki/2011_Texas_wildfires                                                                                                                                                                                                                                                       |
| Texas Wild Fires                           | http://www.huffingtonpost.com/2011/04/11/texas-wildfires-2011-video_n_847776.html                                                                                                                                                                                                                       |
| Texas Wild Fires                           | http://www.kvue.com/news/state/FEMA-reimburses-Texas-nearly-48M-after-wildfires-214925101.html                                                                                                                                                                                                          |
| Texas Wild Fires                           | http://www.csmonitor.com/USA/Politics/2011/0907/Texas-wildfires-Is-Rick-Perry-being-hypocritical-asking-for-federal-aid                                                                                                                                                                                 |
| Texas Wild Fires                           | http://www.cnn.com/2011/US/09/06/texas.fires/index.html                                                                                                                                                                                                                                                 |
| US Drone Attacks in Pakistan               | http://en.wikipedia.org/wiki/Drone_attacks_in_Pakistan                                                                                                                                                                                                                                                  |
| US Drone Attacks in Pakistan               | http://www.thebureauinvestigates.com/2013/01/03/obama-2013-pakistan-drone-strikes/                                                                                                                                                                                                                      |
| US Drone Attacks in Pakistan               | http://www.livingunderdrones.org/living-under-drones/                                                                                                                                                                                                                                                   |
| US Drone Attacks in Pakistan               | http://www.washingtonpost.com/national/national-security/under-obama-an-emerging-global-apparatus-for-drone-killing/2011/12/13/gIQANPdILP_story.html                                                                                                                                                    |
| West Fertilizer Plant Explosion            | http://www.wjla.com/articles/2013/04/west-fertilizer-co-explosion-damage-to-cost-100-million-group-says-87912.html                                                                                                                                                                                      |
| West Fertilizer Plant Explosion            | http://www.wsws.org/en/articles/2013/05/27/west-m27.html                                                                                                                                                                                                                                                |
| Zimbabwe Conflict Diamonds                 | http://www.globalwitness.org/conflict-diamonds                                                                                                                                                                                                                                                          |
| Zimbabwe Conflict Diamonds                 | http://www.kimberleyprocess.com/web/kimberley-process/kp-basics                                                                                                                                                                                                                                         |
| Zimbabwe Conflict Diamonds                 | http://www.humantraffickingmovie.com/stopping-blood-diamonds.html                                                                                                                                                                                                                                       |
+--------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
116 rows in set (0.00 sec)


Show all people with videos associated with Red Cross


+------------------+
| name             |
+------------------+
| Barack Obama     |
| Gail J. McGovern |
+------------------+
2 rows in set (0.00 sec)





Show all organizations related to crises that are natural disasters (using kind).

+--------------------------------------------+------------------+
| name                                       | kind             |
+--------------------------------------------+------------------+
| Hurricane Ike                              | Natural Disaster |
| Water Scarcity in Africa                   | Natural Disaster |
| Katrina                                    | Natural Disaster |
| 2011 Tohoku Earthquake and Tsunami         | Natural Disaster |
| Hurricane Sandy                            | natural disaster |
| 2010 Copiago mining accident               | Natural Disaster |
| Arizona Wildfires                          | Natural disaster |
| Texas Wild Fires                           | Natural disaster |
| 2010 Haiti Earthquake                      | Natural Disaster |
| Moore, Oklahoma Tornado                    | Natural Disaster |
| 2013 Northern India Floods                 | Natural Disaster |
| Cyclone Nargis                             | Natural Disaster |
| Indian Ocean Tsunami and Earthquake (2004) | Natural Disaster |
+--------------------------------------------+------------------+
13 rows in set (0.00 sec)





Crises whose kind value contains the word "shooting



+------------------------------------+---------------+
| name                               | kind          |
+------------------------------------+---------------+
| 2012 Aurora Shooting               | Mass Shooting |
| 2013 Alabama bunker hostage crisis | Mass Shooting |
+------------------------------------+---------------+
2 rows in set (0.00 sec)





Crises that took place in Texas (Location data should contain "Texas" or "TX")



+---------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| name                            | location                                                                                                                                                                         |
+---------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Hurricane Ike                   | ['Turks and Caicos, Bahamas, Haiti, Dominican Republic, Cuba, Florida Keys, Mississippi, Louisiana, Texas, Mississippi Valley, Ohio Valley, Great Lakes region, Eastern Canada'] |
| 2008 Raid on Religious Compound | ['Eldorado, Texas United States']                                                                                                                                                |
| Texas Wild Fires                | ['Texas']                                                                                                                                                                        |
| West Fertilizer Plant Explosion | ['West, Texas']                                                                                                                                                                  |
| Columbia Space Shuttle Disaster | ['Dallas, Texas']                                                                                                                                                                |
+---------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)






Show the name and economic impact of natural disasters occuring after 2001.

--------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------+
| name                                       | economicImpact                                                                                                                |
+--------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------+
| Hurricane Ike                              | ['37.5 billion (2008 USD)']                                                                                                   |
| Katrina                                    | ['Over $100 billion worth of damage']                                                                                         |
| Cyclone Nargis                             | ['Damage was estimated at over US$10 billion, which made it the most damaging cyclone ever recorded in this basin.']          |
| Indian Ocean Tsunami and Earthquake (2004) | ['Damages worth 5.59 Billion USD', 'Loss of property worth 4.33 Billion USD', 'Total economic impact worth 9.93 billion USD'] |
+--------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------+


Name, type, and location of all organizations (no duplicates).


+--------------------------------------------------------------------+--------------------------------------------------------+---------------------------------------------------+
| name                                                               | kind                                                   | location                                          |
+--------------------------------------------------------------------+--------------------------------------------------------+---------------------------------------------------+
| Care                                                               | Humanitarian                                           | Atlanta, USA                                      |
| UNICEF                                                             | Humanitarian                                           | New York, USA                                     |
| Wikileaks                                                          | Nonprofit document archive and disclosure              | Online                                            |
| al-Qaeda                                                           | Terrorist                                              | World Wide                                        |
| World Health Organization                                          | Public Health                                          | Geneva, Switzerland                               |
| Centers for Disease Control and Prevention                         | Public Health                                          | Georgia, USA                                      |
| Oil Spill Recovery Institute                                       | Enviromental                                           | Alaska                                            |
| Egyptian Organization for Human Rights                             | Human Rights                                           | Egypt                                             |
| Iraq and Afghanistan Veterans of America                           | Advocacy group dedicated to US veterans                | New York, USA                                     |
| Ku Klux Klan                                                       | Far-right organization                                 | United States                                     |
| Sicilian Mafia                                                     | Crime Organization                                     | Mainly Italy but also spread throughout the world |
| British Petroleum                                                  | Bio-Refinery                                           | UK                                                |
| Department of Homeland Security                                    | Government                                             | USA                                               |
| Magic Johnson Foundation                                           | Charity                                                | Beverly Hills, CA                                 |
| Red Cross                                                          | relief organization                                    | Washington, D.C, United States of America         |
| International Monetary Fund                                        | economic                                               | Washington, D.C.                                  |
| Federal Emergency Management Agency                                | Disaster Relief                                        | 500 C Street SW, Washington, DC 20472             |
| Environmental Protection Agency                                    | Government organization                                | 1200 Pennsylvania Ave. NW Washington, DC 20460    |
| United Nations                                                     | international organization                             | New York City, USA                                |
| National Oceanic and Atmospheric Administration                    | scientific agency                                      | Silver Spring, Maryland, USA                      |
| International Maritime Organization                                | Maritime Regulation                                    | London, United Kingdom                            |
| Tokyo Electric Power Comapny                                       | Power Provider                                         | Chiyoda, Tokyo, Japan                             |
| General Electric                                                   | American Multinational Conglomerate corporation        | Fairfield, Connecticut                            |
| Catholic Church                                                    | religious establishment                                | Vatican City, Italy                               |
| Morton-Thiokol                                                     | Chemical Corporation                                   | Huntsville, Alabama                               |
| National Aeronautics and Space Administration (NASA)               | Government Organization                                | Washington, DC                                    |
| Joint United Nations Programme on HIV/AIDS                         | Humanitarian Health                                    | Geneva, Switzerland                               |
| The Community First Foundation                                     | Fund-Raising Group                                     | Colorado                                          |
| San Estaban Mining Company                                         | Mining Company                                         | Santiago, Chile                                   |
| Lashkar-e-Taiba                                                    | Terrorist Organization                                 | Pakistan                                          |
| Child Protective Services                                          | Child Protection                                       | Austin, Texas                                     |
| Fundamentalist Church of Jesus Christ of Latter Day Saints         | Church                                                 | Hildale, Utah                                     |
| Federal Bureau of Investigation                                    | Government agency                                      | Washington, D.C                                   |
| Central Intelligence Agency                                        | Government agency                                      | Washington, D.C                                   |
| Valve                                                              | Privately owned Software company                       | Bellevue, WA                                      |
| Salvation Army                                                     | Charity                                                | Alexandria, VA                                    |
| Polaris Project                                                    | NGO, humanitarian                                      | Headquarters in Washington, D.C.                  |
| ASEAN                                                              | Geo-political and economic organization                | Jakarta, indonesia                                |
| BNP Paribas                                                        | Global banking group                                   | Boulevard des Italiens, Paris, France             |
| Prescott Fire Department                                           | Municipal fire department                              | Prescott, Arizona                                 |
| Somaly Mam Foundation                                              | Nonprofit humanitarian organization                    | New York                                          |
| Pink Ribbon Red Ribbon                                             | Humanitarian                                           | Africa and Latin America                          |
| Invisible Children                                                 | Humanitarian                                           | Central Africa                                    |
| The Union of Concerned Scientists                                  | Activist organization                                  | USA                                               |
| National Security Agency                                           | Government organization                                | Fort Meade, Maryland                              |
| The Muslim Brotherhood                                             | Activist organization                                  | Egypt                                             |
| Egyptian Government                                                | Government organization                                | Egypt                                             |
| International Union for Conservation of Nature                     | Activist organization                                  | Global                                            |
| Sinaloa Cartel                                                     | Criminal organization                                  | Mexico                                            |
| Los Zetas Cartel                                                   | Criminal organization                                  | Mexico                                            |
| Government of Mexico                                               | Government organization                                | Mexico                                            |
| LGBT Human Rights Project GayRussia.Ru                             | Activist organization                                  | Russia                                            |
| Brazilian Government                                               | Government organization                                | Brasilia, Brazil                                  |
| Water.org                                                          | Activist organization                                  | United States                                     |
| Texas Commission on Environmental Quality                          | Environmental Agency                                   | Austin, Texas                                     |
| Oklahoma National Guard                                            | Government Organization                                | Oklahoma City, OK                                 |
| Oklahoma City National Memorial Foundation                         | Private Organization                                   | Oklahoma CIty, OK                                 |
| IndustriALL Global Union                                           | Union                                                  | Geneva, Switzerland                               |
| The Global Fund                                                    | International Financing Organization                   | India                                             |
| Prime Minister's Relief Fund                                       | Governement Fund                                       | India                                             |
| United Nations Office for the Coordination of Humanitarian Affairs | Inter Agency Body                                      | United States of America                          |
| United Nations                                                     | Interational Cooperative                               | Worldwide                                         |
| Bill and Melinda Gates Foundation                                  | Interational Cooperative                               | Worldwide                                         |
| Nothing But Nets                                                   | Charity                                                | Worldwide                                         |
| Central Intelligence Agency                                        | Governmental Intelligence                              | Langley, VA                                       |
| Supreme Council of the Armed Forces                                | Governing body of Egyptian military                    | Cairo, Egypt                                      |
| Labour Party (Norway)                                              | Party                                                  | Norway                                            |
| Disasters Emergency Committee                                      | Umbrella Organization for 14 Humanitarian Aid Agencies | London, England                                   |
+--------------------------------------------------------------------+--------------------------------------------------------+---------------------------------------------------+
68 rows in set (0.00 sec)