Level 1 SQL queries - Githubissues

[ ] How many coal/oil/gas fields are covered by the Registry?
[ ] Most recent year production volumes at field level / total recent year production for each fossil fuel (expressed as %)
[ ] Most recent year production volumes at country level / total recent year production for each fossil fuel. (expressed as %)
[ ] Emissions associated with most recent year production volumes at country level / total recent year production for each fossil fuel. (expressed as %)
[ ] Global Scope 1-3 emissions for aggregated b fuel, expressed as GtCO2e, using prior year’s production data: NOTE a) use country level most recent year data b) scopes 2 and 3 are bundled together.
[ ] Top 10 countries, ranked by emissions, as calculate above.
[ ] How do emissions associated with defined global reserves compare with the remaining global carbon budget? Suggested query: Pull carbon budget from IPCC report, compare to Registry calculation of emissions associated with all current reserves. NOTE: Discuss - this is a series of hard coded IPCC GtCO2e numbers that need to be reduced by estimated emissions since then. Also, problem of non-FF anthropogenic (agriculture).
[ ] Which countries produce the most emissions intensive coal/ oil/ gas? Emissions intensity ranks based on fuel, from highest to lowest, based on data that drives the emissions calculator tool.

fossilfuelregistry / portal