https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F954461%2F41f0017368e1043a2c643aea10cbb3e4%2FgoogleDataStudio.jpg?generation=1561570478866938&alt=media" alt="">

Context

This dataset will be used to help users get familiar with Google Data Studio. It's also a great way to mix history with data visualization skills.

Later I will develop a lesson that will help new users get up to speed with Google Data Studio. This dataset is small, but it will be a good dataset to start with. The same concepts learned with this project will be used with larger datasets.

Content

This data comes from wikipedia.

Acknowledgements

wikipedia

https://en.wikipedia.org/wiki/United_States_military_casualties_of_war

Inspiration

Project based learning. Get it going! Teach kids using data.

Colombia CO: Battle-Related Deaths: Number of People data was reported at 87.000 Person in 2023. This records a decrease from the previous number of 107.000 Person for 2022. Colombia CO: Battle-Related Deaths: Number of People data is updated yearly, averaging 398.000 Person from Dec 1989 (Median) to 2023, with 34 observations. The data reached an all-time high of 3,392.000 Person in 2002 and a record low of 23.000 Person in 2020. Colombia CO: Battle-Related Deaths: Number of People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Colombia – Table CO.World Bank.WDI: Population and Urbanization Statistics. Battle-related deaths are deaths in battle-related conflicts between warring parties in the conflict dyad (two conflict units that are parties to a conflict). Typically, battle-related deaths occur in warfare involving the armed forces of the warring parties. This includes traditional battlefield fighting, guerrilla activities, and all kinds of bombardments of military units, cities, and villages, etc. The targets are usually the military itself and its installations or state institutions and state representatives, but there is often substantial collateral damage in the form of civilians being killed in crossfire, in indiscriminate bombings, etc. All deaths--military as well as civilian--incurred in such situations, are counted as battle-related deaths.;Uppsala Conflict Data Program, http://www.pcr.uu.se/research/ucdp/.;Sum;

Analysis of ‘The Lost Journalists: Dataset of journalist deaths’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/yamqwe/journalist-deathse on 13 February 2022.

--- Dataset description provided by original source is as follows ---

Credit for the original dataset goes to CPJ

About this dataset

In-the-News:

• NRT: AT LEAST 122 MEDIA PROFESSIONALS KILLED GLOBALLY IN 2016
• All Africa: Africa: Journalist Killings Ease From Record Highs As Murders Down, Combat Deaths Up
• BBC: The lost journalists of 2016

https://data.world/api/journalism/dataset/journalist-deaths/file/raw/journalist_deaths_by_year.png" alt="journalist_deaths_by_year.png">

Methodology

CPJ began compiling detailed records on journalist deaths in 1992. We apply strict journalistic standards when investigating a death. One important aspect of our research is determining whether a death was work-related. As a result, we classify deaths as "motive confirmed" or "motive unconfirmed."

We consider a case "confirmed" only if we are reasonably certain that a journalist was murdered in direct reprisal for his or her work; was killed in crossfire during combat situations; or was killed while carrying out a dangerous assignment such as coverage of a street protest. We do not include journalists who are killed in accidents such as car or plane crashes.

We include only confirmed cases in the statistical analyses in this database.

When the motive is unclear, but it is possible that a journalist was killed because of his or her work, CPJ classifies the case as "unconfirmed" and continues to investigate. We regularly reclassify cases based on our ongoing research.

Our archives include narrative capsules of all journalists killed, including the cases in which the motive is unconfirmed. In cases where the place of death is incidental to the journalist's killing, we have listed the country where the fatal attack occurred to be the place of the journalist's death (for example, in a case where a journalist is hit by shrapnel in one country and evacuated to another, where he or she dies, CPJ lists the country in which he or she was hit as the place of death).

CPJ defines journalists as people who cover news or comment on public affairs through any media -- including in print, in photographs, on radio, on television, and online. We take up cases involving staff journalists, freelancers, stringers, bloggers, and citizen journalists. The combination of daily reporting and statistical data forms the basis of our case-driven and long-term advocacy.

