search

DOI-ONRR / doi-extractives-data

Information on the extractive industries in the U.S. from federal data.
https://revenuedata.doi.gov/
Other
77 stars 41 forks source link

Case study charts: update #2496

Closed brentryanjohnson closed 6 years ago

brentryanjohnson commented 6 years ago

It's time to update our case study charts again.

2015 values:

Draft for proofing

01-line chart - boone coal prod

2015 values:

Problem with this (and most employment charts)

02-bar chart - boone wage

2015 values:

Draft for proofreading

03-line chart - campbell coal prod

2015 values:

Problem

04-bar chart - campbell wage

2015-16 values:

Draft for proofing

05-line chart - kern oil prod

-[ ] Desoto wage and salary employment chart Chart 2: Wage and salary employment desoto2

2015-16 values:

Problem

13-bar chart - desoto wage

Chart 3: Sales and use taxes desoto3

2015 values:

Draft for proofing

25-bar chart - sales and use tax trends

2015 values:

Draft for proofing

17-line chart - elko gold

Chart 2: Gold mining employment elko2

2015 values:

Draft for proofing

19-bar chart - elko eureka empl

2016 values:

Draft for proofing

15-combo chart - morenci copper

Chart 1: Gold production humbolt1

2015 values:

Draft for proofing

09-line chart - humboldt gold

Chart 2: Gold mining employment humbolt2

2015 values:

Draft for proofing

10-bar chart - humboldt lander empl

Chart 1: Oil production kern1

2015, 2016 values

Draft for proofing

05-line chart - kern oil prod

2015, 2016 values:

Problem

06-bar chart - kern oil

2015, 2016 values:

Draft for proofing

08-bar chart - kern assessment alt

Chart 1: Iron production marquette1

2014 values:

Draft for proofing

16-line chart - marquette iron

2015 values:

Draft for proofing

20-line chart - north slope oil

-[X] North Slope employment chart Chart 2: Employment northslope2

2015 values:

-[X] The existing chart is being replaced by this one: Chart 3: Alaska production and gas tax northslope3

This is a completely revised chart to replace the current one. Here are the new values:

Not sure what's going on here

22-bar chart - alaska quarterly severance tax copy

Chart 1: Copper production pima1

No update

2015 values:

Draft for proofing

24-bar chart - pima wage

Chart 1: Iron ore production stlouis1

2014 values:

Draft for proofing

23-line chart - st louis iron ore

Chart 1: Natural gas production tarrant1

2015, 2016 updates:

Draft for proofing

11-line chart - tarrant johnson gas

Chart 2: Wage and salary employment tarrant2

Draft for proofing

12-bar chart - tarrant empl

ericronne commented 6 years ago

FYI these are manually drawn ... in sketch. :/

2497

brentryanjohnson commented 6 years ago

I know...we'll need to continue our discussions re: the maintainability of case studies as a whole.

coreycaitlin commented 6 years ago

Next step: Pull latest-year numbers from the charts, and identify whether we can get that data from the visuals within 1-2 hours. (If not, we'll request further data files.)

brentryanjohnson commented 6 years ago

@coreycaitlin and @ericronne I'm chipping away at adding the new data values (above).

brentryanjohnson commented 6 years ago

@coreycaitlin and @ericronne I finished pulling out the updated values (above). They should be ready to incorporate into the Sketch charts.

ericronne commented 6 years ago

Excellent! Now they're my problem :) Stay tuned.

ericronne commented 6 years ago

Something seems fishy in boone county...

image

My guess is that the old chart is a stacked bar. The campbell chart matches up fine, except for 2014... image

Also there's no percentage figure for 2015. Something we can calculate?

ericronne commented 6 years ago

Dropped drafts (including images of problematic employment bars) into the mega-note atop this issue.

An early 🎁 for y'all, cuz i care.

brentryanjohnson commented 6 years ago

Hmmm...looking back at #1603, It looks like the Boone numbers might have been accidentally exaggerated at some point. Last year's "other industries" values hovered around 20,000 (not over 25,000, as in the current chart). It seems the chart values we were given this year are more or less consistent with past years.

As for Campbell County, the percent value for 2015 is 29.7%, rounded to 30%.

brentryanjohnson commented 6 years ago

@ericronne and @coreycaitlin I checked the Boone, Logan, and Mingo data against the census source data, and it appears the data as currently represented on the site is accurate (the chart we received this year doesn't appear to be accurate). I pulled the 2015 values from the source:

coreycaitlin commented 6 years ago

Still blocked by needing further data validation.

coreycaitlin commented 6 years ago

Next step: Identify and list outstanding charts that need updating or validation, and come up with a plan to move forward.

brentryanjohnson commented 6 years ago

I pulled out the charts that were not updated because of (1) discrepancies with previous years' values or (2) omission of "new" values.

2015 values:

Problem with this (and most employment charts)

02-bar chart - boone wage

Next step: Change "All other industries" label to "Total employment". Chart 2016 values.

2015 values:

2014 values (revise):

Problem

04-bar chart - campbell wage

Next step: Ask @ericronne to update with latest values. Update 2014 values. Replace "All other industries" label with "Total employment".

2015-16 values:

Problem

13-bar chart - desoto wage

Next step: Ask @ericronne to update with latest/updated values; the differences are small enough that they're likely because of normal data updates

This one is missing the 2016 addition.

2016 values:

Draft for proofing

15-combo chart - morenci copper

Next step: Ask @ericronne to add 2016 data to the chart

2015, 2016 values:

Problem

06-bar chart - kern oil

Next step: Ask @ericronne to chart 2015 and 2016 values.

coreycaitlin commented 6 years ago

Next step: @brentryanjohnson to gather final numbers and clarify outstanding questions here.

brentryanjohnson commented 6 years ago

We received the origin data from Deloitte, but we're still awaiting explanations from them regarding some discrepancies in the data. For that reason, I've added the workflow: blocked label back.

image

Remaining questions:

brentryanjohnson commented 6 years ago

So we've discovered that Jobs in sector + Jobs in all other industries ≠ Total Employment in the Bureau of Labor Statistics data. The Deloitte data charted mining jobs and all other industry jobs, but presented the percentage as mining jobs as a portion of total employment (for Boone, Logan, Mingo).

To move this forward, we decided to omit the "All other industries" values and stack-chart mining and total employment. The chart on the site now uses the "Total Employment" figure instead of the "All other industries" value, even though the latter is represented as the difference of mining employment and total employment.

We have a path forward. I will circle back with @ericronne to move this forward.

brentryanjohnson commented 6 years ago

@ericronne The updated values and labels should be ready to chart; they are in the comment above.

Let me know if you have any questions or concerns.