Google Fusion Tables (or simply Fusion Tables) is a web service provided by Google for data management. Fusion tables can be used for gathering, visualising and sharing data tables. Data are stored in multiple tables that Internet users can view and download. The website launched in June 2009, announced by Alon Halevy and Rebecca Shapley.
The service was further described in a scientific paper in 2010.
In the 2011 upgrade of Google Docs, Fusion Tables became a default feature, under the title "Tables (beta)".
In December 2018, Google announced that it would retire Fusion Tables on 3 December 2019.
|Google Fusion Tables|
Screenshot of Google Fusion Tables.
Type of site
|Registration||Optional, included with a Google Account|
|Launched||9 June 2009|
|Current status||Active (To be discontinued in December 2019)|
The 1828 United States elections elected the members of the 21st United States Congress. It marked the beginning of the Second Party System, and the definitive split of the Democratic-Republican Party into the Democratic Party (organized around Andrew Jackson) and the National Republican Party (organized around John Quincy Adams and opponents of Jackson). While the Democrats cultivated strong local organizations, the National Republicans relied on a clear national platform of high tariffs and internal improvements. Political scientists such as V.O. Key, Jr. consider this election to be a realigning election, while political scientists such as James Reichley instead see the election as a continuation of the Democratic-Republican tradition. Additionally, this election saw the Anti-Masonic Party win a small number of seats in the House, becoming the first third party to gain representation in Congress.
In a re-match of the 1824 Presidential election, Democratic General Andrew Jackson won a large victory over incumbent National Republican President John Quincy Adams. Adams again won New England, but Jackson took most of the rest of the country. Jackson was the first successful presidential candidate who had not served as secretary of state or vice president in the preceding administration (aside from George Washington). Adams was the first President to lose re-election since his father, John Adams, lost re-election in 1800. John C. Calhoun was re-elected vice president, making him the second and last vice president to serve under two different presidents. Jackson's election as president marked the start of Jacksonian democracy, and an ongoing expansion in right to vote saw a dramatic increase in the size of the electorate.In the House, Democrats won several seats, increasing their majority. The Anti-Masonic Party won a small number of seats, gaining representation in Congress for the first time.In the Senate, opponents of Jackson won minor gains, but Democrats retained control of the chamber.1828 United States presidential election
The 1828 United States presidential election was the 11th quadrennial presidential election, held from Friday, October 31, to Tuesday, December 2, 1828. It featured a re-match of the 1824 election, as President John Quincy Adams of the National Republican Party faced Andrew Jackson of the nascent Democratic Party. Unlike in 1824, Jackson defeated Adams, marking the start of Democratic dominance in federal politics. Adams was the second president to lose re-election, following his father, John Adams.
Jackson had won a plurality of the electoral and popular vote in the 1824 election, but had lost the contingent election that was held in the House of Representatives. In the aftermath of the election, Jackson's supporters accused Adams and Henry Clay of having reached a "corrupt bargain" in which Clay helped Adams win the contingent election in return for the position of Secretary of State. After the 1824 election, Jackson's supporters immediately began plans for a re-match in 1828.
As the once-dominant Democratic-Republican Party collapsed, Jackson and allies such as Martin Van Buren and Vice President John C. Calhoun laid the foundations of the Democratic Party. Opponents of Adams coalesced around Jackson, and, unlike the 1824 election, the 1828 election became a two-way contest. Adams's supporters rallied around the president, calling themselves National Republicans in contrast to Jackson's Democrats. Jackson's cause was aided by the passage of the Tariff of 1828, referred to by its opponents as the Tariff of Abominations, which raised tariffs on imported materials and goods from abroad. With the ongoing expansion of the right to vote to most white men, the election marked a dramatic expansion of the electorate, with 9.5% of Americans casting a vote for President, compared with 3.4% in 1824.Passage of the unpopular tariff helped Jackson carry much of the South, and Jackson also swept the Western states. Adams swept New England but won only three states outside of his home region. Jackson became the first president whose home state was neither Massachusetts nor Virginia. The election ushered Jacksonian Democracy into prominence, thus marking the transition from the First Party System to the Second Party System. Historians debate the significance of the election, with many arguing that it marked the beginning of modern American politics with the decisive establishment of democracy and the permanent establishment of a two-party electoral system.Alon Halevy
Alon Yitzchack Halevy (until 2000: Levy) is an Israeli-American computer scientist and a leading researcher in the area of data integration. He was a research scientist at Google from 2005 to 2015, when he left to become head of Recruit Institute of Technology. Until 2006, he was a professor of computer science at the University of Washington. He received his PhD from Stanford University in 1993.
He is a fellow of the ACM and a winner of the 2006 VLDB 10-year best paper award. He was a Sloan Fellow, and received the Presidential Early Career Award for Scientists and Engineers (PECASE) in 2000.
He is the founder of two technology companies, Nimble Technology (now Actuate Corporation) and Transformic Inc.
At Google he was involved in Google Fusion Tables.Contents of the United States diplomatic cables leak
This is a list of notable content from the United States diplomatic cables leak that shows the United States' opinion of related affairs. Beginning on 28 November 2010, WikiLeaks had been publishing classified documents of detailed correspondence—diplomatic cables—between the United States Department of State and its diplomatic missions around the world. On 1 September 2011, it released all of the Cablegate documents in its possession without redaction.Data-driven journalism
Data-driven journalism, often shortened to "ddj", a term in use since 2009, is a journalistic process based on analyzing and filtering large data sets for the purpose of creating or elevating a news story. Many data-driven stories begin with newly available resources such as open source software, open access publishing and open data, while others are products of public records requests or leaked materials. This approach to journalism builds on older practices, most notably on computer-assisted reporting (CAR) a label used mainly in the US for decades. Other labels for partially similar approaches are "precision journalism", based on a book by Philipp Meyer, published in 1972, where he advocated the use of techniques from social sciences in researching stories.
Data-driven journalism has a wider approach. At the core the process builds on the growing availability of open data that is freely available online and analyzed with open source tools. Data-driven journalism strives to reach new levels of service for the public, helping the general public or specific groups or individuals to understand patterns and make decisions based on the findings. As such, data driven journalism might help to put journalists into a role relevant for society in a new way.
Since the introduction of the concept a number of media companies have created "data teams" which develop visualizations for newsrooms. Most notable are teams e.g. at Reuters, Pro Publica, and La Nacion (Argentina). In Europe, The Guardian and Berliner Morgenpost have very productive teams, as well as public broadcasters.
As projects like the MP expense scandal (2009) and the 2013 release of the "offshore leaks" demonstrate, data-driven journalism can assume an investigative role, dealing with "not-so open" aka secret data on occasion.
The annual Data Journalism Awards recognize outstanding reporting in the field of data journalism, and numerous Pulitzer Prizes in recent years have been awarded to data-driven storytelling, including the 2018 Pulitzer Prize in International Reporting and the 2017 Pulitzer Prize in Public ServiceData journalism
Data journalism is a journalism specialty reflecting the increased role that numerical data is used in the production and distribution of information in the digital era. It reflects the increased interaction between content producers (journalist) and several other fields such as design, computer science and statistics. From the point of view of journalists, it represents "an overlapping set of competencies drawn from disparate fields".Data journalism has been widely used to unite several concepts and link them to journalism. Some see these as levels or stages leading from the simpler to the more complex uses of new technologies in the journalistic process.Designers are not always part of the process. According to author and data journalism trainer Henk van Ess, "Data journalism can be based on any data that has to be processed first with tools before a relevant story is possible. It doesn't include visualization per se."Digital history
Digital history is the use of digital media to further historical analysis, presentation, and research. It is a branch of the Digital humanities and an extension of quantitative history, cliometrics, and computing. Digital history is commonly digital public history, concerned primarily with engaging online audiences with historical content, or, digital research methods, that further academic research. Digital history outputs include: digital archives, online presentations, data visualizations, interactive maps, time-lines, audio files, and virtual worlds to make history more accessible to the user. A researcher can interact with, explore and visualise, the output more easily than with conventional historiographical material. Recent digital history projects focus on creativity, collaboration, and technical innovation, text mining, corpus linguistics, network analysis, 3D Modeling, and big data analysis. Utilising these resources the user can rapidly develop new analyses that can link to, extend, and bring to life existing histories.Egyptian Knowledge Bank
The Egyptian Knowledge Bank (EKB) is an online library archive and resource that provides access to learning resources and tools for educators, researchers, students, and the general public of Egypt.Finland
Finland (Finnish: Suomi [suo̯mi] (listen); Swedish: Finland [ˈfɪnland] (listen)), officially the Republic of Finland (Finnish: Suomen tasavalta, Swedish: Republiken Finland (listen to all)) is a country in Northern Europe bordering the Baltic Sea, Gulf of Bothnia, and Gulf of Finland, between Norway to the north, Sweden to the northwest, and Russia to the east. Finland is a Nordic country and is situated in the geographical region of Fennoscandia. The capital and largest city is Helsinki. Other major cities are Espoo, Vantaa, Tampere, Oulu and Turku.
Finland's population is 5.52 million (2018), and the majority of the population is concentrated in the southern region. 88.7% of the population is Finnish and speaks Finnish, a Uralic language unrelated to the Scandinavian languages; next come the Finland-Swedes (5.3%). Finland is the eighth-largest country in Europe and the most sparsely populated country in the European Union. The sovereign state is a parliamentary republic with a central government based in the capital city of Helsinki, local governments in 311 municipalities, and one autonomous region, the Åland Islands. Over 1.4 million people live in the Greater Helsinki metropolitan area, which produces one third of the country's GDP.
Finland was inhabited when the last ice age ended, approximately 9000 BCE. The first settlers left behind artefacts that present characteristics shared with those found in Estonia, Russia, and Norway. The earliest people were hunter-gatherers, using stone tools. The first pottery appeared in 5200 BCE, when the Comb Ceramic culture was introduced. The arrival of the Corded Ware culture in southern coastal Finland between 3000 and 2500 BCE may have coincided with the start of agriculture. The Bronze Age and Iron Age were characterised by extensive contacts with other cultures in the Fennoscandian and Baltic regions and the sedentary farming inhabitation increased towards the end of Iron Age. At the time Finland had three main cultural areas – Southwest Finland, Tavastia and Karelia – as reflected in contemporary jewellery.From the late 13th century, Finland gradually became an integral part of Sweden through the Northern Crusades and the Swedish part-colonisation of coastal Finland, a legacy reflected in the prevalence of the Swedish language and its official status. In 1809, Finland was incorporated into the Russian Empire as the autonomous Grand Duchy of Finland. In 1906, Finland became the first European state to grant all adult citizens the right to vote, and the first in the world to give all adult citizens the right to run for public office.Following the 1917 Russian Revolution, Finland declared itself independent. In 1918, the fledgling state was divided by civil war, with the Bolshevik-leaning Red Guard supported by the equally new Soviet Russia, fighting the White Guard, supported by the German Empire. After a brief attempt to establish a kingdom, the country became a republic. During World War II, the Soviet Union sought repeatedly to occupy Finland, with Finland losing parts of Karelia, Salla, Kuusamo, Petsamo and some islands, but retaining their independence.
Finland joined the United Nations in 1955 and established an official policy of neutrality. The Finno-Soviet Treaty of 1948 gave the Soviet Union some leverage in Finnish domestic politics during the Cold War era. Finland joined the OECD in 1969, the NATO Partnership for Peace in 1994, the European Union in 1995, the Euro-Atlantic Partnership Council in 1997, and finally the Eurozone at its inception, in 1999.
Finland was a relative latecomer to industrialisation, remaining a largely agrarian country until the 1950s. After World War II, the Soviet Union demanded war reparations from Finland not only in money but also in material, such as ships and machinery. This forced Finland to industrialise. It rapidly developed an advanced economy while building an extensive welfare state based on the Nordic model, resulting in widespread prosperity and one of the highest per capita incomes in the world. Finland is a top performer in numerous metrics of national performance, including education, economic competitiveness, civil liberties, quality of life, and human development. In 2015, Finland was ranked first in the World Human Capital and the Press Freedom Index and as the most stable country in the world during 2011–2016 in the Fragile States Index, and second in the Global Gender Gap Report. A large majority of Finns are members of the Evangelical Lutheran Church, and freedom of religion is guaranteed under the Finnish Constitution.Google Crisis Response
Google Crisis Response is a team within Google.org that "seeks to make critical information more accessible around natural disasters and humanitarian crises". The team has responded in the past to the 2010 Haiti earthquake, 2010 Pakistan floods, 2010–11 Queensland floods, February 2011 Christchurch earthquake, and the 2011 Tōhoku earthquake and tsunami among other events, using Google resources and tools such as Google Maps, Google Earth, Google Person Finder, and Google Fusion Tables.Google Drive
Google Drive is a file storage and synchronization service developed by Google. Launched on April 24, 2012, Google Drive allows users to store files on their servers, synchronize files across devices, and share files. In addition to a website, Google Drive offers apps with offline capabilities for Windows and macOS computers, and Android and iOS smartphones and tablets. Google Drive encompasses Google Docs, Sheets, and Slides, an office suite that permits collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the office suite are saved in Google Drive.
Google Drive offers users with 15 gigabytes of free storage through Google One. Google One also offers 100 gigabytes, 200 gigabytes, 2 terabytes, 10 terabytes, 20 terabytes, and 30 terabytes offered through optional paid plans. Files uploaded can be up to 5 terabytes in size. Users can change privacy settings for individual files and folders, including enabling sharing with other users or making content public. On the website, users can search for an image by describing its visuals, and use natural language to find specific files, such as "find my budget spreadsheet from last December".
The website and Android app offer a Backups section to see what Android devices have data backed up to the service, and a completely overhauled computer app released in July 2017 allows for backing up specific folders on the user's computer. A Quick Access feature can intelligently predict the files users need.
Google Drive is a key component of G Suite, Google's monthly subscription offering for businesses and organizations. As part of select G Suite plans, Drive offers unlimited storage, advanced file audit reporting, enhanced administration controls, and greater collaboration tools for teams.
As of March 2017, Google Drive has 800 million active users, and as of September 2015, it has over one million organizational paying users. As of May 2017, there are over two trillion files stored on the service.Heat map
A heat map (or heatmap) is a graphical representation of data where the individual values contained in a matrix are represented as colors. "Heat map" is a newer term but shading matrices have existed for over a century.List of Google products
The following is a list of products and services provided by Google.List of relational database management systems
This is a list of relational database management systems.Malaysia Airlines Flight 17
Malaysia Airlines Flight 17 (MH17) was a scheduled passenger flight from Amsterdam to Kuala Lumpur that was shot down on 17 July 2014 while flying over eastern Ukraine, killing all 283 passengers and 15 crew on board. Contact with the aircraft, a Boeing 777-200ER, was lost when it was about 50 km (31 mi) from the Ukraine–Russia border and wreckage of the aircraft fell near Hrabove in Donetsk Oblast, Ukraine, 40 km (25 mi) from the border. The shoot-down occurred in the War in Donbass, during the Battle of Shakhtarsk, in an area controlled by pro-Russian rebels. The crash was Malaysia Airlines' second aircraft loss during 2014 after the disappearance of Flight 370 on 8 March.The responsibility for investigation was delegated to the Dutch Safety Board (DSB) and the Dutch-led joint investigation team (JIT), who concluded that the airliner was downed by a Buk surface-to-air missile launched from pro-Russian separatist-controlled territory in Ukraine. According to the JIT, the Buk that was used originated from the 53rd Anti-Aircraft Missile Brigade of the Russian Federation, and had been transported from Russia on the day of the crash, fired from a field in a rebel-controlled area, and the launcher returned to Russia after it was used to shoot down MH17. On the basis of the JIT's conclusions, the governments of the Netherlands and Australia hold Russia responsible for the deployment of the Buk installation and are taking steps to hold Russia formally accountable.The DSB and JIT findings confirmed earlier claims by American and German intelligence sources as to the missile type and launch area. In 2014 the American intelligence had also said that Russia had supplied the Buk missile to pro-Russian insurgents, and that the insurgents most plausibly shot down MH17 in error, after misidentifying it as a military aircraft.Ukrainian Prime Minister Arseniy Yatsenyuk laid the blame on professional soldiers who came from Russia, stating that "it wasn't drunken militants with Ukrainian passports [who shot down the Malaysian plane], it was done by Russian professionals and coordinated from Russia", adding that "the whole world has learned about the Russian lies and Russian propaganda." As of May 2018, the Russian government rejects claims that Russia bears any responsibility for the crash, and denies involvement. The Russian defense ministry said that it had never deployed anti-aircraft missile systems in Ukraine. Several false conspiracy theories about the crash have since appeared in Russian media, including that the aircraft was followed by a Ukrainian military jet. The Russian Government holds Ukraine responsible since the crash happened in the Ukrainian flight information region.The Ukrainian Air Force (UAF) was used extensively in operations against the rebels, and several UAF aircraft had been shot down over the rebel-controlled territory, both before and after the MH17 incident. Immediately after the crash, a post appeared on the VKontakte social media profile attributed to Igor Girkin, leader of the Donbass separatist militia, claiming responsibility for shooting down a Ukrainian An-26 military transporter near Torez. This post was removed later the same day, and the separatists then denied shooting down any aircraft. In late July 2014, communications intercepts were made public in which, it is claimed, separatists are heard discussing an aircraft that they had downed. A video from the crash site, recorded by the rebels and obtained by News Corp Australia, shows the first rebel soldiers to arrive at the crash site. At first they assumed that the downed aircraft was a Ukrainian military jet, and were dismayed when they started to realise that it was a civilian airliner.MyTracks
MyTracks was a GPS tracking application that runs on Android. The application uses a device's GPS to collect data, allowing real-time review of path, speed, distance, and elevation. Later, this data can be saved to Google Maps, Google Fusion Tables, or Google Docs and shared with Google+, Facebook, or Twitter. The application also allows a user to record annotations along the path, hear periodic voice announcements of progress, and sync with select third-party bio-metric sensors.
Google has announced that as of the 1st May 2016, MyTracks will be deprecated and no longer available in the Google Play Store. The app itself continues to work and is still available to sideload via APK repositories.
An in-app popup alerted users that MyTracks would stop working on April 30, 2016; Google has confirmed they will be investing in "other, more wide-reaching, mapping projects".OpenRefine
OpenRefine, formerly called Google Refine and before that Freebase Gridworks, is a standalone open source desktop application for data cleanup and transformation to other formats, the activity known as data wrangling. It is similar to spreadsheet applications (and can work with spreadsheet file formats); however, it behaves more like a database.
It operates on rows of data which have cells under columns, which is very similar to relational database tables. An OpenRefine project consists of one table. The user can filter the rows to display using facets that define filtering criteria (for example, showing rows where a given column is not empty). Unlike spreadsheets, most operations in OpenRefine are done on all visible rows: transformation of all cells in all rows under one column, creation of a new column based on existing column data, etc. All actions that were done on a dataset are stored in a project and can be replayed on another dataset.
Unlike spreadsheets, no formulas are stored in the cells, but formulas are used to transform the data, and transformation is done only once. Transformation expressions can be written in General Refine Expression Language (GREL), Jython (i.e. Python) and Clojure.The program has a web user interface. However, it is not hosted on the web (SAAS), but is available for download and use on the local machine. When starting OpenRefine, it starts a web server and starts a browser to open the web UI powered by this web server.United States diplomatic cables leak
The United States diplomatic cables leak, widely known as Cablegate, began on Sunday, 28 November 2010 when WikiLeaks—a non-profit organization that publishes submissions from anonymous whistleblowers—began releasing classified cables that had been sent to the U.S. State Department by 274 of its consulates, embassies, and diplomatic missions around the world. Dated between December 1966 and February 2010, the cables contain diplomatic analysis from world leaders, and the diplomats' assessment of host countries and their officials. According to WikiLeaks, the 251,287 cables consist of 261,276,536 words, making Cablegate "the largest set of confidential documents ever to be released into the public domain." Today, more recent leaks have surpassed that amount. On July 30, 2013, Chelsea Manning was convicted for theft of the cables and violations of the Espionage Act, in a court martial proceeding, and sentenced to 35 years imprisonment. She was released on May 17, 2017, after 7 years total confinement, after her sentence had been commuted by President Obama earlier that year.
The first document, the so-called Reykjavik 13 cable, was released by WikiLeaks on 18 February 2010, and was followed by the release of State Department profiles of Icelandic politicians a month later. Later that year, Julian Assange, WikiLeaks' editor-in-chief, reached an agreement with media partners in Europe and the United States to publish the rest of the cables in redacted form, removing the names of sources and others in vulnerable positions. On 28 November, the first 220 cables were published under this agreement by El País (Spain), Der Spiegel (Germany), Le Monde (France), The Guardian (United Kingdom) and The New York Times (United States). WikiLeaks had planned to release the rest over several months, and as of 11 January 2011, 2,017 had been published.
The remaining cables were published in September 2011 after a series of events compromised the security of a WikiLeaks file containing the cables. This included WikiLeaks volunteers placing an encrypted file containing all WikiLeaks data online as "insurance" in July 2010, in case something happened to the organization. In February 2011 David Leigh of The Guardian published the encryption passphrase in a book; he had received it from Assange so he could access a copy of the Cablegate file, and believed the passphrase was a temporary one, unique to that file. In August 2011, a German magazine, Der Freitag, published some of these details, enabling others to piece the information together and decrypt the Cablegate files. The cables were then available online, fully unredacted. In response, WikiLeaks decided on 1 September 2011 to publish all 251,287 unedited documents.The publication of the cables was the third in a series of U.S. classified document "mega-leaks" distributed by WikiLeaks in 2010, following the Afghan War documents leak in July, and the Iraq War documents leak in October. Over 130,000 of the cables are unclassified, some 100,000 are labeled "confidential", around 15,000 have the higher classification "secret", and none are classified as "top secret" on the classification scale. Reactions to the leak in 2010 varied. Western governments expressed strong disapproval, while the material generated intense interest from the public and journalists. Some political leaders referred to Assange as a criminal, while blaming the U.S. Department of Defense for security lapses. Supporters of Assange referred to him in November 2010 as a key defender of free speech and freedom of the press. Reaction to the release in September 2011 of the unredacted cables attracted stronger criticism, and was condemned by the five newspapers that had first published the cables in redacted form in November 2010.