In 2003, CPJ began documenting the deaths of media support workers. We did so in recognition of the vital role these individuals play in newsgathering. These workers include translators, drivers, fixers, and administrative workers.

Our archives include narrative capsules for media workers killed on duty. These cases are not included our statistical analyses.

About CPJ

The Committee to Protect Journalists is an independent, nonprofit organization that promotes press freedom worldwide. We defend the right of journalists to report the news without fear of reprisal.

Additional Reading
Investigative journalism in Africa – “Walking through a minefield at midnight”
Iraq: The deadliest war for journalists
Being a journalist in Mexico is getting even more dangerous

Source: Committee to Protect Journalists

This dataset was created by Journalism, News, and Media and contains around 2000 samples along with Date, Unnamed: 18, technical information and other features such as: - Local/ Foreign - Unnamed: 20 - and more.

How to use this dataset

• Analyze Coverage in relation to Taken Captive
• Study the influence of Organization on Unnamed: 21
• More datasets

Acknowledgements

If you use this dataset in your research, please credit Journalism, News, and Media

Start A New Notebook!

--- Original source retains full ownership of the source dataset ---

Israel IL: Battle-Related Deaths: Number of People data was reported at 1,671.000 Person in 2014. This records an increase from the previous number of 64.000 Person for 2012. Israel IL: Battle-Related Deaths: Number of People data is updated yearly, averaging 74.000 Person from Dec 1989 (Median) to 2014, with 22 observations. The data reached an all-time high of 1,671.000 Person in 2014 and a record low of 5.000 Person in 1989. Israel IL: Battle-Related Deaths: Number of People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Israel – Table IL.World Bank.WDI: Population and Urbanization Statistics. Battle-related deaths are deaths in battle-related conflicts between warring parties in the conflict dyad (two conflict units that are parties to a conflict). Typically, battle-related deaths occur in warfare involving the armed forces of the warring parties. This includes traditional battlefield fighting, guerrilla activities, and all kinds of bombardments of military units, cities, and villages, etc. The targets are usually the military itself and its installations or state institutions and state representatives, but there is often substantial collateral damage in the form of civilians being killed in crossfire, in indiscriminate bombings, etc. All deaths--military as well as civilian--incurred in such situations, are counted as battle-related deaths.; ; Uppsala Conflict Data Program, http://www.pcr.uu.se/research/ucdp/.; Sum;

Syria SY: Battle-Related Deaths: Number of People data was reported at 24,950.000 Person in 2017. This records a decrease from the previous number of 43,936.000 Person for 2016. Syria SY: Battle-Related Deaths: Number of People data is updated yearly, averaging 41,218.000 Person from Dec 2004 (Median) to 2017, with 8 observations. The data reached an all-time high of 69,086.000 Person in 2013 and a record low of 1.000 Person in 2004. Syria SY: Battle-Related Deaths: Number of People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Syrian Arab Republic – Table SY.World Bank.WDI: Population and Urbanization Statistics. Battle-related deaths are deaths in battle-related conflicts between warring parties in the conflict dyad (two conflict units that are parties to a conflict). Typically, battle-related deaths occur in warfare involving the armed forces of the warring parties. This includes traditional battlefield fighting, guerrilla activities, and all kinds of bombardments of military units, cities, and villages, etc. The targets are usually the military itself and its installations or state institutions and state representatives, but there is often substantial collateral damage in the form of civilians being killed in crossfire, in indiscriminate bombings, etc. All deaths--military as well as civilian--incurred in such situations, are counted as battle-related deaths.; ; Uppsala Conflict Data Program, http://www.pcr.uu.se/research/ucdp/.; Sum;

Context

A dataset of information on deaths related to the Northern Ireland conflict (1969-2005).

Content

• Fatalities: A list of deaths related to the Northern Ireland conflict (Fact table)
• Location: A list of locations where the fatalities took place including GPS coordinates
• Agency: This refers to groups responsible for fatal incidents including agency groups
• Status: This refers to the role of fatality victims including status groups

