US international trade 2017-2018

[collleenwang]

Pitch

I'm focusing on international trade flows, so very obviously, the U.S. is inevitable. Let's look at the current data.

During my first round of searching, many organizations and companies have been keeping following these data, and make them in different kinds of visualization. But I still prefer to complete my trip with it.

Summary

Details

There are plenty of data in Census gov. , Official Bureau of Economic Analysis (BEA )and other organizations, this time, I collected from Census and BEA together, to compare and combine some data together.

Possible headline(s): Balance on Goods and Services Trade in the U.S. (2017-2018)

Data set(s):

Code repository:

Possible problems/fears/questions:

Work so far

I made a world map for US export data in 2017, so we can see which country is imported to US most, yes! it's Canada!

Also we can see US import in 2017, who is the biggest country to export to US? Yes, see the deepest and largest circle, China!

News in the first quarter of 2018, see Canada!

Checklist

This checklist must be completed before you submit your draft.

• [x] I have already spent time with my data set, opening it, exploring it, etc
• [x] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [x] My issue links to my data set(s)
• [ ] My issue links to my code repository
• [x] My issue explains what I'd like to explore in the data set
• [ ] My issue includes images - either inspiration or what I've done so far

[playfairbot]

Hi! I'm a little robot, checking in on your project.

You need some feedback, let me summon @dbaptistr, @SimoneLuc, @maxarvid for you

It looks like we need to fix up your pitch a little bit! Edit it by clicking the pencil in the top right-hand corner. It requires:

• A summary of your pitch, under the 'Summary' section
• Sample headlines
• Links to or descriptions of your datasets
• A link to your code repository
• An explation of the work you've done so far in the 'Work so far' section

[SimoneLuc]

-It seems that you are at the very beginning of your procect. In my opinion the line chart you have chosen shows best ups and downs of the trade. -But why doues does the billion-axes begin at "-20" ?

[dbaptistr]

• I know this is only a rough draft, so I'm looking forward to know what your angle is going to be. Balance on Goods and Services Trade in the U.S. seems like a very wide subject and might make any comparison too broad to have any relevance to the reader.
• Perhaps it'd be useful to have in a first draft a couple of questions you're trying to solve with your data.

[maxarvid]

For us trade newbs, it might be nice to include a line in the pitch on how the US is the largest import/export country in the world (if that indeed is so). I like maps, and I'm wondering that since imports and exports are more or less a binary, I wonder if you would like to explore the possibility of representing both on the same map?

Something like this palm oil flows map (but not sucky)?

[sarahslo]

another approach to these data could be to do a sankey diagram. you can organize the data by most to least, instead of by geography. the hard thing about mapping data like this, tho it has been done well, is that you have to think about map projections, it's a lot of info and you add another layer of complexity when you add geography.

that said, it works well if you want to do small multiples, for instance, show us ALL trade with China, ALL trade with the US.