🏆 Online competition, 19th-25th September 2019: National Oil Company Database

Find out how National Oil Companies impact economies at home and abroad, using data from the Natural Resource Governance Institute :oil_drum:

2019-09-19T16:00:00Z2019-09-25T21:00:00Z

We’re running a week-long virtual hackathon for our community members, with a £100 prize voucher available for the best insight as decided by team members from the NRGI and from Count! Test and improve your data skills, discuss your findings with fellow data enthusiasts, and be in with a chance of winning our competition and being featured in the Count community hall of fame.

Count has partnered with the Natural Resource Governance Institute to share data from the National Oil Company Database for our community to explore. Discover the role that national oil companies play in their home-country economies and in the global oil and gas markets.

Access the data on Count here!

How the competition will work :stopwatch:

  1. Timings: The competition opens at 17:00 on Thursday 19th September (UK time) and entries are to be submitted by 22:00 on Wednesday 25th September. (You can join in at any time during the week.) We will announce the winner on this page at midday, 26th September.
    Late to the party? Don’t worry, you can still share and discuss findings on this page after the 25th September, but your entry won’t be part of the competition.

  2. Challenges:
    Pick from one of the following challenges:

  • What do trends in the National Oil Companies dataset tell us about the countries/regions that will be most in the spotlight during the energy transition?
  • How do you assess the evolution of the economic and financial success of National Oil Companies, or of particular NOC(s), over time?
  1. Tool: Entries in any tool are welcome. You can explore the data using :count:Count’s new data publishing platform, which we’re building so people can find, explore and visualise data easily and share their discoveries all in one place. Or, you can download data tables to analyse and visualise in any another tool of your choice.

  2. Help: If you need help during the event, use the community help pages or contact us at hello@count.co We will get back to you as soon as possible during working hours. First time using Count? Check out our guidance materials on how to use Count before exploring the data for yourself.

  3. Submissions:
    Submissions can include up to 3 charts and a short description of up to 500 characters of what the charts show. We are looking for the best insight (the content of the finding is more important than a beautiful looking visual). To submit your entry:

  • Share your findings by replying to this message! You’ll need to sign up as a community member on the top right of this page. (It only takes a few seconds.)
  • Copy the link to your finding and add a brief (1-2 sentence) description of your insight.

Remember our community guidelines when sharing and discussing findings:

  • Include a link to your work and the data source, or just copy the link to your chart(s) if you are using Count
  • Add a short, clear description (up to 500 characters)
  • You can use any tool to create your insight, but make sure you still cite the data source and do not use any proprietary data in creating your results.
  • Don’t plagiarise! Don’t just repost someone else’s work - like their contribution instead. Credit people who helped you create your finding.
  • We want to be a friendly, constructive community. Abide by our community rules when responding to each others’ findings.

Keep up with all the action on this community page and on Twitter (@counthq, @NRGInstitute). Find out more about Count here.

1 Like

Let us know if you are joining:

  • I’m participating - it’s my first time joining a Count event online or in person!
  • I’m participating - I’ve joined a Count event before

0 voters

Challenge announcements :loudspeaker:

Pick from one of the following challenges:

  1. What do trends in the National Oil Companies dataset tell us about the countries/regions that will be most in the spotlight during the energy transition?
  2. How do you assess the evolution of the economic and financial success of National Oil Companies, or of particular NOC(s), over time?

You can access the data here!

Reminder about submissions
You can share the link to your insights on this page at any point. Make sure to share before the deadline of 22:00 on 25th September for your entry to be considered for the competition prize!

To submit from Count:

  • Create your visual, add a title and include your name in the title or description, then press share.
  • Once you have shared, click on the link symbol :link: to copy the URL to your finding and paste it in a post in this thread.
  • You can include up to 3 links to charts in your post, and a description of up to 500 characters.

To submit from other tools:

  • Share a link (or screenshot) to your findings. Again, you can include up to 3 charts and a description of up to 500 characters as your submission.

If you have questions about the data or need help using Count, post them on this page and we will get back to you during working hours.

We look forward to seeing your findings!

:warning: Important notes

We are still developing the Count platform at the moment: take care not to refresh the page or press the back button, otherwise you will lose your queries. Share your charts so that you can retrieve them in the shared visuals section, if you accidentally refresh the page.

For each company, as the oil and gas reserves of the rest of the world increase over time, the company cuts down its CAPEX. We believe that this is a response to an expected decrease in prices from additional supply being brought to market by foreign competitors

1 Like

DevReserves

Official development aid strongly correlates negatively with national reserves of oil and gas per capita.

1 Like

How do you assess the evolution of the economic and financial success of National Oil Companies, or of particular NOC(s), over time?

“Effective National Oil Companies”, as defined by the Natural Resource Governance Institute, “deliver significant value to their state shareholders via fiscal revenue contributions to the treasury, successful exploration efforts, and the development of new skills and technologies.”

By this definition, the first step and component in assessing the success of a NOC would be to look at how much and how well a NOC contributes to the finances of its government.

First we can simply measure this in sheer amount of the contribution in cash: Total Transfer to Gov by Company.(graphs removed data for NNPC, as data is most likely wrong)

Instead of comparing by total contribution we can compare the success of NOCs by what the proportion of revenue is their total transfer to gov.(graphs removed data for PNOC, as data is most likely wrong)

And last of all we can look at the success of NOC from the government’s perspective by comparing how much each government’s revenue is made up of a NOC’s contributions.

  • https://count.co/oil/share/pBtU4RgTqFhOwvwFWuqsq
  • By this standard we see companies like KPC, Saudi Aramco, Quatar Petroleum, and SNPC come at the top, each making up atleast 10 percent of their respective Government’s Revenue, some point in the past 6 years.
1 Like

Congratulations to @Prateek.Didwania who is the winner of our competition exploring the NRGI’s National Oil Company database! :tada:

Thanks to all who participated. If you missed the competition but are still interested in exploring the data for yourself, you can access the data on Count here!

1 Like