Dimension Remarks

• Name: Spellings might vary from other sources
• Year: Relates to year of death rather than fatal incident
• Religion: Only that of Northern Ireland residents is listed
• Agency: This refers to groups responsible for fatal incidents
• Status: This refers to the role of fatality victims
• Location: Westminster electoral areas are employed for Northern Ireland fatalities
• Rationale: This refers to the inferred purpose underlying the fatal act
• Causality: This probes the degree of inferred purposiveness of a fatal event
• Context: This distinguishes between incidents such as gun fire, explosions, beatings
• New Incident: This offers a count of discrete fatal incidents
• 1st Fatality: This distinguishes multiple fatality incidents

Acknowledgements

The information was compiled by Michael McKeown and was contributed by him to the CAIN Web site. Michael McKeown has taken the decision (June 2009) to make the dataset freely available via the CAIN site. While users are free to download the dataset for research purposes, the database remains copyright © of Michael McKeown.

Inspiration

"The following study represents both the revisiting and continuation of a task which had occupied me for over twenty years. The concluded work highlights complexities and ambiguities in the patterns of the violence in Northern Ireland over the past three decades which are often obscured by the polar interpretations offered by partizan commentaries. For that reason I believe it should be inserted into the public arena for further consideration and possibly as a methodological model for further enquiry." Michael McKeown (2001).

Analysis of ‘Philippine Drug War Casualties ’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/sakinak/philippine-drug-war-casualties on 13 February 2022.

--- Dataset description provided by original source is as follows ---

Context

Philippine President Rodrigo Duterte was elected in 2016 on the promise that he would wage a war on drugs. Since then, thousands of drug suspects have been killed by the police or by masked gunmen. The real number of casualties is contested. This dataset contains information on 2,320 individuals killed in three municipalities in the capital in the first 18 months of the anti-drug campaign.

Content

The Stabile Center for Investigative Journalism collected this information from 23 different sources and visited four communities in Metro Manila to verify. The data here cover the period from July 2016 to December 2017 in the following municipalities: Quezon City, Manila, and Caloocan. There are two types of homicides associated with the drug war: those committed by the police during drug stings and other operations and those killed by unidentified assailants.

For privacy and safety reasons, this dataset lists each individual killing but does not include names and other information that may identify the victims. The sources of information for each homicide are grouped in six categories: police records, news clips, the Philippine Commission on Human Rights (a government watchdog), human rights organizations, church groups, and others. A check mark indicates that the killing was documented by the source.

Nearly 80 percent of these homicides have been recorded in some police document—a spot or incident report, a memo to internal affairs, an entry in a paper or electronic blotter. Nearly 60 percent of the killings have been reported in the news. A small number have been recorded only by churches and human-rights groups.

--- Original source retains full ownership of the source dataset ---

Political scientists have conducted only limited systematic research on the consequences of war for civilian populations. Here we argue that the civilian suffering caused by civil war extends well beyond the period of active warfare. We examine these longer-term effects in a cross-national (1999) analysis of World Health Organization new fine-grained data on death and disability broken down by age, gender, and type of disease or condition. We test hypotheses about the impact of civil wars and find substantial long-term effects, even after controlling for several other factors. We estimate that the additional burden of death and disability incurred in 1999, from the indirect and lingering effects of civil wars in the years 1991–97, was approximately equal to that incurred directly and immediately from all wars in 1999. This impact works its way through specific diseases and conditions and disproportionately affects women and children.

