“Freshen up your formulas and pamper those pivot tables—International Spreadsheet Day is Oct. 17.”
His main concern, it seems, is that the United States has suffered a “trade deficit”. That means South Korea — a key ally in East Asia on security issues, not just trade — has been exporting more goods to the United States than it has been importing.
In 2016, this deficit was about $23.2 billion.
That’s a big figure, but the United States has a big economy. In context, it’s not much.
Before we get to why that matters, here’s a look South Korea’s trade balances with the world’s largest economies last year. It had surpluses with China ($37.5 billion), its main export customer, Hong Kong ($31.2 billion) and the United States ($23.2 billion), among others.
It had trade deficits of its own with some economically powerful countries, by the way, most significantly Japan (-$21.3 billion), Germany (-12.4 billion) and Saudi Arabia (-$10 billion). Take a look:
It’s important to note that trade balances sometimes vary based on the products each country sells and each country’s relative slice of the global economy, not necessarily trade agreements in their early stages. (China is an exporting powerhouse that sells mass quantities of cheap goods to almost everyone. Saudi Arabia, on the other hand, sells pricey oil. The nature of that trade is already imbalanced).
It’s also critical to think about each country’s balance in the context of its overall trade with South Korea.
The United States has that $23 billion deficit, as Trump and others in the United States have noted recently. It imports about $66.4 billion from South Korea and exports about $43.2 billion. A key departure point is automobiles. (You don’t see many American cars on the roads here in Seoul, where I live). Regardless of why, the deficit represented about 21 percent of the overall trade in 2016.
That’s a significant (and growing) figure, but how does it compare relative to other countries?
When normalized, Egypt, Hong Kong, Turkey, Poland, India, Mexico, Belgium and Norway had more unbalanced trade relationships with South Korea than the United States did last year.
Here’s a look at South Korea’s various trade balances with the world’s largest economies, over time, as a percentage of each nation’s overall trade relationship. While South Korea enjoys a trade surplus with the United States, it’s relatively modest in the context of the overall volume — on par with Brazil, China and Thailand, for example.
I’m not saying Trump is wrong to worry about whether the United States has an equal trade relationship with this one trading partner. There’s just a piece of the picture, perhaps, missing from the discussion — even before you consider whether picking an economic fight with a regional security ally is smart policy right now.
[Image from Misaeng (season one, episode 11). It’s an old K-drama I’m just watching now.]
Despite international objections, North Korea has launched four ballistic missiles in the last week, including one that flew over Japan, raising regional tensions about the rogue state’s weapons development even higher.
For those of us who live in South Korea, such provocations have become commonplace, especially since the North’s new leader, Kim Jong Un, took over after his father’s death in late 2011. They interrupt Sunday breakfasts or even national holidays, but they haven’t yet seemed like a real threat.
(Of course, they can just use their ample artillery along the border to strike Seoul, where I live).
The missile testing pace and the North’s increasingly technically ability have increased significantly in the last years, however, causing more and more heartburn in the region.
This chart shows the pace of testing over the years, including missiles that “failed” in flight:
The North has over the years developed (and borrowed) its own set of missiles, each with varying capabilities. Lately they’ve grown more powerful, though not always reliable.
Here’s how often they’ve used them, by missile type:
Since 1984, there have been at least 115 missile launches. But those tests have come from a select group of locations around the North: airfields and testing sites. Here are those tests locations, aggregated, with larger bubbles representing more launches:
And this map shows each launch in time order, with a flurry beginning in 2013. Colors change based on the missile type:
This is just a quick post, created largely because I wanted to build another proportional symbols map with D3. For a more thorough analysis, check out this post.
If President Trump decides after all to replace Attorney General Jeff Sessions, who was approved just 166 days ago, the former Alabama senator would have one of the shortest tenures in history.
More than 80 Americans have been the nation’s top law enforcement officer as cabinet members, rather than acting placeholders. That list includes 39 Republicans and 30 Democrats. Another 13 attorneys general from other parties (Whig, Federalist, etc.) have also held the office.
The average tenure has been about 978 days — or roughly 2.5 years. Now it appears Sessions could get ousted after less than a half year.
Only two others have served shorter terms. One, Elliot Richardson, resigned in protest while serving under Richard Nixon during Watergate. The other, Edwin Stanton, took office in the tumultuous months before Abraham Lincoln became president.
Here’s the list, sorted from longest-to-shortest tenure:
As a newspaper reporter living in South Korea, I’m always aware that a “provocation” by our friends in the North — a missile launch, a nuclear test, or some other incident — could occur on any day.
A recent missile launch came on a Sunday morning, for example, disrupting our family plans. (That’s part of the job, of course).
But which days have been more likely for provocations, I wondered? Thanks to a handy database from the Center for Strategic & International Studies, we now know.
Since 2001, North Korean leaders seem to prefer … Mondays?
The trend is clear in the data: Compared with any other day, provocations have been twice as common on the first work day of the week.
The data also reveal some interesting tidbits about the North’s provocations. Thanks to a recent surge in missile tests, the number of provocations has increased substantially under the new leader, Kim Jong Un, who took power in late December 2011 after the death of his father, Kim Jong Il:
The Center categorizes the provocations by type, too (though I broke our “exchange of fire” incidents from “Other” in the data):
And here you can see the interest in missile tests. Roughly half of all provocations since 2001 have been missile launches or tests (again, propelled in part by Kim Jong Un’s recent interest):
You can explore the Center’s great work here.
The polling firm YouGov estimated the legislation’s unpopularity by congressional district. The bill itself was quite unpopular, it turns out, even in conservative districts, as FiveThirtyEight’s Nate Silver reported.
Thanks to DailyKos Elections, we can also marry the data with President Donald Trump’s vote share in each district.
I’ve been experimenting with maps in D3.js, and I hadn’t yet tried congressional districts. So this seemed like a perfect opportunity, even if thematic maps aren’t particularly useful in this context (because congressional districts vary in size geographically, such maps can be misleading).
Case in point: The national map of congressional districts, with Republicans in red and Democrats in blue . As we all know, Democratic districts tend to be smaller in terms of area and clustered in more densely populated places. So they don’t get a particularly fair representation on a map:
Consider these two treemaps. This first shows members of the U.S. House by party (with some vacancies in gray). Shapes are sized based on the average population of each congressional district: roughly 710,000 people, give or take five percent. The House has 237 Republicans, 193 Democrats and five vacancies. There’s clearly a red majority, but it’s relatively close:
This treemap, however, shows the geographic area in square miles. Now you see the distortion:
OK, you get it. So let’s see how the health care opposition looks on maps.