War heightens public interest in politics, especially when human lives are lost. We examine whether, and how, combat casualties affect the decision to vote in established democracies. Drawing from social psychology research on mortality salience, we expect increasing casualties to increase the salience of death, information that moves people to defend their worldview, especially nationalistic and ideological values. By heightening the importance of values, we propose that combat casualties increase the benefits of voting. In particular, we expect the effect of combat casualties to be pronounced among the least politically engaged. Using both cross-national data of elections in twenty-three democracies over a fifty year period and survey data from the United States and United Kingdom during the Iraq and Afghanistan wars, we found that mounting casualties increase turnout. Furthermore, as expected, we found the effect of casualties to be most pronounced among those least interested in politics. ------------------------------------------------------- This is the materials required to replicate all models and figures in Death and Turnout. Please read the Death and Turnout read me code book first for descriptions of data and to run each analysis. Note that the user must also download the CCES and BES data sets.

The law of 4 April 1873 “relating to the conservation of the graves of soldiers who died during the last war” (i.e. the French-German War of 1870) allows the French State to buy parcels of communal cemeteries or to expropriate private individuals in order to arrange graves for the remains of French and German soldiers. The National Archives kept records of the establishment of these military graves at the end of the 19th century. Classified by municipality, they contain the following parts: by-law instituting the military tomb(s), plan of the location of the burials, financial documents relating to the work surrounding the graves, exhumation and re-humation of bodies, correspondence. Some plans mention the number of soldiers buried, or even certain names or dress characteristics. The dataset made available lists all the records of municipalities kept in the National Archives. A number of these tombs and burials have now disappeared. Where possible, a link to the database Monuments to the Dead was created.

This Open Data Record is comprised of datasets that document human-wildlife coexistence incidents and response actions by Parks Canada Agency from 2010 to 2023. A human-wildlife coexistence (HWC) “incident” is any potential conflict situation between people and wildlife that was assigned to Parks Canada staff to manage to help ensure the safety and wellbeing of people and wildlife. The vast majority of HWC incidents are minor and staff are able to manage them safely with low risk to people, however, a small subset of the dataset is comprised of more hazardous incidents between people and wildlife that can potentially result in injury or death of either wildlife or people. HWC incident data inform Parks Canada Agency policies, programs, and operations, and enable evaluation of HWC patterns to help Parks Canada ensure safe and enjoyable visitor experiences while conserving wildlife and integrity of ecosystems across our national system of protected heritage areas. For any single HWC incident, there may be multiple management actions taken or multiple animals involved, and therefore this Open Data Record includes separate datasets for incidents, responses, animals involved, and human activities. These four datasets include many shared fields, including a unique alphanumeric “Incident Number” that can be used to look-up records between the tables or to join the tables in a relational database. There are also thirteen derived datasets provided to summarize the total number of incidents, animal species involved, animals killed (by human causes), aggressive encounters, unnatural attractants, and response actions taken. Please note: these datasets include some incidents that Parks Canada staff were involved outside of park boundaries on surrounding lands or waters. All HWC incident data remain subject to ongoing revisions as more information comes available or for quality control purposes. All protected, personal, private or confidential information has been removed from these datasets.

Myanmar MM: Battle-Related Deaths: Number of People data was reported at 500.000 Person in 2018. This records an increase from the previous number of 116.000 Person for 2017. Myanmar MM: Battle-Related Deaths: Number of People data is updated yearly, averaging 244.000 Person from Mar 1990 (Median) to 2018, with 29 observations. The data reached an all-time high of 1,617.000 Person in 1993 and a record low of 25.000 Person in 2000. Myanmar MM: Battle-Related Deaths: Number of People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Myanmar – Table MM.World Bank.WDI: Population and Urbanization Statistics. Battle-related deaths are deaths in battle-related conflicts between warring parties in the conflict dyad (two conflict units that are parties to a conflict). Typically, battle-related deaths occur in warfare involving the armed forces of the warring parties. This includes traditional battlefield fighting, guerrilla activities, and all kinds of bombardments of military units, cities, and villages, etc. The targets are usually the military itself and its installations or state institutions and state representatives, but there is often substantial collateral damage in the form of civilians being killed in crossfire, in indiscriminate bombings, etc. All deaths--military as well as civilian--incurred in such situations, are counted as battle-related deaths.; ; Uppsala Conflict Data Program, http://www.pcr.uu.se/research/ucdp/.; Sum;